这是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
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
解决方案 »
- 本人亲自制作的springMVC教程视频(3),持续更新中
- 问一下集群服务器环境中日志的问题
- 怎样在jstl中得到jsp中用EL表达式得到的String的长度
- 远程控制工具pcanywhere 的问题
- jsp表单,三个年月日下拉列表~ request接受到了三个参数~分别是年月日~ 怎样把3个参数变成日期型?
- 问个问题关于传值,不知道怎么解决
- 为什么 tomcat 服务总崩掉呢?
- JSP页面用户输入的信息保存问题???高分求助!!!
- 如何做一个转换??
- TOMCAT中JAVABEAN的路径设置问题(急)
- 我在从Oracle数据库中取出图片在jsp页面进行显示时出了错,但图片能在jsp中正常显示,各位大侠帮我看看是哪出的错,怎么改?
- 请教各位, 我下步应该怎么办?
http://hi.baidu.com/%C9%F1%C1%FA%B0%DA%CE%B2%CE%DE%BE%D0%CA%F8/blog/item/d9721e4bd36b0a2b08f7ef4e.html