mysql实现号码池_数据库链接池实现(mysql--sql server)

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Date;java

import org.apache.commons.dbcp.BasicDataSource;mysql

public class TestMysql {sql

private static BasicDataSource datasource = new BasicDataSource();

private static String DRIVERCLASS = "com.mysql.jdbc.Driver" ;

private static String URL = "jdbc:mysql://localhost/mysql" ;// 后面的一个  mysql 为数据库名

private static String USERNAME = "root" ;

private static String PASSWORD = "root" ;

/*

private String DRIVERCLASS = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;

private String URL = "jdbc:sqlserver://localhost:1433;database=pubs" ;

private String USERNAME = "sa" ;

private String PASSWORD = "" ;

*/