//插入数据
public void Insert(UsersEntity UE)
{
SQLiteCommand cmd = new SQLiteCommand(conn);
cmd.CommandText = "insert into 'Users' values(@name,@path)";
cmd.Parameters.Add(new SQLiteParameter("name", UE.name));
cmd.Parameters.Add(new SQLiteParameter("path", UE.path));
cmd.ExecuteNonQuery();
}
//插入数据
public void Insert(UsersEntity UE)
{
SQLiteCommand cmd = new SQLiteCommand(conn);
cmd.CommandText = "insert into 'Users' values(@name,@path)";
cmd.Parameters.Add(new SQLiteParameter("name", UE.name));
cmd.Parameters.Add(new SQLiteParameter("path", UE.path));
cmd.ExecuteNonQuery();
}
//获取一个用户
public UsersEntity Select(string name)
{
SQLiteCommand cmd = new SQLiteCommand(conn);
cmd.CommandText = "select * from 'Users' where name=@name";
cmd.Parameters.Add(new SQLiteParameter("name", name));
SQLiteDataReader reader = cmd.ExecuteReader();
UsersEntity UE = new UsersEntity();
if (reader.HasRows)
{
while (reader.Read())
{
UE.name = reader.GetValue(0).ToString();
UE.path = reader.GetValue(1).ToString();
}
}
return UE;
}
//获取一个用户
public UsersEntity Select(string name)
{
SQLiteCommand cmd = new SQLiteCommand(conn);
cmd.CommandText = "select * from 'Users' where name=@name";
cmd.Parameters.Add(new SQLiteParameter("name", name));
SQLiteDataReader reader = cmd.ExecuteReader();
UsersEntity UE = new UsersEntity();
if (reader.HasRows)
{
while (reader.Read())
{
UE.name = reader.GetValue(0).ToString();
UE.path = reader.GetValue(1).ToString();
}
}
return(UE);
}
