反序列化后导入SQLserver
0
悬赏园豆：15
[已解决问题]
解决于 2017-03-14 17:12
现在一个文件夹里有很多压缩文件，我需要先解压，然后读取解压后的txt文本内容，文本内容已经是序列化后的格式，现在需要反序列化并导入数据库，然后删除txt文本，下面是我目前的代码
private void button4_Click(object sender, EventArgs e)
{
Person p = new Person();
try
{
if (txtfiles2.Text.Trim() != "")
{
toolStripProgressBar1.Maximum = files2.Length;
for (int i = 0; i < files2.Length; i++)
{
toolStripProgressBar1.Value = i;
string path = files2[i].ToString();
string newpath = path.Remove(path.LastIndexOf("\\") + 1);
UnZip(path, newpath);
string str = null;
using (StreamReader sr = new StreamReader(@"E:\国省道采集数据\Command.txt", System.Text.Encoding.GetEncoding("utf-8")))
{
str = sr.ReadToEnd();
}
var xuliehua = str;
//StreamReader sr = new StreamReader(@"E:\国省道采集数据\Command.txt", Encoding.GetEncoding("gb2312"));
//MessageBox.Show(sr.ToString());
}
toolStripProgressBar1.Value = 0;
MessageBox.Show("解压缩成功！");
}
else
{
MessageBox.Show("警告：请选择要进行批量解压缩的文件！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch { }
}
问题补充：
这是txt文本里的内容
{"UserID":"huangshan1@78","BatchID":"1489281487936","CityCode":"341000","CustomFields":[{"Code":"GLDWMC","Value":"徽州交通局"},{"Code":"QLMC","Value":"杨村2号桥"},{"Code":"QLBH","Value":"K3001"},{"Code":"JCSJ","Value":""},{"Code":"QLCD","Value":"134"},{"Code":"SJHZ","Value":"1"},{"Code":"AKJF","Value":"2"},{"Code":"AJCHNXF","Value":"1"},{"Code":"B_ISDANGER","Value":"2"},{"Code":"KJZC","Value":"125"},{"Code":"DKZDKJ","Value":"25"},{"Code":"QMQK","Value":"8.5"},{"Code":"QMJK","Value":"7.4"},{"Code":"LXBM","Value":"S103341000"},{"Code":"LDXLH","Value":"001"}],"Images":[{"Time":"Mar 12, 2017 12:00:00 AM","FileName":"/storage/emulated/0/easyroad/collectionpo/1489282287821.jpeg","Lon":118.1775853,"Lat":29.97436336,"Alt":0.0}],"Time":"2017-03-12","LineName":"S103341000","Note":"","PO_Code":"T_ql","Pile":"5.092","Version":2,"Lat":29.97436336,"Lon":118.1775853,"Alt":0.0,"Type":4}
最佳答案
0
这段json数据全部存入到DB?
个人建议直接反序列化成实体类,然后再存入DB. 如果是存入不同的表中,并且这些表有关连关系,建议写个存储过程,使用事务提交,try catch 捕捉下异常.
CustomFields这个是对应DB的一个字典表吗?
收获园豆：15
对，是要反序列化成实体类，比如我现在有个实体类
[DataContract]
public class Person
{
[DataMember]
public string UserID { get; set; }
}
@姚刘乐: 你实体类定义好了吗?反序列化就一句话的事,这段json是复杂类型,主要要看你的实体类是怎么定义的了
@～扎克伯格: 定义好了
@姚刘乐: 贴出来,编辑器右上角有插入代码工具,不要直接贴上来
@姚刘乐:
public class JsonHelper { public static List<T> JsonToList<T>(string jsonStr) { JavaScriptSerializer js = new JavaScriptSerializer(); List<T> t = (List<T>)js.Deserialize(jsonStr, typeof(List<T>)); return t; } public static T JsonToEntity<T>(string jsonStr) { JavaScriptSerializer js = new JavaScriptSerializer(); T t = (T)js.Deserialize(jsonStr, typeof(T)); return t; } }
这个json help类先拿去玩玩吧!有问题再说
1 using System; 2 using System.Collections.Generic; 3 using System.ComponentModel; 4 using System.Data; 5 using System.Drawing; 6 using System.Linq; 7 using System.Text; 8 using System.Windows.Forms; 9 using System.Collections; 10 using ICSharpCode.SharpZipLib; 11 using ICSharpCode.SharpZipLib.Zip; 12 using ICSharpCode.SharpZipLib.Checksums; 13 using System.IO; 14 using System.Runtime.Serialization; 15 using System.Text.RegularExpressions; 16 17 namespace BatchDecompression 18 { 19 public partial class Form1 : Form 20 { 21 public Form1() 22 { 23 InitializeComponent(); 24 } 25 26 27 28 29 30 31 /// <summary> 32 /// 解压文件 33 /// </summary> 34 /// <param name="FileToUpZip">待解压的文件</param> 35 /// <param name="ZipedFolder">指定解压目标目录</param> 36 public void UnZip(string FileToUpZip, string ZipedFolder) 37 { 38 if (!File.Exists(FileToUpZip)) 39 { 40 return; 41 } 42 if (!Directory.Exists(ZipedFolder)) 43 { 44 Directory.CreateDirectory(ZipedFolder); 45 } 46 ZipInputStream ZIPStream = null; 47 ZipEntry theEntry = null; 48 string fileName; 49 FileStream streamWriter = null; 50 try 51 { 52 //生成一个GZipInputStream流，用来打开压缩文件 53 ZIPStream = new ZipInputStream(File.OpenRead(FileToUpZip)); 54 while ((theEntry = ZIPStream.GetNextEntry()) != null) 55 { 56 if (theEntry.Name != String.Empty) 57 { 58 fileName = Path.Combine(ZipedFolder, theEntry.Name); 59 //判断文件路径是否是文件夹 60 if (fileName.EndsWith("/") || fileName.EndsWith("\\")) 61 { 62 Directory.CreateDirectory(fileName); 63 continue; 64 } 65 //生成一个文件流，它用来生成解压文件 66 streamWriter = File.Create(fileName); 67 int size = 2048;//指定压缩块的大小，一般为2048的倍数 68 byte[] data = new byte[2048];//指定缓冲区的大小 69 while (true) 70 { 71 size = ZIPStream.Read(data, 0, data.Length);//读入一个压缩块 72 if (size > 0) 73 { 74 streamWriter.Write(data, 0, size);//写入解压文件代表的文件流 75 } 76 else 77 { 78 break;//若读到压缩文件尾，则结束 79 } 80 } 81 } 82 } 83 } 84 finally 85 { 86 if (streamWriter != null) 87 { 88 streamWriter.Close(); 89 streamWriter = null; 90 } 91 if (theEntry != null) 92 { 93 theEntry = null; 94 } 95 if (ZIPStream != null) 96 { 97 ZIPStream.Close(); 98 ZIPStream = null; 99 } 100 GC.Collect(); 101 GC.Collect(1); 102 } 103 } 104 105 106 107 string[] files2;//存储要进行解压缩的文件数组 108 109 110 private void button3_Click(object sender, EventArgs e)//选择批量解压缩的文件 111 { 112 if (openFileDialog2.ShowDialog() == DialogResult.OK) 113 { 114 files2 = openFileDialog2.FileNames; 115 string file = ""; 116 for (int i = 0; i < files2.Length; i++) 117 { 118 file += files2[i].ToString() + ","; 119 } 120 file = file.Remove(file.LastIndexOf(",")); 121 txtfiles2.Text = file; 122 } 123 } 124 125 126 127 private void button4_Click(object sender, EventArgs e) 128 { 129 Person p = new Person(); 130 try 131 { 132 if (txtfiles2.Text.Trim() != "") 133 { 134 toolStripProgressBar1.Maximum = files2.Length; 135 for (int i = 0; i < files2.Length; i++) 136 { 137 toolStripProgressBar1.Value = i; 138 string path = files2[i].ToString(); 139 string newpath = path.Remove(path.LastIndexOf("\\") + 1); 140 UnZip(path, newpath); 141 142 string str = null; 143 using (StreamReader sr = new StreamReader(@"E:\国省道采集数据\Command.txt", System.Text.Encoding.GetEncoding("utf-8"))) 144 { 145 str = sr.ReadToEnd(); 146 147 148 } 149 150 var xuliehua = str; 151 152 //StreamReader sr = new StreamReader(@"E:\国省道采集数据\Command.txt", Encoding.GetEncoding("gb2312")); 153 //MessageBox.Show(sr.ToString()); 154 155 156 } 157 158 toolStripProgressBar1.Value = 0; 159 MessageBox.Show("解压缩成功！"); 160 } 161 else 162 { 163 MessageBox.Show("警告：请选择要进行批量解压缩的文件！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); 164 } 165 } 166 catch { } 167 168 } 169 170 private void txtfiles2_TextChanged(object sender, EventArgs e) 171 { 172 173 } 174 [DataContract] 175 public class Person 176 { 177 [DataMember] 178 public string UserID { get; set; } 179 } 180 181 } 182 183 }
@～扎克伯格: 额好的，我试试哈，谢谢
@姚刘乐:
[DataContract] public class Person { [DataMember] public string UserID { get; set; } }
这是实体类,其他的多余的.
你觉得你的实体类定义的对吗?难道你只打算存UserUD?
@～扎克伯格: 我想先存个试试能不能成功，成功了其他的就好弄了嘛
@姚刘乐: 那你试试呗!看会不会报错.
@～扎克伯格: 额，我先试试这个helpr类怎么用，对反序列化基本不知道是啥....有啥例子供参考不~
@姚刘乐: 你加我qq:2375287790 吧!这里说不方便,每次把框口拉到底回答你
@～扎克伯格: 加了
