Test类：
package 试题信息管理系统数据库版;
public class Test {
public static void main(String[] args) {
new QuestionInfo().Menu();//调用菜单
}
}
信息类：
package 试题信息管理系统数据库版;
public class QuestionInfoManger {
//试题编号
int Questionid;
//题干
String Question;
//选项A
String optionA;
//选项B
String optionB;
//选项C
String optionC;
//选项D
String optionD;
//科目
String subject;
//正确答案
String answer;
public int getQuestionid() {
return Questionid;
}
public void setQuestionid(int questionid) {
Questionid = questionid;
}
public String getQuestion() {
return Question;
}
public void setQuestion(String question) {
Question = question;
}
public String getOptionA() {
return optionA;
}
public void setOptionA(String optionA) {
this.optionA = optionA;
}
public String getOptionB() {
return optionB;
}
public void setOptionB(String optionB) {
this.optionB = optionB;
}
public String getOptionC() {
return optionC;
}
public void setOptionC(String optionC) {
this.optionC = optionC;
}
public String getOptionD() {
return optionD;
}
public void setOptionD(String optionD) {
this.optionD = optionD;
}
public String getSubject() {
return subject;
}
public void setSubject(String subject) {
this.subject = subject;
}
public String getAnswer() {
return answer;
}
public void setAnswer(String answer) {
this.answer = answer;
}
@Override
public String toString() {
return Questionid+"、"+Question+"\n"+"\t\t\t"+"选项A:"+optionA
+"\n"+"\t\t\t"+"选项B:"+optionB+"\n"+"\t\t\t"+"选项C:"+optionC
+"\n"+"\t\t\t"+"选项D:"+optionD+"\t\t\t"+"\n"+"\t\t\t"+"正确答案:"+answer+"\n";
}
}
菜单类：
package 试题信息管理系统数据库版;
import java.sql.*;
import java.util.ArrayList;
import java.util.Scanner;
public class QuestionInfo {
//定义QuestionInfoManger对象数组
static ArrayList<QuestionInfoManger> Question=new ArrayList<>();
//初始化信息
public void Initialization(){
Connection connection=null;
Statement statement=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("连接MySQL...");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/questioninfo?characterEncoding=utf-8&rewriteBatchedStatement=true","root","root");
System.out.println("连接成功！");
statement = connection.createStatement();
String sql = "select * from questioninfo";
ResultSet resultSet = statement.executeQuery(sql);
//填充数据到数组中
while (resultSet.next()) {
int questionid = resultSet.getInt("questionid");
String question = resultSet.getString("question");
String optionA = resultSet.getString("optionA");
String optionB = resultSet.getString("optionB");
String optionC = resultSet.getString("optionC");
String optionD = resultSet.getString("optionD");
String subject =resultSet.getString("subject");
String answer =resultSet.getString("answer");
//创建对象
QuestionInfoManger questionInfoManger=new QuestionInfoManger();
//填充信息到对象
questionInfoManger.setQuestionid(questionid);
questionInfoManger.setQuestion(question);
questionInfoManger.setOptionA(optionA);
questionInfoManger.setOptionB(optionB);
questionInfoManger.setOptionC(optionC);
questionInfoManger.setOptionD(optionD);
questionInfoManger.setSubject(subject);
questionInfoManger.setAnswer(answer);
//将对象添加到对象数组中
Question.add(questionInfoManger);
}
//释放资源
connection.close();
statement.close();
resultSet.close();
}catch (Exception e){
e.printStackTrace();
}finally {
//释放资源
try {
if (connection!=null) connection.close();
}catch (Exception e){
e.printStackTrace();
}
try {
if (statement!=null) statement.close();
}catch (Exception e){
e.printStackTrace();
}
}
}
//菜单
public void Menu(){
while (true){
System.out.println("*****************欢迎使用试题管理系统*****************");
System.out.println();
System.out.println("请选择操作(1.列出所有试题 2.按科目查询 3.按题干查询 4.添加试题 5.删除试题 6.退出系统)");
Scanner scanner=new Scanner(System.in);
int num=scanner.nextInt();
switch (num){
case 1:
for (int i = 0; i < Question.size(); i++) {
Question.remove(i);
}
one();break;
case 2:
for (int i = 0; i < Question.size(); i++) {
Question.remove(i);
}
two();break;
case 3:
for (int i = 0; i < Question.size(); i++) {
Question.remove(i);
}
three();break;
case 4:
four();break;
case 5:
five();break;
case 6:
six();break;
default:
System.out.println("输入错误，请重新输入！");
}
}
}
//1.列出所有试题
public void one(){
Initialization();
for (int i = 0; i < Question.size(); i++) {
System.out.println(Question.get(i).toString());
}
}
//2.按科目查询
public void two(){
Initialization();
System.out.println("请输入科目:(1.Java 2.C# 3.JSP)");
Scanner scanner=new Scanner(System.in);
int num=scanner.nextInt();
switch (num){
case 1:
for (int i = 0; i < Question.size(); i++) {
if (Question.get(i).subject.equals("Java")) {
System.out.println(Question.get(i).toString());
}
}
break;
case 2:
for (int i = 0; i < Question.size(); i++) {
if (Question.get(i).subject.equals("C#")) {
System.out.println(Question.get(i).toString());
}
}
break;
case 3:
for (int i = 0; i < Question.size(); i++) {
if (Question.get(i).subject.equals("JSP")) {
System.out.println(Question.get(i).toString());
}
}
break;
default:
System.out.println("输出错误，请重新输入！");
}
}
//3.按题干查询
public void three(){
Initialization();
System.out.println("请输入题干:");
Scanner scanner=new Scanner(System.in);
String str=scanner.nextLine();
for(int i=0;i<Question.size();i++){
if(Question.get(i).getQuestion().indexOf(str)>=0) {
System.out.println(Question.get(i).toString());
}
}
}
//4.添加试题
public void four(){
int size=Question.size()+1;
Scanner scanner=new Scanner(System.in);
System.out.println("请输入题干:");
String question=scanner.nextLine();
System.out.println("请输入选项A:");
String optionA=scanner.nextLine();
System.out.println("请输入选项B:");
String optionB=scanner.nextLine();
System.out.println("请输入选项C:");
String optionC=scanner.nextLine();
System.out.println("请输入选项D:");
String optionD=scanner.nextLine();
System.out.println("请输入科目:");
String subject=scanner.nextLine();
System.out.println("请输入答案:");
String answer=scanner.nextLine();
Connection connection=null;
Statement statement=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("连接MySQL...");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/questioninfo?characterEncoding=utf-8&rewriteBatchedStatement=true","root","root");
System.out.println("连接成功！");
statement = connection.createStatement();
String sql="insert into questioninfo(question,optionA,optionB,optionC,optionD,subject,answer) values("+"'"+question+"',"+"'"+optionA+"',"+"'"+optionB+"',"+"'"+optionC+"',"+"'"+optionD+"',"+"'"+subject+"',"+"'"+answer+"'"+");";
int i = statement.executeUpdate(sql);
if (i>=1){
System.out.println("添加成功");
}else {
System.out.println("添加失败");
}
connection.close();
statement.close();
}catch (Exception e){
e.printStackTrace();
}finally {
try {
if (connection!=null) connection.close();
}catch (Exception e){
e.printStackTrace();
}
try {
if (statement!=null) statement.close();
}catch (Exception e){
e.printStackTrace();
}
}
}
// 5.删除试题
public void five(){
while (true){
System.out.println("请输入要删除的试题编号:");
Scanner scanner=new Scanner(System.in);
int i=scanner.nextInt();
Connection connection=null;
Statement statement=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("连接MySQL...");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/questioninfo?characterEncoding=utf-8&rewriteBatchedStatement=true","root","root");
System.out.println("连接成功！");
statement = connection.createStatement();
String sql="delete from questioninfo where questionid="+i;
int k = statement.executeUpdate(sql);
if (k>=1){
System.out.println("删除成功");
}else {
System.out.println("对不起，没有要删除的试题编号，请重新输入");
}
connection.close();
statement.close();
}catch (Exception e){
e.printStackTrace();
}finally {
try {
if (connection!=null) connection.close();
}catch (Exception e){
e.printStackTrace();
}
try {
if (statement!=null) statement.close();
}catch (Exception e){
e.printStackTrace();
}
}
break;
}
}
//6.退出系统
public void six(){
System.out.println("退出系统");
System.exit(0);
}
}
网友评论