package com.emprogria; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Timestamp; import java.util.logging.Level; import java.util.logging.Logger; import javax.annotation.Resource; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.sql.DataSource; public class ListAll extends HttpServlet { @Resource(name = "CDRInfo") private DataSource cDRInfo; /** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> 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.setCharacterEncoding("Big5"); response.setContentType("text/plain;charset=Big5"); PrintWriter out = response.getWriter(); try { try { Connection myConnection = cDRInfo.getConnection(); Statement myStatement = myConnection.createStatement(); ResultSet myResultSet = myStatement.executeQuery("SELECT * FROM CDR_Info ORDER BY File_Name, Record_Number"); while (myResultSet.next()) { String fine_name = myResultSet.getString("file_name"); int record_number = myResultSet.getInt("record_number"); String record_data = myResultSet.getString("record_data"); Timestamp entry_time = myResultSet.getTimestamp("entry_time"); out.println(fine_name + "\t" + String.valueOf(record_number) + "\t" + record_data + "\t" + entry_time.toString()); } myConnection.close(); } catch (SQLException ex) { Logger.getLogger(ListAll.class.getName()).log(Level.SEVERE, null, ex); } } finally { out.close(); } } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** * Handles the HTTP <code>GET</code> 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 <code>POST</code> 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 "List All"; }// </editor-fold> }