Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this license header, choose License Headers in Project Properties.
- * To change this template file, choose Tools | Templates
- * and open the template in the editor.
- */
- import com.mysql.jdbc.Connection;
- import com.mysql.jdbc.Statement;
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- /**
- *
- * @author Tbs
- */
- public class ServletLiquidacion extends HttpServlet {
- /**
- * 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.setContentType("text/html;charset=UTF-8");
- PrintWriter out = response.getWriter();
- try {
- String host = "localhost";
- String database = "BD_TP3_CA";
- Class.forName("com.mysql.jdbc.Driver");
- // connect to database
- String url = "jdbc:mysql://" + host + "/" + database;
- Connection con = (Connection) DriverManager.getConnection(url, "root", "mysql");
- String Rut = request.getParameter("rutE");
- String codA = request.getParameter("codafp");
- String codS = request.getParameter("codsalud");
- String hrex = request.getParameter("hrextras");
- String mes = request.getParameter("mes");
- String car = request.getParameter("cargas");
- String bono = request.getParameter("bono");
- if(Rut.trim().equals("") || codA.trim().equals("") || codS.trim().equals("") ||
- hrex.trim().equals("") || mes.trim().equals("")|| car.trim().equals("")|| bono.trim().equals("")){
- out.println("<HTML><BODY>");
- out.println("<h1>Datos incompletos,rellene los campos porfavor</h1> <br>");
- out.println("<a href=Liquidacion.html>Volver</a> <br>");
- out.println("</body>");
- out.println("</html>");
- }else{
- // query database using SQL
- Statement s = (Statement) con.createStatement();
- String consulta = "select * from Empleados where Rut='"+Rut+"'";
- ResultSet rs1 = s.executeQuery(consulta);
- if (rs1.next()) {
- ResultSet rs = s.executeQuery(consulta);
- while (rs.next()) {
- String rutEmpleado = rs.getString("Rut");
- String nombreEmpleado = rs.getString("Nombre");
- String apellidoEmpleado = rs.getString("Apellido");
- String sueldoEmpleado = rs.getObject("Sueldo_Base").toString();
- out.println("<table border=1><TR><TD><strong>Rut Empleado</strong></TD>");
- out.println("<TD><strong>Nombre empleado</strong></TD>");
- out.println("<TD><strong>Apellido</strong></TD>");
- out.println("<TD><strong>Sueldo Base</strong></TD>");
- out.println("<TD><strong>Nombre Afp</strong></TD>");
- out.println("<TD><strong>Porcentaje Afp</strong></TD>");
- out.println("<TD><strong>Nombre Salud</strong></TD>");
- out.println("<TD><strong>Porcentaje Salud</strong></TD></TR>");
- out.println("<TR><TD>"+ rutEmpleado +"</TD>");
- out.println("<TD>" + nombreEmpleado + "</TD>");
- out.println("<TD>" + apellidoEmpleado + "</TD>");
- out.println("<TD>" + sueldoEmpleado + "</TD></tr>");
- //out.println("<table><TR><TD>" + rutEmpleado + "</TD>");
- //out.println("<TD>" + nombreEmpleado + "</TD>");
- //out.println("<TD>" + apellidoEmpleado + "</TD>");
- //out.println("<TD>" + sueldoEmpleado + "</TD></tr>");
- }
- } else {
- out.println("No se han encontrado datos empleado ");
- }
- out.println("</table> <br> <hr>");
- out.println("<a href=index.jsp>Volver</a> <br>");
- out.println("</body>");
- out.println("</html>");
- // close database
- con.close();
- }
- } catch (Exception e) {
- out.println(e);
- }
- }
- // <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 "Short description";
- }// </editor-fold>
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement