• SQLite笔记


    一、SQLite下载:

    http://www.sqlite.org/download.html (或在NuGet下载安装)

    二、SQLite操作:

      1、添加引用System.Data.SQLite,如安装目录在E:Program FilesSystem.Data.SQLite2010in,则找到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"] + "	赏金: " + 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全面学习(一、二、三)

  • 相关阅读:
    scanf的参数类型自动转换
    Gedit中文乱码
    在VirtualBox的Ubuntu虚拟机中与母体Windows共享文件夹
    Win7安vc2008编译报LINK : fatal error LNK1000: Internal error during IncrBuildImage
    贝叶斯后验概率小记
    美国计算机专业最好的前20名学校
    Linux磁盘空间不够怎么办?
    Debian6.0装机过程
    把用户加到sudoers组中的方法
    vi命令手册
  • 原文地址:https://www.cnblogs.com/EminemJK/p/6387034.html
Copyright © 2020-2023  润新知