使用工具
IDEA
MYSQL
Navicat Premium
创建maven项目
导入依赖
创建数据库
create table account(
id int primary key auto_increment,
name varchar(40),
money float
)character set utf8 collate utf8_general_ci;
insert into account(name,money) values('aaa',1000);
insert into account(name,money) values('bbb',1000);
insert into account(name,money) values('ccc',1000);
输入代码后点击运行,然后右键spring_demo下的表刷新,得到创建的表
创建java类
import java.sql.*;
public class JdbcDemo {
public static void main(String[] args) throws Exception {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
// 1、注册驱动
Class.forName("com.mysql.jdbc.Driver");
// DriverManager.registerDriver(new com.mysql.jdbc.Driver());
// 2、获取连接
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/spring_demo?serverTimezone=UTC",
"root","123456");
// 3、获取操作数据库的预处理对象
PreparedStatement pstm = conn.prepareStatement("select * from account");
// 4、执行SQL,得到结果集
ResultSet rs = pstm.executeQuery();
// 5、遍历结果集
while (rs.next()){
System.out.println(rs.getString("name"));
}
// 6、释放资源
rs.close();
pstm.close();
conn.close();
}
}