static public bool execute(string sql)
{
PDO pdo = new PDO();
bool res = pdo.execute(sql);
pdo.Dispose();
return(res);
}
public long executeInsert(string sql)
{
PDO pdo = new PDO();
long lastID = -1;
try
{
System.Diagnostics.Debug.WriteLine(sql);
lastID = pdo.execute(sql, true);
}
catch (Exception e)
{
string message = e.Message;
Console.WriteLine("SQL execute Error");
Console.WriteLine("Message:" + message);
}
finally
{
pdo.Dispose();
}
return(lastID);
}
public bool executeUpdate(string sql)
{
bool res = false;
PDO pdo = new PDO();
try
{
res = pdo.execute(sql);
}
catch (Exception e)
{
string message = e.Message;
Console.WriteLine("SQL execute Error");
Console.WriteLine("Message:" + message);
//e.printStackTrace();
}
finally
{
pdo.Dispose();
}
return(res);
}
