【读取具有特定格式的文件】

Create a table named Quiz within a database called ExamDB. You should use the embedded Java DB mode to implement this database.

Data is stored in a text file in the following csv format (questionNumber, description, choice1, choice2, choice3, choice4, Answer). Create your own csv text file containing quiz questions. Read from this file and store the records in the Quiz table within the ExamDB database.

Give the user a simple MCQ test from your Quiz table with 3 questions each time (one at a time and different each time), and print how many they got right and wrong.

 

Quiz.java

package com.zx.util;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.Random;
import java.util.Scanner;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.zx.bean.Quiz;
import com.zx.dao.QuizMapper;

/**
 * @author 作者
 * @version 创建时间:2019年10月28日 下午6:52:29
 * @email zxiao@stu.ouc.edu.cn 类说明
 */
public class MyUtil {
	// @Test
	public List<String> readFile() {
		List<String> list = new ArrayList<String>();
		File f = new File("csv/file.txt");
		BufferedReader br = null;
		try {
			br = new BufferedReader(new FileReader(f));
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		}
		String line = null;
		try {
			while ((line = br.readLine()) != null) {
				list.add(line);
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
		return list;
	}

	public List<Quiz> analysisString(List<String> list) {
		int i = 0;
		List<Quiz> listQuiz = new ArrayList<>();
		Quiz q = new Quiz();
		while (i != list.size()) {// 遍历所有行
			String str = list.get(i);
			if (str != null && str.charAt(0) >= 49 && str.charAt(0) <= 57) {// 判断是否为题干
				q.setQuestionNumber(Integer.parseInt(str.substring(0, str.indexOf("."))));
				q.setDescription(str.substring(str.indexOf(".") + 1));
			} else {// 如果为选项
				switch (str.charAt(0)) {
				case 'A':
					q.setChoice1(str.substring(str.indexOf(".") + 1));
					break;
				case 'B':
					q.setChoice2(str.substring(str.indexOf(".") + 1));
					break;
				case 'C':
					q.setChoice3(str.substring(str.indexOf(".") + 1));
					break;
				case 'D':
					q.setChoice4(str.substring(str.indexOf(".") + 1, str.length() - 2));
					q.setAnswer(str.charAt(str.length() - 1) + "");// 将答案赋值
					listQuiz.add(q);
					q = new Quiz();
					break;
				default:
					System.out.println("遇到空白行");
					break;
				}
			}
			i++;
		}
		return listQuiz;
	}

	public SqlSessionFactory getSqlSessionFactory() throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		return new SqlSessionFactoryBuilder().build(inputStream);
	}

	public void insertIntoDb() throws IOException {
		MyUtil mu = new MyUtil();
		List<String> readFile = mu.readFile();
		List<Quiz> listQuiz = mu.analysisString(readFile);
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession openSession = sqlSessionFactory.openSession();
		try {
			QuizMapper mapper = openSession.getMapper(QuizMapper.class);
			for (Quiz quiz : listQuiz) {
				mapper.addQuiz(quiz);
			}
			openSession.commit();
		} finally {
			openSession.close();
		}
	}

	public List<Quiz> getExam() throws IOException {
		int arr[] = new int[3];
		List<Quiz> quiz = new ArrayList<>();
		arr = getRandomNotSame(3, 10);
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession openSession = sqlSessionFactory.openSession();
		try {
			QuizMapper mapper = openSession.getMapper(QuizMapper.class);
			for (int i = 0; i < 3; i++) {
				quiz.add(mapper.getQuizById(arr[i]));
			}

		} finally {
			openSession.close();
		}
		return quiz;
	}

	public void showView() throws IOException {
		List<Quiz> quiz = getExam();
		int right = 0;
		int wrong = 0;
		List<String> list = new ArrayList<>();
		for (int i = 0; i < 3; i++) {
			int myArr[] = new int[4];
			myArr = getRandomNotSame(4, 4);
			list.add(quiz.get(i).getChoice1());
			list.add(quiz.get(i).getChoice2());
			list.add(quiz.get(i).getChoice3());
			list.add(quiz.get(i).getChoice4());
			System.out.println(i + 1 + "." + quiz.get(i).getDescription());
			System.out.println("A." + list.get(myArr[0]));
			System.out.println("B." + list.get(myArr[1]));
			System.out.println("C." + list.get(myArr[2]));
			System.out.println("D." + list.get(myArr[3]));
			System.out.println("plz input your answer:");
			Scanner sc = new Scanner(System.in);
			String str = sc.nextLine();
			if (str.equals(quiz.get(i).getAnswer())) {
				right++;
			} else {
				wrong++;
			}
		}
		System.out.println("right:" + right);
		System.out.println("wrong:" + wrong);
	}

	public int[] getRandomNotSame(int num, int range) {
		int arr[] = new int[num];
		Random random = new Random();
		for (int i = 0; i < num; i++) {
			int j = 0;
			int rs = random.nextInt(range);
			while (j < i) {
				if (arr[j] == rs) {
					rs = random.nextInt(range);
					j = 0;
				} else {
					j++;
				}
			}
			arr[i] = rs;
		}
		return arr;
	}
}

QuizMapper.java

package com.zx.dao;

import com.zx.bean.Quiz;

/**
* @author 作者
* @version 创建时间:2019年10月28日 下午4:08:51
* @email zxiao@stu.ouc.edu.cn
* 类说明
*/
public interface QuizMapper {

