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 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 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());
}
}
public static ArrayList Getselect() // 출력
{
MYsql my = new MYsql();
string sql = "select * from Member";
MySqlDataReader sdr = my.Reader(sql);
ArrayList list = new ArrayList();
while (sdr.Read())
{
Hashtable ht = new Hashtable();
for (int i = 0; i < sdr.FieldCount; i++)
{
ht.Add(sdr.GetName(i), sdr.GetValue(i));
//result += string.Format("{0} : {1} ", sdr.GetName(i), sdr.GetValue(i));
}
// result += "\n";
list.Add(ht);
}
return(list);
}