package com.jdbclab;
import java.sql.*;

public class Lab10
{
	public static void main(String[] args){
	  Connection con = null;
	  PreparedStatement ps = null;
	  ResultSet rs = null;
	  try{
	    con = JdbcUtil.getConnection();
		//1.關閉自動提交
		con.setAutoCommit(false);
		//2.進行若干數據庫操作
		String sql =
		  "insert into t_sd0709_test values(?,?)";
		ps = con.prepareStatement(sql);
		//ps.setInt(1,1000);
		//ps.setString(2,"Black");
		//ps.executeUpdate();
		for(int i=101;i<121;i++){
		  ps.setInt(1,i);
		  ps.setString(2,"Rose"+i);
		  ps.executeUpdate();
		}
		JdbcUtil.release(ps);
		sql = "select * from t_sd0709_test order by id";
		ps = con.prepareStatement(sql);
		rs = ps.executeQuery();
		JdbcUtil.printRs(rs);
		JdbcUtil.release(rs);
		//3.提交或回滾
		//con.commit();
        rs = ps.executeQuery();
		System.out.println("-------second select------");
		JdbcUtil.printRs(rs);
	  }catch(Exception e){
	    e.printStackTrace();
		try{
		  if(con!=null) con.rollback();
		}catch(Exception ex){
		  ex.printStackTrace();
		}
	  }finally{
	    JdbcUtil.release(rs,ps,con);
	  }
	
	} 
}