import java.io.*;
import java.util.Enumeration;
import java.util.Date;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class vuser extends HttpServlet { 

	public void dostuff (HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
    		HttpSession tsession=req.getSession(true);
	  	res.setContentType("text/html");
	  	PrintWriter os=res.getWriter();


		HTML

	//code to connect using JDBC
		String url = url
		Connection con;
		Statement stmt;

	//getting info from the HTML page what the user typed in
		String user=req.getParameter("User");
		String passwd=req.getParameter("Password");
		String DBownertype=req.getParameter("dbownertype");

	//Shows Table of roles created
		String table=(("SELECT USERNAME, ROLE FROM ") + user + (".users ORDER BY USERNAME"));

		try {	
			Class.forName( "oracle.jdbc.driver.OracleDriver" );
		} 
		catch (java.lang.ClassNotFoundException e) {
			os.print("ClassNotFound: ");
			os.println(e.getMessage());
		}
		try {	
			con = DriverManager.getConnection( url, user, passwd );
			stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(table);
			os.println("<TABLE CELLSPACING=0 BORDER=1 WIDTH=50%>");
			while (rs.next()) {
				String u = rs.getString("USERNAME");
				String r = rs.getString("ROLE");
				os.println("<tr><td>" + u + "</td><td>" + r + "</td></tr>");
			}
		con.close();
		}

		catch(SQLException ex) {
			os.println("Sorry no users have been created yet!<p><br>");
		}


		os.flush();
	}

	public void doGet (HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
    	dostuff(req, res);}

	public void doPost (HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
	dostuff(req, res);}
}