JSP から MySQL

<%@ page
    language="java"
    import="java.io.*"
    import="java.text.*"
    import="java.util.*"
    import="java.text.SimpleDateFormat"
    import="com.mysql.jdbc.*"
    import="java.sql.DriverManager"
    import="java.sql.ResultSet"
    import="java.sql.SQLException"
    contentType="text/html;charset=utf-8" %>
<%!
 
ServletContext app = null;
HttpServletRequest req = null;
HttpServletResponse res = null;
 
// ***************************
// ログ出力
// ***************************
public void outlog( String message ) {
 
    app.log( String.format("<<JSP>> %s", message )  );
 
}
 
// ***************************
// ヘッダー
// ***************************
public void header( ) {
 
    res.addHeader("Content-Type","text/html; charset=utf-8");
    res.addHeader("Expires","Thu, 19 Nov 1981 08:52:00 GMT");
    res.addHeader("Cache-Control","text/html; no-store, no-cache, must-revalidate, post-check=0, pre-check=0");
    res.addHeader("Pragma","no-cache");
 
}
 
// ***************************
// HTML TD
// ***************************
public void td( StringBuffer sb, String target ) {
 
    sb.append("<td>");
    sb.append( target );
    sb.append("</td>");
 
}
 
// ***************************
// forms : 値取得
// ***************************
public String forms( String fieldName ) {
 
    String result;
    result = req.getParameter( fieldName );
    if ( result == null ) {
        result = "";
    }
    return result;
 
}
 
%>
<%
// *********************************************************
// 入力値の表示
// GET で setCharacterEncoding を有効にするには
// sever.xml => Connector で useBodyEncodingForURI="true"
// *********************************************************
request.setCharacterEncoding("utf-8");  // 入力値のエンコーディング
app = application;
req = request;
res = response;
header();
 
String checkMessage = "";
 
// ***************************
// 入力一覧
// ***************************
StringBuffer sb = new StringBuffer();
for( String name : Collections.list(request.getParameterNames()) ){
    sb.append("<tr>");
    td( sb, name );
    td( sb, forms( name ) );
    sb.append("</tr>");
}
 
 
if ( forms("send1").equals("送信1") ) {
 
    checkMessage += " >> 送信1 がクリックされました";
 
}
if ( forms("send2").equals("送信2") ) {
 
    checkMessage += " >>送信2 がクリックされました";
 
}
 
%>
<!DOCTYPE html>
<html>
<head>
<style>
table {
    margin-top: 20px;
    margin-bottom: 20px;
    border-collapse: collapse;
    border:1px solid #ccc;
}
td {
    padding: 5px;
    border: solid #ccc 1px;
}
</style>
</head>
<body>
<h4><%= checkMessage %></h4>
<div><a href="<%= request.getRequestURI() %>">GET 再読み込み</a></div>
 
<h4>フォーム : GET</h4>
<form method="get">
    <input type="text" name="field_get" value="<%= forms("field_get") %>">
    <input type="submit" name="send1" value="送信1">
</form>
 
<h4>フォーム : POST</h4>
<form method="post">
    <input type="text" name="field_post" value="<%= forms("field_post") %>">
    <input type="submit" name="send2" value="送信2">
</form>
 
<table>
<%= sb.toString() %>
</table>
 
<%
 
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
 
try {
    Class.forName("com.mysql.jdbc.Driver");
    // MySQL Connector/J 接続
    conn = (Connection) DriverManager.getConnection(
        "jdbc:mysql://localhost/lightbox?user=root&password="
    );
 
    stmt = (Statement) conn.createStatement();
    rs = stmt.executeQuery("select * from 社員マスタ");
 
    // select の結果の列情報の取得
    ResultSetMetaData rsmd = (ResultSetMetaData) rs.getMetaData();
 
    // 列数
    int columnCount = rsmd.getColumnCount();
 
    // 列名
    for( int i = 1; i <= columnCount; i++) {
        out.println(rsmd.getColumnName(i));
    }
    out.println("\n<br>");
 
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");
    while( rs.next() ) {
 
        for( int i = 1; i <= columnCount; i++) {
 
            if ( rsmd.getColumnTypeName(i).equals("DATETIME") ) {
                out.println( sdf.format(rs.getDate(i)) );
            }
            else {
                out.println( rs.getString(i) );
            }
 
            out.println(",");
 
        }
        out.println("\n<br>");
    }
 
    rs.close();
    stmt.close();
    conn.close();
 
} catch (SQLException ex) {
    // handle any errors
    out.println("SQLException: " + ex.getMessage());
    out.println("SQLState: " + ex.getSQLState());
    out.println("VendorError: " + ex.getErrorCode());
}
 
%>
 
</body>
</html>