代码如下:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="conn.jsp"%>
<html>
<head>
<title>first jsp</title>
</head>
<body>
<%
sql="select id from info";
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
rs.moveToInsertRow();
rs.updateInt("id", 110);
rs.insertRow();
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
死活不成功,报错
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
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: com.microsoft.sqlserver.jdbc.SQLServerException: 游标是 READ ONLY 的。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.lsj.counter_jsp._jspService(counter_jsp.java:120)
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:377)
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
com.microsoft.sqlserver.jdbc.SQLServerException: 游标是 READ ONLY 的。
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39)
com.microsoft.sqlserver.jdbc.SQLServerResultSet.doInsertRowRPC(SQLServerResultSet.java:3967)
com.microsoft.sqlserver.jdbc.SQLServerResultSet.access$100(SQLServerResultSet.java:16)
com.microsoft.sqlserver.jdbc.SQLServerResultSet$1InsertRowRPC.doExecute(SQLServerResultSet.java:3857)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
com.microsoft.sqlserver.jdbc.SQLServerResultSet.insertRow(SQLServerResultSet.java:3922)
org.apache.jsp.lsj.counter_jsp._jspService(counter_jsp.java:101)
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:377)
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)