Untitled

package good.not.mylife;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * 멤버 리스트를 실행하는 서블릿
 */
@WebServlet("/MemberListServer")
// TODO: @WebServlet("/list")
public class MemberListServer extends HttpServlet {
	private static final long serialVersionUID = 1L;

	/**
	 * 이것은 doGet이다.
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;

		try {
			DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost/studydb?useSSL=false&serverTimezone=UTC",
	                "study",
	                "study");
			stmt=conn.createStatement();
			rs=stmt.executeQuery("SELECT BookID, Title, Author, PublisherID, ISBN from books ORDER BY BookID ASC");

			response.setContentType("text/html; charset=UTF-8");
			PrintWriter out = response.getWriter();
			out.println("<html>");
			out.println("<head>");
			out.println("<title>");
			out.println("책목록");
			out.println("</title>");
			out.println("</head>");
			out.println("<body>");
			out.println("<h1>책 목록</h1>");
	        while (rs.next())
	        {
	            out.println(
	            		rs.getInt("BookID")+",\t"
	            		+rs.getString("Title")+",\t"
	            		+rs.getString("Author")+",\t"
	            		+rs.getString("PublisherID")+",\t"
	            		+rs.getString("ISBN")+"\t" +"<br>"
	            );
	        }
	        out.println("</body>");
	        out.println("</html>");
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		} finally {
			try { if (null!=rs) rs.close(); } catch (Exception e) {}
	        try { if (null!=stmt) stmt.close(); } catch (Exception e) {}
	        try { if (null!=conn) conn.close(); } catch (Exception e) {}
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}