Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Object[][] getEmployees(){
- Connection conn = null;
- Statement stmt = null;
- ResultSet rs = null;
- ResultSet rs2 = null;
- String[] xsettings = null;
- Object[][] userList = new Object[6][];
- try {
- xsettings = Lottery.properties.readConfig();
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- conn = DriverManager.getConnection("jdbc:mysql://"+ xsettings[0] +"/"+ xsettings[4] +"?user="+ xsettings[2] +"&password="+ xsettings[3]);
- stmt = conn.createStatement();
- rs = stmt.executeQuery("SELECT * FROM employees");
- while(rs.next()){
- for (int i = 0, j = 0; j > 6 ; i++) {
- userList[j++][i] = rs.getString("ID");
- userList[j++][i] = rs.getString("name");
- userList[j++][i] = rs.getString("email");
- userList[j++][i] = rs.getString("password");
- userList[j++][i] = rs.getString("phone");
- userList[j++][i] = rs.getString("phone_number");
- System.out.println(userList[1][i]);
- rs.next();
- }
- }
- } catch (Exception ex) {
- ex.printStackTrace();
- }finally {
- if (rs != null) {
- try {
- rs.close();
- } catch (SQLException sqlEx) { } // ignore
- rs = null;
- }
- if (stmt != null) {
- try {
- stmt.close();
- } catch (SQLException sqlEx) { } // ignore
- stmt = null;
- }
- }
- return userList;
- }
- employee_list = new JTable();
- Object[][] userList = new Object[6][];
- employees employees = new employees();
- userList = employees.getEmployees();
- employee_list.setModel(new DefaultTableModel( userList,
- new String[] {
- "ID", "Name", "Email", "Password", "Call?(yes/no)", "Phone Number"
- }
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement