一 .获取数据库连接
1.1 首先要创建jdbc.properties配置文件,声明在src目录下 内容如下
- user=root
- password=123456
- url=jdbc:mysql://localhost:3306/test
- driverClass=com.mysql.jdbc.Driver
1.2连接数据库(通用)
- public static Connection getConnection(){
- //加载配置文件
- InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");
- Properties pros = new Properties();
- pros.load(is);
- //读取配置信息
- String user = pros.getProperties("user");
- String password = pros.getProperties("password");
- String url = pros.getProperties("url");
- String driverClass = pros.getProperties("driverClass");
- //加载驱动
- Class.forName(driverClass);
- //获取链接
- Connection conn = DriverManager.getConnection(url,user,password);
- return conn;
- }
后面可以将这个方法,放在JDBCUtils.java里面
德鲁伊连接池
public class JdbcUtils{
private ststic DruidDataSource datasource;
ststic{
Properties properties = new Properties;
//读取jdbc.properties属性配置文件
InputStream inputstream = JdbcUtils.class.getResourceAsStream("jdbc.properties")
//从流中加载数据
properties.load(inputstream );
//创建数据库连接池
datasource =(DruidDataSource ) DruidDataSourceFactory.creatDataSource(properties);
}
public static Connection getConnection(){
Connection conn = null;
try{
conn = dataSource.getConnection();
}catch {
}
return conn;
}
}