using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Data.sqlite;
using sqliteQueryBrowser;
namespace sqliteDemo
{
class Program
{
static void Main( string[] args)
{
//CreateTable();
//InsertData();
ShowData();
Console.ReadLine();
}
public static void CreateTable()
{
string dbPath = "D:\\Demo.db3";
//如果不存在改数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
sqliteDBHelper.CreateDB( "D:\\Demo.db3");
}
sqliteDBHelper db = new sqliteDBHelper( "D:\\Demo.db3");
string sql = "CREATE TABLE Test3(id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,Name char(3),TypeName varchar(50),addDate datetime,UpdateTime Date,Time time,Comments blob)";
db.ExecuteNonQuery(sql,null);
}
public static void InsertData()
{
string sql = "INSERT INTO Test3(Name,TypeName,addDate,UpdateTime,Time,Comments)values(@Name,@TypeName,@addDate,@UpdateTime,@Time,@Comments)";
sqliteDBHelper db = new sqliteDBHelper( "D:\\Demo.db3");
for ( char c = 'A'; c <= 'Z'; c++)
{
for ( int i = 0; i < 100; i++)
{
sqliteParameter[] parameters = new sqliteParameter[]{
new sqliteParameter( "@Name",c+i.ToString()),
new sqliteParameter( "@TypeName",c.ToString()),
new sqliteParameter( "@addDate",DateTime.Now),
new sqliteParameter( "@UpdateTime",DateTime.Now.Date),
new sqliteParameter( "@Time",DateTime.Now.ToShortTimeString()),
new sqliteParameter( "@Comments","Just a Test"+i)
};
db.ExecuteNonQuery(sql,parameters);
}
}
}
public static void ShowData()
{
//查询从50条起的20条记录
string sql = "select * from test3 order by id desc limit 50 offset 20";
sqliteDBHelper db = new sqliteDBHelper( "D:\\Demo.db3");
using (sqliteDataReader reader = db.ExecuteReader(sql,null))
{
while (reader.Read())
{
Console.WriteLine( "ID:{0},TypeName{1}",reader.GetInt64(0),reader.GetString(1));
}
}
}

}
}