package bean;
import java.sql.*;
public class PersonDAOImpl implements PersonDAO
{
public boolean isLogin(PersonVo pv) throws Exception
{
boolean flag = false;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "SELECT name FROM user WHERE id=? AND pass=?";
DataBaseConnection dbc = null;
try
{
dbc= new DataBaseConnection();
pstmt = dbc.getConnection().prepareStatement(sql);
pstmt.setString(1,pv.getId());
pstmt.setString(2,pv.getPass());
rs = pstmt.executeQuery();
if(rs.next())
{
flag=true;
}
rs.close();
pstmt.close();
}
catch (Exception e)
{
throw new Exception("登录错误");
}
finally
{
dbc.close();
}
return flag;
}
}
我经过排除之后,发现是executequery()方法出错,但我实在想不通为什么。。。求高手帮忙,留下QQ也可以,我把项目给你,帮我看一下,很简单,就是一个登录,连注册都没有。
我的QQ是:274510887
我只截取了一部分报错,太多了,贴不出来,这是第一部分
HTTP Status 500 -
org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.Exception: 登录错误
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)