代码如下:
Vector rowData,columnNames;
columnNames = new Vector();
rowData = new Vector();
columnNames.add("学号");
columnNames.add("学生姓名");
columnNames.add("性别");
columnNames.add("出生日期");
columnNames.add("班级");
columnNames.add("学院");
columnNames.add("年级");
try {
connect_sql consql = new connect_sql();//创建对象
Connection conn = consql.getConnection();//链接数据库
try
{
Statement sta = conn.createStatement();//创建sql语句的接口
ResultSet result = sta.executeQuery("select*from student");//result接受语句选中student表
ResultSetMetaData metaData = result.getMetaData();//接受result中的元数据
while(result.next())
{
Vector hang = new Vector();
int id = result.getInt(1);
String name = result.getString(2);
String sex = result.getString(3);
String brithday = result.getString(4);
String className = result.getString(5);
String insititute = result.getString(6);
int grade = result.getInt(7);
hang.add(id);hang.add(name);hang.add(sex);hang.add(brithday);
hang.add(className);hang.add(insititute);hang.add(grade);
rowData.add(hang);
}
}
catch(Exception e)
{
e.printStackTrace();
conn.close();
}
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
DefaultTableModel model = new DefaultTableModel(rowData,columnNames);
JTable jTable = new JTable(model);//创建表格组件
jTable.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
jsp.add(jTable);