处理查询结果集
package com.etc;
import java.sql.*;
/*
* 处理查询结果集
* */
public class JdbcTest02{
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
//1.注册驱动
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
//2.获取连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3307/test","root","root");
//3.获取数据库操作对象
stmt = conn.createStatement();
//4.执行sql
String sql = "select * from db1";
//int executeUpdate(insert/delete/update)
//ResultSet executeQuery(select)
rs = stmt.executeQuery(sql);//专门执行DQL语句的方法
//5.处理查询结果集
boolean flag1 = rs.next();
//System.out.println(flag1); //true
// if (flag1){
// //光标指向的行有数据
// //取数据
// //getString()方法的特点是:不管数据库中的数据类型是什么,都以String的形式取出
//
// }
while (rs.next()){
int id = rs.getInt(1);
String name = rs.getString(2);
System.out.println(id + "," + name);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
//6.释放资源
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (stmt != null){
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}