/
Program.cs
55 lines (42 loc) · 1.51 KB
/
Program.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
using Microsoft.Data.Sqlite;
static void Open(string oldPassword)
{
string baseConnectionString = "Data Source=local.db";
var connectionString = new SqliteConnectionStringBuilder(baseConnectionString)
{
Mode = SqliteOpenMode.ReadWriteCreate,
Password = oldPassword
}.ToString();
using SqliteConnection? connection = new SqliteConnection(connectionString);
connection.Open();
Console.WriteLine($"Open成功");
}
static int UpdatePassword(string oldPassword, string newPassword)
{
string baseConnectionString = "Data Source=local.db";
var connectionString = new SqliteConnectionStringBuilder(baseConnectionString)
{
Mode = SqliteOpenMode.ReadWriteCreate,
Password = oldPassword
}.ToString();
using (var connection = new SqliteConnection(connectionString))
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT quote($newPassword);";
command.Parameters.AddWithValue("$newPassword", newPassword);
var quotedNewPassword = command.ExecuteScalar() as string;
command.CommandText = "PRAGMA rekey = " + quotedNewPassword;
command.Parameters.Clear();
int x = command.ExecuteNonQuery();
return x;
}
}
}
string oldPassword = "123qwe";
string newPassword = "abcd";
//string oldPassword = "abcd";
//string newPassword = "123qwe";
Open(oldPassword);
//UpdatePassword(oldPassword, newPassword);