DefaultTableModel model=new DefaultTableModel();
//创建表头
model.setColumnIdentifiers(new Object[]{"设备ID","教室ID","设备名称","设备状态"});
//添加一行
model.addRow(new Object[]{"facility_id","classroom_id","facility_name","facility_state"});
// 再次,添加数据
Connection con = null;
try {
con = new Connection();
ResultSet res= con.getFromDatabase("select * from facility;");
System.out.println("select * from facility;");
while(res.next()) {
System.out.println("!!!");
int id=res.getInt("facility_id");
String name=res.getString("classroom_id");
String sex=res.getString("facility_name");
String i=res.getString("facility_state");
//把以上数据添加到表格模型的一行中
model.addRow(new Object[]{id,name,sex,i});
}
} catch(Exception e) {
e.printStackTrace();
} finally {
if(con != null) con.close();
}
//JTable是将数据以表格的形式显示给用户看的一种组件,它包括行和列,其中每列代表一种属性
JTable fk = new JTable(model);
/**
* 滚动面板 将fk表格放到jsp滚动里面
*/
JScrollPane jsp = new JScrollPane(fk);
jsp.setBounds(50, 10, 500, 250);
mid.add(jsp);
效果图