public static void CreateTable()
{
string dbPath = testDatabaseName;
//如果不存在改数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
SQLiteDBHelper.CreateDB(testDatabaseName);
}
bool tableExist = false;
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + dbPath))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = "select count(*) from sqlite_master where type = 'table' and name = 'Test3'";
int num = Convert.ToInt32(command.ExecuteScalar());
if (num > 0)
{
tableExist = true;
}
}
}
if (!tableExist)
{
SQLiteDBHelper db = new SQLiteDBHelper(testDatabaseName);
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);
}
}
static public bool SentToDB()
{
if (!System.IO.File.Exists(dbPath))
{
SQLiteDBHelper.CreateDB(dbPath);
}
bool tableExist = false;
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + dbPath))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = "select count(*) from sqlite_master where type = 'table' and name = '" + existFilessName + "'";
int num = Convert.ToInt32(command.ExecuteScalar());
if (num > 0)
{
tableExist = true;
}
}
}
SQLiteDBHelper db = null;
string sql = null;
if (tableExist)
{
db = new SQLiteDBHelper(dbPath);
sql = "DROP TABLE " + existFilessName;
db.ExecuteNonQuery(sql, null);
}
db = new SQLiteDBHelper(dbPath);
sql = "CREATE TABLE " + existFilessName + @"(
name TEXT,
filePath TEXT )";
db.ExecuteNonQuery(sql, null);
sql = "INSERT INTO " + existFilessName + "(name,filePath)values(@name, @filePath)";
db = new SQLiteDBHelper(dbPath);
for (int i = 0; i < g_FileInfoCollector.Count; i++)
{
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@name", ((FileInformation)g_FileInfoCollector[i]).FileName),
new SQLiteParameter("@filePath", ((FileInformation)g_FileInfoCollector[i]).FullName)
};
db.ExecuteNonQuery(sql, parameters);
}
return(true);
}
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(testDatabaseName);
for (char c = 'A'; c <= 'Z'; c++)
{
for (int i = 0; i < 5; 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);
}
}
}
protected override bool CreateTable()
{
try
{
SQLiteDBHelper db = null;
string sql = null;
db = new SQLiteDBHelper(datebaseName);
if (db.IsTableExist(tableName))
{
db.DeleteTable(tableName);
}
sql = @"CREATE TABLE file_name(
name TEXT,
property1 TEXT,
property2 TEXT,
property3 TEXT,
property4 TEXT,
property5 TEXT,
property6 TEXT,
property7 TEXT,
property8 TEXT,
property9 TEXT,
property10 TEXT)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception)
{
return(false);
}
return(true);
}
