public IList <MUser> GetAllUser() { using (var session = MySQLClientHelper.OpenSession()) { using (var cmd = session.CreateCommand()) { var list = new List <MUser>(); cmd.Connection = session; cmd.CommandText = "select * from users"; var reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine("id: " + reader.GetInt32("id") + " userName : "******"userName")); var user = new MUser(); user.Id = reader.GetInt32("id"); user.UserName = reader.GetString("userName"); user.PassWord = reader.GetString("passWord"); user.Age = reader.GetInt32("age"); list.Add(user); } session.Close(); return(list); } } }
public void SaveUser(MUser user) { using (var session = MySQLClientHelper.OpenSession()) { using (var cmd = session.CreateCommand()) { var list = new List <MUser>(); cmd.Connection = session; cmd.CommandText = string.Format("insert into users(id,userName,passWord,age) values ({0},'{1}','{2}',{3})", user.Id, user.UserName, user.PassWord, user.Age); if (cmd.ExecuteNonQuery() > 0) { Console.WriteLine(" save succeed"); } else { Console.WriteLine(" save failed"); } session.Close(); } } }
public void UpdateUser(MUser user) { using (var session = MySQLClientHelper.OpenSession()) { using (var cmd = session.CreateCommand()) { var list = new List <MUser>(); cmd.Connection = session; cmd.CommandText = string.Format("update users set userName = '******', age = {1}, passWord = '******' where id = {3}", user.UserName, user.Age, user.PassWord, user.Id); if (cmd.ExecuteNonQuery() > 0) { Console.WriteLine(" update succeed"); } else { Console.WriteLine(" update failed"); } session.Close(); } } }
public void DelUser(int id) { using (var session = MySQLClientHelper.OpenSession()) { using (var cmd = session.CreateCommand()) { var list = new List <MUser>(); cmd.Connection = session; cmd.CommandText = string.Format("delete from users where id = {0}", id); if (cmd.ExecuteNonQuery() > 0) { Console.WriteLine(" delete succeed"); } else { Console.WriteLine(" delete failed"); } session.Close(); } } }