基于mysql纯java的智能题库（后期填写注释）

package controller;

import admin.entity.Admin;
import admin.service.AdminService;
import admin.service.impl.AdminServiceImpl;
import questionBank.entity.*;
import questionBank.service.ExamService;
import questionBank.service.Impl.ExamServiceImpl;
import questionBank.service.Impl.QuestionBankServiceImpl;
import questionBank.service.Impl.ScoreSheetServiceImpl;
import questionBank.service.QuestionBankService;
import questionBank.service.ScoreSheetService;
import user.entity.User;
import user.entity.WrongQuestions;
import user.service.UserService;
import user.service.WrongQuestionService;
import user.service.impl.UserServiceImpl;
import user.service.impl.WrongQuestionServiceImpl;
import utils.BaseDao;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Scanner;

/**
 * @author 阿水
 * @create 2023-02-04 19:48
 *
 *                            _ooOoo_
 *                           o8888888o
 *                           88" . "88
 *                           (| -_- |)
 *                           O\  =  /O
 *                        ____/`---'\____
 *                      .'  \\|     |//  `.
 *                     /  \\|||  :  |||//  \
 *                    /  _||||| -:- |||||-  \
 *                    |   | \\\  -  /// |   |
 *                    | \_|  ''\---/''  |   |
 *                    \  .-\__  `-`  ___/-. /
 *                  ___`. .'  /--.--\  `. . __
 *               ."" '<  `.___\_<|>_/___.'  >'"".
 *              | | :  `- \`.;`\ _ /`;.`/ - ` : | |
 *              \  \ `-.   \_ __\ /__ _/   .-` /  /
 *         ======`-.____`-.___\_____/___.-`____.-'======
 *                            `=---='
 *         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 *                  佛祖保佑       永无BUG
 *
 */
