/// <summary> /// 在指定的数据库中,创建数据表 /// </summary> /// <param name="db">指定的数据库</param> /// <param name="dt">要创建的数据表集合</param> /// <param name="dic">数据表中的字段及其数据类型 Dictionary集合</param> /// <param name="connKey">数据库的连接Key</param> public void CreateDataTable(string db, string[] dt, List <Dictionary <string, string> > dic, string connKey) { Helper.SQLSERVER.SqlServer_tool SqlServer_tool = new Helper.SQLSERVER.SqlServer_tool(); //string connToMaster = ConfigurationManager.ConnectionStrings[connKey].ToString(); //判断数据库是否存在 if (IsDBExist(db, connKey) == false) { throw new Exception("数据库不存在!"); } for (int i = 0; i < dt.Count(); i++) { //如果数据库表存在,则抛出错误 if (IsTableExist(db, dt[i], connKey) == true) { //如果数据库表已经存在,则跳过该表 continue; } else//数据表不存在,创建数据表 { //其后判断数据表是否存在,然后创建数据表 string createTableStr = PinjieSql(db, dt[i], dic[i]); SqlServer_tool.ExecuteNonQuery(createTableStr, connKey); } } }
/// <summary> /// 批量删除数据库 /// </summary> /// <param name="db">指定的数据库</param> /// <param name="dt">要删除的数据库表集合</param> /// <param name="connKey">数据库连接串</param> /// <returns>删除是否成功,true表示删除成功,false表示删除失败</returns> public bool DropDataTable(string db, List <string> dt, string connKey) { //string connToMaster = ConfigurationManager.ConnectionStrings[connKey].ToString(); Helper.SQLSERVER.SqlServer_tool SqlServer_tool = new Helper.SQLSERVER.SqlServer_tool(); //判断数据库是否存在 if (IsDBExist(db, connKey) == false) { throw new Exception("数据库不存在!"); } for (int i = 0; i < dt.Count(); i++) { //如果数据库表存在,则抛出错误 if (IsTableExist(db, dt[i], connKey) == false) { //如果数据库表已经删除,则跳过该表 continue; } else//数据表存在,则进行删除数据表 { //其后判断数据表是否存在,然后创建数据表 string createTableStr = "use " + db + " drop table " + dt[i] + " "; SqlServer_tool.ExecuteNonQuery(createTableStr, connKey); } } return(true); }
/// <summary> /// 创建数据库 /// </summary> /// <param name="db">数据库名称</param> /// <param name="connKey">连接数据库的key</param> public void CreateDataBase(string db, string connKey) { Helper.SQLSERVER.SqlServer_tool SqlServer_tool = new Helper.SQLSERVER.SqlServer_tool(); //符号变量,判断数据库是否存在 Boolean flag = IsDBExist(db, connKey); //如果数据库存在,则抛出 if (flag == true) { throw new Exception("数据库已经存在!"); } else { //数据库不存在,创建数据库 //string connToMaster = ConfigurationManager.ConnectionStrings[connKey].ToString(); string createDbStr = "Create database " + db; SqlServer_tool.ExecuteNonQuery(createDbStr, connKey); } }
/// <summary> /// 删除数据库 /// </summary> /// <param name="db">数据库名</param> /// <param name="connKey">数据库连接串</param> /// <returns>删除成功为true,删除失败为false</returns> public bool DropDataBase(string db, string connKey) { Helper.SQLSERVER.SqlServer_tool SqlServer_tool = new Helper.SQLSERVER.SqlServer_tool(); //SQLHelper helper = SQLHelper.GetInstance(); //符号变量,判断数据库是否存在 Boolean flag = IsDBExist(db, connKey); //如果数据库不存在,则抛出 if (flag == false) { return(false); } else { //数据库存在,删除数据库 //string connToMaster = ConfigurationManager.ConnectionStrings[connKey].ToString(); string createDbStr = "Drop database " + db; SqlServer_tool.ExecuteNonQuery(createDbStr, connKey); return(true); } }
/// <summary> ///在指定的数据库中,创建数据库表 /// </summary> /// <param name="db">指定的数据库</param> /// <param name="dt">要创建的数据库表</param> /// <param name="dic">数据表中的字段及其数据类型</param> /// <param name="connKey">数据库的连接Key</param> /// <returns>成功返回“ok” 失败返回“报错信息”</returns> public string CreateDataTable(string db, string dt, Dictionary <string, string> dic, string connKey) { Helper.SQLSERVER.SqlServer_tool SqlServer_tool = new Helper.SQLSERVER.SqlServer_tool(); //string connToMaster = ConfigurationManager.ConnectionStrings[connKey].ToString(); //判断数据库是否存在 if (IsDBExist(db, connKey) == false) { return("数据库不存在!"); //throw new Exception("数据库不存在!"); } //如果数据库表存在,则抛出错误 if (IsTableExist(db, dt, connKey) == true) { return("数据库表已经存在!"); //throw new Exception("数据库表已经存在!"); } //数据库表不存在,创建表 else { //拼接字符串,该串为创建内容 //string content = "serial int identity(1,1) primary key"; string content = ""; //取出dic中的内容,进行拼接 List <string> Keys = new List <string>(dic.Keys); List <string> Values = new List <string>(dic.Values); for (int i = 0; i < dic.Count(); i++) { content = content + "," + Keys[i] + " " + Values[i]; } content = content.Remove(0, 1); //其后判断数据库表是否存在,然创建表 string createTableStr = "use " + db + " create table " + dt + "(" + content + ")"; SqlServer_tool.ExecuteNonQuery(createTableStr, connKey); } return("ok"); }