Mysql JDBC test Mysql
2009.12.04 12:22 Edit
<%@ page language="java" import="java.util.*, java.sql.*" session="true" contentType="text/html;charset=EUC_KR" %>
<HTML>
<HEAD>
<TITLE> MySQL JDBC TEST PAGE </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<h1>MySQL JDBC Test page</h1>
<br>
<table border=1 cellpadding=0 cellspacing=0>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String jdbcUrl ="jdbc:mysql://localhost/DB명?useUnicode=true&characterEncoding=EUC_KR";
String dbUser = "nuguna";
String dbPass = "snrnsk";
try {
Class.forName("com.mysql.jdbc.Driver");
} catch(ClassNotFoundException e) {
System.out.println("mysql driver loading error!");
out.println("mysql driver loading error!");
out.println(e.toString());
return;
}
try {
con = DriverManager.getConnection(jdbcUrl, dbUser, dbPass);
} catch(SQLException e) {
System.out.println("mysql connection error!");
out.println("mysql connection error!");
out.println(e.toString());
return;
}
try {
stmt = con.createStatement();
String query = "show status";
rs = stmt.executeQuery(query);
while(rs.next()) {
out.println("<tr>");
out.println("<td>" + rs.getString(1) + "</td>");
out.println("<td>" + rs.getString(2) + "</td>");
out.println("</tr>");
}
} catch(SQLException e ) {
out.println(e.toString());
}
try {
if(rs !=null) rs.close();
if(stmt != null) stmt.close();
if(con != null) con.close();
} catch(SQLException e) {
out.println(e.toString());
}
%>
</table>
</BODY>
</HTML>
