/// <summary>
/// 添加数据
/// </summary>
public static int Add()
{
string sql = "insert into BaseTable(name,age) values(@name,@age)";
return(SQLHelps.ExecuteNonQuery(sql, new SqlParameter("@name", "张三"), new SqlParameter("@age", 18)));
}
/// <summary>
/// 添加列
/// </summary>
public static int AddCloumn(string column, string type)
{
string sql = "Alter table tabname add " + column + " " + type;
return(SQLHelps.ExecuteNonQuery(sql));
}
/// <summary>
/// 创建表
/// </summary>
public static int AddTable()
{
string sql = "create table tabname(id int primary key )";
return(SQLHelps.ExecuteNonQuery(sql));
}
/// <summary>
/// 删除表
/// </summary>
public static int DropTable()
{
string sql = "drop table tabname";
return(SQLHelps.ExecuteNonQuery(sql));
}
/// <summary>
/// 根据条件修改指定表字段的值
/// </summary>
/// <param name="table">表名</param>
/// <param name="column1">修改的列</param>
/// <param name="value1">修改的值</param>
/// <param name="column2">条件列</param>
/// <param name="value2">条件值</param>
/// <returns></returns>
public static int Update(string table, string column1, string value1, string column2, string value2)
{
string sql = "update " + table + " set " + column1 + "=" + value1 + " where " + column2 + "=" + value2;
return((int)SQLHelps.ExecuteNonQuery(sql));
}
