才开始做小系统 报错误 求高手 前辈解析上
日期：2014-05-17 浏览次数：20692 次
才开始做小系统 报异常 求高手 前辈解析下
做一个通讯录后台管理系统 在TOMCAT上面报错是
java.lang.NullPointerException
com.gem.comm.zhuceDaoImpl.通讯录首页(zhuceDaoImpl.java:21)
com.gem.comm.zhuceServlet.doGet(zhuceServlet.java:24)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
我实现接口的代码是
public class zhuceDaoImpl implements zhuceDao {
public zhucebiao 通讯录首页(String name, String pwd){
Connection conn = null;
PreparedStatement psta = null;
ResultSet rs=null;
zhucebiao zhuce = null;
try {
conn = DBUtil.getConnection();
String sql = "select * from zhucebiao where zhanghao=? and mima=?";
psta = conn.prepareStatement(sql);
psta.setString(1, name);
psta.setString(2, pwd);
rs = psta.executeQuery();
while(rs.next()){
String userName = rs.getString("zhanghao");
String password = rs.getString("mima");
zhuce = new zhucebiao();
zhuce.setZhanghao(userName);
zhuce.setMima(password);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBUtil.closeAll(null, psta, conn);
}
return zhuce;
}
}
servlet 代码是
public class zhuceServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
String name = request.getParameter("userName");
String password = request.getParameter("pwd");
System.out.println(name);
System.out.println(password);
zhuceDao zhuDao = new zhuceDaoImpl();
zhucebiao zhuce = zhuDao.通讯录首页(name, password);
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
if(zhuce == null){
out.println("对不起您的用户名密码错误~~");
}else{
out.println("欢迎登陆~~");
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}
}
哪位大哥帮帮忙 感激不尽 才开始学 每天最开心的就是看见代码运行是成功的 泪流满面
------解决方案--------------------
com.gem.comm.zhuceDaoImpl.通讯录首页(zhuceDaoImpl.java:21)
找找21行，这里出现了空指针异常。建议：不要用中文做为方法名或者类名。在String password = rs.getString("mima");后把userName和password打印出来看下值是多少。
------解决方案--------------------
首先，函数名不要用中文啊，这是最起码的规范，
java.lang.NullPointerException
com.gem.comm.zhuceDaoImpl.通讯录首页(zhuceDaoImpl.java:21)
这个报的是空指针异常，你可以看他已经提示了具体的文件和在哪一行，可以到文件那一行去查看一下；
你这个地方里面的两个变量'
做一个通讯录后台管理系统 在TOMCAT上面报错是
java.lang.NullPointerException
com.gem.comm.zhuceDaoImpl.通讯录首页(zhuceDaoImpl.java:21)
com.gem.comm.zhuceServlet.doGet(zhuceServlet.java:24)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
我实现接口的代码是
public class zhuceDaoImpl implements zhuceDao {
public zhucebiao 通讯录首页(String name, String pwd){
Connection conn = null;
PreparedStatement psta = null;
ResultSet rs=null;
zhucebiao zhuce = null;
try {
conn = DBUtil.getConnection();
String sql = "select * from zhucebiao where zhanghao=? and mima=?";
psta = conn.prepareStatement(sql);
psta.setString(1, name);
psta.setString(2, pwd);
rs = psta.executeQuery();
while(rs.next()){
String userName = rs.getString("zhanghao");
String password = rs.getString("mima");
zhuce = new zhucebiao();
zhuce.setZhanghao(userName);
zhuce.setMima(password);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBUtil.closeAll(null, psta, conn);
}
return zhuce;
}
}
servlet 代码是
public class zhuceServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
String name = request.getParameter("userName");
String password = request.getParameter("pwd");
System.out.println(name);
System.out.println(password);
zhuceDao zhuDao = new zhuceDaoImpl();
zhucebiao zhuce = zhuDao.通讯录首页(name, password);
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
if(zhuce == null){
out.println("对不起您的用户名密码错误~~");
}else{
out.println("欢迎登陆~~");
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}
}
哪位大哥帮帮忙 感激不尽 才开始学 每天最开心的就是看见代码运行是成功的 泪流满面
------解决方案--------------------
com.gem.comm.zhuceDaoImpl.通讯录首页(zhuceDaoImpl.java:21)
找找21行，这里出现了空指针异常。建议：不要用中文做为方法名或者类名。在String password = rs.getString("mima");后把userName和password打印出来看下值是多少。
------解决方案--------------------
首先，函数名不要用中文啊，这是最起码的规范，
java.lang.NullPointerException
com.gem.comm.zhuceDaoImpl.通讯录首页(zhuceDaoImpl.java:21)
这个报的是空指针异常，你可以看他已经提示了具体的文件和在哪一行，可以到文件那一行去查看一下；
你这个地方里面的两个变量'
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
