Re: Put each row into an array of strings?
sorry I was a little too vague asking about this, I've learned about it a litte more and made some progress.
I still have a problem somewhere though- I've created a method to retrieve the data, then in the JTable I call the method as the Object[][] instead of "new Object[][]" but it's not rerieving anything when testing the program.
the retrieval method:
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++] = rs.getString("ID");
userList[j++] = rs.getString("name");
userList[j++] = rs.getString("email");
userList[j++] = rs.getString("password");
userList[j++] = rs.getString("phone");
userList[j++] = rs.getString("phone_number");
System.out.println(userList[1]);
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;
}
!~! and the beginning of the JTable looks like this: ~!~
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"
}
)
Subject
Written By
Posted
Re: Put each row into an array of strings?
July 09, 2014 03:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.