create sequence seq_article increment by 1 start with 1;
create table article(
id int primary key not null,
pid int,
rootid int,
title varchar2(255),
cont varchar2(4000),
pdate date,
isleaf int
);
insert into article (id,pid,rootid,title,cont,pdate,isleaf) values(seq_article.nextval, 0,1,'你好','大家好',sysdate,1);
这是往数据库里插入数据时的语句,设置id号是自动增加的<%@page pageEncoding="UTF-8"%>
<%@page import="java.sql.*,bbs.*"%>
<%
request.setCharacterEncoding("UTF-8");
String action = request.getParameter("action");
if (action != null && action.trim().equals("post")) {
String title = request.getParameter("title");
//System.out.println(title);
String cont = request.getParameter("cont");
//System.out.println(cont); Connection conn = DB.getConn();
boolean autoCommit = conn.getAutoCommit();
conn.setAutoCommit(false);
String sql = "insert into article values(seq_article.nextval,?,?,?,?,sysdate,?)";
PreparedStatement pstmt = DB.prepareStmt(conn, sql,Statement.RETURN_GENERATED_KEYS); pstmt.setInt(1, 0);
pstmt.setInt(2, 1);
pstmt.setString(3, title);
pstmt.setString(4, cont);
pstmt.setInt(5, 0);
pstmt.executeUpdate();
ResultSet rsKey = pstmt.getGeneratedKeys();
rsKey.next();
int rootId= rsKey.getInt(1);
Statement stmt = DB.createStmt(conn);
stmt.executeUpdate("update article set rootid=" + rootId + " where id="+ rootId);
conn.commit();
conn.setAutoCommit(autoCommit);
DB.close(stmt);
DB.close(pstmt);
DB.close(conn);
response.sendRedirect("article.jsp");
}
%>这是发表新主题的页面,提交的时候提示int rootId= rsKey.getInt(1);这一句出错
错误提示:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:519)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:410)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root causejavax.servlet.ServletException: java.sql.SQLException: 无效的列类型: getInt not implemented for class oracle.jdbc.driver.T4CRowidAccessor
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:865)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794)
org.apache.jsp.post_jsp._jspService(post_jsp.java:240)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
在网上查了一下,说ORACLE中 getGeneratedKeys() 拿不到sequence 的nextval,但不知道怎么改。~~~~~
javax.servlet.ServletException: java.sql.SQLException: 无效的列索引
最好的办法就是写个触发器,那么这里你就不需要你去手动指定了。
看看
用getLong试试
rs.next();
String rowid= rs.getString(1);//获得rowid
ps = conn.prepareStatement("select t.micrateruleid from T_MICRATE_RULE t where rowid = ?");
ps.setString(1, rowid);
ResultSet rest2 = ps.executeQuery();
rest2.next();
id=Long.parseLong(rest2.getString(1));