SQLite C#兑现操作

SQLite C#实现操作

debug command

C:\1.db

?

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SQLite;namespace CSharpConnectionSQLLite{    class Program    {        private static SQLiteConnection conn = null;        private static string sql = "CREATE TABLE test(username varchar(20),password varchar(20))";        private static string insertintosql = "INSERT INTO test VALUES('myuser','mypassword')";        private static string querySql = "SELECT * FROM test";        static void Main(string[] args)        {            Dao dao = new Dao();            try            {                conn = dao.GetConnection(args[0]);                conn.Open();                conn.CreateCommand();                Console.WriteLine("Success");                //dao.CreateTable(sql, conn);                dao.InsertIntoValue(insertintosql,conn);                SQLiteDataReader reader = dao.GetTableValue(querySql, conn);                while(reader.Read())                {                    Console.Write(reader.GetString(0));                    Console.Write("\t");                    Console.WriteLine(reader.GetString(1));                }            }            catch(Exception)            {                Console.WriteLine("Failed");            }            finally            {                dao.CloseConnection(conn);            }            Console.ReadKey();        }    }}