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 GetUpdate(Test test)
{
MYsql my = new MYsql();
string sql = string.Format("update Notice set nTitle = '{0}' ,nContents = '{1}' where nNo = {2}", test.nTitle, test.nContents, 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(10,'{0}','{1}')", test.nTitle, test.nContents);
if (my.NonQuery(sql))
{
return(GetSelect());
}
else
{
return(new ArrayList());
}
}
