|
게시판 리스트 검색 기능을 넣었는데,
select랑 검색어 파라미터값은 잘 넘어오는데 쿼리문 세팅이 안되는것 같아요 ㅠㅠ
공백으로 실행하면 검색된 리스트가 잘 출력이 되는데, 검색어만 입력하면 리스트에 아무것도 안뜨네요. 콘솔창에 오류는 없구요.
혹시 DAO 소스에 if문 사용이 잘못된건지 봐주세요~~~! ( _ _ )
<list>
<공백으로 찾기 눌렀을 때>
<검색어 입력했을 때 : list 출력 안됨>
======================================= command 소스 =======================================
package guestBookCommand;
import java.io.UnsupportedEncodingException;
import java.util.ArrayList;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import guestBookServlet.guestBookDAO;
import guestBookServlet.guestBookDTO;
public class guestBookSearchCommand implements guestBookCommand {
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) {
try {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=UTF-8");
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String searchSelect = request.getParameter("searchSelect");
String searchText = request.getParameter("searchText");
//if (searchSelect.equals("searchName")) {
//searchSelect = "name";
//} else {
//searchSelect = "title";
//}
//
guestBookDAO dao = new guestBookDAO();
ArrayList<guestBookDTO> list = dao.search(searchSelect, searchText);
request.setAttribute("list", list);
}
}
======================================= DAO 소스 =======================================
//게시글 찾기 (선택된 select가 작성자(searchName)인지 제목(searchTitle)인지, 검색어)
public ArrayList<guestBookDTO> search(String searchSelect, String searchText) {
ArrayList<guestBookDTO> list = new ArrayList<guestBookDTO>();
pstmt = null;
rs = null;
try {
dbconn();
String sql = "select no, name, title, reg_date, readCnt from guestbook where ? like ?";
pstmt = conn.prepareStatement(sql);
if (searchSelect.equals("searchName")) {
pstmt.setString(1, "name");
} else if (searchSelect.equals("searchTitle")){
pstmt.setString(1, "title");
}
pstmt.setString(2, "%" + searchText + "%");
rs = pstmt.executeQuery();
while (rs.next()) {
int no = rs.getInt("no");
String name = rs.getString("name");
String title = rs.getString("title");
String reg_date = rs.getString("reg_date");
int readCnt = rs.getInt("readCnt");
guestBookDTO dto = new guestBookDTO();
dto.setNo(no);
dto.setName(name);
dto.setTitle(title);
dto.setReg_date(reg_date.substring(0, 10));
dto.setReadCnt(readCnt);
list.add(dto);
}
System.out.println("게시글 찾기 성공!");
} catch (Exception e) {
System.out.println("게시글 찾기 실패!");
e.printStackTrace();
} finally {
try {
if (rs != null) rs.close();
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
===================================== JSP 소스 ==============================================
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>게시판 리스트</title>
<link rel="stylesheet" href="./resources/style.css">
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=UTF-8");
%>
<h2>게시판</h2>
<form action="search.do" method="get">
<tr>
<td>
<select name="searchSelect" style="height: 26px;">
<option value="searchName">작성자</option>
<option value="searchTitle">제목</option>
</select>
</td>
<td colspan="3"><input type="text" name="searchText" placeholder="검색어를 입력하세요." style="height: 20px; width: 328px;"></td>
<td><input type="submit" value="찾기" class="btn"></td>
</tr>
<tr>
<th style="background: gray; color: white;">번호</th>
<th style="background: gray; color: white;">작성자</th>
<th style="background: gray; color: white;">제목</th>
<th style="background: gray; color: white;">작성일</th>
<th style="background: gray; color: white;">조회수</th>
</tr>
<c:forEach var="dto" items="${list}" >
<tr>
<td align="center">${dto.no}</td>
<td align="center">${dto.name}</td>
<td><a href="readMore.do?no=${dto.no}"> ${dto.title} </a></td>
<td align="center">${dto.reg_date}</td>
<td align="center">${dto.readCnt}</td>
</tr>
</c:forEach>
</table>
</form>
<p><input type="button" value="글쓰기" onclick="location.href='write.do'" class="btn" class="write" style="margin-left: 425px;">
</body>
</html>
| 
등록안내
jsp 소스를 보지 못하여 확답은 드릴 수 없지만 select box의 이름과 값이 제대로 설정되어 컨트롤러까지 넘어오는지 로그를 찍어보시면 좋을 것 같습니다.
@별빛바라기 DAO 들어오자마자 값들 잘 찍히고, 쿼리문에 직접 넣어서 테스트 해보니 잘 됩니다 ㅜ_ㅜ,,
답변주셔서 감사해요!!!