Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.52 KB | None | 0 0
  1. package jdbc;
  2.  
  3. import java.awt.BorderLayout;
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Statement;
  9. import java.util.ArrayList;
  10.  
  11. import javax.swing.JPanel;
  12. import javax.swing.JScrollPane;
  13. import javax.swing.JTable;
  14. import javax.swing.table.DefaultTableModel;
  15.  
  16. class student {
  17.  
  18. private int id;
  19. private String fname;
  20. private String lname;
  21. private String mname;
  22. private int age;
  23. private String gender;
  24. private String address;
  25. private String level;
  26. private String section;
  27. private int phone;
  28.  
  29.  
  30. public student(int Stu_ID,String Stu_Fname,String Stu_Lname,String Stu_Mname,int Stu_Age,String Stu_gender,String Stu_Address,String Stu_Level,String Stu_Section,int Stu_phone) {
  31.  
  32. this.id = Stu_ID;
  33. this.fname = Stu_Fname;
  34. this.lname = Stu_Lname;
  35. this.mname = Stu_Mname;
  36. this.age = Stu_Age;
  37. this.gender = Stu_gender;
  38. this.address = Stu_Address;
  39. this.level = Stu_Level;
  40. this.section = Stu_Section;
  41. this.phone = Stu_phone;
  42.  
  43. }
  44.  
  45. public int getStu_ID()
  46. {
  47. return id;
  48. }
  49. public String getStu_Fname()
  50. {
  51. return fname;
  52. }
  53. public String getStu_Lname()
  54. {
  55. return lname;
  56. }
  57. public String getStu_Mname()
  58. {
  59. return mname;
  60. }
  61. public int getStu_Age()
  62. {
  63. return age;
  64. }
  65. public String getStu_gender()
  66. {
  67. return gender;
  68. }
  69. public String getStu_Address()
  70. {
  71. return address;
  72. }
  73. public String getStu_Level()
  74. {
  75. return level;
  76. }
  77. public String getStu_Section()
  78. {
  79. return section;
  80. }
  81.  
  82. public int getStu_phone()
  83. {
  84. return phone;
  85. }
  86.  
  87.  
  88.  
  89.  
  90.  
  91.  
  92.  
  93. static ArrayList<student> getstudent(){
  94.  
  95. ArrayList<student> student = new ArrayList<student>();
  96.  
  97.  
  98.  
  99. Statement st;
  100.  
  101. ResultSet rs;
  102.  
  103. student u;
  104.  
  105. try {
  106. Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
  107. st = con.createStatement();
  108. rs = st.executeQuery("SELECT * FROM student");
  109.  
  110. while(rs.next()){
  111.  
  112. u = new student(
  113. rs.getInt("Stu_ID"),
  114. rs.getString("Stu_Fname"),
  115. rs.getString("Stu_Lname"),
  116. rs.getString("Stu_Mname"),
  117. rs.getInt("Stu_Age"),
  118. rs.getString("Stu_gender"),
  119. rs.getString("Stu_Address"),
  120. rs.getString("Stu_Level"),
  121. rs.getString("Stu_Section"),
  122. rs.getInt("Stu_phone")
  123.  
  124.  
  125.  
  126. );
  127.  
  128. student.add(u);
  129. }
  130.  
  131. } catch (SQLException ex) {
  132.  
  133. }
  134.  
  135. return student;
  136. }
  137.  
  138.  
  139. public static void main(String[] args){
  140.  
  141. /*
  142. now we are gonna create and populate a jtable from the arraylist who is populated from mysql database
  143. */
  144.  
  145. JTable table = new JTable();
  146.  
  147. DefaultTableModel model = new DefaultTableModel();
  148.  
  149. Object[] columnsName = new Object[10];
  150.  
  151. columnsName[0] = "Id";
  152. columnsName[1] = "Fname";
  153. columnsName[2] = "Lname";
  154. columnsName[3] = "Mname";
  155. columnsName[4] = "Age";
  156. columnsName[5] = "Gender";
  157. columnsName[6] = "Address";
  158. columnsName[7] = "Level";
  159. columnsName[8] = "Section";
  160. columnsName[9] = "Phone";
  161.  
  162.  
  163.  
  164. model.setColumnIdentifiers(columnsName);
  165.  
  166. Object[] rowData = new Object[10];
  167.  
  168. for(int i = 0; i < getstudent().size(); i++){
  169.  
  170. rowData[0] = getstudent().get(i).getStu_ID();
  171. rowData[1] = getstudent().get(i).getStu_Fname();
  172. rowData[2] = getstudent().get(i).getStu_Lname();
  173. rowData[3] = getstudent().get(i).getStu_Mname();
  174. rowData[4] = getstudent().get(i).getStu_Age();
  175. rowData[5] = getstudent().get(i).getStu_gender();
  176. rowData[6] = getstudent().get(i).getStu_Address();
  177. rowData[7] = getstudent().get(i).getStu_Level();
  178. rowData[8] = getstudent().get(i).getStu_Section();
  179. rowData[9] = getstudent().get(i).getStu_phone();
  180.  
  181.  
  182. model.addRow(rowData);
  183. }
  184.  
  185. table.setModel(model);
  186.  
  187. // System.out.println(getUsers().size());
  188.  
  189. Work window = new Work();
  190.  
  191. JPanel panel = new JPanel();
  192.  
  193. panel.setLayout(new BorderLayout());
  194.  
  195. JScrollPane pane = new JScrollPane(table);
  196.  
  197. panel.add(pane,BorderLayout.CENTER);
  198.  
  199. window.setContentPane(panel);
  200. }
  201. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement