![](https://img-blog.csdnimg.cn/00de09bb44014cbeb3e70a5ef1a84600.png)
JDBC编程中的查询操作和增删改有所不同,因为查询出来的结果是一张二维表,我们需要特殊处理.增删改用的是executeUpdate()方法,查询则是executeQuery()方法.
数据表结构:
![](https://img-blog.csdnimg.cn/2b4fdfa801b549298029dfa5b00aa2b6.png)
💡 1. 创建数据源
//创建数据源
DataSource dataSource = new MysqlDataSource();
((MysqlDataSource)dataSource).setURL("jdbc:mysql://127.0.0.1:3306/test1?characterEncoding=utf8&useSSL=false");
((MysqlDataSource)dataSource).setUser("root");
((MysqlDataSource)dataSource).setPassword("123456");
💡 2. 建立连接
Connection connection = dataSource.getConnection();
💡 3. 封装对象
//对象
String sql = "select * from student";
PreparedStatement statement = connection.prepareStatement(sql);
💡4. 发送
//发送
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
System.out.println("id: "+id+" name: "+name);
}
💡 5. 释放资源
//释放
resultSet.close();
statement.close();
connection.close();
💡 6. 结果
![](https://img-blog.csdnimg.cn/65d9d031288d47d2beef9b7005eba307.png)