SQLite数据库的增删改查代码

概述//搜集整理了一下网上的代码.找了半天居然找不到一条插入语句.好郁闷的 //感觉速度还可以.小文件.很多小应用程序在用这个数据库 //SQLite使用办法.直接COPYDLL文件System.Data.SQLite.DLL到应用程序DEBUG目录下。 然后在项目中添加引用,找到这个文件即可 //添加引用 using System; using System.Collections.Generic;

//搜集整理了一下网上的代码.找了半天居然找不到一条插入语句.好郁闷的

//感觉速度还可以.小文件.很多小应用程序在用这个数据库

//sqlite使用办法.直接copYDLL文件System.Data.sqlite.DLL到应用程序DEBUG目录下。 然后在项目中添加引用,找到这个文件即可

//添加引用

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.windows.Forms;

using System.IO;
using System.Net;
using System.Data.sqlite;

private static string FavoriteDbPath = System.Environment.CurrentDirectory + "//Favorite.db";

private bool CreatesqliteDb()
{
try
{
System.Data.sqlite.sqliteConnection.Createfile(FavoriteDbPath);
System.Data.sqlite.sqliteConnection Conn = new System.Data.sqlite.sqliteConnection();
System.Data.sqlite.sqliteConnectionStringBuilder ConnStr = new System.Data.sqlite.sqliteConnectionStringBuilder();
ConnStr.DataSource = FavoriteDbPath;
ConnStr.Password = "admin";//设置密码，sqlite ADO.NET实现了数据库密码保护
Conn.ConnectionString = ConnStr.ToString();
Conn.open();
System.Data.sqlite.sqliteCommand cmd = new System.Data.sqlite.sqliteCommand();
string sql = "CREATE table admin(Username varchar(20),UserPass varchar(20))";
cmd.CommandText = sql;
cmd.Connection = Conn;
cmd.ExecuteNonquery();
Conn.dispose();
return true;
}
catch (Exception ex)
{
Console.Writeline(ex.Message);
return false;
}
}

public bool CreatelinkDatatable()
{
try
{
System.Data.sqlite.sqliteConnection Conn = new System.Data.sqlite.sqliteConnection();
System.Data.sqlite.sqliteConnectionStringBuilder ConnStr = new System.Data.sqlite.sqliteConnectionStringBuilder();
ConnStr.DataSource = FavoriteDbPath;
ConnStr.Password = "admin";//设置密码，sqlite ADO.NET实现了数据库密码保护
Conn.ConnectionString = ConnStr.ToString();
Conn.open();
System.Data.sqlite.sqliteCommand cmd = new System.Data.sqlite.sqliteCommand();
string sql = "CREATE table [FavoriteList] ([ID] INTEGER NOT NulL PRIMARY KEY autoINCREMENT,[linkText] NVARCHAR(256) NulL,[linkUrl] NVARCHAR(1000),[AddTime] TIMESTAMP DEFAulT CURRENT_TIMESTAMP NulL)";
cmd.CommandText = sql;
cmd.Connection = Conn;
cmd.ExecuteNonquery();
Conn.dispose();
return true;
}
catch (Exception)
{
return false;
}
}
public bool InsertlinkDatatable(string strlinkText,string strlinkUrl,DateTime dtfileTime)
{
try
{
System.Data.sqlite.sqliteConnection Conn = new System.Data.sqlite.sqliteConnection();
System.Data.sqlite.sqliteConnectionStringBuilder ConnStr = new System.Data.sqlite.sqliteConnectionStringBuilder();
ConnStr.DataSource = FavoriteDbPath;
ConnStr.Password = "admin";//设置密码，sqlite ADO.NET实现了数据库密码保护
Conn.ConnectionString = ConnStr.ToString();
Conn.open();
System.Data.sqlite.sqliteCommand cmd = new System.Data.sqlite.sqliteCommand();
string strInsertsql = "INSERT INTO [FavoriteList] (linkText,linkUrl,AddTime) VALUES('" + strlinkText + "','" + strlinkUrl + "','" + dtfileTime + "');";
Console.Writeline(strInsertsql);
cmd.CommandText = strInsertsql;
cmd.Connection = Conn;
cmd.ExecuteNonquery();
Conn.dispose();
return true;
}
catch (Exception ex)
{
Console.Writeline(ex.Message);
return false;
}
}
public bool GetlinkDatatableRecordList()
{
try
{
System.Data.sqlite.sqliteConnection Conn = new System.Data.sqlite.sqliteConnection();
System.Data.sqlite.sqliteConnectionStringBuilder ConnStr = new System.Data.sqlite.sqliteConnectionStringBuilder();
ConnStr.DataSource = FavoriteDbPath;
ConnStr.Password = "admin";//设置密码，sqlite ADO.NET实现了数据库密码保护
Conn.ConnectionString = ConnStr.ToString();
Conn.open();
System.Data.sqlite.sqliteCommand cmd = new System.Data.sqlite.sqliteCommand();
cmd.Connection = Conn;
cmd.CommandText = "select * from [FavoriteList]";
sqliteDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Console.Writeline("编号 " + System.Convert.ToString(dr["ID"]) + " 文本 " + (string)dr["linktext"] + " 地址 " + (string)dr["linkUrl"]);
}
Conn.dispose();
return true;
}
catch (Exception)
{
return false;
}
}

private voID 创建数据库文件ToolStripMenuItem_Click(object sender,EventArgs e)
{
try
{
if (System.IO.file.Exists(FavoriteDbPath))
{
System.IO.file.Delete(FavoriteDbPath);
}
if (CreatesqliteDb())
{
MessageBox.Show("数据库创建成功");
}
else
{
MessageBox.Show("数据库创建失败");
}
}
catch (Exception ex)
{
MessageBox.Show("创建数据库文件出错" + ex.Message);
}
}

private voID 创建收藏夹数据表ToolStripMenuItem_Click(object sender,EventArgs e)
{
try
{
if (CreatelinkDatatable())
{
MessageBox.Show("创建收藏夹数据表成功");
}
else
{
MessageBox.Show("创建收藏夹数据表失败");
}
}
catch (Exception ex)
{
MessageBox.Show("创建收藏夹数据表出错" + ex.Message);
}
}

private voID 查询收藏夹数据表ToolStripMenuItem_Click(object sender,EventArgs e)
{
try
{
if (GetlinkDatatableRecordList())
{
MessageBox.Show("查询收藏夹数据表成功");
}
else
{
MessageBox.Show("查询收藏夹数据表失败");
}
}
catch (Exception ex)
{
MessageBox.Show("查询收藏夹数据表出错" + ex.Message);
}
}

private voID 插入新的数据记录ToolStripMenuItem_Click(object sender,EventArgs e) { try { if (InsertlinkDatatable("GJKHKJHK","HLKJLJL",DateTime.Now)) { MessageBox.Show("插入新的数据记录成功"); } else { MessageBox.Show("插入新的数据记录失败"); } } catch (Exception ex) { MessageBox.Show("插入新的数据记录出错" + ex.Message); } }

总结

以上是内存溢出为你收集整理的SQLite数据库的增删改查代码全部内容，希望文章能够帮你解决SQLite数据库的增删改查代码所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。