环境准备
- IDEA
- mysql
- SQLyog
详细步骤
- 添加依赖
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.15</version>
</dependency>
</dependencies>
- 创建数据库User,创建数据库表user
userId | username | password |
---|---|---|
1 | zgq | 123456 |
2 | tm | 124456 |
3 | se | 78872 |
- 使用jdbc步骤
- 注册驱动
- 获取连接
- 获取操作数据库的与处理对象
- 执行sql语句
- 遍历结果集
- 释放资源
public class JdbcDemo {
public static void main(String[] args) throws SQLException {
//1.注册驱动
DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
//2.获取连接
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=gbk&useJDBCCompliantTimezoneShift=true&serverTimezone=UTC","root","123456");
//3.获取操作数据库的预处理对象
PreparedStatement pstm=conn.prepareStatement("select *from user");
//4.执行sql,得到结果集
ResultSet rs = pstm.executeQuery();
//5.遍历结果集
while (rs.next()){
System.out.println(rs.getString("username"));
}
//6.释放资源
rs.close();
pstm.close();
conn.close();
}
}
特别注意:本文章是学习Spring视频教程 -IEDA版-4天-2018黑马SSM 所记录知识总结