实验选课系统【控制台+MySQL】（Java课设）

import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Scanner; //操作类 public class Manage { //键盘输入对象 public static Scanner scanner = new Scanner(System.in); //插入语句 public static void insert() throws SQLException { System.out.println("----------增加实验选课信息数据----------"); System.out.println("实验选课的编号"); String id = scanner.next();//获取键盘输入的数据 System.out.println("名称"); String name = scanner.next(); System.out.println("教师"); String teacher= scanner.next(); System.out.println("课时"); String num= scanner.next(); System.out.println("地址"); String address = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; //预编译 PreparedStatement stmt = null; //结果集 ResultSet rs = null; try { //连接数据库 con = JDBCUtils.getConnection(); //定义sql语句 String sql = "insert into sy values(?,?,?,?,?)"; //预编译 stmt = con.prepareStatement(sql); //定义上面问号对应的参数 stmt.setString(1, id); stmt.setString(2, name); stmt.setString(3, teacher); stmt.setString(4, num); stmt.setString(5, address); //执行数据库 stmt.executeUpdate(); System.out.println("增加成功！"); } catch (Exception e) { //打印异常 e.printStackTrace(); }finally { //关闭数据库 JDBCUtils.close(rs, stmt, con); } } //显示所有信息 public static void selectAll() throws SQLException { //注册驱动 使用驱动连接数据库 Connection con = null; Statement stmt = null; ResultSet rs = null; try { //数据库的连接 con = JDBCUtils.getConnection(); //数据库的增删改查 stmt = con.createStatement(); //返回一个结果集 rs =stmt.executeQuery("select * from sy"); System.out.println("--------------------------查询结果如下所示--------------------------"); //遍历结果集 while(rs.next()) { System.out.println(); //输出所有数据 System.out.println("编号："+rs.getString("id") +"\t名称："+rs.getString("name")+"\t教师：" +rs.getString("teacher")+"\t课时：" +rs.getString("num")+"\t地址：" +rs.getString("address")); } } catch (Exception e) { e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } } //根据编号修改 public static void updateById() throws SQLException { System.out.println("----------根据实验选课编号修改----------"); System.out.println("请输入需要修改的实验选课编号"); String id = scanner.next(); System.out.println("请输入需要修改的实验选课信息名称"); String name = scanner.next(); System.out.println(" 请输入需要修改的实验选课信息教师"); String teacher= scanner.next(); System.out.println(" 请输入需要修改的实验选课信息课时"); String num= scanner.next(); System.out.println(" 请输入需要修改的实验选课信息地址"); String address = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { con = JDBCUtils.getConnection(); String sql = "update sy set name=?,teacher=?,num=?, address=? where id = ?"; stmt = con.prepareStatement(sql); stmt.setString(1, name); stmt.setString(2, teacher); stmt.setString(3, num); stmt.setString(4, address); stmt.setString(5, id); 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 id = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { con = JDBCUtils.getConnection(); String sql = "delete from sy where id =?"; stmt = con.prepareStatement(sql); stmt.setString(1,id); stmt.execute(); System.out.println("实验选课删除成功！"); } catch (Exception e) { e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } } public static void main(String[] args) throws SQLException { //菜单 while (true) { System.out.println("--------------欢迎使用实验选课系统-------------"); System.out.println("-------------【1】查询所有实验选课信息-------------"); System.out.println("-------------【2】增加实验选课信息-------------"); System.out.println("-------------【3】修改实验选课信息-------------"); System.out.println("-------------【4】删除实验选课信息-------------"); System.out.println("-------------【0】退出系统-------------"); System.out.println("输入你的选择"); String choice = scanner.next(); //判断输入的是几号数字就调用下面对应的方法 switch (choice) { case "1": Manage.selectAll(); break; case "2": Manage.insert(); break; case "3": Manage.updateById(); break; case "4": Manage.deleteById(); break; case "0": System.exit(0); default: break; } } } }