public class Main extends BaseDao {
    public static void main(String[] args) {
        UserService userService = new UserServiceImpl();
        AdminService adminService = new AdminServiceImpl();
        QuestionBankService questionBankService = new QuestionBankServiceImpl();
        ScoreSheetService scoreSheetService = new ScoreSheetServiceImpl();
        WrongQuestionService wrongQuestionService = new WrongQuestionServiceImpl();
        ExamService examService = new ExamServiceImpl();
        SimpleDateFormat sdf = new SimpleDateFormat();// 格式化时间
        sdf.applyPattern("yyyy-MM-dd HH:mm:ss");// a为am/pm的标记
        Scanner sc = new Scanner(System.in);
        while (true) {
            System.out.println("1、管理员");
            System.out.println("2、用户");
            int x = sc.nextInt();
            if (x == 1) {
                System.out.println("请输入管理员用户名");
                String loginName = sc.next();
                System.out.println("请输入管理员密码");
                String password = sc.next();
                int loginAdminId = adminService.login(loginName, password);
                if (loginAdminId > 0) {
                    System.out.println("登陆完成");
                    while (true) {
                        System.out.println("1、查看所有题目");
                        System.out.println("2、添加题目");
                        System.out.println("3、删除题目");
                        System.out.println("4、新注册管理员");
                        System.out.println("5、出试卷");
                        System.out.println("6、查看试卷");
                        System.out.println("7、查看成绩");
                        int y = sc.nextInt();
                        if (y == 1) {
                            //查看所有题目
                            List<QuestionBank> questionBanks = questionBankService.selectAll();
                            for (QuestionBank questionBank : questionBanks) {
                                System.out.println(questionBank);
                            }

                        } else if (y == 2) {
                            //添加题目
                            List<TypeName> typeName = questionBankService.findTypeName();
                            for (TypeName name : typeName) {
                                System.out.println(name);
                            }
                            System.out.println("请输入题目类型");
                            String type = sc.next();
                            System.out.println("请输入题目");
                            String content = sc.next();
                            System.out.println("请输入答案");
                            String answer = sc.next();
                            questionBankService.insert(new QuestionBank(0, type, content, answer));

                        } else if (y == 3) {
                            //删除题目
                            List<QuestionBank> questionBanks = questionBankService.selectAll();
                            for (QuestionBank questionBank : questionBanks) {
                                System.out.println(questionBank);
                            }
                            System.out.println("请输入删除题目的id");
                            int id = sc.nextInt();
                            questionBankService.delete(id);

                        } else if (y == 4) {
                            //新注册管理员
                            Admin admin = new Admin();
                            System.out.println("请输入管理员名称");
                            String name = sc.next();
                            System.out.println("请输入账号");
                            String loginAdminName = sc.next();
                            System.out.println("请输入密码");
                            String pwd = sc.next();
                            admin.setName(name);
                            admin.setLoginName(loginAdminName);
                            admin.setPassword(pwd);
                            adminService.insert(admin);

                        } else if (y == 5) {
                            //出试卷
                            int count = 0;
                            List<QuestionBank> questionBanks = questionBankService.selectAll();
                            for (QuestionBank questionBank : questionBanks) {
                                System.out.println(questionBank);
                            }
                            System.out.println("请输入本次试卷名称");
                            String examName = sc.next();
                            while (true) {
                                System.out.println("请输入加入考试的题目id,按0结束");
                                int id = sc.nextInt();
                                for (QuestionBank questionBank : questionBanks) {
                                    if (id == questionBank.getId()) {
                                        examService.insert(id, examName);
                                        count--;
                                    }
                                    count++;
                                }
                                if (count == questionBanks.size()) {
                                    System.out.println("查无此题");
                                    break;
                                }
                                if (id == 0) {
                                    break;
                                }
                            }

                        } else if (y == 6) {
                            List<Exam> exams = examService.selectAll();
                            for (Exam exam : exams) {
                                System.out.println(exam);
                            }

                        } else if (y == 7) {
                            List<ScoreSheet> scoreSheets = scoreSheetService.selectAll();
                            for (ScoreSheet scoreSheet : scoreSheets) {
                                System.out.println(scoreSheet);
                            }
                        } else {
                            System.out.println("再见");
                            break;
                        }

                    }


                } else {
                    System.out.println("登陆失败");

                }
            } else if (x == 2) {

                while (true) {
                    System.out.println("1、登录");
                    System.out.println("2、注册");
                    int y = sc.nextInt();
                    if (y == 1) {
                        while (true) {
                            System.out.println("请输入登录账号");
                            String loginName = sc.next();
                            System.out.println("请输入登录密码");
                            String password = sc.next();
                            int loginUserId = userService.login(loginName, password);
                            if (loginUserId > 0) {
                                System.out.println("登录完成");
                                while (true) {

                                    System.out.println("1、刷题模式");
                                    System.out.println("2、按照学科刷题模式");
                                    System.out.println("3、开始考试");
                                    System.out.println("4、按照学科测验练习");
                                    System.out.println("5、查看错题本");
                                    System.out.println("请输入您的选项");
                                    int z = sc.nextInt();
                                    if (z == 1) {
                                        ArrayList<QuestionBank> QuestionBank = new ArrayList<>();
                                        List<QuestionBank> questionBanks = questionBankService.selectAll();
                                        for (questionBank.entity.QuestionBank questionBank : questionBanks) {
                                            System.out.println(questionBank);
                                        }

                                    } else if (z == 2) {
                                        //按照学科刷题模式
                                        //ArrayList<QuestionBank> QuestionBank = new ArrayList<>();
                                        List<TypeName> typeName = questionBankService.findTypeName();
                                        for (TypeName name : typeName) {
                                            System.out.println(name);
                                        }
                                        System.out.println("请您完整输入课程学科");
                                        String inputTypeName = sc.next();
                                        int count = 0;
                                        for (TypeName name : typeName) {
                                            if (name.getName().equals(inputTypeName)) {
                                                count++;
                                            }
                                        }
                                        if (count == 0) {
                                            System.out.println("课程不存在 请仔细检查");
                                            break;
                                        } else {
                                            List<QuestionBank> questionBankByType = questionBankService.selectByType(inputTypeName);
                                            for (QuestionBank questionBank : questionBankByType) {
                                                System.out.println(questionBank);
                                            }
                                        }

                                    } else if (z == 3) {
                                        // 输出已经格式化的现在时间（24小时制）
                                        List<ExamName> examNames = examService.selectByName();
                                        for (ExamName examName : examNames) {
                                            System.out.println(examName);
                                        }
                                        System.out.println("请您完整输入考试名称");
                                        String inputTypeName = sc.next();
                                        int count = 0;
                                        for (ExamName examName : examNames) {
                                            if (examName.getName().equals(inputTypeName)) {
                                                count++;
                                                System.out.println("这是考试模式 记录成绩！！！！！");
                                            }
                                        }
                                        if (count == 0) {
                                            System.out.println("课程不存在 请仔细检查");
                                        } else {

                                            //select * from exam inner join questionbank on exam.questionid = questionbank.id where examName = '无敌巨难试卷';
                                            List<Exam> exams = examService.selectByType(inputTypeName);
                                            double number = 0;
                                            double scoreByUser = 0;
                                            for (Exam exam : exams) {
                                                System.out.println(exam.getTypeName() + " " + exam.getContent());
                                                System.out.println("请输入答案");
                                                String answerByUser = sc.next();
                                                if (answerByUser.equals(exam.getAnswer())) {
                                                    scoreByUser++;
                                                }/*else {
                                                    //wrongQuestionService.insert();
                                                    List<WrongQuestions> wrongQuestions = wrongQuestionService.selectByUserId(loginUserId);
                                                    int var=0;
                                                    for (WrongQuestions wrongQuestion : wrongQuestions) {
                                                        System.out.println(wrongQuestion);

                                                        if (wrongQuestion.getContent().equals(exam.getContent())) {
                                                            wrongQuestionService.update(new WrongQuestions(loginUserId, wrongQuestion.getContent()));
                                                            break;
                                                        } else {
                                                            var++;
                                                        }
                                                        if (var == wrongQuestions.size()) {
                                                            wrongQuestionService.insert(new WrongQuestions(loginUserId,exam.getQuestionId()));
                                                        }
                                                    }

                                                }*/
                                                number++;
                                            }

                                            double sumScore = (scoreByUser / number) * 100;
                                            String str = String.format("%.1f", sumScore);
                                            System.out.println("您考试 考了" + str + "分");
                                            double finalScore = Double.parseDouble(str);
                                            //(int scoreId, String examName, double score, Timestamp dateTime, int userId, String userName)
                                            Date date = new Date();// 获取当前时间
                                            System.out.println(sdf.format(date));
                                            ScoreSheet scoreSheet1 = new ScoreSheet(1, inputTypeName, finalScore, sdf.format(date).toString(), loginUserId, loginName);
                                            scoreSheetService.insert(scoreSheet1);
                                        }

                                    } else if (z == 4) {
                                        //按照学科刷题
                                        List<TypeName> typeName = questionBankService.findTypeName();
                                        for (TypeName name : typeName) {
                                            System.out.println(name);
                                        }
                                        System.out.println("请您完整输入课程学科");
                                        String inputTypeName = sc.next();
                                        int count = 0;
                                        for (TypeName name : typeName) {
                                            if (name.getName().equals(inputTypeName)) {
                                                count++;
                                            }
                                        }
                                        if (count == 0) {
                                            System.out.println("课程不存在 请仔细检查");
                                        } else {
                                            List<QuestionBank> questionBankByType = questionBankService.selectByType(inputTypeName);
                                            System.out.println("这是娱乐模式 不记录成绩");
                                            double number = 0;
                                            double scoreByUser = 0;
                                            for (QuestionBank questionBank : questionBankByType) {
                                                System.out.println(questionBank.getType() + " " + questionBank.getContent());
                                                System.out.println("请输入答案");
                                                String answerByUser = sc.next();
                                                if (answerByUser.equals(questionBank.getAnswer())) {
                                                    scoreByUser++;
                                                } else {
                                                    //wrongQuestionService.insert();
                                                    List<WrongQuestions> wrongQuestions = wrongQuestionService.selectByUserId(loginUserId);
                                                    int var=0;
                                                    for (WrongQuestions wrongQuestion : wrongQuestions) {
                                                        //System.out.println(wrongQuestion);

                                                        if (wrongQuestion.getContent().equals(questionBank.getContent())) {
                                                            wrongQuestionService.update(new WrongQuestions(loginUserId, wrongQuestion.getContent()));
                                                            break;
                                                        } else {
                                                            var++;
                                                        }
                                                        if (var == wrongQuestions.size()) {
                                                            wrongQuestionService.insert(new WrongQuestions(loginUserId, questionBank.getId()));
                                                        }
                                                    }

                                                }
                                                number++;
                                            }
                                            double sumScore = (scoreByUser / number) * 100;
                                            String str = String.format("%.1f", sumScore);
                                            System.out.println("您本次测验考了" + str + "分");
                                            System.out.println("考试结束，记录已上传 无法再打开");


                                        }
                                    } else if (z == 5) {
                                        List<WrongQuestions> wrongQuestions = wrongQuestionService.selectByUserId(loginUserId);
                                        for (WrongQuestions wrongQuestion : wrongQuestions) {
                                            System.out.println("类型:" + wrongQuestion.getTypeName() + " 题目:" + wrongQuestion.getContent() + " 答案:" + wrongQuestion.getAnswer() + " 累计错误次数:" + wrongQuestion.getCount() + "次");
                                        }
                                    } else {
                                        System.out.println("再见");
                                        break;
                                    }
                                }

                            } else {
                                System.out.println("登陆失败");
                                break;
                            }


                        }
                    } else if (y == 2) {
                        System.out.println("请输入姓名");
                        String name = sc.next();
                        System.out.println("请输入登录账号");
                        String loginName = sc.next();
                        System.out.println("请输入登录密码");
                        String password = sc.next();
                        userService.insert(new User(0, name, loginName, password));
                        System.out.println("注册完成啦！！！快去登陆吧哈哈嗨");
                    } else {
                        System.out.println("拜拜了您嘞");
                        break;
                    }


                }

            }

        }

    }
}

 

 

