static OracleConnection mQracleConnecting = null; public static OracleConnection QracleConnecting { get { try { if(mQracleConnecting ==null) mQracleConnecting = new OracleConnection(jksg); if (mQracleConnecting.State != ConnectionState.Open) mQracleConnecting.Open(); return mQracleConnecting; } catch (Exception) { return null; } } } public static DataTable DBGetDataTable(string sql,string conn) { DataTable dataSet = new DataTable(); OracleDataAdapter OraDA = new OracleDataAdapter(sql, conn); OraDA.Fill(dataSet); return dataSet; } public static DataTable DBGetDataTable(string sql, OracleConnection conn) { DataTable dataSet = new DataTable(); OracleDataAdapter OraDA = new OracleDataAdapter(sql, conn); OraDA.Fill(dataSet); return dataSet; } // 执行SQL语句,返回所影响的行数 public static int ExecuteSQL(string sql) { int Cmd = 0; OracleCommand command = new OracleCommand(sql, QracleConnecting); try { Cmd = command.ExecuteNonQuery(); } catch { } return Cmd; } public static int ExecuteSQL_Update(string sql) { OracleDataAdapter OraDA = new OracleDataAdapter(sql, QracleConnecting); return OraDA.UpdateCommand.ExecuteNonQuery(); } public static int ExecuteSQL_Insert(string sql) { OracleDataAdapter OraDA = new OracleDataAdapter(sql, QracleConnecting); return OraDA.InsertCommand.ExecuteNonQuery(); }
2.存储obj,这里默认的为 EF 框架出来的类相似,表名为类名,字段是列名
public string GetInsertstring(object item) { string sql = "INSERT INTO {2} ({0}) VALUES ({1})"; var members = item.GetType().GetProperties(); var classname = item.GetType().Name; string mems=""; string values=""; foreach(var me in members) { mems += me.Name +","; var val =me.GetValue(item); if (me.PropertyType == typeof(System.DateTime)) { if (val == null) { values += ","; continue; } System.DateTime time = (System.DateTime)val; values += "TO_DATE('" + time.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-mm-dd hh24:mi:ss'),"; } else if (me.PropertyType == typeof(string)) { if (val == null) { values += "'',"; continue; } values += "'" +val.ToString()+"',"; } else { if (val == null) { values += ","; continue; } values += val.ToString() + ","; } } mems= mems.Substring(0,mems.Length-1); values = values.Substring(0, values.Length - 1); sql= string.Format(sql, mems, values,classname); return sql; }