宿舍人员信息管理系统【控制台+MySQL】（Java课设）

import java.sql.*; import java.util.Scanner; public class Main { //创建Scanner对象来进行键盘输入 public static Scanner scanner = new Scanner(System.in); //插入 public static void insert() throws SQLException { System.out.println("----------录入宿舍人员信息----------"); System.out.println("学号"); //用scanner对象的对应的nextInt方法来实现键盘输入 String num = scanner.next(); System.out.println("宿舍号"); String room = scanner.next(); System.out.println("床位号"); String bed= scanner.next(); System.out.println("专业"); String mojor= scanner.next(); System.out.println("姓名"); String name = scanner.next(); System.out.println("辅导员姓名"); String fdy = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; //创建PreparedStatement对象用来执行数据库语句 PreparedStatement stmt = null; ResultSet rs = null; try { //调用工具类JDBCUtils来获得一个Connection连接对象 con = JDBCUtils.getConnection(); //定义一个sql语句 String sql = "insert into people values(?,?,?,?,?,?)"; // 执行sql语句 stmt = con.prepareStatement(sql); //定义每个？号对用的参数 stmt.setString(1, num); stmt.setString(2, room); stmt.setString(3, bed); stmt.setString(4, mojor); stmt.setString(5, name); stmt.setString(6, fdy); //执行数据库操作 stmt.executeUpdate(); System.out.println("增加成功！！！"); } catch (Exception e) { // 打印异常 e.printStackTrace(); }finally { //调用JDBCUtils的close方法关闭上面的三个对象 JDBCUtils.close(rs, stmt, con); } } //显示所有信息 public static void selectAll() throws SQLException { //注册驱动 使用驱动连接数据库 Connection con = null; Statement stmt = null; ResultSet rs = null; try { //数据库的连接 con = JDBCUtils.getConnection(); //调用Connection对象的createStatement方法得到一个Statement对象 stmt = con.createStatement(); //返回一个结果集 rs =stmt.executeQuery("select * from people"); System.out.println("---------------------查询结果如下所示---------------------"); while(rs.next()) { System.out.println(); System.out.println("学号："+rs.getString("num")+"\t宿舍号："+rs.getString("room") +"\t床位号："+rs.getString("bed")+"\t专业："+rs.getString("major") +"\t姓名："+rs.getString("name")+"\t辅导员姓名："+rs.getString("fdy")); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } } //根据编号修改 public static void updateById() throws SQLException { System.out.println("----------根据学号修改宿舍人员信息----------"); System.out.println("请输入需要修改的学号"); String num = scanner.next(); System.out.println("请输入需要修改的宿舍号"); String room = scanner.next(); System.out.println("请输入需要修改的床位号"); String bed= scanner.next(); System.out.println("请输入需要修改的专业"); String mojor= scanner.next(); System.out.println("请输入需要修改的姓名"); String name = scanner.next(); System.out.println("请输入需要修改的辅导员姓名"); String fdy = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { con = JDBCUtils.getConnection(); String sql = "update people set room=?,bed=?,major=?, name=?,fdy=? where num = ?"; stmt = con.prepareStatement(sql); stmt.setString(1, room); stmt.setString(2, bed); stmt.setString(3, mojor); stmt.setString(4, name); stmt.setString(5, fdy); stmt.setString(6, num); stmt.execute(); System.out.println("修改成功!"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } } //根据编号删除 public static void deleteById() throws SQLException { System.out.println("----------根据学号删除宿舍个人信息----------"); System.out.println("请输入需要删除的学号"); String num = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { con = JDBCUtils.getConnection(); String sql = "delete from people where num =?"; stmt = con.prepareStatement(sql); stmt.setString(1,num); stmt.execute(); System.out.println("删除成功！！！"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } } //按学号查询 public static void selectByNum(){ System.out.println("----------根据学号查询宿舍个人信息----------"); System.out.println("请输入需要查询的学号"); String num = scanner.next(); //注册驱动 使用驱动连接数据库 String sql = "select * from people where num = ?"; PreparedStatement pst = null; ResultSet rs = null; Connection conn = JDBCUtils.getConnection(); try { pst = conn.prepareStatement(sql); pst.setString(1, num); rs = pst.executeQuery(); while(rs.next()){ System.out.println(); System.out.println("学号："+rs.getString("num")+"\t宿舍号："+rs.getString("room") +"\t床位号："+rs.getString("bed")+"\t专业："+rs.getString("major") +"\t姓名："+rs.getString("name")+"\t辅导员姓名："+rs.getString("fdy")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //按姓名查询 public static void selectByName(){ System.out.println("----------根据姓名查询宿舍个人信息----------"); System.out.println("请输入需要查询的姓名"); String num = scanner.next(); //注册驱动 使用驱动连接数据库 String sql = "select * from people where name = ?"; PreparedStatement pst = null; ResultSet rs = null; Connection conn = JDBCUtils.getConnection(); try { pst = conn.prepareStatement(sql); pst.setString(1, num); rs = pst.executeQuery(); while(rs.next()){ System.out.println(); System.out.println("学号："+rs.getString("num")+"\t宿舍号："+rs.getString("room") +"\t床位号："+rs.getString("bed")+"\t专业："+rs.getString("major") +"\t姓名："+rs.getString("name")+"\t辅导员姓名："+rs.getString("fdy")); } } catch (SQLException e) { // TODO Auto-generated catch bl