c3p0包装update（可变类型和个数参数的函数）

包装updata

package zjtool2;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.mchange.v2.c3p0.ComboPooledDataSource;


public class c3p0tool {
	public static Connection getConnection(){
		Connection con = null;
		ComboPooledDataSource datasource=new ComboPooledDataSource("zj");//
		try {
			con=datasource.getConnection();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return con;
	}
	public static void update(String sql,Object...objects) throws SQLException{
		Connection con=getConnection();
		PreparedStatement prs = con.prepareStatement(sql);
		int count=prs.getParameterMetaData().getParameterCount();
		for(int i=0;i<count;i++){
			prs.setObject(i+1,objects[i]);
		}
		prs.executeUpdate();
	zjtool.jdbctool.release(prs,con);
	}
}