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;
}
转载于:https://www.cnblogs.com/leolzi/p/7985824.html
