将word文档数据导入到sql server数据库中

你的名字 2021-09-16 21:12 688阅读 0赞

### 我现在的需求是这样的，需要将这些题目插入到sql server数据库中。 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzQyNzIw_size_16_color_FFFFFF_t_70][]

![20181103124857443.png][]

### 并且要对应起来，一开始在网上找了很多方法，都没有找到合适的。 ###

**后面感觉，还是自己写一个比较好，因为只有自己写的，才是最适合你的！**

**于是就开始倒腾。**

**1、首先是读取word中的数据，在我上一篇博客中有相关的方式，博客链接：**[https://blog.csdn.net/qq\_36742720/article/details/83686097][https_blog.csdn.net_qq_36742720_article_details_83686097]**。**

**2、主要步骤**

**（1）将word文档整理成你想要的样子**

**（2）通过字符串分隔生成数组**

**（3）将题目数组、选项数组对应起来拼接sql，并执行sql**

**3、具体操作**

**（1）整理word**

下面是我整理题库后整理完成的两份word

链接：https://pan.baidu.com/s/1k7OpLNKTpOp3wR9gYMbLkg   
提取码：er0g   
**（2）在数据库中建好如图所示的表（表名：tb\_radio）**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzQyNzIw_size_16_color_FFFFFF_t_70 1][]

**(3)打开vs，新建一个控制台项目，在App.config中配置你的数据库连接，main()函数中的代码如下**

#region 获取标题数组
    
                //加载Word文档
                Document docTitle = new Document();
                docTitle.LoadFromFile("C:/Users/承蒙时光不弃/Desktop/题目.doc");
    
                //使用GetText方法获取文档中的所有文本
                string titleStr = docTitle.GetText();
                string[] titleArr = titleStr.Split(new string[] { "1．", "2．", "3．", "4．", "5．", "6．", "7．", "8．", "9．", "10．", "11．", "12．", "13．", "14．", "15．", "16．", "17．", "18．", "19．", "20．", "21．", "22．", "23．", "24．", "25．", "26．", "27．", "28．", "29．", "30．", "31．", "32．", "33．", "34．", "35．", "36．", "37．", "38．", "39．", "40．", "41．", "42．", "43．", "44．", "45．", "46．", "47．", "48．", "49．", "50．", }, StringSplitOptions.RemoveEmptyEntries);
    
    
                Console.WriteLine(titleArr.Length);
                //for (int i = 0; i < titleArr.Length; i++)
                //{
                //    Console.WriteLine(titleArr[i].Trim());
                //    Console.WriteLine("------------------------------------------------------");
                //}
                #endregion
    
    
                #region 获取选项数组
                //加载选项文档
                string[,] xuanXiangArr2 = new string[70, 4];
                Document docXuanXiang = new Document();
                docXuanXiang.LoadFromFile("C:/Users/承蒙时光不弃/Desktop/答案.doc");
                string xuanXiangStr1 = docXuanXiang.GetText();
                string[] xuanXiangArr1 = xuanXiangStr1.Split(new string[] { "A." }, StringSplitOptions.RemoveEmptyEntries);
                Console.WriteLine("选项共有：" + xuanXiangArr1.Length);
    
                string[] temp;
                for(int i = 0; i < xuanXiangArr1.Length; i++)
                {
    
                    temp=xuanXiangArr1[i].Split(new string[] { "B.","C.","D." }, StringSplitOptions.RemoveEmptyEntries);
                    for(int j = 0; j < temp.Length; j++)
                    {
                        xuanXiangArr2[i, j] = temp[j];
                        //Console.WriteLine(xuanXiangArr2[i, j].Trim());
    
                    }
                    //Console.WriteLine("------------------------------------------------------");
    
                }
                #endregion
    
                //拼接sql语句并执行
                string title;
                string A;
                string B;
                string C;
                string D;
                string sql;
                for(int i = 0; i < xuanXiangArr1.Length; i++)
                {
                    title = titleArr[i].Trim();
                    A = xuanXiangArr2[i, 0].Trim();
                    B = xuanXiangArr2[i, 1].Trim();
    
                    C = xuanXiangArr2[i, 2]==null?"null":xuanXiangArr2[i,2].Trim();
                    D = xuanXiangArr2[i, 3] == null ? "null" : xuanXiangArr2[i, 3].Trim();
                    if (C == "null" && D == "null")
                    {
                        sql = "insert into tb_radio(Title, A, B) values('"+title+"', '"+A+"', '"+B+"')";
                        SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text);
                    }
                    else if (C!="null"&&D == "null")
                    {
                        sql = "insert into tb_radio(Title, A, B, C) values('" + title + "', '" + A + "', '" + B + "', '"+C+"')";
                        SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text);
                    }
                    else if (C != "null" && D != "null")
                    {
                        sql = "insert into tb_radio(Title, A, B, C, D) values('" + title + "', '" + A + "', '" + B + "', '" + C + "', '" + D + "')";
                        SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text);
                    }
    
                    Console.WriteLine("插入一条记录成功"+(i+1));
                }

上面执行sql时用到了我自己封装的SqlHelper，这里也一并提供给大家。

链接：https://pan.baidu.com/s/1fOu8m4soC-wHcrWruSrJKg   
提取码：bwob

**（4）运行代码，数据插入成功！**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzQyNzIw_size_16_color_FFFFFF_t_70 2][]

##    有不懂的欢迎留言私我~~ ##

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzQyNzIw_size_16_color_FFFFFF_t_70]: /images/20210813/25cf44d9b6034000bb5c171d71cfd4b6.png
[20181103124857443.png]: /images/20210813/f521b413ec424d4ca860d237e0729afd.png
[https_blog.csdn.net_qq_36742720_article_details_83686097]: https://blog.csdn.net/qq_36742720/article/details/83686097
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzQyNzIw_size_16_color_FFFFFF_t_70 1]: /images/20210813/4a84e80a852b4f2e9bab21a3e11f71eb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzQyNzIw_size_16_color_FFFFFF_t_70 2]: /images/20210813/99e87b13a2dc45d29c705b5d54d81518.png