lab18.java

来自「jdbc 源代码」· Java 代码 · 共 30 行

package com.jdbclab;
import java.sql.*;
public class Lab18
{
	public static void main(String[] args){
	   Connection con = null;
	   CallableStatement cs = null;
	   String sql="{call p_test(?)}";
	   try{
	     con = JdbcUtil.getConnection();
		 con.setAutoCommit(false);
		 cs = con.prepareCall(sql);
		 cs.setInt(1,100000);
		 cs.execute();
		 con.commit();
	   }catch(Exception e){
	     e.printStackTrace();
		 if(con!=null){
		   try{
		     con.rollback();
		   }catch(Exception ex){
		     ex.printStackTrace();
		   }
		 }
	   }finally{
	     JdbcUtil.release(null,cs,con);
	   }
	
	}
}