//插入数据 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); }