java.lang.NullPointerException错误不知什么问题
package com.ushio.oa;
import java.sql.*;
/**
* @author user
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class CreateCon {
Connection con;
Statement stmt;
public Connection getCon()
{
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}catch(Exception e){
System.err.println(e.getMessage());
}
String sqlStr="String strUrl=jdbc:mysql://localhost/Emp_Info?user=root&password=ushio&useUnicode=true&characterEncoding=GB2312";
try{
con=DriverManager.getConnection(sqlStr);
}catch(SQLException ex)
{
System.out.print(ex);
}
return con;
}
public Statement getStmt()
{
//con=getCon();
try{
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}catch(SQLException ex)
{
System.out.println(ex.getMessage());
}
return stmt;
}
}
loginAccount类
/*
* Created on 2005-6-5
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
package com.ushio.oa;
import java.sql.*;
//import com.ushio.oa.*;
/**
* @author user
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class loginAccount{
public ResultSet db_query(String sql)
{
Statement stmt;
CreateCon aa=new CreateCon();
stmt=aa.getStmt();
//Connection con=aa.getCon();
ResultSet rs=null;
try {
rs=stmt.executeQuery(sql);
}catch(SQLException e)
{
System.out.println(e.getMessage());
}
return rs;
}
public void db_update(String sql)
{
boolean success;
Statement stmt;
CreateCon ConCreater=new CreateCon();
stmt=ConCreater.getStmt();
try{
success=stmt.execute(sql);
}catch(SQLException e)
{
System.out.print(e.getMessage());
}
}
}
newUser 类
/*
* Created on 2005-6-6
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
package com.ushio.oa;
/**
* @author user
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class newUser {
String user;
String password;
String Department;
int power;
public void setUser(String strUser)
{
user=strUser;
}
public String getUser()
{
return user;
}
public void setPassword(String strPwd)
{
password=strPwd;
}
public String getPassword()
{
return password;
}
public void setDepartment(String strDepartment)
{
Department=strDepartment;
}
public String getDepartment()
{
return Department;
}
public void setPower(int intPower)
{
power=intPower;
}
public int getPower()
{
return power;
}
public boolean adduser()
{
boolean success=true;
String sqlStr="";
if(user=="")
{
success=false;
}
loginAccount db_action=new loginAccount();
sqlStr="insert into login_account(user,password,Department,power) values('"+user+"','"+password+"','"+Department+"','"+power+"')";
db_action.db_update(sqlStr);
return success;
}
}
regpage.jsp
<%@ page language="java" %>
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>User Regation</title>
</head>
<body bgcolor="#FFFFFF">
<form method="post" name="reguser" action="regDo.jsp" >
<table align="center">
<tr><td align="center">UserReg</td></tr>
<tr><td>Please Input UserName:<input type="text" name="user" size="15"></td></tr>
<tr><td>Please Input Password:<Input type="password" Name="password" size="15"></td></tr>
<tr><td>Please Input Department:<Input type="text" Name="Department" size="15"></td></tr>
<tr><td>Please Input PowerLevel:<Input type="Text" Name="power" size="5">*input the int</td></tr>
<tr><td><input type="submit" value="AddNew"></td></tr>
</table>
</form>
</body>
</html>
regDo.jsp
<%@ page language="java" %>
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>Lomboz JSP</title>
</head>
<body bgcolor="#FFFFFF">
<jsp:useBean id="addnew" scope="page" class="com.ushio.oa.newUser"/>
<%
String user=request.getParameter("user");
String password=request.getParameter("password");
String Department=request.getParameter("Department");
String power=request.getParameter("power");
addnew.setUser(user);
addnew.setPassword(password);
addnew.setDepartment(Department);
addnew.setPower(1);
boolean aa=addnew.adduser();
out.println(aa);
%>
</body>
</html>
问题是点击addnew后出现
下面的错误
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException
com.ushio.oa.CreateCon.getStmt(CreateCon.java:39)
com.ushio.oa.loginAccount.db_update(loginAccount.java:40)
com.ushio.oa.newUser.adduser(newUser.java:63)
org.apache.jsp.regDo_jsp._jspService(regDo_jsp.java:67)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
相关推荐
CRASH问题:java.lang.NullPointerException
java.lang.NullPointerException: Attempt to invoke virtual method ‘void android.widget.ImageView.setImageResource(int)’ on a null object reference 今天在家练习ListView的时候,遇到一个java.lang.NullPointerException的空指针异常,log如下: 2020-05-10 15:40:29.249 20436-20436/? E/k.myapplicatio: Unknown bits set in runtime_flag
java.lang.NullPointerException的解决方法
启动Tomcat时出现了下面的这种错误,找了很久的原因终于知道是因为tomcat和jdk要放在任意一个盘的根目录下面,而不能是放在 而不能放在某个盘根目录下的子目录里面,最好是放在C盘的根目录下面(比如C:\tomcat-6.0.20、C:\jdk1.6)!
java.lang.NullPointerException
java.lang.NullPointerException错误解决办法 ,很不错的文档
java.lang.NullPointerException出现的几种原因及解决方案
主要介绍了java.lang.NullPointerException出现的几种原因及解决方案,本文给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友可以参考下
绝望,上传文件失败。。遇到并解决java.lang.NullPointerException
解决报错:java.lang.NullPointerException 解决方法:将文件的编码方式改为utf-8即可! 截图: 修改成功后: 代码: import os import json import re def json_to_html(i,cvenum): print('正在处理:'+cvenum) head = 漏洞对应信息摘要 \ cvesummary for this cve tail = #padding-left: 320px cvesummary_context = head + i +


Web 开发
