写了一个搜索方法,不知道该如何调用,想输入一个学号点击按钮就可以跳转到另一个jsp页面,查找出相应数据
方法如下/*
* 检索学生
*/
public List<Student> listStudent(String schword)
{
//数据库连接
Connection conn = DB.getConn();
String sql = "select * from students ";
if(!"".equals(schword))
sql = sql + " where zkzh like '' or name like ''";
sql = sql + "order by zkzh ";
Statement stmt = DB.getStatement(conn);
ResultSet rs = DB.getResultSet(stmt, sql);
List<Student> lst = new ArrayList<Student>();
try {
while (rs.next()) {
Student stu = new Student();
stu.setZkzh(rs.getString("zkzh"));
stu.setName(rs.getString("name"));
stu.setBirthday(rs.getDate("birthday"));
stu.setSex(rs.getString("sex"));
stu.setAddress(rs.getString("address"));
stu.setPhone(rs.getString("phone"));
stu.setInyear(rs.getInt("inyear"));
lst.add(stu);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DB.close(rs);
DB.close(stmt);
DB.close(conn);
} return lst;
}
想在
方法如下/*
* 检索学生
*/
public List<Student> listStudent(String schword)
{
//数据库连接
Connection conn = DB.getConn();
String sql = "select * from students ";
if(!"".equals(schword))
sql = sql + " where zkzh like '' or name like ''";
sql = sql + "order by zkzh ";
Statement stmt = DB.getStatement(conn);
ResultSet rs = DB.getResultSet(stmt, sql);
List<Student> lst = new ArrayList<Student>();
try {
while (rs.next()) {
Student stu = new Student();
stu.setZkzh(rs.getString("zkzh"));
stu.setName(rs.getString("name"));
stu.setBirthday(rs.getDate("birthday"));
stu.setSex(rs.getString("sex"));
stu.setAddress(rs.getString("address"));
stu.setPhone(rs.getString("phone"));
stu.setInyear(rs.getInt("inyear"));
lst.add(stu);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DB.close(rs);
DB.close(stmt);
DB.close(conn);
} return lst;
}
想在
要的话邮箱给我
有空的帮帮忙阿阿阿