/// <summary> /// 修改 /// </summary> /// <param name="user"></param> /// <returns></returns> public int Change(MOD.User user) { string sql = "update user set username='******'" + user.Key + "'," + "userNumber='" + user.Number + "',userWhere='" + user.Where + "' where ID='" + user.ID1 + "'"; return(xiugaiuser(sql)); }
//查询 public MOD.User SelectUser(string userName) { sqlConnection.Open(); MySqlCommand mySqlCommand = new MySqlCommand("select * from user where UserName='******'", sqlConnection); MySqlDataReader reader = mySqlCommand.ExecuteReader(); if (reader.Read()) { MOD.User user = new MOD.User(Convert.ToInt32(reader[0].ToString()), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString()); sqlConnection.Clone(); return(user); } else { sqlConnection.Close(); return(null); } }
//增加 public int AddUser(MOD.User user) { sqlConnection.Open(); MySqlCommand mySqlCommand = new MySqlCommand(); mySqlCommand.Connection = sqlConnection; mySqlCommand.CommandText = "insert into User (UserName ,UserKey,UserNumber,UserWhere) " + "values (@UserName ,@Key ,@Number,@Where)"; mySqlCommand.Parameters.AddRange( new MySqlParameter[] { new MySqlParameter("@UserName", user.UserName), new MySqlParameter("@Key", user.Key), new MySqlParameter("@Number", user.Number), new MySqlParameter("@Where", user.Where) } ); int a = mySqlCommand.ExecuteNonQuery(); sqlConnection.Close(); return(a); }