1、导包
2、导入DruidUtil类
package com.atshiyou.util;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import javax.xml.transform.Result;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class DruidUtil {
private static DataSource ds;
static{
try {
Properties ppt = new Properties();
ppt.load(DruidUtil.class.getClassLoader().getResourceAsStream("druid.properties"));
ds = DruidDataSourceFactory.createDataSource(ppt);
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 从连接池中取出一个连接给用户
* @return
*/
public static Connection getConnection(){
try {
return ds.getConnection();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return null;
}
public static void close(Connection conn, Statement state, ResultSet rs){
try {
rs.close();
} catch (Exception throwables) {
throwables.printStackTrace();
}
try {
state.close();
} catch (Exception throwables) {
throwables.printStackTrace();
}
try {
conn.close();
} catch (Exception throwables) {
throwables.printStackTrace();
}
}
}
3、导入配置文件
url=jdbc:mysql://localhost:3306/express?useUnicode=true&characterEncoding=utf-8
username=root
password=123456
driverClassName=com.mysql.jdbc.Driver
initialSize=5
maxActive=10
minIdle=5
maxWait=3000
4、使用
比如,某个类中需要连接数据库,直接继承DruidUtil
那么类中的所有方法就可以直接使用了
public class StudentDaoImpl extends DruidUtil implements StudentDao {
List<Student> list = new ArrayList<>();
@Override
public List<Student> findAll() {
Connection connection = getConnection();
PreparedStatement statement = null;
ResultSet resultSet = null;
String sql = "select * from student";
try {
statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();
while(resultSet.next()) {
Student student = new Student();
student.setStudentid(resultSet.getInt("studentid"));
student.setGradeid(resultSet.getInt("gradeid"));
student.setStuage(resultSet.getInt("stuage"));
student.setStudentno(resultSet.getString("studentno"));
student.setStuname(resultSet.getString("stuname"));
list.add(student);
}
} catch (SQLException throwables) {
throwables.printStackTrace();
} finally {
close(connection,statement,resultSet);
}
return list;
}
}