public class DBHelper
{
private DBHelper(){}//阻止实例化
private static final String driver="com.mysql.jdbc.Driver";
private static final String url="jdbc:mysql://localhost:3306/d_test";
private static final String user="root";
private static final String password="123";
//创建连接
public static Connection getCon()
{
Connection con=null;
try
{
Class.forName(driver);
con=DriverManager.getConnection(url, user, password);
}
catch(Exception e)
{
e.printStackTrace();
}
return con;
}
//创建数据源
public static DataSource getDatasource()
{
DruidDataSource ds=null;
try
{
ds=new DruidDataSource();
ds.setDriverClassName(driver);
ds.setUrl(url);
ds.setUsername(user);
ds.setPassword(password);
}
catch(Exception e)
{
e.printStackTrace();
}
return ds;
}
}