Re: Put each row into an array of strings?

[Branden Patey]

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"
}
)