/// <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)); }