<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%! Connection con=null; %>
<%! Statement st= null; %>
<%! ResultSet rs= null; %>


<%
    try
    {
       Class.forName("com.mysql.jdbc.Driver").newInstance();
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbswcorp?user=root&password=");
        st = con.createStatement();
        rs = st.executeQuery("select * from usermaster");

         out.println("<table border=1>");

         out.println("<tr bgcolor='skyblue'>");
            out.println( "<td>User ID</td>");
            out.println( "<td>Name </td> ");
            out.println( "<td>Password</td> ");
            out.println( "<td>User Level</td> ");
            out.println( "<td>Status</td>  ");
         out.println("</tr>");

         while( rs.next() ){
                 out.println("<tr>");

                        out.println( "<td>" + rs.getString("userid") + " </td>");
                        out.println( "<td>" + rs.getString("username") + " </td> ");
                        out.println( "<td>" + rs.getString("password") + " </td> ");
                        out.println( "<td>" + rs.getString("userlevel") + " </td> ");
                        out.println( "<td>" + rs.getString("status") + " </td>  ");

                  out.println("</tr>");
          }
          out.println("</table>");

        rs.close();
        st.close();
        con.close();

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