1、添加数据库相关依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.29</version>
</dependency>
2、JDBC固定六部曲
数据库基本信息配置
String url = "jdbc:mysql://localhost:3306/javaweb?useUnicode=true&characterEncoding=utf-8&useSSL=true";
//根据自己的数据库配置用户名密码
String username = "";
String password ;
(1)加载驱动
Class.forName("com.mysql.cj.jdbc.Driver");
(2)连接数据库
Connection connection = DriverManager.getConnection(url,username,password);
(3)向数据库发送SQL的对象statement
Statement statement = connection.createStatement();
(4)编写SQL(根据业务,不同的SQL语句)
String sql = "select * from users";
(5)执行SQL
ResultSet resultSet = statement.executeQuery(sql);
while(resultSet.next()){
System.out.println("id="+resultSet.getObject("id"));
System.out.println("username="+resultSet.getObject("username"));
}
(6)关闭连接
resultSet.close();
statement.close();
connection.close();
3、根据Idea右侧数据库工具来测试连接
完整代码
public class JDBCTest {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//配置信息
String url = "jdbc:mysql://localhost:3306/javaweb?useUnicode=true&characterEncoding=utf-8&useSSL=true";
String username ;
String password ;
//1.加载驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//2.连接数据库,代表数据库
Connection connection = DriverManager.getConnection(url,username,password);
//3.向数据库发送SQL对象Statement:CRUD
Statement statement = connection.createStatement();
//4.编写sql语句
String sql = "select * from users";
//5.执行查询SQL,返回一个ResultSet 结果集
ResultSet resultSet = statement.executeQuery(sql);
while(resultSet.next()){
System.out.println("id="+resultSet.getObject("id"));
System.out.println("username="+resultSet.getObject("username"));
}
//6.关闭连接,释放资源
resultSet.close();
statement.close();
connection.close();
}
}
测试结果
SQL语句
增
insert into users values(?,?)
删
delete from users where id = ?
改
update users set username= ? where id = ?
查
select * from users where(条件)