Untitled


<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>

<%! Connection con=null; %>
<%! Statement st= null; %>
<%! ResultSet rs= null; %>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
<%
    try
    {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbuitmjasin?user=root&password=");

        st = con.createStatement();
        rs = st.executeQuery("select * from usermaster");
        out.println("<table border=1>");

             out.println("<tr bgcolor='yellow'>");
                    out.println( "<td> User ID </td>");
                    out.println( "<td> Name </td>");
                    out.println( "<td> Address </td>");
                    out.println( "<td> Tel No </td>");
                    out.println( "<td> Email </td>");
             out.println("</tr>");

        while(rs.next()) {
             out.println("<tr>");
                    out.println( "<td><a href='DataEntry?uid=" + rs.getString("userid").toString() + "'>" + rs.getString("userid") + "</a></td>");
                    out.println( "<td>" + rs.getString("username") + "</td>");
                    out.println( "<td>" + rs.getString("address") + "</td>");
                    out.println( "<td>" + rs.getString("telno") + "</td>");
                    out.println( "<td>" + rs.getString("email") + "</td>");
             out.println("</tr>");
        }
        out.println("</table>");
        rs.close();
        st.close();
        con.close();

    }catch(SQLException e)
    {
        e.printStackTrace();
    }
%>

    </body>
</html>