// boardId에 따라 데이터 삭제해주는 함수 - 삭제하려는 개수가 하나일 경우
public Boolean Delete(String boardId)
{
db = new CDatabase();
string sql = "DELETE Board WHERE board_id =" + boardId;
Boolean result = db.ExecuteSQL(sql);
db.Dispose();
return(result);
}
// 작성자 검색해주는 쿼리문
public DataTable SelectWriter(String writer)
{
db = new CDatabase();
DataTable table = new DataTable();
string sql = "SELECT * FROM Board WHERE board_writer LIKE '%" + writer + "%';";
SqlDataReader reader = db.GetQueryResult(sql);
table.Load(reader);
db.Dispose();
return(table);
}
// 내용 검색해주는 쿼리문
public DataTable SelectContent(String content)
{
db = new CDatabase();
DataTable table = new DataTable();
string sql = "SELECT * FROM Board WHERE board_content LIKE '%" + content + "%';";
SqlDataReader reader = db.GetQueryResult(sql);
table.Load(reader);
db.Dispose();
return(table);
}
// boardId에 따라 데이터 삭제해주는 함수 - 삭제하려는 개수가 여러개일 경우
public Boolean Delete(ArrayList boardNumList)
{
db = new CDatabase();
Boolean result = false;
String sql = "";
foreach (object boardId in boardNumList)
{
string boardnum = (string)boardId;
sql += "DELETE Board WHERE board_id =" + boardnum + "\n";
}
result = db.ExecuteSQL(sql);
db.Dispose();
return(result);
}
// order에 따라 정렬한 데이터 가져오는 함수
public DataTable selectAll(String order)
{
db = new CDatabase();
DataTable table = new DataTable();
string sql = "SELECT * FROM Board Order BY " + order + ";";
SqlDataReader reader = db.GetQueryResult(sql);
table.Load(reader);
db.Dispose();
return(table);
}
// 전체 board 데이터 가져오는 함수
public DataTable selectAll()
{
db = new CDatabase();
DataTable table = new DataTable();
string sql = "SELECT * FROM Board Order BY board_date DESC, board_id DESC";
SqlDataReader reader = db.GetQueryResult(sql);
table.Load(reader);
db.Dispose();
return(table);
}
// board 수정해주는 함수
public Boolean Update(String boardTitle, String boardWriter, String boardContent, String boardId)
{
CDatabase _db = new CDatabase();
string sql = "";
sql = "UPDATE Board SET board_title='" + boardTitle + "',board_date = CAST( GETDATE() AS DATE), board_content = '" + boardContent + "' WHERE board_id = " + boardId;
Boolean result = _db.ExecuteSQL(sql);
_db.Dispose();
return(result);
}
// board 삽입해주는 함수
public Boolean Insert(String boardTitle, String boardWriter, String boardContent, String boardPw)
{
CDatabase db = new CDatabase();
string sql = "";
sql = "INSERT INTO Board(board_title,board_writer,board_date,board_content,board_pw)";
sql += "VALUES ('" + boardTitle + "','" + boardWriter + "',CAST( GETDATE() AS DATE),'" + boardContent + "','" + boardPw + "')";
Boolean result = db.ExecuteSQL(sql);
db.Dispose();
return(result);
}
// 전체 검색해주는 쿼리문
public DataTable SelectSum(String all)
{
db = new CDatabase();
DataTable table = new DataTable();
string sql = "SELECT * FROM Board WHERE board_title LIKE '%" + all + "%'"
+ "UNION SELECT * FROM Board WHERE board_content LIKE '%" + all + "%'"
+ "UNION SELECT * FROM Board WHERE board_writer LIKE '%" + all + "%';";
SqlDataReader reader = db.GetQueryResult(sql);
table.Load(reader);
db.Dispose();
return(table);
}
// boardId에 따라 데이터 가져오는 함수
public Boards Select(String boardId)
{
db = new CDatabase();
Boards board = new Boards();
string sql = "SELECT * FROM Board WHERE board_id =" + boardId + ";";
SqlDataReader reader = db.GetQueryResult(sql);
while (reader.Read())
{
board.setBoardId(reader.GetInt32(0));
board.setBoardTitle(reader.GetString(1));
board.setBoardWriter(reader.GetString(2));
board.setBoardDate(reader.GetDateTime(3));
board.setBoardContent(reader.GetString(4));
board.setBoardPw(reader.GetString(5));
}
db.Dispose();
return(board);
}
