110,534
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Data.SQLite;
using System.Windows.Forms;
namespace WindowsFormsApp4
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
sqlite sqlite = new sqlite("devices", "dev");
}
}
class sqlite
{
//全局变量
SQLiteConnection m_dbConnection;
//构造函数
public sqlite(string db_name, string table_name)
{
createNewDatabase(db_name);
connectToDatabase(db_name);
// 创表并创建字段: name varchar(20), model varchar(20), sn varchar(20)
createTable(table_name);
// 插入数据 (name, model, sn)
insert(table_name, "小米", "米3", "sn123456");
// 查询数据
Select(table_name);
}
//创建数据库
void createNewDatabase(string db_name)
{
SQLiteConnection.CreateFile($"{db_name}.sqlite");
}
//创建一个连接到指定数据库
void connectToDatabase(string db_name)
{
m_dbConnection = new SQLiteConnection($"Data Source={db_name}.sqlite;Version=3;");
m_dbConnection.Open();
}
//在指定数据库中创建一个table
void createTable(string table_name)
{
string sql = $"create table {table_name} (name varchar(20), model varchar(20), sn varchar(20))";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
}
//插入一些数据
void insert(string table_name, string name, string model, string sn)
{
string sql = $"insert into {table_name} (name, model, sn) values ('{name}', '{model}', '{sn}')";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
}
//使用sql查询语句,并显示结果
void Select(string table_name)
{
string sql = $"select * from {table_name}";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
MessageBox.Show(
"\tname: " + reader["name"] +
"\tmodel: " + reader["model"] +
"\tsn: " + reader["sn"]);
}
}
}