jsp代码是:<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%> <html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@thl:1521:esako";
//orcl为你的数据库的SID
String user="scott";
String password="thl132";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test1";
ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html> 结果只显示:数据库操作成功,恭喜你
没有我要提出的数据啊!我的test1表的数据:F1 F2
---------- ----------
t11 t12
t21 t22我把while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
改成:%> <%=rs.getString("F1")%> 后,结果是:
javax.servlet.ServletException: 结果集已耗尽
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.test_jsp._jspService(org.apache.jsp.test_jsp:80)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: 结果集已耗尽
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
oracle.jdbc.driver.ScrollableResultSet.getOracleObject(ScrollableResultSet.java:496)
oracle.jdbc.driver.ScrollableResultSet.getString(ScrollableResultSet.java:515)
oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1515)
org.apache.jsp.test_jsp._jspService(org.apache.jsp.test_jsp:60)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)我该怎么办?
<%@ page import="java.sql.*"%> <html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@thl:1521:esako";
//orcl为你的数据库的SID
String user="scott";
String password="thl132";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test1";
ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html> 结果只显示:数据库操作成功,恭喜你
没有我要提出的数据啊!我的test1表的数据:F1 F2
---------- ----------
t11 t12
t21 t22我把while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
改成:%> <%=rs.getString("F1")%> 后,结果是:
javax.servlet.ServletException: 结果集已耗尽
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.test_jsp._jspService(org.apache.jsp.test_jsp:80)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: 结果集已耗尽
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
oracle.jdbc.driver.ScrollableResultSet.getOracleObject(ScrollableResultSet.java:496)
oracle.jdbc.driver.ScrollableResultSet.getString(ScrollableResultSet.java:515)
oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1515)
org.apache.jsp.test_jsp._jspService(org.apache.jsp.test_jsp:60)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)我该怎么办?
不行哦!!!!!
String sql="select * from test1";
ResultSet rs=stmt.executeQuery(sql); 改为:
String sql="select * from test1";
PreparedStatement stmt=conn.prepareStatement(sql);
ResultSet rs=pstmt.executeQuery();
没有显示我查询的结果。
不过挺谢谢chzwin(成志)的!
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
改成:%> <%=rs.getString("F1")%>
=============================================没看明白,怎么改的?
感觉应该没有问题了
========================
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%> <html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@thl:1521:esako";
//orcl为你的数据库的SID
String user="scott";
String password="thl132";
Connection conn= DriverManager.getConnection(url,user,password);
String sql="select * from test2";
PreparedStatement stmt=conn.prepareStatement(sql);
ResultSet rs=stmt.executeQuery();
rs.next();
%> <%=rs.getString(1)%> <%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
我的jsp代码没问题,
是我数据库的数据没有提交----我在sqlplus中进行了insert后,都没有commit,虽然能看到我的test1表的数据:F1 F2
---------- ----------
t11 t12
t21 t22
但是实际上表里什么都没有
感谢大家了。
这不是笑话问题,很多都犯过,我就是其中一个。
曾经没commit,结果在hibernate中插入数据出现死锁。