噢:忘了错误信息:
--------------------------------如下:
500 Servlet Exception
java.lang.NullPointerException
at _first._register_0confirm__jsp._jspService(/first/register_confirm.jsp:25)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:342)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:272)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
Resin 2.1.4 (built Fri Aug 2 14:16:52 PDT 2002)
--------------------------------如下:
500 Servlet Exception
java.lang.NullPointerException
at _first._register_0confirm__jsp._jspService(/first/register_confirm.jsp:25)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:342)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:272)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
Resin 2.1.4 (built Fri Aug 2 14:16:52 PDT 2002)
解决方案 »
- linux乱码
- 关于Tomcat 7绑定域名的问题
- 图片循环问题!请各位大虾帮帮忙,急啊!!!!!!
- 请教jsp:plugin加载applet传递参数的一个问题?
- *dll already loaded in another classloader 连接db2数据库时常出现这样的错误!!怎样解决???
- 为了消除jsp页面上的java代码
- 利用jsp做简单购物车 出现问题
- java程序调试,都快一个星期了,我都没有解决
- 只能用JSP,没有数据库支持,能做搜索引擎吗?
- windows 98 用jsp 应该需要什么环境.怎么配置.
- 在tomcat中可以设置数据库连接池吗?
- 为何提交表单,没有反应,我怎样......
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close(); //在这里的时候你已经把数据库连接close掉了。在jsp里用的时候 conn.close();//当然出错啦!不要关闭试试看!
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
}
try {
Class.forName(sDBDriver).newInstance();
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("有错啦:mydb(): " + e.getMessage());
}
}
代码如下:--------------------------
package mydb;
import java.sql.*;public class mydb {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:sunshine";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public mydb() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("mydb(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
import java.sql.*;
public class database
{
ResultSet rs=null;
Connection conn=null;
public database()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database():"+e.getMessage()) ;
}
}
public ResultSet executeQuery(String sql)
{
rs=null;
try
{
conn=DriverManager.getConnection("jdbc:odbc:kkk");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("executesql:"+ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql)
{
int i=0;
try
{
conn=DriverManager.getConnection("jdbc:odbc:kkk");
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
i=1;
return i;
}
catch(SQLException ex)
{
System.err.println("executesql:"+ex.getMessage());
i=-1;
return i;
}
}
}