public AccountEntity login(string email,string password) { //string mysql = "SELECT * FROM yumiyumi.yumi_account where user_name ='"+email+"'"; string mysql = "SELECT * FROM yumiyumi.yumi_account where user_name = ?user_name"; MySqlParameter[] parameters = { new MySqlParameter("?user_name", MySqlDbType.VarChar, 255), }; parameters[0].Value = email; MySqlDataReader myreader = MySqlHelper.ExecuteReader(mysql, parameters); AccountEntity user = new AccountEntity(); while (myreader.Read()) { user.user_id = myreader.GetInt32(0); user.user_name = myreader.GetString(1); user.password = myreader.GetString(2); } myreader.Close(); return user; }
public AccountEntity addUser() { string myStr = ConfigurationManager.AppSettings["entityFramework"].ToString(); string mysql = "SELECT * FROM yumiyumi.yumi_account"; MySqlConnection conn = new MySqlConnection(myStr); conn.Open(); MySqlCommand cmd = new MySqlCommand(mysql, conn); MySqlCommand mycommand = new MySqlCommand(mysql, conn); //通过MySqlCommand的ExecuteReader()方法构造DataReader对象 MySqlDataReader myreader = mycommand.ExecuteReader(); AccountEntity user = new AccountEntity(); while (myreader.Read()) { user.user_id = myreader.GetInt32(0); user.user_name = myreader.GetString(1); user.password = myreader.GetString(2); } myreader.Close(); conn.Close(); return user; }