JSP 发表新主题总报错求助！！

Summerle 2012-06-29 03:50:18



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 cause

javax.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，但不知道怎么改。。。。~~~~~

...全文

223 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

mesada_yangzaixing 2013-08-17

打赏
举报

rs = ps.getGeneratedKeys(); 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));