黑马版
- 导入jar包
- 注册驱动
- 获取数据库连接对象
- 定义sql语句
- 获取执行sql的对象 statement
- 执行sql
- 处理结果
- 释放资源
package com.bytedance.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class JDBCdemo {
public static void main(String[] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/yaojun?serverTimezone=UTC", "root","123456");
String sql = "update department set phone = 123 where id = 1";
Statement statement = conn.createStatement();
int count = statement.executeUpdate(sql);
System.out.println(count);
conn.close();
statement.close();
}
}
狂神版
参考视频
- JDBC是Java操作数据库的规范
- 应用程序—JDBC—数据库驱动(mysql)—真正的数据库
- 加载驱动
- 用户信息和URL
- 连接成功,数据库对象
- 执行SQL的对象
- 执行SQL,查看结果
- 释放连接
package com.bytedance.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Demo {
public static void main(String[] args) throws Exception {
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/yaojun?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8";
String username = "root";
String password = "123456";
Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
String sql = "select * from user";
ResultSet resultSet = statement.executeQuery(sql);
while(resultSet.next()){
System.out.print("id:"+resultSet.getObject("id"));
System.out.print(" name:"+resultSet.getObject("name"));
System.out.println(" pwd:"+resultSet.getObject("pwd"));
}
resultSet.close();
statement.close();
connection.close();
}
}
依赖包
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>