接続文字列の確認をしたかったのだ
package test;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class TestXMLload extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse
response)
throws IOException, ServletException{
String F1str = "";
String F2str = "";
try{
Class.forName("org.gjt.mm.mysql.Driver");
Connection db =
DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=mysqladmin&useUnicode=true&characterEncoding=Shift_JIS");
db.setReadOnly(true);
Statement objSql = db.createStatement();
ResultSet rs = objSql.executeQuery("SELECT * FROM tab1");
while(rs.next()){
F1str = rs.getString("F1");
F2str = rs.getString("F2");
}
rs.close();
objSql.close();
db.close();
}
catch(Exception e){
e.printStackTrace();
}
String naiyo = F1str + ":" + F2str;
String htmlstr = "<html><head><meta http-equiv='content-type'
content='text/html; charset=UTF-8'><title>testpage</title></head><body>" +
naiyo + "</body></html>";
response.setCharacterEncoding("UTF-8");
Writer rw = response.getWriter();
rw.write(htmlstr);
rw.close();
}
}
0 件のコメント:
コメントを投稿