基于Mybatis的随机点名系统

81 阅读 0 评论 54 点赞

我是靠谱客的博主自然乌冬面，最近开发中收集的这篇文章主要介绍基于Mybatis的随机点名系统，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

基于mybatis的随机点名系统

## 缺陷： jacob包导入不进去，一直报错，不然可以实现语音播报功能

导入依赖


<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.3.13</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.25</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.7</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.6</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.13</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.3.13</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.22</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.jacob/jacob 文字转语音 -->
<dependency>
<groupId>com.hynnet</groupId>
<artifactId>jacob</artifactId>
<version>1.18</version>
</dependency>

config类

import org.apache.ibatis.datasource.pooled.PooledDataSource;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
@ComponentScan("com.text")
//扫描mapper目录
@MapperScan("com.text.mapper")
//主配置类
@Configuration
public class Configration {
//
第一种方式
//
编写datasource
@Bean
public DataSource dataSource(){
PooledDataSource dataSource=new PooledDataSource();
//
加载驱动
dataSource.setDriver("com.mysql.cj.jdbc.Driver");
//
编写url，注意这里的db10是我的数据库名
dataSource.setUrl("jdbc:mysql://localhost:3306/db10?useUnicode=true&characterEncoding=UTF-8&userSSL=false&serverTimezone=GMT%2B8");
//
编写账号
dataSource.setUsername("root");
//
编写密码
dataSource.setPassword("123456");
return dataSource;
}
//
编写SqlSessionFactoryBean
@Bean
public SqlSessionFactoryBean sqlSessionFactoryBean(@Autowired DataSource dataSource){
SqlSessionFactoryBean bean=new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
return bean;
}
}

student实体类

import lombok.Data;
//为了打印tostring方法
@Data
public class Student {
int id;
String name;
String sex;
}

mapper接口

import com.text.entry.Student;
import org.apache.ibatis.annotations.Select;
import java.util.List;
//mapper，这里是数据源，用来操作数据库
//这是一个接口
public interface Mapper {
@Select("select name from Student where id like #{sex}")
List<String> findByName(String sex);
}

service接口

import com.text.entry.Student;
import java.util.List;
//service接口
public interface Service {
List<String> findByName(String sex);
}

service实现类


import com.text.entry.Student;
import com.text.mapper.Mapper;
import com.text.service.Service;
import org.springframework.stereotype.Component;
import javax.annotation.Resource;
import java.util.List;
//bean
@Component
//实现接口
public class ServiceImpl implements Service {
//
数据源
@Resource
Mapper mapper;
public List<String> findByName(String sex) {
return mapper.findByName("%");
}
}

main方法

import com.text.config.Configration;
import com.text.service.Service;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;
import java.util.LinkedList;
import java.util.List;
import java.util.Random;
//主方法
public class Main {
public static void main(String[] args) throws InterruptedException {
//
加载配置类
AnnotationConfigApplicationContext context=new AnnotationConfigApplicationContext(Configration.class);
//
加载service接口，这里并没有直接调用service实现类
Service service = context.getBean(Service.class);
//
测试
//
System.out.println(service.findByName("1"));
List<String> and =service.findByName("1");
int sum=0;
int[] solder =new int [service.findByName("1").size()];
//
System.out.println(solder.length-1);
Random random=new Random();
while (sum<service.findByName("1").size()){
int a=random.nextInt((solder.length));
if(solder[a]==0){
//
System.out.println(a);
System.out.println(and.get(a));
Thread.sleep(2000);
solder[a]=1;
sum++;
}
}
}
}

数据库

/*
Navicat MySQL Data Transfer
Source Server
: fiveGods
Source Server Version : 80016
Source Host
: localhost:3306
Source Database
: db10
Target Server Type
: MYSQL
Target Server Version : 80016
File Encoding
: 65001
Date: 2022-03-02 10:55:04
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`sex` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('1', 'wei', '男');
INSERT INTO `student` VALUES ('2', '测试2', '男');
INSERT INTO `student` VALUES ('6', '测试3', '男');
INSERT INTO `student` VALUES ('7', '测试4', '男');