c/s实现增删改查 学生管理系统 Apache

**

使用Apache（阿帕奇）来实现c/s的增删改查

**

需要导入的包：
commons-dbutils-1.7.jar
mysql-connector-java-5.1.32.jar

主界面代码

import java.util.List;
import java.util.Scanner;

public class XStongji {
   
    static Scanner sc = new Scanner(System.in);
    static XSDao dao = new XSDao();

    public static void main(String[] args) throws Exception {
   

        while (true) {
   
            System.out.println("-----学生管理系统-----");
            System.out.println("-----1.学生查询全部-----");
            System.out.println("----2。学生关键字查询----");
            System.out.println("-----3.学生增加信息-----");
            System.out.println("-----4.学生修改信息-----");
            System.out.println("-----5.学生删除信息-----");
            System.out.println("-------0.退出系统-------");
            System.out.println("-----请输入要操作的数字:-----");
            int caozuo = sc.nextInt();
            if (caozuo == 1) {
   
                chaxunquanbu();
            } else if (caozuo == 2) {
   
                guanjianzichaxun();
            } else if (caozuo == 3) {
   
                zengjiaxinxi();
            } else if (caozuo == 4) {
   
                xiugaixinxi();
            } else if (caozuo == 5) {
   
                shanchuxinxi();
            } else if (caozuo == 0) {
   
                tuichuxit();
            }
        }
    }

    //查询全部
    private static void chaxunquanbu() throws Exception {
   
        List<XSlei> xSleiList = dao.chaxunqunbu();
        for (XSlei xSlei : xSleiList){
   
            System.out.println(xSlei);
        }
        //iter快捷键

    }

    //关键字查询
    private static void guanjianzichaxun() {
   
        System.out.println("请输入你想要的查询的关键字:");
        String guanjianzi = sc.next();
        List<XSlei> list = dao.gaunjianzi(guanjianzi);
        for (XSlei xSlei : list) {
   
            System.out.println(xSlei);
        }

    }

    //添加学生
    private static void zengjiaxinxi() {
   
        System.out.println("请输入学生姓名:");
        String name = sc.next();
        System.out