|
public ExecuteNonQuery ( string sql, |
||
| sql | string | 要执行的增删改的SQL语句 |
| parameters | 执行增删改语句所需要的参数，参数必须以它们在SQL语句中的顺序为准 | |
| Результат | int | |
static void CreateTable()
{
try
{
string dbPath = "E:\\Andwho.db";
//如果不存在改数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
SqlLiteDBHelper.CreateDB(dbPath);
}
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
string sql = @"CREATE TABLE t_notepad(
Title varchar(30) NOT NULL,
CreateTime datetime NOT NULL,
UpdateTime datetime NOT NULL,
Content TEXT)";
db.ExecuteNonQuery(sql, null);
Console.WriteLine("建表成功");
}
catch (Exception e)
{
Console.WriteLine("建表失败：" + e.ToString());
}
}
static void CreateTable()
{
try
{
string dbPath = "E:\\Andwho.db";
//如果不存在改数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
SqlLiteDBHelper.CreateDB(dbPath);
}
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
string sql = @"CREATE TABLE t_notepad(
Title varchar(30) NOT NULL,
CreateTime datetime NOT NULL,
UpdateTime datetime NOT NULL,
Content TEXT)";
db.ExecuteNonQuery(sql, null);
Console.WriteLine("建表成功");
}
catch (Exception e)
{
Console.WriteLine("建表失败：" + e.ToString());
}
}
static void UpdateData()
{
try
{
string dbPath = "E:\\data.db";
string sql = "update t_set set SetValue=@SetValue where SetName=@SetName";
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@SetName", "UseDate"),
new SQLiteParameter("@SetValue", "")
};
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
int ret = db.ExecuteNonQuery(sql, parameters);
if (ret > 0)
{
Console.WriteLine("更新数据成功");
}
else
{
Console.WriteLine("更新数据失败");
}
}
catch (Exception ex)
{
Console.WriteLine("更新数据失败：" + ex.ToString());
}
}
static void DeleteData()
{
try
{
string dbPath = "E:\\data.db";
string sql = "delete from t_income";
//SQLiteParameter[] parameters = new SQLiteParameter[]{
// new SQLiteParameter("@UserCode",usercode)
// };
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
int ret = db.ExecuteNonQuery(sql, null);
if (ret > 0)
{
Console.WriteLine("删除数据成功");
}
else
{
Console.WriteLine("删除数据失败");
}
}
catch (Exception ex)
{
Console.WriteLine("删除数据失败：" + ex.ToString());
}
}
static void AddColumns()
{
try
{
string dbPath = "E:\\data.db";
string sql = "alter table t_income add column BarberId varchar(30)";
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
db.ExecuteNonQuery(sql, null);
Console.WriteLine("添加字段成功");
}
catch (Exception e)
{
Console.WriteLine("添加字段失败：" + e.ToString());
}
}
static void AddColumns()
{
try
{
string dbPath = "E:\\data.db";
string sql = "alter table t_income add column BarberId varchar(30)";
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
db.ExecuteNonQuery(sql, null);
Console.WriteLine("添加字段成功");
}
catch (Exception e)
{
Console.WriteLine("添加字段失败：" + e.ToString());
}
}
static void DropTable()
{
try
{
string dbPath = "E:\\Andwho.db";
//如果不存在
if (!System.IO.File.Exists(dbPath))
{
return;
}
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
string sql = "DROP TABLE t_expenditure ";
db.ExecuteNonQuery(sql, null);
Console.WriteLine("删表成功");
}
catch (Exception e)
{
Console.WriteLine("删表失败：" + e.ToString());
}
}
static void InertData()
{
try
{
string dbPath = @"E:\Andwho.db";
string sql = "INSERT INTO t_config(Name,Value)values(@Name,@Value)";
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
//string password = MD5EncryptDES("123");
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@Name", "CityCode"),
new SQLiteParameter("@Value", "101010100")
};
db.ExecuteNonQuery(sql, parameters);
Console.WriteLine("插入数据成功");
}
catch (Exception e)
{
Console.WriteLine("插入数据失败：" + e.ToString());
}
}
static void DeleteData()
{
try
{
string dbPath = "E:\\data.db";
string sql = "delete from t_income";
//SQLiteParameter[] parameters = new SQLiteParameter[]{
// new SQLiteParameter("@UserCode",usercode)
// };
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
int ret = db.ExecuteNonQuery(sql, null);
if (ret > 0)
{
Console.WriteLine("删除数据成功");
}
else
{
Console.WriteLine("删除数据失败");
}
}
catch (Exception ex)
{
Console.WriteLine("删除数据失败：" + ex.ToString());
}
}
static void UpdateData()
{
try
{
string dbPath = "E:\\data.db";
string sql = "update t_set set SetValue=@SetValue where SetName=@SetName";
SQLiteParameter[] parameters = new SQLiteParameter[]{
new SQLiteParameter("@SetName","UseDate"),
new SQLiteParameter("@SetValue","")
};
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
int ret = db.ExecuteNonQuery(sql, parameters);
if (ret > 0)
{
Console.WriteLine("更新数据成功");
}
else
{
Console.WriteLine("更新数据失败");
}
}
catch (Exception ex)
{
Console.WriteLine("更新数据失败：" + ex.ToString());
}
}
static void InertData()
{
try
{
string dbPath = @"E:\Andwho.db";
string sql = "INSERT INTO t_config(Name,Value)values(@Name,@Value)";
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
//string password = MD5EncryptDES("123");
SQLiteParameter[] parameters = new SQLiteParameter[]{
new SQLiteParameter("@Name","CityCode"),
new SQLiteParameter("@Value","101010100")
};
db.ExecuteNonQuery(sql, parameters);
Console.WriteLine("插入数据成功");
}
catch (Exception e)
{
Console.WriteLine("插入数据失败：" + e.ToString());
}
}
static void DropTable()
{
try
{
string dbPath = "E:\\Andwho.db";
//如果不存在
if (!System.IO.File.Exists(dbPath))
{
return ;
}
SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
string sql = "DROP TABLE t_expenditure ";
db.ExecuteNonQuery(sql, null);
Console.WriteLine("删表成功");
}
catch (Exception e)
{
Console.WriteLine("删表失败：" + e.ToString());
}
}
