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();
}
}
}
}
jdbc----Statement应用场景
最新推荐文章于 2022-03-03 20:42:36 发布