Advertisement
Guest User

JTable/myql

a guest
Jul 9th, 2014
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.91 KB | None | 0 0
  1.     public Object[][] getEmployees(){
  2.         Connection conn = null;
  3.         Statement stmt = null;
  4.         ResultSet rs = null;
  5.         ResultSet rs2 = null;
  6.         String[] xsettings = null;
  7.         Object[][] userList = new Object[6][];
  8.        
  9.         try {
  10.             xsettings = Lottery.properties.readConfig();
  11.             Class.forName("com.mysql.jdbc.Driver").newInstance();
  12.             conn = DriverManager.getConnection("jdbc:mysql://"+ xsettings[0] +"/"+ xsettings[4] +"?user="+ xsettings[2] +"&password="+ xsettings[3]);
  13.             stmt = conn.createStatement();
  14.             rs = stmt.executeQuery("SELECT * FROM employees");
  15.            
  16.             while(rs.next()){
  17.                 for (int i = 0, j = 0; j > 6 ; i++) {
  18.                     userList[j++][i] = rs.getString("ID");
  19.                     userList[j++][i] = rs.getString("name");
  20.                     userList[j++][i] = rs.getString("email");
  21.                     userList[j++][i] = rs.getString("password");
  22.                     userList[j++][i] = rs.getString("phone");
  23.                     userList[j++][i] = rs.getString("phone_number");
  24.                     System.out.println(userList[1][i]);
  25.                     rs.next();
  26.                 }
  27.             }  
  28.            
  29.         } catch (Exception ex) {
  30.             ex.printStackTrace();
  31.         }finally {
  32.  
  33.             if (rs != null) {
  34.                 try {
  35.                     rs.close();
  36.                 } catch (SQLException sqlEx) { } // ignore
  37.  
  38.                 rs = null;
  39.             }
  40.  
  41.             if (stmt != null) {
  42.                 try {
  43.                     stmt.close();
  44.                 } catch (SQLException sqlEx) { } // ignore
  45.  
  46.                 stmt = null;
  47.             }
  48.         }
  49.         return userList;
  50.     }
  51.  
  52.         employee_list = new JTable();
  53.         Object[][] userList = new Object[6][];
  54.         employees employees = new employees();
  55.         userList = employees.getEmployees();
  56.         employee_list.setModel(new DefaultTableModel( userList,
  57.             new String[] {
  58.                 "ID", "Name", "Email", "Password", "Call?(yes/no)", "Phone Number"
  59.             }
  60.         )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement