JDBC各个类详解--ResultSet--基本使用，JDBC练习--select

黑马程序员

JDBC各个类详解–ResultSet–基本使用

package cn.itcast.jdbc;

import java.sql.*;

public class Jdbc_Test2 {

    public static void main(String[] args) {
        Connection conn = null;
        Statement statement = null;
        ResultSet resultSet=null;

        try {
            //1.导入jar包
            //2.注册驱动
            Class.forName("com.mysql.jdbc.Driver");
            //3.获取数据库链接对象
            //("jdbc:mysql://127.0.0.1:3306/db03","root","jia5211314")
            conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/db03","root","jia5211314");
            //4.定义sql语句
            String sql="select * from dept";
            //5.获取执行sql的对象Statement
            statement = conn.createStatement();
            //6.执行sql
            resultSet = statement.executeQuery(sql);
            while (resultSet.next()){
                System.out.print(resultSet.getString(1));
                System.out.print(resultSet.getString(2));
                System.out.println(resultSet.getString(3));
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if(statement!=null){
                try {
                    statement.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(conn!=null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

            if (resultSet!=null){
                try {
                    resultSet.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }



    }
}

1研发部db03
2人事部db03
3财务部db03
4市场部db03
5运维部db03

JDBC练习–select

• 释放资源
  
• main
  
  案例简单，明白思想即可