jdbc----Statement应用场景

package com.Jdbc;

import java.sql.*;
import java.util.Scanner;

public class test03 {
    public static void main(String args[] ){
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        System.out.println("请输入 1(管理员) 2(经理) 3(员工) ");
        Scanner in = new Scanner(System.in);
        String role = in.nextLine();

        try{
            //1.注册驱动
            DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
            //2.获取数据库连接
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/sm?useUnicode=true&useEncoding=utf8","root","root");
            //3.获取数据库执行对象
            statement = connection.createStatement();
            //4.执行sql语句
            String sql = "select  userName from smbms_user order by id "+role;
            resultSet = statement.executeQuery(sql);
            //5.返回结果集
            while(resultSet.next()){
                String userName = resultSet.getString("userName");
                System.out.println(userName);
            }

        }catch(SQLException e){
            e.printStackTrace();
        }finally{
            //6.释放资源
            if (resultSet!=null){
                try {
                    resultSet.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

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

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

    }
}