只是为了可以学的更好。
注意:
每次用完连接后,一定要关闭。
/**
* @author XiaoY
* 连接池
*/
public class ConFactoryMysql
{
private static BasicDataSource bs;
private static String driverClassName = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://localhost:3306/test";
private static String username = "root";
private static String password = "root";
public static BasicDataSource getBSPool()
{
if(null == bs)
{
bs = new BasicDataSource();
bs.setDriverClassName(driverClassName);
bs.setUrl(url);
bs.setUsername(username);
bs.setPassword(password);
bs.setMaxActive(5);
}
return bs;
}
public static void main(String[] args)
{
try
{
Connection con = ConFactoryMysql.getBSPool().getConnection();
System.out.println(con.isClosed());
con.close();
} catch (SQLException e)
{
e.printStackTrace();
}
}
}
注意:
每次用完连接后,一定要关闭。