58,454
社区成员
发帖
与我相关
我的任务
分享
public void actionPerformed(ActionEvent arg0) {
Connection conn = null;
Statement st = null;
ResultSet rs = null;
try{
conn = DataConn.getAccessConn();
//st = conn.createStatement();
st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from users";
rs = st.executeQuery(sql);
String[] columnNames = {"ID","name","password","addr","tel"};
int tableRows = 0;
if (rs.last()&& rs.getString("name") != null)
tableRows = rs.getRow();
String[][] tableValues = new String[tableRows][5];
rs.beforeFirst();
int currentRow = 0;
while(rs.next() && rs.getString("name") != null){
//tableValues[0][1] = rs.getString(1);//这句本来是不该有的
for(int i = 0; i <5; i ++){
int column = i + 1 ;
tableValues[currentRow][i] = rs.getString(column);//这里为什么总报错?
}
currentRow ++;
}
DefaultTableModel tableModel = new DefaultTableModel(tableValues,columnNames);
table.setModel(tableModel);
}catch(Exception e){
e.printStackTrace();
}
}