<%@ page language="java" contentType="text/html; charset=euc-kr" pageEncoding="euc-kr"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<html>
<head>
<title>MySQL select example</title>
</head>
<body>
<%
String DB_URL = "jdbc:mysql://localhost:3306/database_name?useUnicode=true&characterEncoding=euc_kr";
String DB_USER = "root";
String DB_PASSWORD= "pwd";
Connection conn;
Statement stmt;
ResultSet rs = null;
String query = "select * from zipcode";
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
stmt = conn.createStatement();
rs = stmt.executeQuery(query);
out.print("result: </br>");
String s;
while (rs.next())
{
out.println(rs.getString(1));
out.println(" ");
s = rs.getString(2);
s = new String(s.getBytes("8859_1"),"euc-kr");
out.println(s);
s = rs.getString(3);
s = new String(s.getBytes("8859_1"),"euc-kr");
out.println(s);
s = rs.getString(4);
s = new String(s.getBytes("8859_1"),"euc-kr");
out.println(s);
out.println("<br>");
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
out.print("Exception Error...");
out.print(e.toString());
}
finally {
}
%>
</body>
</html>
'DB & SQL & web' 카테고리의 다른 글
| MySQL - 유니코드 (0) | 2012.09.26 |
|---|---|
| MySQL - 복사&보관&복원 (0) | 2012.09.01 |
| 아파치 톰캣 (Apache Tomcat) 7 // 수동 설치 ( install 사용 안함 ) (0) | 2011.09.28 |
| MySQL 5.5.13 & Workbench 5.2.34 수동 설치 (0) | 2010.08.23 |
| HTML 스타일시트 한글 입력 시작 또는 비활성화 하기 (0) | 2009.08.19 |