SQLite笔记
来源:互联网 发布:网络大电影计划 编辑:程序博客网 时间:2024/06/15 18:56
一、SQLite下载:
http://www.sqlite.org/download.html (或在NuGet下载安装)
二、SQLite操作:
1、添加引用System.Data.SQLite,如安装目录在E:\Program Files\System.Data.SQLite\2010\bin,则找到System.Data.SQLite.dll引用到当前项目中;
using System.Data.SQLite;
2、进行简单增删改查操作,语法跟sql server相差不大
public class UseSQLIte { SQLiteConnection m_dbConnection; public UseSQLIte() { createNewDatabase(); connectToDatabase(); createTable(); fillTable(); ShowInfo(); } //创建一个空的数据库 void createNewDatabase() { SQLiteConnection.CreateFile("SqliteDemo"); } //建立连接 bool connectToDatabase() { try { m_dbConnection = new SQLiteConnection("Data Source=SqliteDemo;Version=3;"); m_dbConnection.Open(); return true; } catch { return false; } } //创建表 void createTable() { string sql = "create table OnePiece(name VARCHAR(20), Reward BIGINT)"; SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); command.ExecuteNonQuery(); } //插入数据 void fillTable() { string sql = "insert into OnePiece (name, Reward) values ('路飞', 5000000000)"; SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); command.ExecuteNonQuery(); sql = "insert into OnePiece (name, Reward) values ('索隆', 3000000000)"; command = new SQLiteCommand(sql, m_dbConnection); command.ExecuteNonQuery(); sql = "insert into OnePiece (name, Reward) values ('山治', 2000000000)"; command = new SQLiteCommand(sql, m_dbConnection); command.ExecuteNonQuery(); sql = "insert into OnePiece (name, Reward) values ('乔巴', 100)"; command = new SQLiteCommand(sql, m_dbConnection); command.ExecuteNonQuery(); } //查询语句,并显示结果 void ShowInfo() { string sql = "select * from OnePiece order by Reward desc"; SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) Console.WriteLine("姓名: " + reader["name"] + "\t赏金: " + reader["Reward"]); } Console.ReadLine(); } bool check(string tableName) { string sql = "select count(*) from sqlite_master where type='table' and name ='" + tableName + "'"; SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); int i = Convert.ToInt32(command.ExecuteScalar()); return i > 0; } }
3、效果显示:
三、资源收录
Sqlite全面学习(一、二、三)
0 0
- sqlite笔记
- sqlite笔记
- SQLite 笔记
- sqlite笔记
- sqlite笔记
- SQLITE 笔记
- SQLite笔记
- SQLite 笔记
- SQLite笔记
- SQLite笔记
- SQLite笔记
- SQLite笔记
- SQLite笔记
- SQLite学习笔记
- sqlite笔记1
- sqlite笔记2
- android sqlite开发笔记
- SQLite学习笔记1
- CSS学习笔记12:伪类和超链接的美化
- logstash Output plugins >> elasticsearch
- type = hidden 隐藏域有什么作用?
- Android中RelativeLayout各个属性和自带样式 theme
- 安装redis
- SQLite笔记
- 我们为什么要用nginx,nginx的特点
- C语言 在被调函数中改变指针变量值的方法
- 欢迎使用CSDN-markdown编辑器
- PAT 1064 朋友数
- day05
- unable to find vcvarsall.bat
- 如何榨干cpu的每一滴资源(parallel computing in R)
- ACE 架构学习笔记