	public void addQuiz(Quiz q);
	
	public Quiz getQuizById(Integer id);
	
	
}

Exam.java

package com.zx.main;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.zx.bean.Quiz;
import com.zx.dao.QuizMapper;
import com.zx.util.MyUtil;

/**
 * @author 作者
 * @version 创建时间:2019年10月28日 下午4:10:59
 * @email zxiao@stu.ouc.edu.cn 类说明
 */
public class Exam {

	public static void main(String[] args) throws IOException {
		MyUtil mu = new MyUtil();
		mu.insertIntoDb();
		mu.showView();
	}
}

MyUtil.java

package com.zx.util;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.Random;
import java.util.Scanner;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.zx.bean.Quiz;
import com.zx.dao.QuizMapper;

/**
 * @author 作者
 * @version 创建时间:2019年10月28日 下午6:52:29
 * @email zxiao@stu.ouc.edu.cn 类说明
 */
public class MyUtil {
	// @Test
	public List<String> readFile() {
		List<String> list = new ArrayList<String>();
		File f = new File("csv/file.txt");
		BufferedReader br = null;
		try {
			br = new BufferedReader(new FileReader(f));
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		}
		String line = null;
		try {
			while ((line = br.readLine()) != null) {
				list.add(line);
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
		return list;
	}

	public List<Quiz> analysisString(List<String> list) {
		int i = 0;
		List<Quiz> listQuiz = new ArrayList<>();
		Quiz q = new Quiz();
		while (i != list.size()) {// 遍历所有行
			String str = list.get(i);
			if (str != null && str.charAt(0) >= 49 && str.charAt(0) <= 57) {// 判断是否为题干
				q.setQuestionNumber(Integer.parseInt(str.substring(0, str.indexOf("."))));
				q.setDescription(str.substring(str.indexOf(".") + 1));
			} else {// 如果为选项
				switch (str.charAt(0)) {
				case 'A':
					q.setChoice1(str.substring(str.indexOf(".") + 1));
					break;
				case 'B':
					q.setChoice2(str.substring(str.indexOf(".") + 1));
					break;
				case 'C':
					q.setChoice3(str.substring(str.indexOf(".") + 1));
					break;
				case 'D':
					q.setChoice4(str.substring(str.indexOf(".") + 1, str.length() - 2));
					q.setAnswer(str.charAt(str.length() - 1) + "");// 将答案赋值
					listQuiz.add(q);
					q = new Quiz();
					break;
				default:
					System.out.println("遇到空白行");
					break;
				}
			}
			i++;
		}
		return listQuiz;
	}

	public SqlSessionFactory getSqlSessionFactory() throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		return new SqlSessionFactoryBuilder().build(inputStream);
	}

	public void insertIntoDb() throws IOException {
		MyUtil mu = new MyUtil();
		List<String> readFile = mu.readFile();
		List<Quiz> listQuiz = mu.analysisString(readFile);
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession openSession = sqlSessionFactory.openSession();
		try {
			QuizMapper mapper = openSession.getMapper(QuizMapper.class);
			for (Quiz quiz : listQuiz) {
				mapper.addQuiz(quiz);
			}
			openSession.commit();
		} finally {
			openSession.close();
		}
	}

	public List<Quiz> getExam() throws IOException {
		int arr[] = new int[3];
		List<Quiz> quiz = new ArrayList<>();
		arr = getRandomNotSame(3, 10);
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession openSession = sqlSessionFactory.openSession();
		try {
			QuizMapper mapper = openSession.getMapper(QuizMapper.class);
			for (int i = 0; i < 3; i++) {
				quiz.add(mapper.getQuizById(arr[i]));
			}

		} finally {
			openSession.close();
		}
		return quiz;
	}

	public void showView() throws IOException {
		List<Quiz> quiz = getExam();
		int right = 0;
		int wrong = 0;
		List<String> list = new ArrayList<>();
		for (int i = 0; i < 3; i++) {
			int myArr[] = new int[4];
			myArr = getRandomNotSame(4, 4);
			list.add(quiz.get(i).getChoice1());
			list.add(quiz.get(i).getChoice2());
			list.add(quiz.get(i).getChoice3());
			list.add(quiz.get(i).getChoice4());
			System.out.println(i + 1 + "." + quiz.get(i).getDescription());
			System.out.println("A." + list.get(myArr[0]));
			System.out.println("B." + list.get(myArr[1]));
			System.out.println("C." + list.get(myArr[2]));
			System.out.println("D." + list.get(myArr[3]));
			System.out.println("plz input your answer:");
			Scanner sc = new Scanner(System.in);
			String str = sc.nextLine();
			if (str.equals(quiz.get(i).getAnswer())) {
				right++;
			} else {
				wrong++;
			}
		}
		System.out.println("right:" + right);
		System.out.println("wrong:" + wrong);
	}

	public int[] getRandomNotSame(int num, int range) {
		int arr[] = new int[num];
		Random random = new Random();
		for (int i = 0; i < num; i++) {
			int j = 0;
			int rs = random.nextInt(range);
			while (j < i) {
				if (arr[j] == rs) {
					rs = random.nextInt(range);
					j = 0;
				} else {
					j++;
				}
			}
			arr[i] = rs;
		}
		return arr;
	}
}

QuizMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zx.dao.QuizMapper">
<!-- public void addQuiz(Quiz q);-->
	<insert id="addQuiz">
		insert into quiz(questionNumber,description,choice1,choice2,choice3,choice4,answer) 
		value (#{questionNumber},#{description},#{choice1},#{choice2},#{choice3},#{choice4},#{answer})
	</insert>
<!-- 	public Quiz getQuizById(Integer id);-->
	<select id="getQuizById" resultType="com.zx.bean.Quiz">
		select * from quiz where questionNumber = #{questionNumber}
	</select>
</mapper>

 

 

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
SQLAlchemy 是一个 SQL 工具包和对象关系映射(ORM)库,用于 Python 编程语言。它提供了一个高级的 SQL 工具和对象关系映射工具,允许开发者以 Python 类和对象的形式操作数据库,而无需编写大量的 SQL 语句。SQLAlchemy 建立在 DBAPI 之上,支持多种数据库后端,如 SQLite, MySQL, PostgreSQL 等。 SQLAlchemy 的核心功能: 对象关系映射(ORM): SQLAlchemy 允许开发者使用 Python 类来表示数据库表,使用类的实例表示表中的行。 开发者可以定义类之间的关系(如一对多、多对多),SQLAlchemy 会自动处理这些关系在数据库中的映射。 通过 ORM,开发者可以像操作 Python 对象一样操作数据库,这大大简化了数据库操作的复杂性。 表达式语言: SQLAlchemy 提供了一个丰富的 SQL 表达式语言,允许开发者以 Python 表达式的方式编写复杂的 SQL 查询。 表达式语言提供了对 SQL 语句的灵活控制,同时保持了代码的可读性和可维护性。 数据库引擎和连接池: SQLAlchemy 支持多种数据库后端,并且为每种后端提供了对应的数据库引擎。 它还提供了连接池管理功能,以优化数据库连接的创建、使用和释放。 会话管理: SQLAlchemy 使用会话(Session)来管理对象的持久化状态。 会话提供了一个工作单元(unit of work)和身份映射(identity map)的概念,使得对象的状态管理和查询更加高效。 事件系统: SQLAlchemy 提供了一个事件系统,允许开发者在 ORM 的各个生命周期阶段插入自定义的钩子函数。 这使得开发者可以在对象加载、修改、删除等操作时执行额外的逻辑。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值