public static int ExecSQL(List <string> sqls, List <object[]> parmList)
{
JDBBASE db = DbConnectionPool.Instance();
try
{
if (db != null)
{
try
{
IDBBASE vDB = (IDBBASE)db;
return(vDB.ExecSQL(sqls, parmList));
}
catch (Exception ex)
{
log4net.WriteLogFile(ex.Message, 3);
return(0);
}
}
else
{
log4net.WriteLogFile("获取连接对象失败", 3);
return(-1);
}
}
finally
{
DbConnectionPool.ReturnConnect(db);
}
}
public static String ServerDateTime()
{
JDBBASE db = DbConnectionPool.Instance();
try
{
if (db != null)
{
IDBBASE myface = (IDBBASE)db;
return(myface.ServerDateTime());
}
else
{
log4net.WriteLogFile("获取连接对象失败", 3);
return(null);
}
}
finally
{
DbConnectionPool.ReturnConnect(db);
}
}
public static DataTable QueryData(string strSQL)
{
JDBBASE db = DbConnectionPool.Instance();
try
{
if (db != null)
{
IDBBASE vDB = (IDBBASE)db;
return(vDB.Query(strSQL));;
}
else
{
log4net.WriteLogFile("获取连接对象失败", 3);
return(null);
}
}
finally
{
DbConnectionPool.ReturnConnect(db);
}
}
