private void toolBar1_ToolbarItemClick(object sender, ToolbarClickEventArgs e) { switch (e.Name) { case "Hots": Form_Hots form_hots = new Form_Hots(); this.Show(form_hots); break; case "News": Form_Defult form_news = new Form_Defult(); this.Show(form_news); break; case "Types": Form_Types form_types = new Form_Types(); this.Show(form_types); break; case "Mine": Form_Mine form_mine = new Form_Mine(); this.Show(form_mine); break; default: break; } ; }
private void btn_log_Press(object sender, EventArgs e) { Console.WriteLine("初始化?"); String connetStr = "server=" + Config.server + ";" + "port=" + Config.port + ";" + "user="******";" + "password="******"; " + "database=" + Config.database + ";"; // server=127.0.0.1/localhost 代表本机,端口号port默认是3306可以不写 MySqlConnection conn = new MySqlConnection(connetStr); try { string username = textBox_user.Text.Trim(); string password = textBox_pwd.Text.Trim(); if (string.IsNullOrEmpty(username)) { throw new Exception("请输入用户名!"); } if (string.IsNullOrEmpty(password)) { throw new Exception("请输入密码!"); } if (checkRemeber.Checked == true) { LoadClientData("username", textBox_user.Text); LoadClientData("password", textBox_pwd.Text); } conn.Open();//打开通道,建立连接,可能出现异常,使用try catch语句 Console.WriteLine("已经建立连接"); //在这里使用代码对数据库进行增删查改 string sql = "select * from `user_table` where user_name = '" + textBox_user.Text + "'"; MySqlDataAdapter find = new MySqlDataAdapter(sql, conn); DataSet save = new DataSet(); find.Fill(save); if (save.Tables[0].Rows.Count <= 0) { throw new Exception("用户不存在,请重新输入!"); } string pwd = save.Tables[0].Rows[0][2].ToString(); //登录成功,在此跳转 if (pwd == textBox_pwd.Text) { MessageBox.Show("密码正确!"); Form_Defult form_Defult = new Form_Defult(); this.Show(form_Defult); } else { throw new Exception("密码不正确,请重新输入!"); } } catch (Exception ex) { //RemoveClientData("username", (object s, ClientDataResultHandlerArgs args) => //{ // Toast("账户名清空"); // Console.WriteLine("11"); //}); //RemoveClientData("password", (object s, ClientDataResultHandlerArgs args) => //{ // Toast("密码清空"); // Console.WriteLine("11"); //}); MessageBox.Show(ex.Message); } finally { conn.Close(); } }