Sqlite 常用函数封装：修改密码，创建数据库、获取表段、字段，取值、插入、删除数据、执行Sqlite指令

原文地址：http://www.jb51.cc/article/p-unrjqlwc-gu.html

以下是频繁用到的sqlite函数，内容格式相对固定，封装一下有助于提高开发效率（^_^至少提高Codeeer的效率了）

而且，我发现sqlite中文资料比较少，起码相对其他找起来要复杂些，服务一下大众~

我没有封装读取部分，因为数据库读取灵活性太大，封装起来难度也大，而且就算封装好了，也难以应付所有情况，还是建议根据实际情况设计代码逻辑。

解释下，为啥代码中的注释基本都用英文写了，因为这段时间在学双拼- -。可是还不太熟悉，打字超慢，而且Code的时候容易打断思路，好在~英文不多，而且这些都看不懂的话你……你要向我解释一下你是怎么一路学到数据库的 0。0

修改密码

@H_403_20@

[csharp] view plain copy print ?

///<summary>
///ChangePassword
///</summary>
///<paramname="DataSource"></param>
///<paramname="OldPassword"></param>
///<paramname="NewPassword"></param>
///<returns></returns>
publicstaticboolPasswordChange(stringDataSource,stringOldPassword,stringNewPassword)
{
try
{
using(sqliteConnectionconn=newsqliteConnection())
{
sqliteConnectionStringBuilderSCS=newsqliteConnectionStringBuilder();
SCS.DataSource=DataSource;
SCS.Password=OldPassword;
conn.ConnectionString=SCS.ToString();
conn.Open();
//ChangePassword
conn.ChangePassword(NewPassword);
}
returntrue;
}
catch(ExceptionE)
{
MessageBox.Show(E.Message,"提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
returnfalse;
}
}

/// <summary> /// Change Password /// </summary> /// <param name="DataSource"></param> /// <param name="OldPassword"></param> /// <param name="NewPassword"></param> /// <returns></returns> public static bool PasswordChange(string DataSource,string OldPassword,string NewPassword) { try { using (sqliteConnection conn = new sqliteConnection()) { sqliteConnectionStringBuilder SCS = new sqliteConnectionStringBuilder(); SCS.DataSource = DataSource; SCS.Password = OldPassword; conn.ConnectionString = SCS.ToString(); conn.Open(); //Change Password conn.ChangePassword(NewPassword); } return true; } catch (Exception E) { MessageBox.Show(E.Message,"提示",MessageBoxIcon.Information); return false; } }

/// <summary> /// Creat New sqlite File /// </summary> /// <param name="NewTable">New Table Name</param> /// <param name="NewWords">Words list of the New Table</param> /// <param name="CreatNew">Creat or Add to the Database(Using to make Multi Tables)</param> /// <returns></returns> public static bool Creat(string DataSource,string NewTable,List<string> NewWords,string PassWord = null,bool CreatNew = true) { try { if (CreatNew) { //Creat Data File sqliteConnection.CreateFile(DataSource); } //Creat Table using (sqliteConnection conn = new sqliteConnection()) { sqliteConnectionStringBuilder SCS = new sqliteConnectionStringBuilder(); SCS.DataSource = DataSource; SCS.Password = PassWord; conn.ConnectionString = SCS.ToString(); conn.Open(); //Creat string Bazinga = "create table [" + NewTable + "] ("; foreach (string Words in NewWords) { Bazinga += "[" + Words + "] TEXT COLLATE NOCASE,"; } //Set Primary Key //The Top item from the "NewWords" Bazinga += @"PRIMARY KEY ([" + NewWords[0] + "]))"; DbCommand cmd = conn.CreateCommand(); cmd.Connection = conn; cmd.CommandText = Bazinga; cmd.ExecuteNonQuery(); } return true; } catch (Exception E) { MessageBox.Show(E.Message,MessageBoxIcon.Information); return false; } }

/// <summary> /// Get Tables From sqlite /// </summary> /// <returns>list of Tables</returns> public static List<string> GetTables(string DataSource,string PassWord = null) { List<string> ResultLst = new List<string>(); try { using (sqliteConnection conn = new sqliteConnection()) { sqliteConnectionStringBuilder SCS = new sqliteConnectionStringBuilder(); SCS.DataSource = DataSource; SCS.Password = PassWord; conn.ConnectionString = SCS.ToString(); conn.Open(); using (sqliteCommand tablesGet = new sqliteCommand("SELECT name from sqlite_master where type='table'",conn)) { using (sqliteDataReader tables = tablesGet.ExecuteReader()) { while (tables.Read()) { try { ResultLst.Add(tables[0].ToString()); } catch (Exception E) { MessageBox.Show(E.Message,MessageBoxIcon.Information); } } } } } } catch (Exception E) { MessageBox.Show(E.Message,MessageBoxIcon.Information); } return ResultLst; }

/// <summary> /// Get Words From Table->sqlite /// </summary> /// <param name="TargetTable">Target Table</param> /// <returns>list of Words</returns> public static List<string> GetWords(string DataSource,string TargetTable,string PassWord = null) { List<string> WordsLst = new List<string>(); using (sqliteConnection conn = new sqliteConnection()) { sqliteConnectionStringBuilder SCS = new sqliteConnectionStringBuilder(); SCS.DataSource = DataSource; SCS.Password = PassWord; conn.ConnectionString = SCS.ToString(); conn.Open(); using (sqliteCommand tablesGet = new sqliteCommand(@"SELECT * FROM " + TargetTable,conn)) { using (sqliteDataReader Words = tablesGet.ExecuteReader()) { try { for (int i = 0; i < Words.FieldCount; i++) { WordsLst.Add(Words.GetName(i)); } } catch (Exception E) { MessageBox.Show(E.Message,MessageBoxIcon.Information); } } } } return WordsLst; }

/// <summary> /// Get Values From sqlite /// </summary> /// <returns>list of Values</returns> public static List<string> GetValues(string DataSource,string sql,string GetColumu,string PassWord = null) { List<string> ResultLst = new List<string>(); using (sqliteConnection conn = new sqliteConnection()) { sqliteConnectionStringBuilder SCS = new sqliteConnectionStringBuilder(); SCS.DataSource = DataSource; SCS.Password = PassWord; conn.ConnectionString = SCS.ToString(); conn.Open(); using (sqliteCommand cmd = new sqliteCommand(sql,conn)) { using (sqliteDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { try { ResultLst.Add(dr[GetColumu].ToString()); } catch (Exception E) { MessageBox.Show(E.Message,MessageBoxIcon.Information); } } } } } return ResultLst; }

/// <summary> /// Insert Data /// </summary> /// <param name="DataSource"></param> /// <param name="TargetTable"></param> /// <returns></returns> public static bool Insert(string DataSource,string ColumnS,string ValueS,string PassWord = null) { try { using (sqliteConnection conn = new sqliteConnection()) { sqliteConnectionStringBuilder SCS = new sqliteConnectionStringBuilder(); SCS.DataSource = DataSource; SCS.Password = PassWord; conn.ConnectionString = SCS.ToString(); conn.Open(); //Insert DbCommand cmd = conn.CreateCommand(); cmd.CommandText = "insert into [" + TargetTable + "] (" + ColumnS + ") values (" + ValueS + ")"; cmd.ExecuteNonQuery(); return true; } } catch (Exception E) { MessageBox.Show(E.Message,MessageBoxIcon.Information); return false; } }

/// <summary> /// Delete Date /// </summary> /// <param name="DataSource"></param> /// <param name="TargetTable"></param> /// <param name="Word"></param> /// <param name="Value"></param> /// <returns></returns> public static bool Delete(string DataSource,string Word,string Value,string PassWord = null) { try { //Connect using (sqliteConnection conn = new sqliteConnection()) { sqliteConnectionStringBuilder SCS = new sqliteConnectionStringBuilder(); SCS.DataSource = DataSource; SCS.Password = PassWord; conn.ConnectionString = SCS.ToString(); conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.Connection = conn; //Delete cmd.CommandText = "Delete From " + TargetTable + " where [" + Word + "] = '" + Value + "'"; cmd.ExecuteNonQuery(); } return true; } catch (Exception E) { MessageBox.Show(E.Message,MessageBoxIcon.Information); return false; } }

/// <summary> /// sqliteCommand /// </summary> /// <param name="DataSource"></param> /// <param name="sql"></param> /// <returns></returns> public static bool sqlCommand(string DataSource,string PassWord = null) { try { using (sqliteConnection conn = new sqliteConnection()) { sqliteConnectionStringBuilder SCS = new sqliteConnectionStringBuilder(); SCS.DataSource = DataSource; SCS.Password = PassWord; conn.ConnectionString = SCS.ToString(); conn.Open(); using (sqliteCommand cmd_Re = new sqliteCommand(sql,conn)) { cmd_Re.ExecuteNonQuery(); } } return true; } catch (Exception E) { MessageBox.Show(E.Message,MessageBoxIcon.Information); return false; } }

Sqlite 常用函数封装：修改密码，创建数据库、获取表段、字段，取值、插入、删除数据、执行Sqlite指令

猜你在找的Sqlite相关文章