dbutil 操作笔记

//声明属性文件

Properties properties = new Properties();

//src 下面 dbcpconfig.properties 文件

properties.load(DbUtils.class.getResourceAsStream("/dbcpconfig.properties"));

//加入属性文件

DataSource dataSource = BasicDataSourceFactory.createDataSource(properties);

//获得连接

localconn = dataSource.getConnection();

//设置提交方式

localconn.setAutoCommit(false);

 

//   -------dbcpconfig.properties-----------

//            driverClassName=net.sourceforge.jtds.jdbc.Driver
//            url=jdbc:jtds:sqlserver://192.168.1.102:1432/CF_TOPSOFT_NEW
//            username=sa
//            password=12
//
//            dataSource.initialSize=10
//
//            dataSource.maxIdle=20
//
//            dataSource.minIdle=5
//           
//            dataSource.maxActive=50
//
//            dataSource.logAbandoned=true
//
//            dataSource.removeAbandoned=true
//
//            dataSource.removeAbandonedTimeout=180
//
//            dataSource.maxWait=1000

 

 

 

 

//执行方法
QueryRunner runner = new QueryRunner();
//读取返回实体类
List<ProductBean> list = (List<ProductBean>)runner .query(

                             //Connection 连接

                             localconn ,

                             //sql 语句

                             "select * from product where pid = ?" ,

                             //读取返回实体类

                             new BeanListHandler<ProductBean>(ProductBean.class) ,

                             //查询参数

                             new Object[]{endId} );

 

 

//读取返回List数组

ArrayList<Object []> column = (ArrayList<Object []>)runner .query(

                            //Connection 连接

                            localconn ,

                            //sql 语句

                            "select * from product where pid = ?" ,

                            //读取返回实体类

                            new ArrayListHandler() ,

                            //查询参数

                            params );

 

 

//修改

int result = runner.update (

                             //Connection 连接

                             remoteconn ,

                             //sql 语句

                             "delete from table" ,

                             //查询参数

                             params );

 

 

//提交

localconn.commit();