package admin.dao.impl;

import admin.dao.AdminDao;
import admin.entity.Admin;
import utils.BaseDao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

/**
 * @author 刘品水
 * @create 2023-02-04 18:31
 */
public class AdminDaoImpl extends BaseDao implements AdminDao {
    
    @Override
    public int insert(Admin admin) {
        String sql = "insert into admin (name,loginName,password) " +
                "values ('" + admin.getName() + "','" + admin.getLoginName() + "','" + admin.getPassword() + "')";
        int result = 0;
        System.out.println(sql);
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    @Override
    public int delete(int id) {
        String sql = "delete from admin where id=" + id;
        System.out.println(sql);
        int result = 0;
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    @Override
    public int update(Admin admin) {
        String sql = "update admin set name='" + admin.getName() + "', password='" + admin.getPassword() + "' where id=" + admin.getId();
        int result = 0;
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        System.out.println(sql);
        return result;
    }

    @Override
    public List<Admin> selectAll() {
        ArrayList<Admin> admins = new ArrayList<>();
        ResultSet resultSet = null;
        try {
            resultSet = this.find("select * from admin");
            while (resultSet.next()) {
                Admin a = new Admin(resultSet.getInt("id"), resultSet.getString("name"), resultSet.getString("loginName"), resultSet.getString("password"));
                admins.add(a);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        return admins;
    }

    @Override
    public Admin selectById(int id) {
        ResultSet resultSet = null;
        Admin a = new Admin();
        try {
            resultSet = this.find("select * from admin where id=" + id);
            if (resultSet != null) {
                a = new Admin(resultSet.getInt("id"), resultSet.getString("name"), resultSet.getString("loginName"), resultSet.getString("password"));

            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        return a;
    }

    @Override
    public int login(String loginName, String password) {
        int id = 0;
        ResultSet resultSet = null;
        try {
            String sql = "select * from admin where loginName=? and password=?";
            PreparedStatement pst = this.getPreparedStatement(sql);
            pst.setString(1, loginName);
            pst.setString(2, password);

            resultSet = pst.executeQuery();
     /*       System.out.println(resultSet);
            System.out.println(sql);*/


            if (resultSet.next()) {
                id = resultSet.getInt("id");
            }

        } catch (Exception e) {
            e.printStackTrace();
        }

        //return false;
        return id;
    }
}

package admin.dao;

import admin.entity.Admin;

import java.util.List;

/**
 * @author 刘品水
 * @create 2023-02-04 18:30
 */
public interface AdminDao {

    int insert(Admin admin);
    int delete(int id);
    int update(Admin admin);
    List<Admin> selectAll();
    Admin selectById(int id);
    int login(String loginName, String password);




}

package admin.entity;

public class Admin{

    private int id;
    private String name;
    private String loginName;
    private String password;

    public Admin() {
    }

    public Admin(int id, String name, String loginName, String password) {
        this.id = id;
        this.name = name;
        this.loginName = loginName;
        this.password = password;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getLoginName() {
        return loginName;
    }

    public void setLoginName(String loginName) {
        this.loginName = loginName;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "Admin{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", loginName='" + loginName + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

package admin.service.impl;

import admin.dao.AdminDao;
import admin.dao.impl.AdminDaoImpl;
import admin.entity.Admin;
import admin.service.AdminService;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 16:46
 */
public class AdminServiceImpl implements AdminService {
    private AdminDao adminDao=new AdminDaoImpl();
    @Override
    public int insert(Admin admin) {
        return adminDao.insert(admin);
    }

    @Override
    public int delete(int id) {
        return adminDao.delete(id);
    }

    @Override
    public int update(Admin admin) {
        return adminDao.update(admin);
    }

    @Override
    public List<Admin> selectAll() {
        return adminDao.selectAll();
    }

    @Override
    public Admin selectById(int id) {
        return adminDao.selectById(id);
    }

    @Override
    public int login(String loginName, String password) {
        return adminDao.login(loginName,password);
    }
}

package admin.service;

import admin.entity.Admin;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 16:46
 */
public interface AdminService {
    int insert(Admin admin);
    int delete(int id);
    int update(Admin admin);
    List<Admin> selectAll();
    Admin selectById(int id);
    int login(String loginName, String password);
}

package questionBank.dao;

import questionBank.entity.Exam;
import questionBank.entity.ExamName;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 19:23
 */
public interface ExamDao {
    int insert(int qid, String eName);
    int delete(int id);
    int update(Exam exam);
    List<Exam> selectAll();
    Exam selectById(int id);

    List<ExamName> selectByName();

    List<Exam> selectByType(String inputTypeName);
}

package questionBank.dao.impl;

import questionBank.dao.QuestionBankDao;
import questionBank.entity.QuestionBank;
import questionBank.entity.TypeName;
import utils.BaseDao;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 18:50
 */
public class QuestionBankDaoImpl extends BaseDao implements QuestionBankDao {

    @Override
    public int insert(QuestionBank questionBank) {
        String sql = "insert into questionbank (typeName,content,answer) " +
                "values ('" + questionBank.getType() + "','" + questionBank.getContent() + "','" + questionBank.getAnswer() + "')";
        int result = 0;
        //System.out.println(sql);
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    @Override
    public int delete(int id) {
        String sql = "delete from questionbank where id=" + id;
        //System.out.println(sql);
        int result = 0;
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    @Override
    public int update(QuestionBank questionBank) {
        String sql = "update questionbank set typeName='" +questionBank.getType() + "', content='" + questionBank.getContent() +"',answer='"+ questionBank.getAnswer()+"' where id=" + questionBank.getId();
        int result = 0;
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        //System.out.println(sql);
        return result;
    }

    @Override
    public List<QuestionBank> selectAll() {
        ArrayList<QuestionBank> list = new ArrayList<>();
        ResultSet resultSet = null;
        try {
            resultSet = this.find("select * from questionbank");
            while (resultSet.next()) {
                QuestionBank a = new QuestionBank(resultSet.getInt("id"), resultSet.getString("typeName"), resultSet.getString("content"), resultSet.getString("answer"));
                list.add(a);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        return list;
    }

    @Override
    public QuestionBank selectById(int id) {
        ResultSet resultSet = null;
        QuestionBank a = null;
        try {
            resultSet = this.find("select * from questionbank where id=" + id);
            if (resultSet != null) {
                 a = new QuestionBank(resultSet.getInt("id"), resultSet.getString("typeName"), resultSet.getString("content"), resultSet.getString("answer"));

            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        return a;
    }

    @Override
    public List<TypeName> findTypeName() {
        ArrayList<TypeName> list = new ArrayList<>();
        ResultSet resultSet = null;
        try {
            resultSet = this.find("select distinct typeName from questionbank;");
            while (resultSet.next()) {
                TypeName a = new TypeName(resultSet.getString("typeName"));
                list.add(a);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        return list;
    }

    @Override
    public List<QuestionBank> selectByType(String inputTypeName) {
        ArrayList<QuestionBank> list = new ArrayList<>();
        ResultSet resultSet = null;
        try {
            resultSet = this.find("select * from questionbank where typeName = '"+inputTypeName+"';");
            while (resultSet.next()) {
                QuestionBank a = new QuestionBank(resultSet.getInt("id"), resultSet.getString("typeName"), resultSet.getString("content"), resultSet.getString("answer"));
                list.add(a);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        return list;
    }

}

package questionBank.dao.impl;

import questionBank.dao.ScoreSheetDao;
import questionBank.entity.ScoreSheet;
import utils.BaseDao;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-07 11:04
 */
public class ScoreSheetDaoImpl extends BaseDao implements ScoreSheetDao {

    @Override
    public int insert(ScoreSheet scoreSheet) {
       /* String sql = "insert into questionbank (typeName,content,answer) " +
                "values ('" + questionBank.getType() + "','" + questionBank.getContent() + "','" + questionBank.getAnswer() + "')";
      */
        String sql="insert into score_sheet (examName, userId, score, datatime) values" +
                " ('"+scoreSheet.getExamName()+"',"+scoreSheet.getUserId()+","+scoreSheet.getScore()+",'"+scoreSheet.getDateTime()+"');";
        int result = 0;
        System.out.println(sql);
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;

    }

    @Override
    public int delete(int id) {
        return 0;
    }

    @Override
    public int update(ScoreSheet scoreSheet) {
        return 0;
    }

    @Override
    public List<ScoreSheet> selectAll() {
        ArrayList<ScoreSheet> list = new ArrayList<>();
        ResultSet resultSet = null;
        try {
            resultSet = this.find("select  score_sheet.id,examName, score, datatime , user.id,name from score_sheet inner  join user on score_sheet.userId=user.id;");
            while (resultSet.next()) {
                ScoreSheet a = new ScoreSheet(resultSet.getInt("score_sheet.id"),resultSet.getString("score_sheet.examName"),resultSet.getDouble("score_sheet.score"),resultSet.getString("datatime"),resultSet.getInt("user.id"),resultSet.getString("user.name"));

                list.add(a);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        return list;
    }

    @Override
    public ScoreSheet selectById(int id) {
        return null;
    }
}

package questionBank.dao;

import questionBank.entity.Exam;
import questionBank.entity.ExamName;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 19:23
 */
public interface ExamDao {
    int insert(int qid, String eName);
    int delete(int id);
    int update(Exam exam);
    List<Exam> selectAll();
    Exam selectById(int id);

    List<ExamName> selectByName();

    List<Exam> selectByType(String inputTypeName);
}

package questionBank.dao;

import questionBank.entity.QuestionBank;
import questionBank.entity.TypeName;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 18:50
 */
public interface QuestionBankDao {
    int insert(QuestionBank questionBank);
    int delete(int id);
    int update(QuestionBank questionBank);
    List<QuestionBank> selectAll();
    QuestionBank selectById(int id);
    List<TypeName> findTypeName();
    List<QuestionBank> selectByType(String inputTypeName);
}

package questionBank.dao;

import questionBank.entity.ScoreSheet;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-07 11:04
 */
public interface ScoreSheetDao {
    int insert(ScoreSheet scoreSheet);
    int delete(int id);
    int update(ScoreSheet scoreSheet);
    List<ScoreSheet> selectAll();
    ScoreSheet selectById(int id);

}

package questionBank.entity;

import java.io.Serializable;

public class Exam implements Serializable {
    private int id;
    private int questionId;
    private String examName;
    private String typeName;
    private String content;
    private String answer;

    public Exam(int questionId, String typeName, String content, String answer) {
        this.questionId = questionId;
        this.typeName = typeName;
        this.content = content;
        this.answer = answer;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getQuestionId() {
        return questionId;
    }

    public void setQuestionId(int questionId) {
        this.questionId = questionId;
    }

    public Exam(int id, int questionId, String examName, String typeName, String content, String answer) {
        this.id = id;
        this.questionId = questionId;
        this.examName = examName;
        this.typeName = typeName;
        this.content = content;
        this.answer = answer;
    }

    public Exam(String examName, String typeName, String content, String answer) {
        this.examName = examName;
        this.typeName = typeName;
        this.content = content;
        this.answer = answer;
    }

    public Exam() {
    }

    @Override
    public String toString() {
        return "Exam{" +
                "id=" + id +
                ", examName='" + examName + '\'' +
                ", typeName='" + typeName + '\'' +
                ", content='" + content + '\'' +
                ", answer='" + answer + '\'' +
                '}';
    }

    public Exam(int id, String examName, String typeName, String content, String answer) {
        this.id = id;
        this.examName = examName;
        this.typeName = typeName;
        this.content = content;
        this.answer = answer;
    }

    public Exam(String examName, String typeName, String content) {
        this.examName = examName;
        this.typeName = typeName;
        this.content = content;
    }

 /*   public Exam(String examName, String typeName, String content, String answer) {
        this.examName = examName;
        this.typeName = typeName;
        this.content = content;
        this.answer = answer;
    }
*/
    public String getExamName() {
        return examName;
    }

    public void setExamName(String examName) {
        this.examName = examName;
    }

    public String getTypeName() {
        return typeName;
    }

    public void setTypeName(String typeName) {
        this.typeName = typeName;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public String getAnswer() {
        return answer;
    }

    public void setAnswer(String answer) {
        this.answer = answer;
    }

}

package questionBank.entity;

/**
 * @author 阿水
 * @create 2023-02-07 14:38
 */
public class ExamName {
    private String name ;

    public ExamName() {
    }

    public ExamName(String name) {
        this.name = name;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    @Override
    public String toString() {
        return "ExamName{" +
                "name='" + name + '\'' +
                '}';
    }
}

package questionBank.entity;

public class QuestionBank {


    private int id;
    private String type;//题目标题，可省略
    private String content;
    private String answer;

    public QuestionBank() {
    }

    public QuestionBank(int id, String type, String content, String answer) {
        this.id = id;
        this.type = type;
        this.content = content;
        this.answer = answer;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public String getAnswer() {
        return answer;
    }

    public void setAnswer(String answer) {
        this.answer = answer;
    }

    @Override
    public String toString() {
        return "QuestionBank{" +
                "id=" + id +
                ", type='" + type + '\'' +
                ", content='" + content + '\'' +
                ", answer='" + answer + '\'' +
                '}';
    }
}

 

package questionBank.entity;

/**
 * @author 阿水
 * @create 2023-02-07 11:01
 */
public class ScoreSheet {
    private int scoreId;
    private String examName;

    private double score;
    private String dateTime;

    private int userId;
    private String userName;

    public ScoreSheet() {
    }

    @Override
    public String toString() {
        return "ScoreSheet{" +
                "scoreId=" + scoreId +
                ", examName='" + examName + '\'' +
                ", score=" + score +
                ", dateTime='" + dateTime + '\'' +
                ", userId=" + userId +
                ", userName='" + userName + '\'' +
                '}';
    }

    public int getScoreId() {
        return scoreId;
    }

    public void setScoreId(int scoreId) {
        this.scoreId = scoreId;
    }

    public String getExamName() {
        return examName;
    }

    public void setExamName(String examName) {
        this.examName = examName;
    }

    public double getScore() {
        return score;
    }

    public void setScore(double score) {
        this.score = score;
    }

    public String getDateTime() {
        return dateTime;
    }

    public void setDateTime(String dateTime) {
        this.dateTime = dateTime;
    }

    public int getUserId() {
        return userId;
    }

    public void setUserId(int userId) {
        this.userId = userId;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public ScoreSheet(int scoreId, String examName, double score, String dateTime, int userId, String userName) {
        this.scoreId = scoreId;
        this.examName = examName;
        this.score = score;
        this.dateTime = dateTime;
        this.userId = userId;
        this.userName = userName;
    }
}

package questionBank.entity;

/**
 * @author 阿水
 * @create 2023-02-07 10:03
 */
public class TypeName {
    private String name;

    public TypeName() {
    }

    public TypeName(String name) {
        this.name = name;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    @Override
    public String toString() {
        return "TypeName{" +
                "name='" + name + '\'' +
                '}';
    }
}

package questionBank.service.Impl;

import questionBank.dao.ExamDao;
import questionBank.dao.impl.ExamDaoImpl;
import questionBank.entity.Exam;
import questionBank.entity.ExamName;
import questionBank.service.ExamService;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 20:05
 */
public class ExamServiceImpl implements ExamService {
    ExamDao examDao=new ExamDaoImpl();
    @Override
    public int insert(int qid, String eName) {
        return examDao.insert(qid,eName);
    }

    @Override
    public int delete(int id) {
        return 0;
    }

    @Override
    public int update(Exam exam) {
        return 0;
    }

    @Override
    public List<Exam> selectAll() {
        return examDao.selectAll();
    }

    @Override
    public Exam selectById(int id) {
        return null;
    }

    @Override
    public List<ExamName> selectByName() {
        return examDao.selectByName();
    }

    @Override
    public List<Exam> selectByType(String inputTypeName) {
        return examDao.selectByType(inputTypeName);
    }
}

package questionBank.service.Impl;

import questionBank.dao.QuestionBankDao;
import questionBank.dao.impl.QuestionBankDaoImpl;
import questionBank.entity.QuestionBank;
import questionBank.entity.TypeName;
import questionBank.service.QuestionBankService;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 19:02
 */
public class QuestionBankServiceImpl implements QuestionBankService {
    private QuestionBankDao questionBankDao=new QuestionBankDaoImpl();

    @Override
    public int insert(QuestionBank questionBank) {
        return questionBankDao.insert(questionBank);
    }

    @Override
    public int delete(int id) {
        return questionBankDao.delete(id);
    }

    @Override
    public int update(QuestionBank questionBank) {
        return questionBankDao.update(questionBank);
    }

    @Override
    public List<QuestionBank> selectAll() {
        return questionBankDao.selectAll();
    }

    @Override
    public QuestionBank selectById(int id) {
        return questionBankDao.selectById(id);
    }

    @Override
    public List<TypeName> findTypeName() {
        return questionBankaDao.findTypeName();
    }

    @Override
    public List<QuestionBank> selectByType(String inputTypeName) {
        return questionBankDao.selectByType(inputTypeName);
    }


}

package questionBank.service.Impl;

import questionBank.dao.ScoreSheetDao;
import questionBank.dao.impl.ScoreSheetDaoImpl;
import questionBank.entity.ScoreSheet;
import questionBank.service.ScoreSheetService;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-07 11:04
 */
public class ScoreSheetServiceImpl implements ScoreSheetService {
    private ScoreSheetDao scoreSheetDao=new ScoreSheetDaoImpl();
    @Override
    public int insert(ScoreSheet scoreSheet) {
        return scoreSheetDao.insert(scoreSheet);
    }

    @Override
    public int delete(int id) {
        return scoreSheetDao.delete(id);
    }

    @Override
    public int update(ScoreSheet scoreSheet) {
        return scoreSheetDao.update(scoreSheet);
    }

    @Override
    public List<ScoreSheet> selectAll() {
        return scoreSheetDao.selectAll();
    }

    @Override
    public ScoreSheet selectById(int id) {
        return scoreSheetDao.selectById(id);
    }
}

package questionBank.service;

import questionBank.entity.Exam;
import questionBank.entity.ExamName;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 19:23
 */
public interface ExamService {
    int insert(int qid, String eName);
    int delete(int id);
    int update(Exam exam);
    List<Exam> selectAll();
    Exam selectById(int id);
    List<ExamName> selectByName();

    List<Exam> selectByType(String inputTypeName);
}

package questionBank.service;

import questionBank.entity.QuestionBank;
import questionBank.entity.TypeName;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 18:50
 */
public interface QuestionBankService {
    int insert(QuestionBank questionBank);
    int delete(int id);
    int update(QuestionBank questionBank);
    List<QuestionBank> selectAll();
    QuestionBank selectById(int id);

    //void selectAlType();

    List<TypeName> findTypeName();


    List<QuestionBank> selectByType(String inputTypeName);
}

package questionBank.service;

import questionBank.entity.ScoreSheet;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-07 11:04
 */
public interface ScoreSheetService {
    int insert(ScoreSheet scoreSheet);
    int delete(int id);
    int update(ScoreSheet scoreSheet);
    List<ScoreSheet> selectAll();
    ScoreSheet selectById(int id);
}

package user.dao.impl;

import user.dao.UserDao;
import user.entity.User;
import utils.BaseDao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 14:05
 */
public class UserDaoImpl extends BaseDao implements UserDao {
    @Override
    public int insert(User user) {
        String sql = "insert into user (name,loginName,password) " +
                "values ('" + user.getName() + "','" + user.getLoginName() + "','" + user.getPassword() + "')";
        int result = 0;
        System.out.println(sql);
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    @Override
    public int delete(int id) {
        String sql = "delete from user where id=" + id;
        System.out.println(sql);
        int result = 0;
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    @Override
    public int update(User user) {
        String sql = "update user set name='" + user.getName() + "', password='" + user.getPassword() + "' where id=" + user.getId();
        int result = 0;
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        System.out.println(sql);
        return result;
    }

    @Override
    public List<User> selectAll() {
        ArrayList<User> users = new ArrayList<>();
        ResultSet resultSet = null;
        try {
            resultSet = this.find("select * from user");
            while (resultSet.next()) {
                User u = new User(resultSet.getInt("id"), resultSet.getString("name"), resultSet.getString("loginName"), resultSet.getString("password"));
                users.add(u);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        return users;
    }

    @Override
    public User selectById(int id) {
        ResultSet resultSet = null;
        User u = new User();
        try {
            resultSet = this.find("select * from user where id=" + id);
            if (resultSet != null) {
                u = new User(resultSet.getInt("id"), resultSet.getString("name"), resultSet.getString("loginName"), resultSet.getString("password"));

            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        return u;
    }

    @Override
    public int login(String loginName, String password) {
        int id = 0;
        ResultSet resultSet = null;
        try {
            String sql = "select * from user where loginName=? and password=?";
            PreparedStatement pst = this.getPreparedStatement(sql);
            pst.setString(1, loginName);
            pst.setString(2, password);

            resultSet = pst.executeQuery();
     /*       System.out.println(resultSet);
            System.out.println(sql);*/


            if (resultSet.next()) {
                id = resultSet.getInt("id");
            }

        } catch (Exception e) {
            e.printStackTrace();
        }

        //return false;
        return id;

    }
}

package user.dao.impl;

import user.dao.WrongQuestionDao;
import user.entity.WrongQuestions;
import utils.BaseDao;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-07 17:23
 */
public class WrongQuestionDaoImpl extends BaseDao implements WrongQuestionDao {
    @Override
    public int insert(WrongQuestions wrongQuestions) {
        String sql = "insert into wrongquestion values (0,"+wrongQuestions.getUserId()+","+wrongQuestions.getQuestionId()+",1);";
        int result = 0;
        System.out.println(sql);
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    @Override
    public int delete(int id) {
        return 0;
    }

    @Override
    public int update(WrongQuestions wrongQuestions) {
        String sql = "update wrongquestion inner join user u on wrongquestion.user_id = u.id inner join questionbank q on wrongquestion.question_id = q.id set count=count + 1 where content = '"+wrongQuestions.getContent()+"' and user_id="+wrongQuestions.getUserId()+";";
        int result = 0;
        try {
            result = this.update(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        System.out.println(sql);
        return result;
    }

    @Override
    public List<WrongQuestions> selectAll() {
        return null;
    }

    @Override
    public List<WrongQuestions> selectByContent() {
        ResultSet resultSet = null;
        ArrayList<WrongQuestions> list = new ArrayList<>();
        try {
            resultSet = this.find("select  content\n" +
                    "from wrongquestion\n" +
                    "         inner join user u on wrongquestion.user_id = u.id\n" +
                    "         inner join questionbank q on wrongquestion.question_id = q.id\n" +
                    "where user_id=1\n" +
                    ";");
            while (resultSet != null) {
                WrongQuestions wrongQuestions1 = new WrongQuestions(resultSet.getInt("wrongquestion.id"), resultSet.getString("typeName"), resultSet.getString("content"), resultSet.getString("answer"), resultSet.getInt("count"));
                list.add(wrongQuestions1);


            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        return list;
    }

    @Override
    public List<WrongQuestions> selectByUserId(int id) {
        ArrayList<WrongQuestions> list = new ArrayList<>();
        ResultSet resultSet = null;
        try {
            resultSet = this.find("select  typeName,content,answer,count from wrongquestion inner join user u on wrongquestion.user_id = u.id inner join questionbank q on wrongquestion.question_id = q.id where user_id="+id+";");
            while (resultSet.next()) {
                WrongQuestions a = new WrongQuestions(resultSet.getString("typeName"),resultSet.getString("content"),resultSet.getString("answer"),resultSet.getInt("count"));

                list.add(a);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        return list;
    }
}

package user.dao;

import user.entity.User;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 14:01
 */
public interface UserDao {

    int insert(User user);
    int delete(int id);
    int update(User user);
    List<User> selectAll();
    User selectById(int id);

    int login(String loginName, String password);


}

package user.dao;

import user.entity.WrongQuestions;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-07 17:22
 */
public interface WrongQuestionDao {
    int insert(WrongQuestions wrongQuestions);
    int delete(int id);
    int update(WrongQuestions wrongQuestions);
    List<WrongQuestions> selectAll();
    List<WrongQuestions> selectByContent();
    List<WrongQuestions> selectByUserId(int id);
}

package user.entity;

public class User  {


    private int id;
    private String name;
    private String loginName;
    private String password;

    public User() {
    }

    public User(int id, String name, String loginName, String password) {
        this.id = id;
        this.name = name;
        this.loginName = loginName;
        this.password = password;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getLoginName() {
        return loginName;
    }

    public void setLoginName(String loginName) {
        this.loginName = loginName;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", loginName='" + loginName + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

package user.entity;

import java.io.Serializable;
//错题集
public class WrongQuestions implements Serializable {
    private int id;
    private int userId;
    private int questionId;
    private String typeName;

    public WrongQuestions(int userId, int questionId) {
        this.userId = userId;
        this.questionId = questionId;
    }

    public WrongQuestions(int userId, String content) {
        this.userId = userId;
        this.content = content;
    }

    private String content;
    private String answer;
    private int count;

    public WrongQuestions(String typeName, String content, String answer, int count) {
        this.typeName = typeName;
        this.content = content;
        this.answer = answer;
        this.count = count;
    }

    public WrongQuestions(int id, String typeName, String content, String answer, int count) {
        this.id = id;
        this.typeName = typeName;
        this.content = content;
        this.answer = answer;
        this.count = count;
    }

    public WrongQuestions(int id, int userId, int questionId, String typeName, String content, String answer, int count) {
        this.id = id;
        this.userId = userId;
        this.questionId = questionId;
        this.typeName = typeName;
        this.content = content;
        this.answer = answer;
        this.count = count;
    }

    public int getCount() {
        return count;
    }

    public void setCount(int count) {
        this.count = count;
    }

    public WrongQuestions() {
    }

    public int getQuestionId() {
        return questionId;
    }

    public void setQuestionId(int questionId) {
        this.questionId = questionId;
    }

    public WrongQuestions(int id, int userId, int questionId, String typeName, String content, String answer) {
        this.id = id;
        this.userId = userId;
        this.questionId = questionId;
        this.typeName = typeName;
        this.content = content;
        this.answer = answer;
    }


    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getUserId() {
        return userId;
    }

    public void setUserId(int userId) {
        this.userId = userId;
    }


    public String getTypeName() {
        return typeName;
    }

    public void setTypeName(String typeName) {
        this.typeName = typeName;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public String getAnswer() {
        return answer;
    }

    public void setAnswer(String answer) {
        this.answer = answer;
    }

    @Override
    public String toString() {
        return "WrongQuestions{" +
                "id=" + id +
                ", userId=" + userId +
                ", questionId=" + questionId +
                ", typeName='" + typeName + '\'' +
                ", content='" + content + '\'' +
                ", answer='" + answer + '\'' +
                ", count=" + count +
                '}';
    }
}

package user.service.impl;

import user.dao.UserDao;
import user.dao.impl.UserDaoImpl;
import user.entity.User;
import user.service.UserService;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 15:25
 */
public class UserServiceImpl implements UserService {
    private UserDao userDao=new UserDaoImpl();
    @Override
    public int insert(User user) {
        return userDao.insert(user);
    }

    @Override
    public int delete(int id) {
        return userDao.delete(id);
    }

    @Override
    public int update(User user) {
        return userDao.update(user);
    }

    @Override
    public List<User> selectAll() {
        return userDao.selectAll();
    }

    @Override
    public User selectById(int id) {
        return userDao.selectById(id);
    }

    @Override
    public int login(String loginName, String password) {
        return userDao.login(loginName,password);
    }
}

package user.service.impl;

import user.dao.WrongQuestionDao;
import user.dao.impl.WrongQuestionDaoImpl;
import user.entity.WrongQuestions;
import user.service.WrongQuestionService;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-07 17:23
 */
public class WrongQuestionServiceImpl implements WrongQuestionService {
    private WrongQuestionDao wrongQuestionDao=new WrongQuestionDaoImpl();

    @Override
    public int insert(WrongQuestions wrongQuestions) {
        return wrongQuestionDao.insert(wrongQuestions);
    }

    @Override
    public int delete(int id) {
        return wrongQuestionDao.delete(id);
    }

    @Override
    public int update(WrongQuestions wrongQuestions) {
        return wrongQuestionDao.update(wrongQuestions);
    }

    @Override
    public List<WrongQuestions> selectAll() {
        return wrongQuestionDao.selectAll();
    }

    @Override
    public List<WrongQuestions> selectByUserId(int id) {
        return wrongQuestionDao.selectByUserId(id);
    }
}

package user.service;

import user.entity.User;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-05 15:25
 */
public interface UserService {
    int insert(User user);
    int delete(int id);
    int update(User user);
    List<User> selectAll();
    User selectById(int id);
    int login(String loginName, String password);
}

package user.service;

import user.entity.WrongQuestions;

import java.util.List;

/**
 * @author 阿水
 * @create 2023-02-07 17:23
 */
public interface WrongQuestionService {
    int insert(WrongQuestions wrongQuestions);
    int delete(int id);
    int update(WrongQuestions wrongQuestions);
    List<WrongQuestions> selectAll();
    List<WrongQuestions> selectByUserId(int id);
}

package utils;

import java.sql.*;

/**
 * @author 阿水
 * @create 2023-02-04 19:20
 */
public class BaseDao {
    //!!!!resultSet
    private String url = "jdbc:mysql://localhost:3306/finalquestionbank?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai";
    private String root = "root";
    private String pwd = "XXXXXXXX";
    private Connection connection;
    private PreparedStatement preparedStatement;
    private ResultSet resultSet;

    /**
     * 增删改数据库 返回被执行操作的行数
     * @param sql
     * @return
     * @throws Exception
     */
    protected int update(String sql) throws Exception{
        int var = 1;
        PreparedStatement pst=getPreparedStatement(sql);
        var = pst.executeUpdate();
        this.closeAll();
        return var;
    }

    /**
     * 查询 select 返回resultSet数据类型数据
     * @param sql
     * @return
     * @throws Exception
     */
    protected ResultSet find(String sql) throws Exception {
        PreparedStatement pst1=getPreparedStatement(sql);
        resultSet = pst1.executeQuery();
        return resultSet;
    }
   /* protected ResultSet findByLogin(String sql) throws Exception {
        PreparedStatement pst1=getPreparedStatement(sql);
        resultSet = pst1.executeQuery();
        return resultSet;
    }*/

    public Connection getConnection() throws Exception {
        if (connection == null) {
            Class.forName("com.mysql.cj.jdbc.Driver");
            this.connection = DriverManager.getConnection(url, root, pwd);
        }
        return connection;
    }

    public PreparedStatement getPreparedStatement(String sql) throws Exception {
        this.preparedStatement = getConnection().prepareStatement(sql);
        return preparedStatement;
    }

    /**
     * 关闭所有的SQL流
     */
    public void closeAll() {
        try {
            if (this.resultSet != null) {

                this.resultSet.close();
            }
            if (this.preparedStatement!=null){

                this.preparedStatement.close();
            }
            if (this.connection!=null){

                this.connection.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        this.connection=null;
    }


}