简单的使用Druid
1.创建一个lib文件
lib文件里面存放的是Mysql,druid相关的资源包,然后把这些资源导入
2.创建一个druid.properties文件,里面存放的是一些配置的文件
//存放的是mySql资源包里面的drier的路径名
drierClassName="com.mysql.cj.jdbc.Driver"
//url里面存放的是一些数据库的相关配置
//serverTimezone=Asia/Shanghai这部分如果不写可能出错,这里是你归属地的时间
url=jdbc:mysql://localhost:3306/数据库的名字/serverTimezone=Asia/Shanghai
//这个是登录数据库的用户名
username=****
//这个是登录数据库的密码
password=******************
3.这部分我们要加载配置文件里面的内容
import java.io.IOException;
import java.util.Properties;
import javax.sql.DataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
public class JDBCUtils2 {
private static Properties p = new Properties();
static {
try {
p.load(JDBCUtils2.class.getClassLoader().getResourceAsStream("druid.properties"));
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 通过运用druid里面的工具栏得到一个dataSource
* @return
* 返回一个dataSource
*/
public static DataSource getDataSource() {
try {
returnDruidDataSourceFactory.createDataSource(p);
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
}
4.应用得到的dataSource
@Test
public void test2() {
QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());
try {
Object[] obj = qr.query("select * from user where user_id in (?,?,?)", new ArrayHandler(), 1, 2, 3);
for (Object object : obj) {
System.out.println(object);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
@Test
public void test3() {
QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());
try {
List<Object[]> list = qr.query("select * from user where user_id in (?,?,?)", new ArrayListHandler(), 1, 2, 3);
for (Object[] objects : list) {
System.out.println(Arrays.toString(objects));
}
System.out.println("=============================================");
user u = qr.query("select * from user where user_id in (?,?)",new BeanHandler<user>(user.class),1,2);
System.out.println(u);
System.out.println("=============================================");
List<user> list2 = qr.query("select * from user where user_id in (?,?)",new BeanListHandler<user>(user.class),1,2);
for (user user2 : list2) {
System.out.println(user2);
}
System.out.println("=============================================");
List<Object> list3 = qr.query("select * from user where user_id in (?,?)",new ColumnListHandler(),1,2);
for (Object object : list3) {
System.out.println(object);
}
System.out.println("=============================================");
DataSource dataSource = JDBCUtils.getDataSource();
Connection conn = dataSource.getConnection();
Map<Object, Map<String, Object>> map = qr.query("select * from user", new KeyedHandler());
for (Map.Entry<Object, Map<String, Object>> entry : map.entrySet()) {
System.out.println(entry.getValue());
}
} catch (SQLException e) {
e.printStackTrace();
}
}
注重看把查询到的数据创建成对象那几个