c3p0包装update(可变类型和个数参数的函数)

来源:互联网 发布:centos tinyproxy 编辑:程序博客网 时间:2024/06/17 12:27

包装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 blocke.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);}}