private static string buildQueryCmd()
{
string rtnString = null;
for (int index = 0; index < MapList.Count; index++)
{
Attr2FieldMap map = MapList[index];
if (rtnString == null)
{
rtnString = map.Field;
continue;
}
rtnString = rtnString + "," + map.Field;
}
return(String.Format("select {0} from {1} where 1=1;", rtnString, _tableName));
}
public static List <SUrlAttribute> FetchObject(MysqlDBHelper helper)
{
initMap();
List <SUrlAttribute> rtnResult = new List <SUrlAttribute>();
String cmdString = buildQueryCmd();
MySqlCommand cmd = new MySqlCommand(cmdString, helper.DbConnector);
//查询结果读取器
MySqlDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
SUrlAttribute cfg = new SUrlAttribute();
for (int index = 0; index < MapList.Count; index++)
{
Attr2FieldMap map = MapList[index];
Attr2FieldMap.setValue(cfg, reader[index], map.Attrbute);
}
rtnResult.Add(cfg);
}
}
catch (Exception ex)
{
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(rtnResult);
}