Untitled

traineeReport.jsp
<%--
    Document   : traineeReport
    Created on : Mar 14, 2017, 4:36:19 PM
    Author     : Lenovo
--%>

<%--
    Document   : addtrainee
    Created on : Mar 14, 2017, 4:12:58 PM
    Author     : Lenovo
--%>
<%@page import = "java.sql.Connection"%>
<%@page import = "java.sql.DriverManager"%>
<%@page import = "java.sql.Statement"%>
<%@page import = "java.sql.ResultSet"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>LIST OF TRAINEE</title>
        <h1>LIST OF TRAINEE</h1>
    </head>
    <body>
       <%
           Connection conn = null;
           try
           {
               Class.forName("org.gjt.mm.mysql.Driver");
               String url = "jdbc:mysql://localhost/traineemanagementsystem";
               String user = "root";
               String pwd = "";
               conn = DriverManager.getConnection(url,user,pwd);
               Statement s = conn.createStatement();

               String query = "SELECT * FROM trainee";
            ResultSet res = s.executeQuery(query);

            while(res.next())
            {
                int empID = res.getInt("employeeID");
                String name = res.getString("traineeNAME");
                String city = res.getString("traineeCITY");
                out.println(empID+" "+name+" "+city+"<br>");
            }
             if(conn!=null)
                 conn.close();
           }
              catch (Exception e){response.sendError(HttpServletResponse.SC_NOT_FOUND);}

              finally
              {
                 if(null != conn)
                 {conn.close();}
              }
       %>

<a href=traineeForm.html>Add New Trainee</a>
</body>
</html>