/// <summary>
/// //初始化数据库
/// </summary>
public MySqlite(string sBaseName = "MyDatabase.sqlite")
{
m_dbConnection = new SQLiteConnection("Data Source=" + sBaseName + ";Version=3;");
m_dbConnection.Open();
try
{
string sql = "SELECT COUNT(*) FROM " + sTableName + "";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteScalar();
}
catch (Exception ex)
{
string sql = "create table " + sTableName + " (name varchar(20), value varchar(20))";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
}
}
/// <summary>
/// ///数据库sqlite连接
/// </summary>
SQLiteConnection m_dbConnection;
/// <summary>
/// ///表名
/// </summary>
string sTableName = "param";
/// <summary>
/// /保存数值
/// </summary>
/// <param name="name">名称</param>
/// <param name="value">数值</param>
/// <returns>返回错误信息</returns>
public void Set(string name, string value)
{
string sql = string.Empty;
sql = "delete from " + sTableName + " where name = '" + name + "'";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
sql = "insert into " + sTableName + " (name, value) values ('" + name + "', '" + value + "')";
command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
}
/// <summary>
/// //获取名称对应的数值
/// </summary>
/// <param name="name">名称</param>
/// <returns>数值</returns>
public string Get(string name)
{
string sql = "select * from " + sTableName + " where name = '" + name + "'";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string value = reader["value"].ToString();
return value;
}
return "";
}