jdbc处理查询结果集

处理查询结果集

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();
                }
            }
        }
    }
}