import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; public class DatabaseTest1 extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException{ response.setContentType("text/html; charset=Shift_JIS"); PrintWriter out = response.getWriter(); out.println(""); out.println("
"); out.println("");
Connection conn = null;
String url = "jdbc:mysql://localhost/jdbctestdb";
String user = "testuser";
String password = "testpass";
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
out.println("ドライバのロードに成功しました
");
conn = DriverManager.getConnection(url, user, password);
out.println("データベース接続に成功しました
");
}catch (ClassNotFoundException e){
out.println("ClassNotFoundException:" + e.getMessage());
}catch (SQLException e){
out.println("SQLException:" + e.getMessage());
}catch (Exception e){
out.println("Exception:" + e.getMessage());
}finally{
try{
if (conn != null){
conn.close();
out.println("データベース切断に成功しました");
}else{
out.println("コネクションがありません");
}
}catch (SQLException e){
out.println("SQLException:" + e.getMessage());
}
}
out.println("