学生管理系统MYSQL数据库版

主方法

package com.zzu.main;

import com.zzu.tool.db.IRowMapper;
import com.zzu.tool.db.Linked;

import javax.swing.tree.RowMapper;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class Main {
   
    private static Linked linked = new Linked();

    public static void main(String[] args) {
   
        System.out.println("*********************************");
        System.out.println("*\t\t\t\t*");
        System.out.println("*\t欢迎使用学生信息管理系统\t*");
        System.out.println("*\t\t\t\t*");
        System.out.println("*********************************");
        while (true) {
   
            menu();
        }
    }

    static void menu() {
   
        System.out.println("1、添加学生信息");
        System.out.println("2、删除学生信息");
        System.out.println("3、修改学生信息");//地址传递
        System.out.println("4、查询学生信息");//name
        System.out.println("请输入操作，以Enter键结束:");
        Scanner sc = new Scanner(System.in);
        int option  = sc.nextInt();
        switch (option) {
   
            case 1:
                System.out.println("请输入学号");
                String id = sc.next();
                String sql =  "select id from student where id='"+id+"'";
                if (linked.exist(sql)){
   
                    System.out.println("学号存在，请重试");
                    return;
                }
                System.out.println("请输入姓名");
                String name = sc.next();
                System.out.println("请输入电话号吗");
                String mobile = sc.next();
                System.out.println("请输入家庭地址");
                String address = sc.next();
                sql = "insert into student values('"+id+"','"+name+"','"+mobile+"','"+address+"')";
                if(l