c#上传文件并将word pdf转化成txt存储并将内容写入数据库
using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using Microsoft.Office.Core;//添加引用 com Microsoft.Office 12.0 using Microsoft.Office.Interop.PowerPoint;//添加引用 com Microsoft Powerpoint 12.0 using Microsoft.Office.Interop.Word; //添加引用 com Microsoft word 12.0 using System.IO; using org.pdfbox.util;//网上下载PDFBox-0.7.3 引用PDFBox-0.7.3.dll、IKVM.GNU.Classpath.dll、IKVM.Runtime.dll、FontBox-0.1.0-dev.dll using org.pdfbox.pdmodel; using System.Text; public partial class _Default : System.Web.UI.Page { dbcommand db = new dbcommand(); prompt pt = new prompt(); protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; } protected void decide_Click(object sender, EventArgs e) { //获取文件全名 string filename = fj.PostedFile.FileName.ToString(); //上传文件类型 string filetype = filename.Substring(filename.LastIndexOf('.') + 1); if (filetype == "doc" || filetype == "docx" || filetype == "pdf") { string strpath = "~/Upload/" + filename; fj.PostedFile.SaveAs(Server.MapPath(strpath)); //获取文件名 string strname = filename.Substring(0, filename.LastIndexOf('.')); FileInfo fi1 = new FileInfo(@"E:\FUL\Upload\" + filename); FileInfo fi2 = new FileInfo(@"E:\FUL\txt\" + strname + ".txt"); if (filetype == "pdf") pdf2txt(fi1, fi2); else word2text(fi1, fi2); StreamReader sr=text2reader(fi2); string sql="insert into fujian(subject,content) values('"+subject.Text+"','"+sr.ReadToEnd()+"')"; int num=db.AffectedRow(sql);//写入数据库，返回影响行数函数，这里你可以自己写 if (num > 0) pt.message("上传成功！");//弹出对话框，这里你可以自己写 } } /// <summary> /// pdf文件转成txt /// </summary> /// <param name="file"></param> /// <param name="txtfile"></param> public void pdf2txt(FileInfo file, FileInfo txtfile) { PDDocument doc = PDDocument.load(file.FullName); PDFTextStripper pdfStripper = new PDFTextStripper(); string text = pdfStripper.getText(doc); StreamWriter swPdfChange = new StreamWriter(txtfile.FullName, false, Encoding.GetEncoding("gb2312")); swPdfChange.Write(text); swPdfChange.Close(); } /// <summary> ///word文档转成txt,对于doc文件中的表格，读出的结果是去除掉了网格线，内容按行读取。 /// </summary> /// <param name="file"></param> /// <param name="txtfile"></param> public void word2text(FileInfo file, FileInfo txtfile) { object readOnly = true; object missing = System.Reflection.Missing.Value; object fileName = file.FullName; Microsoft.Office.Interop.Word.ApplicationClass wordapp = new Microsoft.Office.Interop.Word.ApplicationClass(); Document doc = wordapp.Documents.Open(ref fileName, ref missing, ref readOnly, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing); string text = doc.Content.Text; doc.Close(ref missing, ref missing, ref missing); wordapp.Quit(ref missing, ref missing, ref missing); StreamWriter swWordChange = new StreamWriter(txtfile.FullName, false, Encoding.GetEncoding("gb2312")); swWordChange.Write(text); swWordChange.Close(); } public void ppt2txt(FileInfo file, FileInfo txtfile) { Microsoft.Office.Interop.PowerPoint.Application pa = new Microsoft.Office.Interop.PowerPoint.ApplicationClass(); Microsoft.Office.Interop.PowerPoint.Presentation pp = pa.Presentations.Open(file.FullName, Microsoft.Office.Core.MsoTriState.msoTrue, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoFalse); string pps = ""; StreamWriter swPPtChange = new StreamWriter(txtfile.FullName, false, Encoding.GetEncoding("gb2312")); foreach (Microsoft.Office.Interop.PowerPoint.Slide slide in pp.Slides) { foreach (Microsoft.Office.Interop.PowerPoint.Shape shape in slide.Shapes) pps += shape.TextFrame.TextRange.Text.ToString(); } swPPtChange.Write(pps); swPPtChange.Close(); } /// <summary> /// 取txt文件的内容 /// </summary> /// <param name="file"></param> /// <returns></returns> public StreamReader text2reader(FileInfo file) { StreamReader st = null; switch (file.Extension.ToLower()) { case ".txt": st = new StreamReader(file.FullName, Encoding.GetEncoding("gb2312")); break; case ".doc": FileInfo wordfile = new FileInfo(@"E:\myprograms\200807program\FileSearch\App_Data\word2txt.txt");//不能使用相对路径，想办法改进 word2text(file, wordfile); st = new StreamReader(wordfile.FullName, Encoding.GetEncoding("gb2312")); break; case ".pdf": FileInfo pdffile = new FileInfo(@"E:\myprograms\200807program\FileSearch\App_Data\pdf2txt.txt"); pdf2txt(file, pdffile); st = new StreamReader(pdffile.FullName, Encoding.GetEncoding("gb2312")); break; case ".ppt": FileInfo pptfile = new FileInfo(@"E:\myprograms\200807program\FileSearch\App_Data\ppt2txt.txt"); ppt2txt(file, pptfile); st = new StreamReader(pptfile.FullName, Encoding.GetEncoding("gb2312")); break; } st = new StreamReader(file.FullName, Encoding.GetEncoding("gb2312")); return st; } }
//下面的和上面的没有直接关系，下面的只是上传文件
上传附件
<asp:FileUpload ID="FileUpload1" runat="server" />
1 using System; 2 using System.Data; 3 using System.Configuration; 4 using System.Web; 5 using System.Web.Security; 6 using System.Web.UI; 7 using System.Web.UI.WebControls; 8 using System.Web.UI.WebControls.WebParts; 9 using System.Web.UI.HtmlControls; 10 public partial class _Default : System.Web.UI.Page 11 { 12 protected void Page_Load(object sender, EventArgs e) 13 { 14 } 15 protected void Button1_Click(object sender, EventArgs e) 16 { 17 string name = FileUpload1.FileName;//上传文件名 18 string size = FileUpload1.PostedFile.ContentLength.ToString();//得到上传文件的大小 19 string type = FileUpload1.PostedFile.ContentType;//得上传文件的类型 20 string type2 = name.Substring(name.LastIndexOf(".")+1);//得后缀名 21 string ipath = Server.MapPath("upimg") + "\\" + name; 22 if (FileType == "pdf" || FileType == "doc" || FileType == "xls" || FileType == "txt" || FileType == "jpg" || FileType == "JPG" || FileType == "gif" || FileType == "bmp" || FileType == "rar" || FileType == "zip" || FileType == "dwg") 23 { 24 FileUpload1.SaveAs("ipath"); 25 Image1.ImageUrl = wpath; 26 Label1.Text = "上传文件的名称" + name + "上传文件的大小" + size + "上传文件的类型" + type + "后缀名" + type2 + "实际路径" + ipath; 27 } 28 } 29 }
打开附件：
前台：<asp:HyperLink ID="fj" runat="server" Visible="False"></asp:HyperLink>
1 using System; 2 using System.Data; 3 using System.Configuration; 4 using System.Collections; 5 using System.Web; 6 using System.Web.Security; 7 using System.Web.UI; 8 using System.Web.UI.WebControls; 9 using System.Web.UI.WebControls.WebParts; 10 using System.Web.UI.HtmlControls; 11 public partial class ViewBlog : System.Web.UI.Page 12 { 13 dbcommand db = new dbcommand(); 14 prompt pt = new prompt(); 15 protected void Page_Load(object sender, EventArgs e) 16 { 17 if (Session["username"] == null) 18 { 19 Response.Write("<script type='text/javascript'>alert('" + "请先登录!" + "');top.location='Login.aspx';</script>"); 20 Response.End(); 21 } 22 int id = int.Parse(HttpContext.Current.Request.QueryString["id"].ToString()); 23 string sql = "select T_USER.username,T_Blog.* from T_USER,T_Blog where T_USER.id=T_Blog.blogUser and T_Blog.id=" + id; 24 DataSet ds = db.GetDateset(sql); 25 以下是显示附件信息 26 if (ds.Tables[0].Rows[0]["FileName"].ToString() != "")//如果有附件 27 { 28 fj.Text = ds.Tables[0].Rows[0]["FileName"].ToString();//显示附件名称 29 fj.Visible = true; 30 fj.NavigateUrl = "Upload/" + ds.Tables[0].Rows[0]["FileName"].ToString();//附件所在路径 31 fj.Target = "_blank"; 32 } 33 } 34 }
FileUpload默认最大上传4m 要上传更大 可是web.config中设置 代码如下：
1 <?xml version="1.0"?> 2 <!-- 3 注意: 除了手动编辑此文件以外，您还可以使用 4 Web 管理工具来配置应用程序的设置。可以使用 Visual Studio 中的 5 “网站”->“Asp.Net 配置”选项。 6 设置和注释的完整列表在 7 machine.config.comments 中，该文件通常位于 8 \Windows\Microsoft.Net\Framework\v2.x\Config 中 9 --> 10 <configuration> 11 <appSettings/> 12 <connectionStrings> 13 <!--连接数据库 这里是sql server2008--> 14 <add name="strcnn" connectionString="Data Source=.;Initial Catalog=inshineProject;Persist Security Info=True;User ID=sa;Password=sa;Pooling=False" providerName="System.Data.SqlClient"/> </connectionStrings> 15 <system.web> 16 <!-- 17 设置 compilation debug="true" 将调试符号插入 18 已编译的页面中。但由于这会 19 影响性能，因此只在开发过程中将此值 20 设置为 true。 21 --> 22 <!--这里调车最多可上传200M ，可以根据自己的需要设置更大--> 23 <httpRuntime executionTimeout="10000 " maxRequestLength="2048000 "/> 24 <compilation debug="true"> 25 <assemblies> 26 <add assembly="System.Design, Version=2.0.0.0, Culture=neutral,PublicKeyToken=B03F5F7F11D50A3A"/> 27 <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies></compilation> 28 <!-- 29 通过 <authentication> 节可以配置 ASP.NET 使用的 30 安全身份验证模式， 31 以标识传入的用户。 32 --> 33 <authentication mode="Windows"/> 34 <!-- 35 如果在执行请求的过程中出现未处理的错误， 36 则通过 <customErrors> 节可以配置相应的处理步骤。具体说来， 37 开发人员通过该节可以配置 38 要显示的 html 错误页 39 以代替错误堆栈跟踪。 40 <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> 41 <error statusCode="404" redirect="FileNotFound.htm" /> 42 </customErrors> 43 --> 44 </system.web> 45 </configuration>