写在类里面的sql语句综合

2023年6月21日发(作者：)

写在类⾥⾯的sql语句综合把sql语句写在类⾥⾯在以后的使⽤中直接调⽤，不仅提⾼了代码的重⽤率，也很好的简化了页⾯的代码复杂度，其实现在⼤多数公司都是这样做的，⾃⼰没有刻意去寻找是否⽹上已经有这样的代码，既然⾃⼰写了，就贴出来给⼤家批评指正吧。下⾯是三个最基本的语句（SELECT、UPDATE、INSERT）using System;using ;using uration;using ;using ty;using ;using trols;using ts;using ntrols;using ent;///

/// SQL 的摘要说明///

public class SQL{ public SQL() { // // TODO: 在此处添加构造函数逻辑 // } //Insert返回bool型，传回插⼊是否成功 public bool Insert(string table,string[] data,string[] values)//表名，字段，添加的值 { string strdata=""; string strvalues=""; foreach(string temp in data) { strdata =strdata + temp +","; strvalues =strvalues + "@" + temp +","; } strdata = (-1);

strvalues = (-1); string dsn = tionStrings["friendConnectionString"].ToString(); SqlConnection conn = null; conn = new SqlConnection(dsn); SqlCommand cmd = new SqlCommand("", conn);

string SqlStr = "INSERT ["+table+"]("+strdata+") VALUES("+strvalues+")"; dText = SqlStr; int i=0; foreach(string temp in values) { (new SqlParameter("@"+data[i],temp)); i++; }

(); try { if (eNonQuery() == 0) return false; else return true; } catch (Exception ex) { return false; } }

//Select返回的是查询结果，放在数组⾥⾯ public string[] Select(string table, string[] data,string whereid, string values)//表名、查找的参数、判断的条件字段、判断的条件的值 { string[] getdata=new string[20]; string strdata="";

foreach(string temp in data) { strdata =strdata + temp +",";

} strdata = (-1); string dsn = tionStrings["friendConnectionString"].ToString(); SqlConnection conn = null; conn = new SqlConnection(dsn); SqlCommand cmd = new SqlCommand("", conn); string SqlStr = "SELECT "+ strdata +" FROM [" + table + "] WHERE "+whereid+"="+"@"+whereid; dText = SqlStr; (new SqlParameter("@" + whereid, values));

(); SqlDataReader MyReader = eReader(); int i=0; if (()) { foreach (string temp in data) { getdata[i++] = MyReader[temp].ToString(); } } return getdata; }//Update返回的是bool型，判断是否更新成功

public bool Update(string table, string[] data, string[] values, string whereid, string realid)//表名，需要更新的字段，更新的值,更新判断的条件，条件的满⾜ { string strdata = "";

foreach (string temp in data) { strdata = strdata + temp + "=@"+ temp + ",";

} strdata = ( - 1); string dsn = tionStrings["friendConnectionString"].ToString(); SqlConnection conn = null; conn = new SqlConnection(dsn); SqlCommand cmd = new SqlCommand("", conn); string SqlStr = "UPDATE [" + table + "] SET " + strdata + " WHERE " + whereid + "=" + realid; dText = SqlStr; int i = 0; foreach (string temp in values) { (new SqlParameter("@" + data[i], temp)); i++; } (); try { if (eNonQuery() == 0) return false; else return true; } catch (Exception ex) { return false; } }}

2023年6月21日发(作者：)

写在类⾥⾯的sql语句综合把sql语句写在类⾥⾯在以后的使⽤中直接调⽤，不仅提⾼了代码的重⽤率，也很好的简化了页⾯的代码复杂度，其实现在⼤多数公司都是这样做的，⾃⼰没有刻意去寻找是否⽹上已经有这样的代码，既然⾃⼰写了，就贴出来给⼤家批评指正吧。下⾯是三个最基本的语句（SELECT、UPDATE、INSERT）using System;using ;using uration;using ;using ty;using ;using trols;using ts;using ntrols;using ent;///

/// SQL 的摘要说明///

public class SQL{ public SQL() { // // TODO: 在此处添加构造函数逻辑 // } //Insert返回bool型，传回插⼊是否成功 public bool Insert(string table,string[] data,string[] values)//表名，字段，添加的值 { string strdata=""; string strvalues=""; foreach(string temp in data) { strdata =strdata + temp +","; strvalues =strvalues + "@" + temp +","; } strdata = (-1);

strvalues = (-1); string dsn = tionStrings["friendConnectionString"].ToString(); SqlConnection conn = null; conn = new SqlConnection(dsn); SqlCommand cmd = new SqlCommand("", conn);

string SqlStr = "INSERT ["+table+"]("+strdata+") VALUES("+strvalues+")"; dText = SqlStr; int i=0; foreach(string temp in values) { (new SqlParameter("@"+data[i],temp)); i++; }

(); try { if (eNonQuery() == 0) return false; else return true; } catch (Exception ex) { return false; } }

//Select返回的是查询结果，放在数组⾥⾯ public string[] Select(string table, string[] data,string whereid, string values)//表名、查找的参数、判断的条件字段、判断的条件的值 { string[] getdata=new string[20]; string strdata="";

foreach(string temp in data) { strdata =strdata + temp +",";

} strdata = (-1); string dsn = tionStrings["friendConnectionString"].ToString(); SqlConnection conn = null; conn = new SqlConnection(dsn); SqlCommand cmd = new SqlCommand("", conn); string SqlStr = "SELECT "+ strdata +" FROM [" + table + "] WHERE "+whereid+"="+"@"+whereid; dText = SqlStr; (new SqlParameter("@" + whereid, values));

(); SqlDataReader MyReader = eReader(); int i=0; if (()) { foreach (string temp in data) { getdata[i++] = MyReader[temp].ToString(); } } return getdata; }//Update返回的是bool型，判断是否更新成功

public bool Update(string table, string[] data, string[] values, string whereid, string realid)//表名，需要更新的字段，更新的值,更新判断的条件，条件的满⾜ { string strdata = "";

foreach (string temp in data) { strdata = strdata + temp + "=@"+ temp + ",";

} strdata = ( - 1); string dsn = tionStrings["friendConnectionString"].ToString(); SqlConnection conn = null; conn = new SqlConnection(dsn); SqlCommand cmd = new SqlCommand("", conn); string SqlStr = "UPDATE [" + table + "] SET " + strdata + " WHERE " + whereid + "=" + realid; dText = SqlStr; int i = 0; foreach (string temp in values) { (new SqlParameter("@" + data[i], temp)); i++; } (); try { if (eNonQuery() == 0) return false; else return true; } catch (Exception ex) { return false; } }}