58,454
社区成员
发帖
与我相关
我的任务
分享
public void btnShow_ActionPerformed(ActionEvent ae){
try{
// 获得连接
Connection conn=new Main().getConn();
// 建立查询条件
String sql = "select * from Xfgl_Food";
PreparedStatement pstm = conn.prepareStatement(sql);
// 执行查询
ResultSet rs = pstm.executeQuery();
// 计算有多少条记录
int count = 0;
while(rs.next()){
count++;
}
rs = pstm.executeQuery();
// 将查询获得的记录数据,转换成适合生成JTable的数据形式
Object[][] info = new Object[count][4];
count = 0;
while(rs.next()){
info[count][0] = Integer.valueOf( rs.getInt("Fno"));
info[count][1] = Integer.valueOf( rs.getInt("Fname"));
info[count][2] = Integer.valueOf( rs.getInt("Price") );
count++;
}
// 定义表头
String[] title = {"学号","姓名","年龄"};
// 创建JTable
tabDemo = new JTable(info,title);
// 显示表头
jth = this.tabDemo.getTableHeader();
// 将JTable加入到带滚动条的面板中
scpDemo.getViewport().add(tabDemo);
}//catch(ClassNotFoundException cnfe){ JOptionPane.showMessageDialog(null,"数据源错误","错误",JOptionPane.ERROR_MESSAGE);}
catch(SQLException sqle){
JOptionPane.showMessageDialog(null,"数据操作错误","错误",JOptionPane.ERROR_MESSAGE);
}
}