| sitelink1 | |
|---|---|
| sitelink2 | |
| sitelink3 | |
| sitelink4 | |
| sitelink5 | |
| sitelink6 |
<%@ page language="java" import="java.util.*, java.sql.*" session="true" contentType="text/html;charset=UTF-8" %>
<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>
<%
/**
mysql용 JDBC 드라이버를 classpath 에 우선 추가하세요.
jdbcUrl 의 chat 를 해당 dbname으로 변경하세요.
dbUser, dbPass 도 마찬가지로 설정하세요.
**/
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String driverClassName = "com.mysql.jdbc.Driver";
String dbName = "jpetstore";
String dbUser = "jpetstore";
String dbPass = "jpetstore";
String jdbcUrl = "jdbc:mysql://localhost:3306/"+dbName+"?useUnicode=true&characterEncoding=UTF8";
try {
Class.forName(driverClassName);
} 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>
