JDBC JDBC 테스트 페이지

황제낙엽 2007.02.22 11:06 조회 수 : 66 추천:226

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>

이 게시물을
목록
쓰기 태그