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

阅读原文时间：2023年07月08日阅读：2

1 package controller;
2
3 import admin.entity.Admin;
4 import admin.service.AdminService;
5 import admin.service.impl.AdminServiceImpl;
6 import questionBank.entity.*;
7 import questionBank.service.ExamService;
8 import questionBank.service.Impl.ExamServiceImpl;
9 import questionBank.service.Impl.QuestionBankServiceImpl;
10 import questionBank.service.Impl.ScoreSheetServiceImpl;
11 import questionBank.service.QuestionBankService;
12 import questionBank.service.ScoreSheetService;
13 import user.entity.User;
14 import user.entity.WrongQuestions;
15 import user.service.UserService;
16 import user.service.WrongQuestionService;
17 import user.service.impl.UserServiceImpl;
18 import user.service.impl.WrongQuestionServiceImpl;
19 import utils.BaseDao;
20
21 import java.text.SimpleDateFormat;
22 import java.util.ArrayList;
23 import java.util.Date;
24 import java.util.List;
25 import java.util.Scanner;
26
27 /**
28 * @author 阿水
29 * @create 2023-02-04 19:48
30 *
31 * _ooOoo_
32 * o8888888o
33 * 88" . "88
34 * (| -_- |)
35 * O\ = /O
36 * ____/`---'\____
37 * .' \\| |// `.
38 * / \\||| : |||// \
39 * / _||||| -:- |||||- \
40 * | | \\\ - /// | |
41 * | \_| ''\---/'' | |
42 * \ .-\__ `-` ___/-. /
43 * ___`. .' /--.--\ `. . __
44 * ."" '< `.___\_<|>_/___.' >'"".
45 * | | : `- \`.;`\ _ /`;.`/ - ` : | |
46 * \ \ `-. \_ __\ /__ _/ .-` / /
47 * ======`-.____`-.___\_____/___.-`____.-'======
48 * `=---='
49 * ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
50 * 佛祖保佑永无BUG
51 *
52 */
53 public class Main extends BaseDao {
54 public static void main(String[] args) {
55 UserService userService = new UserServiceImpl();
56 AdminService adminService = new AdminServiceImpl();
57 QuestionBankService questionBankService = new QuestionBankServiceImpl();
58 ScoreSheetService scoreSheetService = new ScoreSheetServiceImpl();
59 WrongQuestionService wrongQuestionService = new WrongQuestionServiceImpl();
60 ExamService examService = new ExamServiceImpl();
61 SimpleDateFormat sdf = new SimpleDateFormat();// 格式化时间
62 sdf.applyPattern("yyyy-MM-dd HH:mm:ss");// a为am/pm的标记
63 Scanner sc = new Scanner(System.in);
64 while (true) {
65 System.out.println("1、管理员");
66 System.out.println("2、用户");
67 int x = sc.nextInt();
68 if (x == 1) {
69 System.out.println("请输入管理员用户名");
70 String loginName = sc.next();
71 System.out.println("请输入管理员密码");
72 String password = sc.next();
73 int loginAdminId = adminService.login(loginName, password);
74 if (loginAdminId > 0) {
75 System.out.println("登陆完成");
76 while (true) {
77 System.out.println("1、查看所有题目");
78 System.out.println("2、添加题目");
79 System.out.println("3、删除题目");
80 System.out.println("4、新注册管理员");
81 System.out.println("5、出试卷");
82 System.out.println("6、查看试卷");
83 System.out.println("7、查看成绩");
84 int y = sc.nextInt();
85 if (y == 1) {
86 //查看所有题目
87 List questionBanks = questionBankService.selectAll();
88 for (QuestionBank questionBank : questionBanks) {
89 System.out.println(questionBank);
90 }
91
92 } else if (y == 2) {
93 //添加题目
94 List typeName = questionBankService.findTypeName();
95 for (TypeName name : typeName) {
96 System.out.println(name);
97 }
98 System.out.println("请输入题目类型");
99 String type = sc.next();
100 System.out.println("请输入题目");
101 String content = sc.next();
102 System.out.println("请输入答案");
103 String answer = sc.next();
104 questionBankService.insert(new QuestionBank(0, type, content, answer));
105
106 } else if (y == 3) {
107 //删除题目
108 List questionBanks = questionBankService.selectAll();
109 for (QuestionBank questionBank : questionBanks) {
110 System.out.println(questionBank);
111 }
112 System.out.println("请输入删除题目的id");
113 int id = sc.nextInt();
114 questionBankService.delete(id);
115
116 } else if (y == 4) {
117 //新注册管理员
118 Admin admin = new Admin();
119 System.out.println("请输入管理员名称");
120 String name = sc.next();
121 System.out.println("请输入账号");
122 String loginAdminName = sc.next();
123 System.out.println("请输入密码");
124 String pwd = sc.next();
125 admin.setName(name);
126 admin.setLoginName(loginAdminName);
127 admin.setPassword(pwd);
128 adminService.insert(admin);
129
130 } else if (y == 5) {
131 //出试卷
132 int count = 0;
133 List questionBanks = questionBankService.selectAll();
134 for (QuestionBank questionBank : questionBanks) {
135 System.out.println(questionBank);
136 }
137 System.out.println("请输入本次试卷名称");
138 String examName = sc.next();
139 while (true) {
140 System.out.println("请输入加入考试的题目id,按0结束");
141 int id = sc.nextInt();
142 for (QuestionBank questionBank : questionBanks) {
143 if (id == questionBank.getId()) {
144 examService.insert(id, examName);
145 count--;
146 }
147 count++;
148 }
149 if (count == questionBanks.size()) {
150 System.out.println("查无此题");
151 break;
152 }
153 if (id == 0) {
154 break;
155 }
156 }
157
158 } else if (y == 6) {
159 List exams = examService.selectAll();
160 for (Exam exam : exams) {
161 System.out.println(exam);
162 }
163
164 } else if (y == 7) {
165 List scoreSheets = scoreSheetService.selectAll();
166 for (ScoreSheet scoreSheet : scoreSheets) {
167 System.out.println(scoreSheet);
168 }
169 } else {
170 System.out.println("再见");
171 break;
172 }
173
174 }
175
176
177 } else {
178 System.out.println("登陆失败");
179
180 }
181 } else if (x == 2) {
182
183 while (true) {
184 System.out.println("1、登录");
185 System.out.println("2、注册");
186 int y = sc.nextInt();
187 if (y == 1) {
188 while (true) {
189 System.out.println("请输入登录账号");
190 String loginName = sc.next();
191 System.out.println("请输入登录密码");
192 String password = sc.next();
193 int loginUserId = userService.login(loginName, password);
194 if (loginUserId > 0) {
195 System.out.println("登录完成");
196 while (true) {
197
198 System.out.println("1、刷题模式");
199 System.out.println("2、按照学科刷题模式");
200 System.out.println("3、开始考试");
201 System.out.println("4、按照学科测验练习");
202 System.out.println("5、查看错题本");
203 System.out.println("请输入您的选项");
204 int z = sc.nextInt();
205 if (z == 1) {
206 ArrayList QuestionBank = new ArrayList<>();
207 List questionBanks = questionBankService.selectAll();
208 for (questionBank.entity.QuestionBank questionBank : questionBanks) {
209 System.out.println(questionBank);
210 }
211
212 } else if (z == 2) {
213 //按照学科刷题模式
214 //ArrayList QuestionBank = new ArrayList<>();
215 List typeName = questionBankService.findTypeName();
216 for (TypeName name : typeName) {
217 System.out.println(name);
218 }
219 System.out.println("请您完整输入课程学科");
220 String inputTypeName = sc.next();
221 int count = 0;
222 for (TypeName name : typeName) {
223 if (name.getName().equals(inputTypeName)) {
224 count++;
225 }
226 }
227 if (count == 0) {
228 System.out.println("课程不存在请仔细检查");
229 break;
230 } else {
231 List questionBankByType = questionBankService.selectByType(inputTypeName);
232 for (QuestionBank questionBank : questionBankByType) {
233 System.out.println(questionBank);
234 }
235 }
236
237 } else if (z == 3) {
238 // 输出已经格式化的现在时间（24小时制）
239 List examNames = examService.selectByName();
240 for (ExamName examName : examNames) {
241 System.out.println(examName);
242 }
243 System.out.println("请您完整输入考试名称");
244 String inputTypeName = sc.next();
245 int count = 0;
246 for (ExamName examName : examNames) {
247 if (examName.getName().equals(inputTypeName)) {
248 count++;
249 System.out.println("这是考试模式记录成绩！！！！！");
250 }
251 }
252 if (count == 0) {
253 System.out.println("课程不存在请仔细检查");
254 } else {
255
256 //select * from exam inner join questionbank on exam.questionid = questionbank.id where examName = '无敌巨难试卷';
257 List exams = examService.selectByType(inputTypeName);
258 double number = 0;
259 double scoreByUser = 0;
260 for (Exam exam : exams) {
261 System.out.println(exam.getTypeName() + " " + exam.getContent());
262 System.out.println("请输入答案");
263 String answerByUser = sc.next();
264 if (answerByUser.equals(exam.getAnswer())) {
265 scoreByUser++;
266 }/*else {
267 //wrongQuestionService.insert();
268 List wrongQuestions = wrongQuestionService.selectByUserId(loginUserId);
269 int var=0;
270 for (WrongQuestions wrongQuestion : wrongQuestions) {
271 System.out.println(wrongQuestion);
272
273 if (wrongQuestion.getContent().equals(exam.getContent())) {
274 wrongQuestionService.update(new WrongQuestions(loginUserId, wrongQuestion.getContent()));
275 break;
276 } else {
277 var++;
278 }
279 if (var == wrongQuestions.size()) {
280 wrongQuestionService.insert(new WrongQuestions(loginUserId,exam.getQuestionId()));
281 }
282 }
283
284 }*/
285 number++;
286 }
287
288 double sumScore = (scoreByUser / number) * 100;
289 String str = String.format("%.1f", sumScore);
290 System.out.println("您考试考了" + str + "分");
291 double finalScore = Double.parseDouble(str);
292 //(int scoreId, String examName, double score, Timestamp dateTime, int userId, String userName)
293 Date date = new Date();// 获取当前时间
294 System.out.println(sdf.format(date));
295 ScoreSheet scoreSheet1 = new ScoreSheet(1, inputTypeName, finalScore, sdf.format(date).toString(), loginUserId, loginName);
296 scoreSheetService.insert(scoreSheet1);
297 }
298
299 } else if (z == 4) {
300 //按照学科刷题
301 List typeName = questionBankService.findTypeName();
302 for (TypeName name : typeName) {
303 System.out.println(name);
304 }
305 System.out.println("请您完整输入课程学科");
306 String inputTypeName = sc.next();
307 int count = 0;
308 for (TypeName name : typeName) {
309 if (name.getName().equals(inputTypeName)) {
310 count++;
311 }
312 }
313 if (count == 0) {
314 System.out.println("课程不存在请仔细检查");
315 } else {
316 List questionBankByType = questionBankService.selectByType(inputTypeName);
317 System.out.println("这是娱乐模式不记录成绩");
318 double number = 0;
319 double scoreByUser = 0;
320 for (QuestionBank questionBank : questionBankByType) {
321 System.out.println(questionBank.getType() + " " + questionBank.getContent());
322 System.out.println("请输入答案");
323 String answerByUser = sc.next();
324 if (answerByUser.equals(questionBank.getAnswer())) {
325 scoreByUser++;
326 } else {
327 //wrongQuestionService.insert();
328 List wrongQuestions = wrongQuestionService.selectByUserId(loginUserId);
329 int var=0;
330 for (WrongQuestions wrongQuestion : wrongQuestions) {
331 //System.out.println(wrongQuestion);
332
333 if (wrongQuestion.getContent().equals(questionBank.getContent())) {
334 wrongQuestionService.update(new WrongQuestions(loginUserId, wrongQuestion.getContent()));
335 break;
336 } else {
337 var++;
338 }
339 if (var == wrongQuestions.size()) {
340 wrongQuestionService.insert(new WrongQuestions(loginUserId, questionBank.getId()));
341 }
342 }
343
344 }
345 number++;
346 }
347 double sumScore = (scoreByUser / number) * 100;
348 String str = String.format("%.1f", sumScore);
349 System.out.println("您本次测验考了" + str + "分");
350 System.out.println("考试结束，记录已上传无法再打开");
351
352
353 }
354 } else if (z == 5) {
355 List wrongQuestions = wrongQuestionService.selectByUserId(loginUserId);
356 for (WrongQuestions wrongQuestion : wrongQuestions) {
357 System.out.println("类型:" + wrongQuestion.getTypeName() + " 题目:" + wrongQuestion.getContent() + " 答案:" + wrongQuestion.getAnswer() + " 累计错误次数:" + wrongQuestion.getCount() + "次");
358 }
359 } else {
360 System.out.println("再见");
361 break;
362 }
363 }
364
365 } else {
366 System.out.println("登陆失败");
367 break;
368 }
369
370
371 }
372 } else if (y == 2) {
373 System.out.println("请输入姓名");
374 String name = sc.next();
375 System.out.println("请输入登录账号");
376 String loginName = sc.next();
377 System.out.println("请输入登录密码");
378 String password = sc.next();
379 userService.insert(new User(0, name, loginName, password));
380 System.out.println("注册完成啦！！！快去登陆吧哈哈嗨");
381 } else {
382 System.out.println("拜拜了您嘞");
383 break;
384 }
385
386
387 }
388
389 }
390
391 }
392
393 }
394 }

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 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 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 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 selectAll();
QuestionBank selectById(int id);
List findTypeName();
List 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 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 selectAll();
Exam selectById(int id);
List 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 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 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 selectAll();
List selectByContent();
List 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 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 selectAll();
List 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;  
}

}

手机扫一扫

移动阅读更方便

你可能感兴趣的文章

Sql Server海量数据插入

Redis进阶实践之九独立封装的RedisClient客户端工具类

Java IO编程全解（三）——伪异步IO编程

java之jvm学习笔记十三(jvm基本结构)

INotifyPropertyChanged接口的实现

Java数据结构和算法（九）——高级排序

Java中普通代码块，构造代码块，静态代码块执行顺序

04-01 Java switch、for、while、do while语句，循环嵌套，跳转语句break、continue、return

DataGridView导出Excel

第五章 springboot + mybatis(转载)