我想把从数据库里面掉出来的数据加到自己创建的表格里面,怎么加(表格省略)
public void connectionDB(){ //连接数据库
Connection con = null;
PreparedStatement stm = null;
ResultSet rs = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:recruit","user15","user15");
String str ="select * from studentinformation";
stm = con.prepareStatement(str);
rs =stm.executeQuery();
ResultSetMetaData md = rs.getMetaData();
int col = md.getColumnCount();
int row = rs.getRow();
System.out.println(col+" "+row);
String head[] = new String[col]; //保存表头数据
String data[][] = new String[row][col]; //保存表体数据
for (int t =0;t<col;t++){
head[t]= md.getColumnName(t+1); //表头数据初始化
}
//rs.beforeFirst(); //移动到第一行记录前面
int k=0;
while(rs.next()){
//System.out.println(rs.getString(getstring[k]));
for (int h = 0; h<col; h++){
data[k][h]=rs.getString(h+1); //表体数据数组初始化
}
k++;
}
dtm = new DefaultTableModel(data,head);
jtable.setModel(dtm);
public void connectionDB(){ //连接数据库
Connection con = null;
PreparedStatement stm = null;
ResultSet rs = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:recruit","user15","user15");
String str ="select * from studentinformation";
stm = con.prepareStatement(str);
rs =stm.executeQuery();
ResultSetMetaData md = rs.getMetaData();
int col = md.getColumnCount();
int row = rs.getRow();
System.out.println(col+" "+row);
String head[] = new String[col]; //保存表头数据
String data[][] = new String[row][col]; //保存表体数据
for (int t =0;t<col;t++){
head[t]= md.getColumnName(t+1); //表头数据初始化
}
//rs.beforeFirst(); //移动到第一行记录前面
int k=0;
while(rs.next()){
//System.out.println(rs.getString(getstring[k]));
for (int h = 0; h<col; h++){
data[k][h]=rs.getString(h+1); //表体数据数组初始化
}
k++;
}
dtm = new DefaultTableModel(data,head);
jtable.setModel(dtm);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货