如何将word中汉字分割为单个并插入数据库？

一，做这个功能的原因

家里的小朋友在读小学一年级，发现她很多数学题会做但是题目不会读，于是我花了三天时间，和她一起把她在教科书上不认识的字都做好标记，然后抄录到了word文档里面，但是有个问题，我发现这里面的字很多是重复的，于是我想到要不把这些字去重，然后再后面开发一个微信小游戏，让她在游戏里面学习这些生字，说干就干。

二、java代码实现，让word中生字入库，再去重导出

第一步，导入数据库crud相关jar包，持久层mybatis,数据库mysql

1.导数据相关jar包

<dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.6</version>
</dependency>
<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>6.0.6</version>
</dependency>

2.mybatis配置文件,在src/mian/java目录下创建resources目录，创建mybatis-config.xml文件，并右键mark dictionary as为根目录，这样mybatis才能找得到。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/demo01?useUnicode=true&amp;characterEncoding=utf8&amp;serverTimezone=Asia/Shanghai&amp;useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="org/example/mapper/WordDisMapper.xml"/>
    </mappers>
</configuration>

3.创建mapper接口WordDisMapper.java和WordDisMapper.xml文件，后面就比较简单，这边省略了。

4.测试数据库连接,数据入库了

public class App 
{
    public static void main( String[] args ) throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession(true);
        WordDisMapper mapper = sqlSession.getMapper(WordDisMapper.class);   
        mapper.insertWord("123456");

    }
}

5.导入word操作jar包

 <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>4.1.2</version>
 </dependency>
 <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>4.1.2</version>
 </dependency>

6.在main方法中调用word操作的相关方法

public class App 
{
    public static void main( String[] args ) throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession(true);
        try {
            File file=new File("C:\\Users\\yao\\Desktop\\333333.docx");
            FileInputStream fileInputStream=new FileInputStream(file);
            XWPFDocument document=new XWPFDocument(fileInputStream);
            XWPFWordExtractor extractor=new XWPFWordExtractor(document);
            String str=extractor.getText();
            WordDisMapper mapper = sqlSession.getMapper(WordDisMapper.class);
            for(int i=1;i<str.length();i++){
                String wordDis2=str.substring(i,i+1);
                mapper.insertWord(wordDis2);
            }
        }finally {
            sqlSession.close();
        }


    }
}

7.最后大功告成，数据入库了，然后我通过sql去重查询，导出数据

 三、准备认字微信小游戏的开发

待完成。。。