*接続試験用JSPファイル [#f47cee6a]
**使用方法 [#p0028ba7]
1. 所定位置に配置
2. 「DataSource ds」の「java:comp/env/jdbc/mysql」を定期性値に変更
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>