创建两个连接,根据选课表(学号、课程号、……、……)中的某个列值(课程号),得到课程表(课程号、……、……、……)某行符合条件(课程号)的记录。
Connection con=SQLServerConnection.getCon();
Connection con2=SQLServerConnection.getCon();
Statement statement=con.createStatement();
Statement statement2=con2.createStatement();
ResultSet rs=statement.executeQuery("select * from 选课 where 学号='"+StuNumb+"'");
while(rs.next()){
Vector<String> col=new Vector<String>();
String c1=new String(rs.getString(1).trim());
String c2=new String(rs.getString(2).trim());
String c4=new String(rs.getString(3).trim());
String c5=new String(rs.getString(4).trim());
ResultSet rs2=statement2.executeQuery("select * from 课程 where 课程号='"+c2+"'");
String c3=new String();
while(rs2.next()){
c3=new String(rs2.getString(2).trim());
}
col.add(c1);
col.add(c2);
col.add(c3);
col.add(c4);
col.add(c5);
row.add(col);
}