Stringname=request.getParameter("name");out.print(name);ResultSetrs=stmt.executeQuery("select*fromstudentwhere学生学号='name'"以上代码中的ResultSetrs=stmt.executeQuery("s...
String name=request.getParameter("name");
out.print(name);
ResultSet rs=stmt.executeQuery("select * from student where 学生学号='name'"
以上代码中的ResultSet rs=stmt.executeQuery("select * from student where 学生学号='name'"
name无法获取,如果把name改为数据库中的确定值则可以执行,如果按上面数据则没有数据显示,为什么?
完整代码如下:
查询结果如下:
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:study";
String user="sa";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
stmt.setMaxRows(10);
String name=request.getParameter("name");
out.print(name);
ResultSet rs=stmt.executeQuery("select * from student where 学生学号='name'");
ResultSetMetaData rsmd=rs.getMetaData();
int cols=rsmd.getColumnCount();
out.println("
out.println("
");for(int i=1;i<=cols;i++)
{
out.print("
");out.print(rsmd.getColumnLabel(i));
out.println("
");}
out.print("
");while(rs.next()){
out.print("
");for(int i=1;i<=cols;i++){
out.print("
");Object obj=rs.getObject(i);
if(obj!=null)
out.print(obj.toString());
else
out.print("");
out.println("
");}//end of for
out.print("
");}//end of while
out.print("
");rs.close();
stmt.close();
conn.close();
}
catch(ClassNotFoundException ex){
out.println(ex.getMessage());
}
catch(SQLException ex){
out.println(ex.getMessage());
}
展开