使用前,需要先引入依赖
<!-- mysql数据库驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- 数据库连接工具包 -->
<dependency>
<groupId>commons-dbutils</groupId>
<artifactId>commons-dbutils</artifactId>
<version>1.6</version>
</dependency>
使用
1、建立连接
2、查询及修改语句
//连接数据库
String url = "";
String username = "";
String pwd = "";
Connection connection ;
try {
connection = DriverManager.getConnection(url,username,pwd);
//连接数据库做操作
QueryRunner queryRunner = new QueryRunner();
//查询结果返回一个字段
String sql = "'";
//查询结果返回的是一个字段
Object result = queryRunner.query(connection,sql,new ScalarHandler<>());
System.out.println("查询结果"+result);
//查询结果返回一条数据,new MapHandler())返回数据存储的类型
String sql1 = "";
Map<String,Object> result1 = queryRunner.query(connection,sql1,new MapHandler());
System.out.println(result1);
//查询结果返回多条数据,new MapListHandler()表示返回数据封装的类型
String sql2 = "";
List<Map<String,Object>> reslut3 = queryRunner.query(connection,sql2,new MapListHandler());
System.out.println(reslut3);
//更新数据库数据、删除
String sql3 = "";
queryRunner.update(connection,sql3);
封装成方法
/**
* 建立数据库连接
* @return
*/
public static Connection getConnection(){
//连接数据库
String url = "";
String username = "";
String pwd = "";
Connection connection;
try {
connection = DriverManager.getConnection(url,username,pwd);
} catch (SQLException e) {
throw new RuntimeException(e);
}
return connection;
}
/**
* 查询数据库返回的是单个字段
* @param sql
* @return
*/
public static Object querySingleData(String sql){
Connection connection = getConnection();
QueryRunner queryRunner = new QueryRunner();
Object result;
try {
result = queryRunner.query(connection,sql,new ScalarHandler<>());
} catch (SQLException e) {
throw new RuntimeException(e);
}
return result;
}
/**
* 查询接口是一条或者多条数据
* @param sql
* @return
*/
public static List<Map<String, Object>> queryListData(String sql){
Connection connection = getConnection();
QueryRunner queryRunner = new QueryRunner();
List<Map<String,Object>> result;
try {
result = queryRunner.query(connection,sql,new MapListHandler());
} catch (SQLException e) {
throw new RuntimeException(e);
}
return result;
}