Guest User

Untitled

a guest
Jan 18th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.48 KB | None | 0 0
  1. form.getContentPane().add(table);
  2.  
  3. Vector columnNames = new Vector();
  4. Vector data = new Vector();
  5. Class.forName("com.mysql.jdbc.Driver").newInstance();
  6. Connection con =DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "colorway", "colorway");
  7. String sql = "Select name,lname from student";
  8. Statement statement = con.createStatement();
  9. ResultSet resultSet = statement.executeQuery(sql);
  10. ResultSetMetaData metaData = resultSet.getMetaData();
  11. int columns = metaData.getColumnCount();
  12. for (int i = 1; i <= columns; i++) {
  13. columnNames.addElement(metaData.getColumnName(i));
  14. }
  15.  
  16. while (resultSet.next()) {
  17. Vector row = new Vector(columns);
  18. for (int i = 1; i <= columns; i++) {
  19. row.addElement(resultSet.getObject(i));
  20. }
  21. data.addElement(row);
  22. }
  23. resultSet.close();
  24. statement.close();
  25. Students form=new Students();
  26. JTable table=new JTable(data, columnNames);
  27. form.setContentPane(table);
  28. form.setVisible(true);
  29.  
  30. public class Students extends javax.swing.JFrame {
  31. //somecode
  32. // Variables declaration - do not modify
  33. private javax.swing.JButton jButton1;
  34. private javax.swing.JButton jButton2;
  35. private javax.swing.JPanel jPanel1;
  36. private javax.swing.JScrollPane jScrollPane1;
  37. private javax.swing.JTable jTable1;
  38. // End of variables declaration
  39.  
  40. public JPanel getjpanel(){
  41. return this.jPanel1;
  42. }
  43.  
  44. public JScrollPane getJscrollPane()
  45. {
  46. return this.jScrollPane1;
  47. }
  48.  
  49. public JTable getJTable()
  50. {
  51. return this.jTable1;
  52. }
  53. }
  54.  
  55. form.getContentPane().add(table);
  56.  
  57. form.getContentPane().add(button, BorderLayout.SOUTH);
  58.  
  59. import javax.swing.*;
  60. import java.awt.event.*;
  61. import java.awt.*;
  62.  
  63. public class MyFrame extends JFrame {
  64. public MyFrame () {
  65.  
  66. String[] columns = {"one", "two", "three"};
  67. String[][] data = {
  68. {"a1", "a2", "a3"},
  69. {"b1", "b2", "b3"},
  70. };
  71.  
  72. JTable table = new JTable(data, columns);
  73.  
  74. getContentPane().add(new JScrollPane(table));
  75. getContentPane().add(new JButton("Hello"), BorderLayout.SOUTH);
  76.  
  77. pack();
  78. setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  79. setVisible(true);
  80. }
  81.  
  82. public static void main(String[] args) {
  83. SwingUtilities.invokeLater(new Runnable() {
  84. @Override
  85. public void run() { new MyFrame(); }
  86. });
  87. }
  88. }
Add Comment
Please, Sign In to add comment