jsp调用java的数据库连接,jsp调用javabean连接数据库报空指针错

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

关于jsp中使用javabean老报空指针异常javbean代码&＃xff1a;

public class connectsql {

public static Statement getStatement(){

Connection conn&＃61;null;

Statement stmt&＃61;null;

String url&＃61;"jdbc:sqlserver://localhost:1444;DataBaseName&＃61;photouser";

String username&＃61;"sa";

String password&＃61;"123456";

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

try {

conn&＃61;DriverManager.getConnection(url,username,password);

stmt&＃61;conn.createStatement();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} catch (InstantiationException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

} catch (IllegalAccessException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

} catch (ClassNotFoundException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

return stmt;

}

public void adduser(String username,String password){

try {

String sql&＃61;"insert into yao(username,password) values(&＃39;"&＃43;username&＃43;"&＃39;,&＃39;"&＃43;password&＃43;"&＃39;)";

getStatement().executeUpdate(sql);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

jsp代码&＃xff1a;

request.setCharacterEncoding("gb2312");

String username&＃61;request.getParameter("username");

String password&＃61;request.getParameter("password");

dan.adduser("23213","2312412");

%>

报错&＃xff1a;

严重: Servlet.service() for servlet [jsp] in context with path [/test] threw exception [java.lang.NullPointerException] with root cause

java.lang.NullPointerException

at com.jdbc.connectsql.adduser(connectsql.java:43)

at org.apache.jsp.Judge_jsp._jspService(Judge_jsp.java:84)