java连接数据库使用queryrunner对数据库进行操作
1.下载下面的jar包;官网:https://mvnrepository.com/artifact/mysql/mysql-connector-java
2.在Ecplise中创建一个Dynamic Web project 项目 配置好Tomcat
3.在javaScource的src目录下创建一个db.properties和一个工具包package :com.hui.utils
4.db.properties添加代码如下:
url=jdbc:mysql://localhost:3306/crebas?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
username=root
password=123456
6.在工具包创建一个java类
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.commons.dbcp2.BasicDataSourceFactory;
//如果没有这个包需要到官网下载
public class propertiesUtil {
public static Properties properties = new Properties();
static {
try {
InputStream is=propertiesUtil.class.getClassLoader().getResourceAsStream("db.properties");
properties.load(is);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static DataSource getDataSource() {
try {
return BasicDataSourceFactory.createDataSource(properties);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
}
```java
在这里插入代码片
7.在src下建一个test.java
添加代码如下`
`package com.hui.dao;
import java.sql.SQLException;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ArrayHandler;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import com.hui.utils.propertiesUtil;
public class test {
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
QueryRunner queryRunner=new QueryRunner(propertiesUtil.getDataSource());
String sql = "SELECT * FROM student1";
//调用queryrunner的query查询方法
Object[] result = queryRunner.query(sql, new ArrayHandler());
for(Object obj:result) {
System.out.print(obj + " ");
}
}
}##
8.右键运行run-as->java application
看控制台是否有输出数据库里的student表的信息
若输出则连接成功
需要的jar包:
本文地址:https://blog.csdn.net/weixin_45330152/article/details/107290632