C#文件压缩解压与sqlite存储文件数据资源-CSDN文库

共389个文件

dll：78个

xml：77个

_：50个

需积分: 9 163 浏览量 2022-11-17 16:21:21 上传评论收藏 42.68MB ZIP 举报

在IT行业中，C#是一种广泛使用的编程语言，尤其在Windows应用程序开发、游戏开发以及Web服务等领域。本主题聚焦于如何利用C#实现文件的压缩与解压缩，以及如何结合SQLite数据库来存储和检索这些文件数据。这样的技术组合在文件管理、备份、分布式系统和移动应用中非常常见。让我们探讨C#中的文件压缩。C#提供了System.IO.Compression命名空间，其中包含GZipStream和DeflateStream类，可以用来进行GZIP和DEFLATE压缩。如果你需要支持更通用的ZIP格式，可以使用第三方库如SharpZipLib或System.IO.Compression.ZipFile类（自.NET Framework 4.5开始提供）。例如，你可以创建一个方法来压缩文件： ```csharp using System.IO; using System.IO.Compression; public static void CompressFile(string inputFile, string outputFile) { using (FileStream input = File.OpenRead(inputFile)) using (FileStream output = File.Create(outputFile)) using (DeflateStream gzip = new DeflateStream(output, CompressionLevel.Optimal)) { input.CopyTo(gzip); } } ``` 接下来，我们将讨论如何将压缩的文件数据存储到SQLite数据库。SQLite是一个轻量级的、自包含的数据库引擎，可以在各种应用程序中嵌入使用。C#可以通过System.Data.SQLite库访问SQLite数据库。你需要创建一个表来存储文件数据，可能包括文件名、文件大小和二进制数据等字段。然后，可以将压缩后的文件写入Blob类型的数据字段： ```csharp using System.Data.SQLite; using System.IO; public static void StoreCompressedFileInSQLite(string compressedFile, string connectionString) { byte[] fileBytes = File.ReadAllBytes(compressedFile); using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { conn.Open(); SQLiteCommand cmd = new SQLiteCommand("INSERT INTO Files (FileName, Data) VALUES (@Name, @Data)", conn); cmd.Parameters.AddWithValue("@Name", Path.GetFileName(compressedFile)); cmd.Parameters.AddWithValue("@Data", fileBytes); cmd.ExecuteNonQuery(); } } ``` 当需要从SQLite数据库中读取并解压缩文件时，可以执行反向操作。查询数据库获取文件数据，然后将其写入一个临时文件，最后使用C#的解压缩功能来还原原始文件： ```csharp public static void RetrieveAndDecompressFileFromSQLite(string fileName, string connectionString) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { conn.Open(); SQLiteCommand cmd = new SQLiteCommand("SELECT Data FROM Files WHERE FileName=@Name", conn); cmd.Parameters.AddWithValue("@Name", fileName); SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { byte[] fileBytes = (byte[])reader["Data"]; string tempFilePath = Path.GetTempFileName(); using (FileStream output = File.Create(tempFilePath)) { output.Write(fileBytes, 0, fileBytes.Length); } // 使用DeflateStream或GZipStream进行解压缩，取决于压缩时所用的方法 DecompressFile(tempFilePath, Path.Combine(Directory.GetCurrentDirectory(), fileName)); } } } public static void DecompressFile(string compressedFile, string outputFile) { // 这里使用DeflateStream，如果使用GZIP则替换为GZipStream using (FileStream input = File.OpenRead(compressedFile)) using (FileStream output = File.Create(outputFile)) using (DeflateStream gzip = new DeflateStream(input, CompressionMode.Decompress)) { gzip.CopyTo(output); } } ``` 通过这种方式，C#结合SQLite可以有效地管理和分发文件，尤其是在需要进行离线存储或在网络连接不稳定的情况下。这在文件存储、部署、备份策略以及需要在不同设备之间同步数据的应用程序中具有很高的实用性。记得在实际项目中考虑错误处理、性能优化以及安全性问题，比如使用参数化SQL查询防止SQL注入，以及确保正确处理文件I/O异常。

资源推荐

资源详情

资源评论

收起资源包目录

C# 文件压缩解压与sqlite存储文件数据（389个子文件）

_._ 0B

_IsIncrementalBuild 32B

System.Data.SQLite.dll.altconfig 739B

Harpy.v1.eagle.b64sig 4KB

文件存储Sqlite.csproj.AssemblyReference.cache 17KB

DesignTimeResolveAssemblyReferencesInput.cache 8KB

DesignTimeResolveAssemblyReferences.cache 2KB

文件存储Sqlite.csproj.GenerateResource.cache 126B

