import java.util.List;
import java.util.ArrayList;
import java.io.*;
import java.sql.*;
import javax.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import jp.ac.wakhok.library.*;

public class BookSearchServlet extends HttpServlet {

	private String jspFile = "/list.jsp";
	private ServletContext context;

	public void init() throws ServletException {
		context = getServletContext();
	}

	public void doGet(HttpServletRequest request,
	                  HttpServletResponse response)
	                  throws ServletException, IOException {
		doIt(request, response);
	}

	public void doPost(HttpServletRequest request,
	                   HttpServletResponse response)
	                   throws ServletException, IOException {
		doIt(request, response);
	}

	private void doIt(HttpServletRequest request,
	                  HttpServletResponse response)
	                  throws ServletException, IOException {
		request.setCharacterEncoding("Shift_JIS");

		String ndc           = request.getParameter("ndc");
		String tyosya_hyouji = request.getParameter("tyosya_hyouji");
		String id            = request.getParameter("id");
		String title         = request.getParameter("title");
		String author        = request.getParameter("author");
		String publisher     = request.getParameter("publisher");
		List list =
			search(ndc, tyosya_hyouji, id, title, author, publisher);

		HttpSession session = request.getSession();
		session.setAttribute("bookList", list);

		context.getRequestDispatcher(jspFile)
		       .forward(request, response);
	}

	private List search(String ndc, String tyosya_hyouji,
						String id, String title,
						String author, String publisher) {
		List list = new ArrayList();
		try {
			Class.forName("org.hsqldb.jdbcDriver");
			String url = "jdbc:hsqldb:hsql://localhost";
			Connection con = DriverManager.getConnection(url, "sa", "");

			String selectStatement =
				"select * " +
				"from books where ndc           like ? " +
				             "and tyosya_hyouji like ? " +
				             "and id            like ? " +
				             "and title         like ? " +
				             "and author        like ? " +
				             "and publisher     like ? ";
			PreparedStatement prepStmt =
				con.prepareStatement(selectStatement);
			prepStmt.setString(1, appendPercent(ndc));
			prepStmt.setString(2, appendPercent(tyosya_hyouji));
			prepStmt.setString(3, appendPercent(id));
			prepStmt.setString(4, appendPercent(title));
			prepStmt.setString(5, appendPercent(author));
			prepStmt.setString(6, appendPercent(publisher));

			ResultSet rs = prepStmt.executeQuery();
			while (rs.next()) {
				BookData book = new BookData();
				book.setNdc(rs.getString("ndc"));
				book.setTyosya_hyouji(rs.getString("tyosya_hyouji"));
				book.setId(rs.getString("id"));
				book.setTitle(rs.getString("title"));
				book.setAuthor(rs.getString("author"));
				book.setPublisher(rs.getString("publisher"));
				list.add(book);
			}
			rs.close();
			prepStmt.close();
			con.close();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return list;
	}

	private String appendPercent(String from) {
		StringBuffer to = new StringBuffer();
		to.append("%");
		to.append(from);
		to.append("%");

		return new String(to);
	}
}