import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class mysql extends HttpServlet{ public void doGet (HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{ Connection mydb = null; PrintWriter out; response.setContentType("text/html; charset=EUC_JP"); out = response.getWriter(); out.println("MySQL Servlet テスト(Amber)"); out.println("

select * from aptable の実行結果(Servlet利用);

"); try{ Class.forName("org.gjt.mm.mysql.Driver"); mydb = DriverManager.getConnection("jdbc:mysql://localhost/test","mysql","mysql"); Statement sql = mydb.createStatement(); ResultSet myrs = sql.executeQuery("select * from aptable"); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); while(myrs.next()){ out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); } out.println(""); out.println(""); sql.close(); mydb.close(); out.close(); } catch(SQLException e) { out.println("DBサーバ接続エラー ：" + e.toString()); out.close(); } catch(Exception e){ e.printStackTrace(); } finally{ try{ mydb.close(); } catch(Exception e){} } } }
apnameapversionapcommentapcount
" + myrs.getString("apname") + "" + myrs.getString("apversion") + "" + myrs.getString("apcomment") + "" + myrs.getString("apcount") + "