MyEclipse5.5 mysql5.0 structs1.2 登录报空指针异常 NullPointerException
控制台输出以下错误:
连接成功!
2008-10-17 11:58:06 org.apache.struts.action.RequestProcessor processException
警告: Unhandled Exception thrown: class java.lang.NullPointerException
2008-10-17 11:58:06 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet action threw exception
java.lang.NullPointerException
at com.index.bean.WorkBean.isLogin(WorkBean.java:38)
at com.index.struts.action.LoginAction.execute(LoginAction.java:48)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
代码:
public class WorkBean {
Connection con;
Statement st;
ResultSet rs;
public Connection getConn(){
try {
Class.forName("com.mysql.jdbc.Driver");
DriverManager.getConnection("jdbc:mysql://localhost:3306/users", "root", "123");
System.out.println("连接成功!");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
public boolean isLogin(Connection con2,String username, String password) {
boolean flag=false;
try {
st=con2.createStatement();
rs=st.executeQuery("select * from users where username='"+username+"' and "+"password='"+password+"'");
while(rs.next()){
flag=true;
}
} catch (SQLException e) {
flag=false;
e.printStackTrace();
} finally{
try {
con2.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return flag;
}
}