java运行jsp_在JAVA里成功运行 在JSP中报错

JAVA中运行代码publicclasstest{publicstaticvoidmain(String[]args){Connectionconn=null;PreparedStatementps=null;ResultSetrs=null;Useruser=newUser();Stringsql="select*fromus...

JAVA中运行代码

public class test {

public static void main( String[] args ){

Connection conn=null;

PreparedStatement ps=null;

ResultSet rs=null;

User user=new User();

String sql = "select * from user where user_id='rokok123' ";

rs=user.query(sql);

try {

while (rs.next()) {

System.out.println(rs.getString("user_id")+","+rs.getString("user_password"));

}

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

}

}

JSP中运行

//user对象中的userName和userPWD是通过自省完成赋值的

String userName = user.getId();

String userPwd = user.getPassword();

String sql = "select * from user where user_id='rokok123' ";

ResultSet rs = user.query(sql) ;

try {

while (rs.next()) {//这一行报错The server encountered an internal error that prevented it from fulfilling this request.

}

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

错误信息 An exception occurred processing JSP page /page/login.jsp at line 25

22: String sql = "select * from user where user_id='rokok123' ";

23: ResultSet rs = user.query(sql) ;

24: try {

25: while (rs.next()) {

26:

27: }

28: } catch (SQLException e) {

%>

user中的方法public ResultSet query(String sql){

Connection con=null;

Statement stat = null;

ResultSet rs=null;

try{

con = DBConnection.getConnection();

stat = con.createStatement();

rs = stat.executeQuery(sql);

}catch(Exception ex){

ex.printStackTrace();

}

return rs;

}

展开