2017数学三级数大题:2017年计算机三级数据库知识：数据库里的记录与json之间的转换

using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using System.Data.SqlClient; 
namespace OTC.Utility 
...{ 
public sealed class JSONHelper 
...{ 
/**//// 
/// 获取JSON字符串 
/// 
/// 值 
/// 数据表名 
/// 
public static string GetJSON(SqlDataReader drValue, string strTableName) 
...{ 
StringBuilder sb = new StringBuilder(); 
sb.AppendLine("{"); 
sb.AppendLine(" " + strTableName + ":{"); 
sb.AppendLine(" records:["); 
try 
...{ 
while (drValue.Read()) 
...{ 
sb.Append(" {"); 
for (int i = 0; i < drValue.FieldCount; i++) 
...{ 
sb.AppendFormat(""{0}":"{1}",", drValue.GetName(i), drValue.GetValue(i)); 
} 
sb.Remove(sb.ToString().LastIndexOf(’,’), 1); 
sb.AppendLine("},"); 
} 
sb.Remove(sb.ToString().LastIndexOf(’,’), 1); 
} 
catch(Exception ex) 
...{ 
throw new Exception(ex.Message); 
} 
finally 
...{ 
drValue.Close(); 
} 
sb.AppendLine(" ]"); 
sb.AppendLine(" }"); 
sb.AppendLine(" };"); 
return sb.ToString(); 
} 
} 
}