jsp mysql 에서 한글로 입력받는 방법..

http://sapius.dnip.net/~sapius/zpboard/list.jsp

이상하게 한글이 깨져서 나오네요.

아무래도 mysql 에서 불러올때 코드셋이 틀력서 그런거 같은데..

어떻게 해결해야할까요? 설명으로 나온책에는 이런 말은 없는데 ㅡ.ㅡ;;

<%@page contentType="text/html; charset=euc-kr" import="java.sql.*,java.util.*"%>

<%
/*
 * Data Base Connection to Zeropage BBS
 */
        String DB_URL = "jdbc:mysql://165.194.17.15:3306/zeropage";
        String DB_USER = "ID";
        String DB_PASSWORD = "PASS";

        try {
                Class.forName("com.mysql.jdbc.Driver");
        } catch (Exception e) {
                out.println("DB Driver eror<BR/>\n");
                e.printStackTrace();
        }

        Connection conn;
        conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);

        if (conn == null)
                out.println("Connection error<BR/>\n");

        Statement stmt;
        stmt = conn.createStatement();
        if (stmt != null) out.println("Connection SUCCESS<BR/>\n");
%>

<%
        /* get data from zeropage mysql server.  */
//      String query = "select * from open where ";
        String query = "select * from open where id>0 AND id<10";
        ResultSet result = stmt.executeQuery(query);
%>

<%
        Vector id = new Vector();
        Vector date = new Vector();
        Vector loginid = new Vector();
        Vector author = new Vector();
        Vector email = new Vector();
        Vector title = new Vector();
        Vector content = new Vector();
        Vector count = new Vector();

        while (result.next()) {
                id.add(result.getString("id"));
                date.add(result.getString("date"));
                loginid.add(result.getString("loginid"));
                author.add(result.getString("auther"));
                email.add(result.getString("email"));
                title.add(result.getString("title"));
                content.add(result.getString("content"));
                count.add(result.getString("count"));
        }
%>

<%
        out.println("<table style='border-width:1px; border-style:dotted;'>");
        out.println("<tr><td>ID</td><td>DATE</td><td>AUTHOR</td><td>EMAIL</td><td>TITLE</td><td>CONTENT</td><td>COUNT</td></tr>");
        for (int i=0; i<id.size(); i++) {
                out.println(
                                "<!--"+i+"-->\n"+
                                "<tr>\n<td>"+id.get(i)+"</td>\n"+
                                "<td>"+date.get(i)+"</td>\n"+
                                "<td>"+author.get(i)+"</td>\n"+
                                "<td>"+email.get(i)+"</td>\n"+
                                "<td>"+title.get(i)+"</td>\n"+
                                "<td>"+content.get(i)+"</td>\n"+
                                "<td>"+count.get(i)+"</td>\n</tr>"
                                );
        }
        out.println("</table>");
%>

<%
        //Connection close.
        stmt.close();
        conn.close();
%>