public static ArrayList GetUpdate(Test test) { MYsql my = new MYsql(); string sql = string.Format("update Notice set nTitle = '{1}', nContents = '{2}' where mNo = {0};", 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 mNo = {0};", test.mNo); 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()); } }