word试卷导入数据库java_java读取word表格导入数据库，支持doc、docx

导入Word表格数据到数据库可以分为以下几步：

1. 读取Word文档中的表格数据
2. 连接数据库，并创建表格
3. 将读取到的表格数据插入到数据库中

下面是代码示例：

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import org.apache.poi.hwpf.HWPFDocument;
import org.apache.poi.hwpf.usermodel.Table;
import org.apache.poi.hwpf.usermodel.TableCell;
import org.apache.poi.hwpf.usermodel.TableIterator;
import org.apache.poi.hwpf.usermodel.TableRow;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.xwpf.usermodel.XWPFDocument;
import org.apache.poi.xwpf.usermodel.XWPFTable;
import org.apache.poi.xwpf.usermodel.XWPFTableRow;
import org.apache.poi.xwpf.usermodel.XWPFTableCell;

public class WordToDatabase {
    public static void main(String[] args) {
        String fileName = "test.docx";
        String url = "jdbc:mysql://localhost:3306/test";
        String user = "root";
        String password = "123456";
        String tableName = "word_table";

        Connection conn = null;
        PreparedStatement ps = null;

        try {
            // 连接数据库
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(url, user, password);

            // 创建表格
            String createTableSql = "CREATE TABLE " + tableName + " (";
            createTableSql += "id INT NOT NULL AUTO_INCREMENT, ";

            // 读取Word文档中的表格数据
            File file = new File(fileName);
            FileInputStream fis = new FileInputStream(file);
            POIFSFileSystem pfs = new POIFSFileSystem(fis);
            HWPFDocument hwpf = new HWPFDocument(pfs);
            TableIterator iterator = new TableIterator(hwpf);

            while (iterator.hasNext()) {
                Table table = iterator.next();
                for (int i = 0; i < table.numRows(); i++) {
                    TableRow row = table.getRow(i);
                    createTableSql += "col_" + i + " VARCHAR(255), ";
                }
            }

            createTableSql += "PRIMARY KEY (id))";
            ps = conn.prepareStatement(createTableSql);
            ps.executeUpdate();

            // 插入数据
            String insertSql = "INSERT INTO " + tableName + " (";
            for (int i = 0; i < iterator.numTables(); i++) {
                XWPFTable table = iterator.getTables().get(i);
                for (int j = 0; j < table.getRows().size(); j++) {
                    XWPFTableRow row = table.getRow(j);
                    for (int k = 0; k < row.getTableCells().size(); k++) {
                        XWPFTableCell cell = row.getTableCells().get(k);
                        insertSql += "col_" + k + ", ";
                    }
                }
            }

            insertSql = insertSql.substring(0, insertSql.length() - 2);
            insertSql += ") VALUES (";

            for (int i = 0; i < iterator.numTables(); i++) {
                XWPFTable table = iterator.getTables().get(i);
                for (int j = 0; j < table.getRows().size(); j++) {
                    XWPFTableRow row = table.getRow(j);
                    for (int k = 0; k < row.getTableCells().size(); k++) {
                        XWPFTableCell cell = row.getTableCells().get(k);
                        insertSql += "'" + cell.getText() + "', ";
                    }
                }
            }

            insertSql = insertSql.substring(0, insertSql.length() - 2);
            insertSql += ")";
            ps = conn.prepareStatement(insertSql);
            ps.executeUpdate();

            System.out.println("插入成功！");
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (ps != null) {
                    ps.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
}

这段代码可以处理docx格式的Word文档。如果需要处理doc格式的Word文档，只需要将代码中的XWPFDocument改为HWPFDocument即可。