jsp 按照学号查找学生_怎样做才可以用JSP实现只输入姓名或学号就可以进行查询...

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());

}

下一个查询

展开