public static ArrayList GetUpdate(Test test) { MYsql my = new MYsql(); //Console.WriteLine("GetUpdate 진입성공"); string sql = string.Format("update Notice set nTitle = '{1}', nContents = '{2}' where nNo = {0};", test.nNo, test.nTitle, test.nContents); if (my.NonQuery(sql)) { return(GetSelect()); } else { return(new ArrayList()); } }
public static ArrayList GetDelete(Test test) { //Console.WriteLine("GetDelete 진입성공 test.nNo : " + test.nNo); 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) { int mNo = Member_GetSelect(test); //Console.WriteLine("성공1 : " + mNo); MYsql my = new MYsql(); string sql = string.Format("insert into Notice (mNo, nTitle, nContents) values ('{0}','{1}','{2}');", mNo, test.nTitle, test.nContents); if (my.NonQuery(sql)) { return(GetSelect()); } else { return(new ArrayList()); } }