?? lab11.java
字號:
package day02;
import java.sql.*;
public class Lab11 {
public static void main(String[] args) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "insert into xun" + "values(?,?)";
if (args.length != 1) {
System.out.println("+++++++++++++++++");
return;
}
try {
con = JdbcUtil.getConnection();
con.setAutoCommit(false);
ps = con.prepareStatement(sql);
for (int i = 180; i < 200; i++) {
ps.setInt(1, i);
ps.setString(2, "user" + i);
ps.executeUpdate();
}
sql = "select * from xun " + "where studentId >?";
JdbcUtil.release(ps);
ps = con.prepareStatement(sql);
ps.setInt(1, 179);
rs = ps.executeQuery();
JdbcUtil.release(rs);
if ("c".equals(args[0])) {
con.commit();
} else {
con.rollback();
}
System.out.println("--------------send-------------");
JdbcUtil.release(rs);
ps.setInt(1, 179);
rs = ps.executeQuery();
JdbcUtil.release(rs);
} catch (Exception e) {
e.printStackTrace();
if (con != null) {
try {
con.rollback();
} catch (Exception ek) {
ek.printStackTrace();
}
}
} finally {
JdbcUtil.release(rs, ps, con);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -