JDBC中连接池的使用

最新推荐文章于 2023-12-18 18:23:41 发布

疯狂的代码

最新推荐文章于 2023-12-18 18:23:41 发布

阅读量515

点赞数

分类专栏： JDBC

本文链接：https://blog.csdn.net/maxiaoming_07/article/details/8744542

版权

JDBC 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

package com.pool;
import java.sql.*;

import org.apache.commons.dbcp.BasicDataSource;
public class TestConnectionPool {

  /**
   * @param args
   */
  public static void main(String[] args) {
    execute();
  }
  
  public static void execute(){
    String url = "jdbc:oracle:thin:@192.169.0.26:1521:tarena";
    String driver = "oracle.jdbc.driver.OracleDriver";
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(driver);
    ds.setUrl(url);
    ds.setUsername("openlab");
    ds.setPassword("open123");
    try {
      Connection conn = ds.getConnection();
      Statement stmt = conn.createStatement();
      ResultSet rs = 
        stmt.executeQuery(
            "select count(*) from mystu");
      if (rs.next()){
        System.out.println(rs.getInt(1));
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }finally {
      try {
        ds.close();
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
    
  }

}