数据库连接、数据源编写

实际案例可以点击此处

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;
    }
}