public ArrayList GetDelete(string id, string name, string passwd) { MySql my = new MySql(); string sql = string.Format("delete from test where id = '{0}'", id); if (my.NonQuery(sql)) { return(GetSelect()); } else { return(new ArrayList()); } }
public bool NonQuery_INSERT(string val) { MySql my = new MySql(); string sql = val; if (my.NonQuery(sql)) { return(true); } else { return(false); } }
public ArrayList GetUpdate(string id, string name, string passwd) { MySql my = new MySql(); string sql = string.Format("update test set name = '{1}', passwd = '{2}' where id = '{0}';", id, name, passwd); if (my.NonQuery(sql)) { return(GetSelect()); } else { return(new ArrayList()); } }
public ArrayList GetInsert(string id, string name, string passwd) { MySql my = new MySql(); string sql = string.Format("insert into test values ('{0}','{1}','{2}');", id, name, passwd); if (my.NonQuery(sql)) { return(GetSelect()); } else { return(new ArrayList()); } }
public void GetUPDATE_Pass(string passwod, string user_number) { MySql my = new MySql(); string sql = string.Format("UPDATE signup set passwod = '{0}' where user_number = {1};", passwod, user_number); if (my.NonQuery(sql)) { MessageBox.Show("수정 완료"); } else { MessageBox.Show("수정 실패"); } }
public void GetUPDATE(string email, string Phon, string addres, string user_number) { MySql my = new MySql(); string sql = string.Format("UPDATE signup set email = '{0}',phone_number = '{1}',address = '{2}' where user_number = {3};", email, Phon, addres, user_number); if (my.NonQuery(sql)) { MessageBox.Show("수정 완료"); } else { MessageBox.Show("수정 실패"); } }
public void GetInsert() { MySql my = new MySql(); string sql = string.Format("INSERT INTO book_rental(book_number, user_number) VALUES({0}, {1}); update book_info set availability = '불가' where book_number = {0};", 번호값.Text, login_frm.User_Number.ToString()); if (my.NonQuery(sql)) { MessageBox.Show("대여 완료!"); } else { MessageBox.Show("대여 실패!"); } }
public void GetInsert(string ID, string Pass, string Name, string Gender, string Birth, string email, string Phon, string addres) { MySql my = new MySql(); string sql = string.Format("INSERT INTO signup(id,passwod,name,gender,birthday,email,phone_number,address) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}');", ID, Pass, Name, Gender, Birth, email, Phon, addres); if (my.NonQuery(sql)) { MessageBox.Show("회원가입 완료!"); this.Hide(); main.Login.Show(); } else { MessageBox.Show("가입실패"); this.Hide(); main.user1.Show(); } }