public static ArrayList Getupdate(Test test) { MYsql my = new MYsql(); string sql = string.Format("update Notice set mNo = '{1}', nTtitle = '{2}', nContents = '{3}' where nNo='{0}';", test.nNo, test.mNo, test.nTitle, test.nContents); if (my.NonQuery(sql)) { return(Getselect()); } else { return(new ArrayList()); } }
public static ArrayList Getdelete(Test test) { MYsql my = new MYsql(); string sql = string.Format("update Notice set delYn = 'Y' where nNo = {0}", test.nNo); if (my.NonQuery(sql)) { return(Getselect()); } else { return(new ArrayList()); } }
public static ArrayList Getinsert(Test test) //입력 { MYsql my = new MYsql(); string sql = string.Format("insert into Notice (mNo,nTitle,nContents) values ({0},'{1}','{2}');", test.mNo, test.nTitle, test.nContents); if (my.NonQuery(sql)) { return(Getselect()); } else { return(new ArrayList()); } }