/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package koerapakett; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.sql.*; /** * * @author turing */ public class koerteloetelu extends HttpServlet { /** * Processes requests for both HTTP GET and POST methods. * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); try { out.println(" "); out.println(""); out.println(""); out.println("Koerte loetelu"); out.println(""); out.println(""); out.println("

Koerte andmed

"); Connection cn=DriverManager.getConnection( "jdbc:derby://localhost:1527/sample", "app", "app"); Statement st=cn.createStatement(); ResultSet rs=st.executeQuery("SELECT koeranimi, synniaasta FROM koerad"); out.println(""); while(rs.next()){ out.println(""); } out.println("
"); out.println(rs.getString("koeranimi")+""+rs.getInt("synniaasta")+ "
"); cn.close(); out.println(""); out.println(""); }catch(Exception ex){ ex.printStackTrace(out); } finally { out.close(); } } // /** * Handles the HTTP GET method. * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Handles the HTTP POST method. * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Returns a short description of the servlet. * @return a String containing servlet description */ @Override public String getServletInfo() { return "Short description"; }// }