c3p0使用

package jx.util;import java.sql.Connection;import java.sql.DatabaseMetaData;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import javax.sql.DataSource;import com.mchange.v2.c3p0.ComboPooledDataSource;public class jdbc {protected  Connection conn=null;//����oracle��ݿ�protected PreparedStatement ps=null;//Ԥ����SQL���(��ֹSQLע��)protected ResultSet rs=null;//��ѯ���protected int rtn=0;private static DataSource dataSource=null;      static{          dataSource=new ComboPooledDataSource();  //读取c3p0配置文件    }  public   void getConn(){//������ݿ�try {conn=dataSource.getConnection();System.out.println("连接数据。。。。。。。。。。。。。。。。。");} catch (Exception e) {// TODO �Զ���ɵ� catch ��e.printStackTrace();}}public void extupdate(String sql,Object...obj){//��ݸ��try {System.out.println(sql);ps=conn.prepareStatement(sql);for(int i=0;i<obj.length;i++){ps.setObject(i+1, obj[i]);}rtn=ps.executeUpdate();} catch (Exception e) {// TODO �Զ���ɵ� catch ��e.printStackTrace();}}public void extquery(String sql,Object...obj){//��ݲ�ѯtry {System.out.println(sql);ps=conn.prepareStatement(sql);for(int i=0;i<obj.length;i++){ps.setObject(i+1, obj[i]);}rs=ps.executeQuery();} catch (SQLException e) {// TODO �Զ���ɵ� catch ��e.printStackTrace();}}public void closeall(){//�ر�����try {if(conn!=null){conn.close();}if(ps!=null){ps.close();}if(rs!=null){rs.close();}System.out.println("断开连接。。。。。。。。。。。。。。。");} catch (SQLException e) {// TODO �Զ���ɵ� catch ��e.printStackTrace();}}