2020-12-02

最新推荐文章于 2024-02-05 16:30:00 发布

爱吃芝士的小王

最新推荐文章于 2024-02-05 16:30:00 发布

阅读量114

点赞数 1

本文链接：https://blog.csdn.net/AWYn121/article/details/110497266

版权

java.sql.SQLException: Operation not allowed after ResultSet closed这个报错问题求解决

<%@page import="java.sql.SQLClientInfoException"%>
<%@page import="java.sql.SQLException"%>
<%@page import="SQL_java_con.Sql_con"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
	Connection con=null;
	Statement sql;
	ResultSet rs1,rs2;
	con=Sql_con.getCon();
	try{
		int n=50;
		con.setAutoCommit(false);//关闭自动提交模式
		sql=con.createStatement();
		rs1=sql.executeQuery("select userMoney from bank where name='王卫'");
		rs1.next();
		double oneMoney=rs1.getDouble("userMoney");
		rs2=sql.executeQuery("select userMoney from bank_2 where name='万颜'");
		rs2.next();
		double shouMoney=rs2.getDouble("userMoney");
		out.print("转账前万颜的userMoney的值是"+shouMoney+"<br>");
		out.print("转账后王卫的userMoney的值是"+oneMoney+"<br>");
		oneMoney=oneMoney-n;
		if(oneMoney>=0){
			shouMoney=shouMoney+n;
			sql.executeUpdate("update bank_2 set userMoney="+shouMoney+"where name='万颜'");
			//rs1.last();
			sql.executeUpdate("update bank set userMoney="+oneMoney+"where name='王卫'");
			//rs2.last();
			con.commit();//事务处理
			
		}
		rs1=sql.executeQuery("select * from bank where name='王卫'");
		//rs1.last();
		rs2=sql.executeQuery("select * from bank_2 where name='万颜'");
		//rs2.last();
		out.print("转账后的最后情况如下<br>");
		while(rs1.next()){
			out.print(rs1.getString(2)+"");
			out.print(rs1.getString(3));
			out.print("<br>");
		}
		while(rs2.next()){
			out.print(rs2.getString(2)+"");
			out.print(rs2.getString(3));
			out.print("<br>");
			
		}
		con.close();
	}catch(SQLException e){
		try{
			con.rollback();//回滚
		}catch(SQLClientInfoException exp){}
		out.print(e);
	}
%>
</body>
</html>

求大神赐教！！！！

爱吃芝士的小王

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
2020-12-02

java.sql.SQLException: Operation not allowed after ResultSet closed这个报错问题求解决<%@page import="java.sql.SQLClientInfoException"%><%@page import="java.sql.SQLException"%><%@page import="SQL_java_con.Sql_con"%><%@page import="java.sql.R
复制链接

扫一扫