用.NET语言写一个操作SQLITE数据库的类,这个类具有增加,删除,修改,查询的功能
时间: 2023-06-23 17:09:23 浏览: 76
好的,我能为您提供帮助。以下是一个用.NET语言编写的操作SQLITE数据库的类示例:
```
using System.Data.SQLite;
public class SQLiteHelper {
private string _connectionString;
public SQLiteHelper(string connectionString) {
_connectionString = connectionString;
}
public void Insert(string tableName, string[] columns, string[] values) {
using (var connection = new SQLiteConnection(_connectionString)) {
connection.Open();
var command = connection.CreateCommand();
command.CommandText = String.Format("INSERT INTO {0} ({1}) VALUES (@{2})", tableName, String.Join(",", columns), String.Join(",@", columns));
for (int i = 0; i < columns.Length; i++) {
command.Parameters.AddWithValue("@" + columns[i], values[i]);
}
command.ExecuteNonQuery();
}
}
public void Update(string tableName, string[] columns, string[] values, string condition) {
using (var connection = new SQLiteConnection(_connectionString)) {
connection.Open();
var command = connection.CreateCommand();
command.CommandText = String.Format("UPDATE {0} SET {1} WHERE {2}", tableName, String.Join(",", columns.Select((c, i) => c + " = @" + i)), condition);
for (int i = 0; i < values.Length; i++) {
command.Parameters.AddWithValue("@" + i, values[i]);
}
command.ExecuteNonQuery();
}
}
public void Delete(string tableName, string condition) {
using (var connection = new SQLiteConnection(_connectionString)) {
connection.Open();
var command = connection.CreateCommand();
command.CommandText = String.Format("DELETE FROM {0} WHERE {1}", tableName, condition);
command.ExecuteNonQuery();
}
}
public DataTable Select(string tableName, string[] columns, string condition) {
using (var connection = new SQLiteConnection(_connectionString)) {
connection.Open();
var command = connection.CreateCommand();
command.CommandText = String.Format("SELECT {0} FROM {1} WHERE {2}", String.Join(",", columns), tableName, condition);
var reader = command.ExecuteReader();
var table = new DataTable();
table.Load(reader);
return table;
}
}
}
```
这个类包括了增加、删除、修改和查询操作。您可以将表名、列名、值以及条件传递给这些函数来进行操作。
请注意,这个例子包含了一些占位符,例如“@ColumnName”。您需要将这些占位符替换为合适的参数,以便适应您的应用程序的需要。