接続試験用JSP - Knowlege Database

接続試験用JSPファイル†

使用方法†

1. 所定位置に配置
2. 「DataSource ds」の「java:comp/env/jdbc/mysql」を定期性値に変更

<%@ page contentType="text/html;charset=UTF-8"%>
<%@ page import="javax.naming.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mysql");
Connection con = ds.getConnection();
Statement stmt = con.createStatement();
ResultSet rset = stmt.executeQuery ("select user()");
%>
  <HTML>
    <HEAD>
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
    </HEAD>
    <BODY>
      <TABLE border=1>
      <%
        while (rset.next ()) {
          out.print("<tr>");
          out.print("<td>" + rset.getString(1) + "</td>");
          out.print("</tr>");
        }
      %>
      </TABLE>
    </BODY>
  </HTML>