<%@ page language="java" import="java.util.*,java.sql.*,bbs.*"
pageEncoding="GB18030"%><%
request.setCharacterEncoding("UTF-8"); int pid = Integer.parseInt(request.getParameter("pid"));
int rootId = Integer.parseInt(request.getParameter("rootId")); String title = request.getParameter("title");
System.out.println(title);
String cont = request.getParameter("cont");
System.out.println(cont); Connection conn = DB.getConn();
String sql = "insert into article values(null,?,?,?,?,sysdate,?)";
PreparedStatement pstmt = DB.prepareStmt(conn, sql);
pstmt.setInt(1, pid);
pstmt.setInt(2, rootId);
pstmt.setString(3, title);
pstmt.setString(4, cont);
pstmt.setInt(5, 0);
pstmt.executeUpdate();
DB.close(pstmt);
DB.close(conn);
%>
----------------------------------------------
数据已经能够提交,可是查询数据库发现其中的ID显示的是NULL,insert into article values(ID,pid,rootid,title,cont,pdate,isleaf) ID号不是从上一个页面传过来的不用自己设置的嘛
pageEncoding="GB18030"%><%
request.setCharacterEncoding("UTF-8"); int pid = Integer.parseInt(request.getParameter("pid"));
int rootId = Integer.parseInt(request.getParameter("rootId")); String title = request.getParameter("title");
System.out.println(title);
String cont = request.getParameter("cont");
System.out.println(cont); Connection conn = DB.getConn();
String sql = "insert into article values(null,?,?,?,?,sysdate,?)";
PreparedStatement pstmt = DB.prepareStmt(conn, sql);
pstmt.setInt(1, pid);
pstmt.setInt(2, rootId);
pstmt.setString(3, title);
pstmt.setString(4, cont);
pstmt.setInt(5, 0);
pstmt.executeUpdate();
DB.close(pstmt);
DB.close(conn);
%>
----------------------------------------------
数据已经能够提交,可是查询数据库发现其中的ID显示的是NULL,insert into article values(ID,pid,rootid,title,cont,pdate,isleaf) ID号不是从上一个页面传过来的不用自己设置的嘛
解决方案 »
- 急急急急,关于ie 和firefox显示不 兼容问题(重谢~~~)
- jsp页面如何转换保存为pdf文件呢?
- the request was rejected because no multipart boundary was found
- 下载中文名文件时出现乱码,请大家帮忙解决!!!!
- 寻速度快和稳定的虚拟空间,支持JSP
- 乱谈Java版本号
- 在jsp里面怎样自定义函数?
- 有哪位,用struts实现过分页的,进来一下,谢谢...
- 更新数据库字段的问题,很简单的,帮查看一下,在线等,很急的!!!!
- WIN2000下 Tomcat 4.1 不能启动
- 求高手给条sql 啊!!!!!!
- jsp页面上的时间算法
javax.servlet.ServletException: java.sql.SQLException: ORA-00947: 没有足够的值