#08. [Side Project 1] JSP 로그인, 게시판 만들기 (8) :: 글 검색 기능

 

■ BbsDao.java (getBbsList())

public List<BbsDto> getBbsList(String choice, String searchWord) {
        
        String sql = " SELECT SEQ, ID, REF, STEP, DEPTH, "
                        + " TITLE, CONTENT, WDATE, "
                        + " DEL, READCOUNT "
                        + " FROM BBS ";                    
                        
        String sqlWord = "";
        if(choice.equals("title")) {
            sqlWord = " WHERE TITLE LIKE '%" + searchWord.trim() + "%' AND DEL=0 ";
        }else if(choice.equals("writer")) {
            sqlWord = " WHERE ID='" + searchWord.trim() + "'"; 
        }else if(choice.equals("content")) {
            sqlWord = " WHERE CONTENT LIKE '%" + searchWord.trim() + "%' ";
        } 
        sql = sql + sqlWord;
                
        sql += " ORDER BY REF DESC, STEP ASC ";
        
        Connection conn = null;
        PreparedStatement psmt = null;
        ResultSet rs = null;
        
        List<BbsDto> list = new ArrayList<BbsDto>();
        
        try {
            conn = DBConnection.getConnection();
            System.out.println("1/6 getBbsList success");
            
            psmt = conn.prepareStatement(sql);
            System.out.println("2/6 getBbsList success");
            
            rs = psmt.executeQuery();
            System.out.println("3/6 getBbsList success");
            
            while(rs.next()) {
                int i = 1;
                BbsDto dto = new BbsDto(rs.getInt(i++), 
                                        rs.getString(i++), 
                                        rs.getInt(i++), 
                                        rs.getInt(i++), 
                                        rs.getInt(i++), 
                                        rs.getString(i++), 
                                        rs.getString(i++), 
                                        rs.getString(i++), 
                                        rs.getInt(i++), 
                                        rs.getInt(i++));                
                list.add(dto);
            }
            System.out.println("4/6 getBbsList success");
            
        } catch (Exception e) {            
            e.printStackTrace();
        } finally {
            DBClose.close(psmt, conn, rs);            
        }
        return list;
    }
    

 

 

 

■ BbsDao.jsp (getAllBbs())

public int getAllBbs(String choice, String searchWord) {
        String sql = " SELECT COUNT(*) FROM BBS ";
        
        String sqlWord = "";
        if(choice.equals("title")) {
            sqlWord = " WHERE TITLE LIKE '%" + searchWord.trim() + "%' ";
        }else if(choice.equals("writer") && !searchWord.equals("")) {
            sqlWord = " WHERE ID='" + searchWord.trim() + "'";
        }else if(choice.equals("content")) {
            sqlWord = " WHERE CONTENT LIKE '%" + searchWord.trim() + "%' ";
        }
        sql += sqlWord;
        
        Connection conn = null;
        PreparedStatement psmt = null;
        ResultSet rs = null;
        int len = 0;
                
        try {
            conn = DBConnection.getConnection();
            psmt = conn.prepareStatement(sql);
            rs = psmt.executeQuery();
            if(rs.next()) {
                len = rs.getInt(1);
            }            
        } catch (Exception e) {
            System.out.println("getAllBbs fail");
            e.printStackTrace();
        } finally {
            DBClose.close(psmt, conn, rs);            
        }
        return len;        
    }

 

■ bbslist.jsp

<select id="choice"> <!-- 높이:20 중간맞춤 -->
    <option value="sel">선택</option>
    <option value="title">제목</option>
    <option value="writer">작성자</option>
    <option value="content">내용</option>
</select>
 
<input type="text" id="search" value="<%=searchWord %>">
 
<button onclick="searchBbs()">검색</button>
 
</div>
 
<script type="text/javascript">
function searchBbs() {
    var choice = document.getElementById("choice").value;
    var word = document.getElementById("search").value;
//    alert(choice);
//    alert(word);
 
    /* if(word == ""){
        document.getElementById("search").value = "";
        document.getElementById("choice").value = 'sel';
    } */
    
    location.href = "bbslist.jsp?searchWord=" + word + "&choice=" + choice;
}
 

function searchBbs() {
	var choice = document.getElementById("choice").value;
	var word = document.getElementById("search").value;
//	alert(choice);
//	alert(word);

	/* if(word == ""){
		document.getElementById("search").value = "";
		document.getElementById("choice").value = 'sel';
	} */
	
	location.href = "bbslist.jsp?searchWord=" + word + "&choice=" + choice;
}