"+title+"

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

public class MyGroup extends HttpServlet {

String sunrise = "http://sunrise.npac.syr.edu/servlet/";

public void service(HttpServletRequest req, HttpServletResponse res)
	throws ServletException, IOException{
	

	String s_id = req.getParameter("id");
	String name = req.getParameter("me");
//	int id ;
	PrintStream out;
	res.setContentType("text/html");
	out = new PrintStream(res.getOutputStream());
	printPageHeader(out, name);
	String url = "jdbc:oracle:thin:@sunrise.npac.syr.edu:1521:frog";
	Connection con;
	String db_id = "quasar";String db_passwd = "quasar";

	try{
//	id = Integer.parseInt(s_id);
	Class.forName("oracle.jdbc.driver.OracleDriver");
	con = DriverManager.getConnection(url,db_id,db_passwd);
	Statement stmt = con.createStatement();
	String query="select * from sub_table where id="+s_id;
	ResultSet rs = stmt.executeQuery(query);
	ResultSetMetaData rsmd = rs.getMetaData();
	out.println("<p><br><h3>Group "+name+"<hr>");
	out.println("<ol>");
	while(rs.next()){
	dispResultSet(rs, out, rsmd);
	}
	stmt.close();
	con.close();
	}
	catch (SQLException ex) {
	}
	catch (java.lang.Exception ex) {
	}
	out.println("</h3></ol>");
	printPageFooter(out);
}

private void dispResultSet(ResultSet rs, PrintStream out, ResultSetMetaData rsmd)
	throws SQLException{
	String name = rs.getString(2);
//	int id = rs.getInt(1);
//	String t = "<a href=\""+sunrise+"MyGroup?id="+id+"&me="+name+"\">";
	out.println("<li>"+name+"<p>");

}
private void printPageHeader(PrintStream out, String title) {
                out.println("<html>");
                out.println("<head>");
                out.println("<title>"+title+"</title>");
                out.println("</head>");
        }

private void printPageFooter(PrintStream out) {

		String t = "<i>For now, you can look at contents of all ";
		t += "directories but in order to upload files, you need to ";
		t += "be either one of group ID or guest ID with proper ";
		t += "password which you could get from the group ";
		t += "you need to post data file.<p>";
		t += "For further question, you can contact mjlee@npac.syr.edu";
		t += "</i>";
                out.println(t+"</body>");
                out.println("</html>");
                out.flush();
        }


}