文件存储Sqlite.csproj.CoreCompileInputs.cache 42B

文件存储Sqlite.csproj.SuggestedBindingRedirects.cache 0B

packages.config 672B

文件存储Sqlite.exe.config 177B

App.config 177B

文件存储Sqlite.csproj.CopyComplete 0B

Form1.Designer.cs 6KB

Form1.cs 3KB

Resources.Designer.cs 3KB

AssemblyInfo.cs 1KB

Settings.Designer.cs 1KB

Program.cs 539B

.NETFramework,Version=v4.8.AssemblyAttributes.cs 210B

文件存储Sqlite.csproj 7KB

Eagle.dll 5.35MB

EntityFramework.dll 4.76MB

EntityFramework.dll 4.75MB

EntityFramework.dll 4.55MB

SQLite.Interop.dll 1.73MB

SQLite.Interop.dll 1.72MB

SQLite.Interop.dll 1.71MB

SQLite.Interop.dll 1.7MB

SQLite.Interop.dll 1.39MB

SQLite.Interop.dll 1.37MB

SQLite.Interop.dll 1.33MB

SQLite.Interop.dll 1.32MB

SQLite.Interop.dll 1.24MB

Harpy.dll 1.21MB

Badge.dll 973KB

EntityFramework.SqlServer.dll 578KB

EntityFramework.SqlServer.dll 573KB

System.Data.SQLite.dll 410KB

System.Data.SQLite.dll 401KB

共 389 条

.NET Core uses third-party libraries or other resources that may be distributed under licenses different than the .NET Core software. In the event that we accidentally failed to list a required notice, please bring it to our attention. Post an issue or email us: dotnet@microsoft.com The attached notices are provided for information only. License notice for Slicing-by-8 ------------------------------- http://sourceforge.net/projects/slicing-by-8/ Copyright (c) 2004-2006 Intel Corporation - All Rights Reserved This software program is licensed subject to the BSD License, available at http://www.opensource.org/licenses/bsd-license.html. License notice for Unicode data ------------------------------- http://www.unicode.org/copyright.html#License Copyright © 1991-2017 Unicode, Inc. All rights reserved. Distributed under the Terms of Use in http://www.unicode.org/copyright.html. Permission is hereby granted, free of charge, to any person obtaining a copy of the Unicode data files and any associated documentation (the "Data Files") or Unicode software and any associated documentation (the "Software") to deal in the Data Files or Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, and/or sell copies of the Data Files or Software, and to permit persons to whom the Data Files or Software are furnished to do so, provided that either (a) this copyright and permission notice appear with all copies of the Data Files or Software, or (b) this copyright and permission notice appear in associated Documentation. THE DATA FILES AND SOFTWARE ARE PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR HOLDERS INCLUDED IN THIS NOTICE BE LIABLE FOR ANY CLAIM, OR ANY SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THE DATA FILES OR SOFTWARE. Except as contained in this notice, the name of a copyright holder shall not be used in advertising or otherwise to promote the sale, use or other dealings in these Data Files or Software without prior written authorization of the copyright holder. License notice for Zlib ----------------------- https://github.com/madler/zlib http://zlib.net/zlib_license.html /* zlib.h -- interface of the 'zlib' general purpose compression library version 1.2.11, January 15th, 2017 Copyright (C) 1995-2017 Jean-loup Gailly and Mark Adler This software is provided 'as-is', without any express or implied warranty. In no event will the authors be held liable for any damages arising from the use of this software. Permission is granted to anyone to use this software for any purpose, including commercial applications, and to alter it and redistribute it freely, subject to the following restrictions: 1. The origin of this software must not be misrepresented; you must not claim that you wrote the original software. If you use this software in a product, an acknowledgment in the product documentation would be appreciated but is not required. 2. Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software. 3. This notice may not be removed or altered from any source distribution. Jean-loup Gailly Mark Adler jloup@gzip.org madler@alumni.caltech.edu */ License notice for Mono ------------------------------- http://www.mono-project.com/docs/about-mono/ Copyright (c) .NET Foundation Contributors MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the Software), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. License notice for International Organization for Standardization ----------------------------------------------------------------- Portions (C) International Organization for Standardization 1986: Permission to copy in any form is granted for use with conforming SGML systems and applications as defined in ISO 8879, provided this notice is included in all copies. License notice for Intel ------------------------ "Copyright (c) 2004-2006 Intel Corporation - All Rights Reserved Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. License notice for Xamarin and Novell ------------------------------------- Copyright (c) 2015 Xamarin, Inc (http://www.xamarin.com) Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. Copyright (c) 2011 Novel

评论收藏

内容反馈