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);
		}
	}

}