0

I have retrieved information from a database through a servlet and I am able to print it using the same servlet (on web page using tomcat). But in order to format it nicely (perhaps like a table), I will probably have to use html. Can someone please help me on how to do this? Perhaps pass the values to a html page and display it like that? Thanks :)

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class PersonalInfoOutput extends HttpServlet {

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            response.setContentType("text/html;charset=UTF-8");
            PrintWriter out = response.getWriter();

            String firstname = request.getParameter("firstname");
            String lastname = request.getParameter("lastname");
            String address = request.getParameter("address");
            boolean st = false;
            try { 
                Class.forName("com.mysql.jdbc.Driver").newInstance(); 
                Connection con =    DriverManager.getConnection("jdbc:mysql://localhost:3306/payroll_system", "root", ""); 
                PreparedStatement ps = con.prepareStatement("select FirstName, LastName, Address from payroll_system.employee_info where employeeID = 1234"); 
                ResultSet rs = ps.executeQuery(); 
                st = rs.next(); 
                if(st){

                out.println(rs.getString("FirstName"));
                out.println(rs.getString("LastName"));
                out.println(rs.getString("Address"));

                }
             }catch(Exception e)
              {
                  e.printStackTrace();
              }
            out.close();
    }
}
BalusC
  • 1,082,665
  • 372
  • 3,610
  • 3,555
Programmer
  • 1,266
  • 5
  • 23
  • 44

0 Answers0