General error帮我看看

yangjiyue 2004-12-21 04:53:31

我写了一个连接数据库的和一个对各个表操作的BEAN
代码如下
package com.solve.myjsp;
import java.util.*;
import java.io.*;
import java.sql.*;
import dbClass.*;
import table.*;

public class insertbean{
private szjzbean szjzb;
private Connection con;
public insertbean(){
String ClassforName="sun.jdbc.odbc.JdbcOdbcDriver";
String Url="jdbc:odbc:solve";
String User="gas";
String Pas="aav";
try
{
Class.forName(ClassforName);
con=DriverManager.getConnection(Url,User,Pas);
}
catch(Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}
}
public void setszjzb(szjzbean szjzb){
this.szjzb=szjzb;
}
public void insert() throws Exception {
String sql="insert into zh_szjz values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1,szjzb.getXH());
pstmt.setString(1,szjzb.getXM());
pstmt.setString(1,szjzb.getJTTJ());
pstmt.setString(1,szjzb.getXSLB());
pstmt.setString(1,szjzb.getXKLB());
pstmt.setString(1,szjzb.getPYLB());
pstmt.setString(1,szjzb.getSXKPCJ());
pstmt.setString(1,szjzb.getZQKHCJ());
pstmt.setString(1,szjzb.getXWLWCJ());
pstmt.setString(1,szjzb.getNJPM());
pstmt.setInt(1,szjzb.getPJXFJ());
pstmt.setString(1,szjzb.getSFBG());
pstmt.setInt(1,szjzb.getKKS());
pstmt.setString(1,szjzb.getSFWB());
pstmt.setString(1,szjzb.getSFBJG());
pstmt.setString(1,szjzb.getSFWFTL());
pstmt.setInt(1,szjzb.getLWHXPS());
pstmt.setInt(1,szjzb.getLWSJPS());
pstmt.setString(1,szjzb.getLJXGZ());
pstmt.setString(1,szjzb.getQXBGZ());
pstmt.setString(1,szjzb.getQJCGZ());
pstmt.setString(1,szjzb.getSFSHXS());
pstmt.setString(1,szjzb.getSFYXXG());
pstmt.setString(1,szjzb.getSFHWTMC());
pstmt.setString(1,szjzb.getSFHJXJ());
pstmt.setInt(1,szjzb.getGZNS());
pstmt.setString(1,szjzb.getSFZSZG());
pstmt.setString(1,szjzb.getPQZRQ());
pstmt.setString(1,szjzb.getBYYF());
pstmt.setString(1,szjzb.getSFTQBY());
pstmt.setInt(1,szjzb.getNJ());
pstmt.executeUpdate();

}
}
jsp中的代码如下
<jsp:useBean class="com.solve.myjsp.szjzbean" id="szjz" scope="request"/>
<jsp:setProperty name="szjz" property="*"/>
<jsp:useBean id="insert" class="com.solve.myjsp.insertbean" scope="request"/>
<%
insert.setszjzb(szjz);
insert.insert();
out.print("success");
%>
出现了下面的错误
exception

javax.servlet.ServletException: General error
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.solve.view_jsp._jspService(view_jsp.java:79)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

root cause

java.sql.SQLException: General error
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6908)
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3104)
sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:214)
sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPreparedStatement.java:136)
com.solve.myjsp.insertbean.insert(insertbean.java:64)
org.apache.jsp.solve.view_jsp._jspService(view_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

note The full stack trace of the root cause is available in the Tomcat logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.0.19

...全文