这是category.jsppackage com.jnkaixin.shopping;import java.sql.*;import com.jnkaixin.shopping.util.*;public class CategoryDAO {
public static void save(Category c){
Connection conn = null;
PreparedStatement pstmt=null;
try {
conn = DB.getConn();
String sql = "insert into category values (?, ?, ?, ?, ?, ?)"; 
pstmt = DB.getpStmt(conn,sql);
pstmt.setInt(1, c.getId());
pstmt.setString(2, c.getName());
pstmt.setString(3, c.getDescr());
pstmt.setInt(4, c.getPid());
pstmt.setInt(5, c.isLeaf() ?  0 : 1);
pstmt.setInt(6, c.getGrade());
pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
DB.closeStmt(pstmt);
DB.closeConn(conn);

}           

}}
插不进去,以下是报的错误。
2009-4-8 2:11:23 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\jdk1.5.0_17\bin;.;C:\WINDOWS\system32;C:\WINDOWS; c:\ProgrameFiles;c:\jdk1.5.0_17\bin;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\Program Files\StormII\Codec;C:\Program Files\StormII;D:\Backup\QQ\369619017\Codec;D:\Backup\QQ\369619017
2009-4-8 2:11:23 org.apache.coyote.http11.Http11BaseProtocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
2009-4-8 2:11:23 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 828 ms
2009-4-8 2:11:24 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2009-4-8 2:11:24 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/5.5.27
2009-4-8 2:11:24 org.apache.catalina.core.StandardHost start
信息: XML validation disabled
2009-4-8 2:11:24 org.apache.coyote.http11.Http11BaseProtocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2009-4-8 2:11:24 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2009-4-8 2:11:24 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/141  config=null
2009-4-8 2:11:24 org.apache.catalina.storeconfig.StoreLoader load
信息: Find registry server-registry.xml at classpath resource
2009-4-8 2:11:24 org.apache.catalina.startup.Catalina start
信息: Server startup in 1094 ms
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'pid' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3513)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
at com.jnkaixin.shopping.CategoryDAO.save(CategoryDAO.java:22)
at com.jnkaixin.shopping.Category.addTopCategory(Category.java:59)
at org.apache.jsp.admin.categoryadd_jsp._jspService(categoryadd_jsp.java:65)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
2009-4-8 2:14:44 org.apache.catalina.core.StandardContext reload
信息: Reloading this Context has started