c3p0连接池连接Sybase 简单应用

最新推荐文章于 2018-03-20 16:55:42 发布

Veteran_

最新推荐文章于 2018-03-20 16:55:42 发布

阅读量2.4k

点赞数

分类专栏：连接池连接池c3p0 连接Sybase 文章标签： sybase c3p0 exception string scroll jdbc

本文链接：https://blog.csdn.net/Veteran_/article/details/7861166

版权

连接池同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

连接池c3p0 连接Sybase

1 篇文章 0 订阅

订阅专栏

package batch;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.mchange.v2.c3p0.*;

public class c3p0demo {
   public static void main(String[] args){
       // TODO Auto-generated method stub
       String sql = "SELECT * FROM TAB_TABLE2 ";
       ComboPooledDataSource ds=new ComboPooledDataSource();
       try {
           ds.setUser( "comoa");
           ds.setPassword( "123456");
           ds.setJdbcUrl( "jdbc:sybase:Tds:192.168.1.5:5000/comoa");
           ds.setDriverClass("com.sybase.jdbc2.jdbc.SybDriver");
           //jdbc:mysql://127.0.0.1:3306/test?autoReconnect=true&useUnicode=true&characterEncoding=GB2312
           ds.setInitialPoolSize(2);
            ds.setMinPoolSize(1);
            ds.setMaxPoolSize(10);
            ds.setMaxStatements(50);
            ds.setMaxIdleTime(60);


       } catch (Exception e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
       try{
           Statement stmt=ds.getConnection().createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

           ResultSet rs=stmt.executeQuery(sql);
           while(rs.next()) {
               System.out.println(rs.getString(1));
               System.out.println(rs.getString(2));
       }

       }catch(SQLException e)
       {
           e.printStackTrace();
       }
       ds.close();
       System.out.println("asdfasdfasfasf");
   }
}