java while con_为什么会在while(rs1.next())报结果集已关闭

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

String UserName = "sa";

String Password = "sa";

String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String Url = "jdbc:sqlserver://127.0.0.1;database=book3";

try {

try {

Class.forName(driverName);

} catch (ClassNotFoundException e4) {

// TODO 自动生成的 catch 块

e4.printStackTrace();

}

System.out.println("数据库驱动加载成功");

con = DriverManager.getConnection(Url, UserName, Password);

} catch (SQLException e1) {

// TODO 自动生成的 catch 块

e1.printStackTrace();

}

try {

if (!con.isClosed()) {

System.out.println("数据库连接成功");

}

} catch (SQLException e2) {

// TODO 自动生成的 catch 块

e2.printStackTrace();

}

sm1 = con.createStatement();

rs1 = sm1.executeQuery("select * from system_book where book_type='" + jcb1.getSelectedItem().toString()

+ "' or book_name='" + jcb2.getSelectedItem().toString() + "' or book_author='"

+ jcb3.getSelectedItem().toString() + "' or book_address='" + jcb4.getSelectedItem().toString()

+ "' ");

while (rs1.next()) {================报结果集已关闭

String v = rs1.getString("book_number");

String v1 = rs1.getString("quantity");

String v3 = rs1.getString("book_name");

System.out.println(v);

System.out.println(v1);

System.out.println(v3);

int i = sm1

.executeUpdate("update system_book set quantity=quantity+1 where book_number='" + v + "'");

if (i == 1) {

con.commit();

System.out.println("更新成功1");

}

Statement sm2 = con.createStatement();

rs2 = sm2.executeQuery("select rent_date from rent where book_number='" + v + "'");

while (rs2.next()) {

String a = rs2.getString("rent_date");

System.out.println(a);

jtf1.setText(a);// 得到借书时间

// 得到还书时间

SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

jtf3.setText(df.format(new Date()));

String dateStr = df.format(new Date());

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

long m = 0;

m = sdf.parse(dateStr).getTime() - sdf.parse(a).getTime();

//System.out.println("11111111111");

int days = (int) m / (1000 * 60 * 60 * 24);

String a4 = days + "";

//System.out.println("222222222----"+days);

//错误开始地方

if (days > 60) {// 同时确定超期次数

int a5 = days - 60;

String a6 = a5 + "";

jtf4.setText(a6);// 得到罚款

int i3 = 0;

//System.out.println("测试222222222222");

i3 = sm2.executeUpdate(

"insert into returnbook values('" + user.user_name + "','" + jtf3.getText()

+ "','" + v + "','" + v1 + "','" + a4 + "','overbacktime+1')");

con.commit();

if (i3 == 1) {

System.out.println("插入成功2222");

}

int f = 0;

f = sm2.executeUpdate("delete from rent where book_number='" + v + "'");

con.commit();

if (f == 1) {

System.out.println("删除成功251");

}

int i1 = 0;

i1 = sm2.executeUpdate("insert into fine values('" + user.user_name + "','" + v

+ "','" + v3 + "','" + a6 + "','" + a4 + "')");

con.commit();

if (i1 == 1) {

System.out.println("插入成功6");

}

int i11 = 0;

i11 = sm2.executeUpdate("update creditrating set creditrating=creditrating-1");

con.commit();

if (i11 == 1) {

System.out.println("插入成功3");

}

}

else {

String b = "0";

int i2 = 0;

i2 = sm1.executeUpdate("insert into returnbook values('" + user.user_name + "','"

+ jtf3.getText() + "','" + v + "','" + v1 + "','" + a4 + "','" + b + "')");

con.commit();

if (i2 == 1) {

System.out.println("插入成功22");

}

jtf4.setText("0");// 罚款为0

}

}

//rs2.close();

}

//finally{

//rs1.close();

if (sm1!=null) {

sm1.close();//关闭结果集对象

}

if (con!=null) {

con.close();//关闭结果集对象

}

//}