import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.net.*;
import java.sql.*;
public class EnterTool extends HttpServlet {
String sunrise = "http://sunrise.npac.syr.edu/servlet/";
public void service(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
PrintStream out;
res.setContentType("text/html");
out = new PrintStream(res.getOutputStream());
printPageHeader(out, "Webtools");
String url = "jdbc:oracle:thin:@sunrise.npac.syr.edu:1521:frog";
Connection con;
String db_id = "quasar";String db_passwd = "quasar";
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url,db_id,db_passwd);
Statement stmt = con.createStatement();
String query="select * from Admins_table ";
ResultSet rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
out.println("
Group IDs
");
while(rs.next()){
dispResultSet(rs, out, rsmd);
}
stmt.close();
con.close();
}
catch (SQLException ex) {
}
catch (java.lang.Exception ex) {
}
out.println("
");
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 = "";
out.println(t+name+"");
}
private void printPageHeader(PrintStream out, String title) {
out.println("");
out.println("
");
out.println(""+title+"");
out.println("");
}
private void printPageFooter(PrintStream out) {
String t = "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.";
t += "For further question, you can contact mjlee@npac.syr.edu";
t += "";
out.println(t+"");
out.println("