Advertisement
Guest User

Untitled

a guest
May 17th, 2018
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.61 KB | None | 0 0
  1. package Subiect3_2;
  2.  
  3. import java.io.BufferedReader;
  4. import java.io.IOException;
  5. import java.io.InputStreamReader;
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10. import java.sql.Statement;
  11.  
  12. public class MainApp {
  13.  
  14. public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException, IOException {
  15. // TODO Auto-generated method stub
  16.  
  17. BufferedReader flux_tastatura = new BufferedReader(new InputStreamReader (System.in));
  18.  
  19. String url = "jdbc:mysql://localhost:3306/test";
  20. Class.forName("com.mysql.jdbc.Driver").newInstance();
  21. Connection con = (Connection)DriverManager.getConnection(url,"root","root");
  22. Statement sql = (Statement)con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
  23. ResultSet rs = sql.executeQuery("select * from destinatii");
  24.  
  25. int optiune;
  26.  
  27. do
  28. {
  29. System.out.println("\n1.Afisare baza de date");
  30. System.out.println("2.Adaugare destinatie turistica");
  31. System.out.println("3.Modificare numar obiective");
  32. System.out.println("4.Iesire");
  33. System.out.println("\nDati optiunea: ");
  34. optiune = Integer.parseInt(flux_tastatura.readLine());
  35.  
  36. switch(optiune)
  37. {
  38. case 1:
  39. //afisare
  40. rs.first();
  41. do
  42. {
  43. String tara = rs.getString("Tara");
  44. String statiunea = rs.getString("Statiunea");
  45. String nr_ob = rs.getString("Nr_Obiective");
  46.  
  47. System.out.println(tara + ", " + statiunea + ", " + nr_ob);
  48. }while (rs.next());
  49. break;
  50. case 2:
  51. //adaugare
  52. System.out.println("\nIntroduceti o noua destinatie turistica:");
  53. String element = flux_tastatura.readLine();
  54. String [] parts = element.split(", ");
  55. String tara = parts[0];
  56. String statiunea = parts[1];
  57. String nr_ob = parts[2];
  58.  
  59. rs.moveToInsertRow();
  60. rs.updateString("Tara", parts[0]);
  61. rs.updateString("Statiunea", parts[1]);
  62. rs.updateInt("Nr_Obiective", Integer.parseInt(parts[2]));
  63. rs.insertRow();
  64. break;
  65. case 3:
  66. //actualizare nr_obiective
  67. System.out.println("Dati statiunea: ");
  68. String statiune = flux_tastatura.readLine();
  69. System.out.println("Dati noul numar de obiective: ");
  70. String nr = flux_tastatura.readLine();
  71.  
  72. rs.first();
  73. do
  74. {
  75. if (rs.getString("Statiunea").equalsIgnoreCase(statiune))
  76. {
  77. rs.updateInt("Nr_Obiective", Integer.parseInt(nr));
  78. rs.updateRow();
  79. }
  80. }while (rs.next());
  81. break;
  82. case 4:
  83. break;
  84. }
  85. }while (optiune!=4);
  86. }
  87. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement