Advertisement
Guest User

GestioneDatabase

a guest
Jan 29th, 2017
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.04 KB | None | 0 0
  1. import java.sql.*;
  2. import java.awt.*;
  3. import javax.swing.*;
  4. import javax.swing.table.*;
  5. import java.awt.event.*;
  6. import java.io.*;
  7. import javax.swing.table.AbstractTableModel;
  8.  
  9. public class GestioneDatabase extends JFrame implements ActionListener
  10. {
  11. JPanel pMain = new JPanel();
  12. JTabbedPane tabPane = new JTabbedPane();
  13. JPanel PTabella = new JPanel();
  14. JPanel PInserimento = new JPanel();
  15. JPanel PAggiorna = new JPanel();
  16. JPanel PElimina = new JPanel();
  17.  
  18. //Componenti TAB 1
  19. DefaultTableModel dtm;
  20. JTable table;
  21. String[] intestazione={"ID","Nome","Cognome","Classe"};
  22. String[][] dati;
  23.  
  24. //Componenti TAB 2
  25. JTextField t_nome=new JTextField(20);
  26. JTextField t_cognome=new JTextField(20);
  27. JTextField t_classe=new JTextField(20);
  28. JButton b_inserisci=new JButton("Inserisci");
  29.  
  30. Connection connection=null;
  31. Statement stm=null;
  32. ResultSet rs=null;
  33. String DRIVER="com.mysql.jdbc.Driver";
  34. String url="jdbc:mysql://localhost:3306/bagnulo_01";
  35. public GestioneDatabase()
  36. {
  37. try
  38. {
  39. Class.forName(DRIVER);
  40. }
  41. catch(java.lang.ClassNotFoundException e)
  42. {
  43. System.out.println("Driver non trovato "+e.getMessage());
  44. }
  45. try
  46. {
  47. connection= DriverManager.getConnection(url,"root","");
  48. stm=connection.createStatement();
  49.  
  50. visualizza();
  51. }
  52. catch(Exception e)
  53. {
  54. System.err.println(e.getMessage());
  55. }
  56.  
  57. dtm=new DefaultTableModel(dati,intestazione);
  58. JTable table=new JTable(dtm);
  59. PTabella.add(table);
  60.  
  61. tabPane.addTab("Database", PTabella );
  62. tabPane.addTab("Inserimento", PInserimento );
  63. tabPane.addTab("Aggiorna", PAggiorna);
  64. tabPane.addTab("Elimina", PElimina);
  65.  
  66. add(pMain);
  67. pMain.add(tabPane);
  68.  
  69. this.setTitle("Gestione Database");
  70. this.pack();
  71. this.setVisible(true);
  72. this.setLocation(500,100);
  73. }
  74.  
  75. public void actionPerformed(ActionEvent ev)
  76. {
  77. }
  78.  
  79. public static void main(String arg[])
  80. {
  81. GestioneDatabase gdb= new GestioneDatabase();
  82. }
  83.  
  84. public void visualizza()
  85. {
  86. try
  87. {
  88. int cont=0;
  89. rs=stm.executeQuery("SELECT * FROM studenti");
  90.  
  91. while(rs.next())
  92. {
  93. String id=rs.getString(1);
  94. String nome=rs.getString(2);
  95. String cognome=rs.getString(3);
  96. String classe=rs.getString(4);
  97. System.out.println(id+nome+cognome+classe);
  98. dati[cont][0]=id;
  99. dati[cont][1]=nome;
  100. dati[cont][2]=cognome;
  101. dati[cont][3]=classe;
  102. cont++;
  103. }
  104. }
  105. catch(Exception e)
  106. {
  107. System.out.println(e.getMessage());
  108. }
  109. }
  110. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement