【システム構成】
・WindowsXP professional SP2
・InternetExplorer6
・MySQL4.1.12a
・Tomcat5.0.28
・Java1.4.2_08
【DB構成】
ユーザ名：abc
パスワード：xyz
DB名：mojitest (キャラクターセット:UTF8)
テーブル名：mojitest(DDLは以下の通り)
CREATE TABLE mojitest (
message text
) ENGINE=InnoDB;
【Webアプリ構成】※□：フォルダ、●：ファイル
□%CATALINA_HOME%
└□webapps
└□jsptest
├●mojitest.jsp
└□WEB-INF
├●web.xml
└□classes
├●EncodingFilter.java
└●EncodingFilter.class ←EncodingFilter.javaをコンパイルして作成
【ファイルの中身】
●mojitest.jsp
<%@ page language="java" contentType="text/html; charset=Windows-31J" pageEncoding="Windows-31J"%>
<%@ page import="java.sql.*" %>
<HTML>
<HEAD><TITLE>文字登録テスト</TITLE></HEAD>
<BODY>
<%
// 変数宣言
String resultMessage = "";
String text = request.getParameter("text");
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql:///mojitest?useUnicode=true&characterEncoding=UTF-8","abc","xyz");
// フォームからのデータがあればデータ登録
if (text != null) {
if (!text.equals("")) {
con.createStatement().executeUpdate("INSERT INTO mojitest ( message ) VALUES ( '" + text + "' ) ");
resultMessage = "送信データ" + text + "をアップデートしました.";
}
}
// DBからのデータ取得処理
ResultSet rs = con.createStatement().executeQuery("SELECT * FROM mojitest");
%>
DBデータ<BR>
<%
while (rs.next()) {
%>
<%=rs.getString("message")%><BR>
<%
}
%>
<BR>
<FORM NAME="testForm" METHOD="post" ACTION="/jsptest/mojitest.jsp">
<TEXTAREA NAME="text"></TEXTAREA>
<INPUT TYPE="submit" VALUE="送信">
</FORM>
<%
} catch (Exception e) {
String errMessage = "";
StackTraceElement[] es = e.getStackTrace();
if (es != null) {
int i = 1;
errMessage = es[i].toString();
while (i < es.length) {
errMessage = errMessage + "<BR> at " + es[i].toString();
i++;
}
}
resultMessage = "エラーが発生しました.<BR>" + errMessage;
} finally {
if (con != null) {
con.close();
}
}
%>
<%=resultMessage%><BR><BR>
</BODY>
</HTML>
●EncodingFilter.java
import java.io.*;
import javax.servlet.*;
public class EncodingFilter implements Filter {
protected String encoding = null;
protected FilterConfig filterConfig = null;
protected boolean ignore = true;
public void destroy() {
this.encoding = null;
this.filterConfig = null;
}
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException {
if (ignore || (request.getCharacterEncoding() == null)) {
String encoding = selectEncoding(request);
if (encoding != null)
request.setCharacterEncoding(encoding);
}
chain.doFilter(request, response);
}
public void init(FilterConfig filterConfig) throws ServletException {
this.filterConfig = filterConfig;
this.encoding = filterConfig.getInitParameter("encoding");
String value = filterConfig.getInitParameter("ignore");
if (value == null)
this.ignore = true;
else if (value.equalsIgnoreCase("true"))
this.ignore = true;
else if (value.equalsIgnoreCase("yes"))
this.ignore = true;
else
this.ignore = false;
}
protected String selectEncoding(ServletRequest request) {
return (this.encoding);
}
}
●web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<!-- Example filter to set character encoding on each request -->
<filter>
<filter-name>Set Character Encoding</filter-name>
<filter-class>EncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>Windows-31J</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>Set Character Encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
|
