public void doGet(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException {
res.setContentType("text/html");
try {
PrintWriter pw = res.getWriter();
pw.println("<html><head><TITLE>Web-Enabled Automated Manufacturing System</TITLE></head>");
pw.println(
"<body><br><br><br><form name=modifyuser method=post action='http://peers:8080/servlet/showUser')");
v = U.allUsers();
pw.println("<table align='center' border=0> <tr><td>");
pw.println(
"Select User Name To Modify</td><td><SELECT id=select1 name=uid style='HEIGHT: 22px; LEFT: 74px; TOP: 222px; WIDTH: 155px'>");
pw.println("<OPTION selected value=''></OPTION>");
for (i = 0; i < v.size(); i++)
pw.println(
"<OPTION value="
+ (String) v.elementAt(i)
+ ">"
+ (String) v.elementAt(i)
+ "</OPTION>");
pw.println(
"</SELECT></td></tr><tr><td></td><td><input type='submit' name='submit' value='Submit'></td></tr></table></form></body></html>");
pw.flush();
pw.close();
} catch (Exception e) {
}
}
/**
* ** Encodes the specified DBRecordKyes into XML and writes it to ** a specified PrintWriter
* ** @param out The PrintWriter ** @param dbrk The list of DBRecordKeys
*/
public static void printXML(PrintWriter out, DBRecordKey... dbrk) {
if (out != null) {
out.write("<" + DBFactory.TAG_RecordKeys + ">\n");
for (int i = 0; i < dbrk.length; i++) {
dbrk[i].printXML(out, 4);
}
out.write("</" + DBFactory.TAG_RecordKeys + ">\n");
out.flush();
}
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException {
res.setContentType("text/html");
PrintWriter pw = res.getWriter();
PR.deleteProduct(req.getParameter("prid"));
pw.println("<html><head><TITLE>Web-Enabled Automated Manufacturing System</TITLE></head>");
pw.println("<table align='center' border=0>");
pw.println("<tr col span=2><th>Web-Enabled Automated Manufacturing Process</th></tr>");
pw.println("<tr><td>Product ID:</td><td>" + req.getParameter("prid") + "</td></tr>");
pw.println("<tr><td>Product data is deleted Click on OK to Continue</td></tr>");
pw.println(
"<tr><td align=center><a href='http://peers:8080/servlet/deleteProduct' target='main'>OK</a></td>");
pw.println("<td></td></tr>");
pw.println("</table></form></body></html>");
pw.flush();
pw.close();
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException {
res.setContentType("text/html");
hs = req.getSession(true);
PrintWriter pw = res.getWriter();
uid = req.getParameter("did");
if (!uid.equals("")) {
v = D.getDealer(uid);
pw.println(
"<html><head><TITLE>Web-Enabled Automated Manufacturing System</TITLE><script language=javascript>function set() {");
pw.println(
"document.deldealer.select1.value='"
+ (String) v.elementAt(4)
+ "'} </script></head><P align=center><FONT color=deepskyblue size=4><STRONG>MODIFY DEALER </STRONG></FONT></P> ");
pw.println(
"<body onLoad=set()><br><br><form name=deldealer method=post action='http://peers:8080/servlet/DelDealer'>");
pw.println(
"<center><TABLE border=0 cellPadding=1 cellSpacing=1 width='75%' style='HEIGHT: 147px; WIDTH: 248px'>");
pw.println(
"<TR><TD>DealerId </TD><TD><INPUT id=text1 name=did value="
+ (String) v.elementAt(0)
+ "></TD></TR>");
pw.println(
"<TR><TD>DealerName</TD><TD><INPUT id=text2 name=dname value="
+ (String) v.elementAt(1)
+ " ></TD></TR><TR><TD>DealerAddress</TD>");
pw.println(
"<TD><INPUT id=text2 type=text name=daddr value="
+ (String) v.elementAt(2)
+ "></TD></TR><TR><TD>CreditLimit</TD><TD><INPUT id=text4 name=cl value="
+ v.get(3).toString());
pw.println(
"></TD></TR><TR><TD><P>Staus</P></TD><td><SELECT id=select1 name=status style='HEIGHT: 22px; LEFT: 1px; TOP: 1px; WIDTH: 136px'> <OPTION ");
pw.println(
"selected value=''></OPTION><OPTION value=Active>Active</OPTION><OPTION value=Inactive>Inactive</OPTION></SELECT><INPUT id=submit1 name=submit1 style='LEFT: 151px; TOP: 318px' type=submit value=Delete></TD></TR>");
pw.println("</table></center></form></body></html>");
pw.flush();
pw.close();
}
}
/**
* ** Encodes this DBRecordKey into XML and writes it to a specified PrintWriter ** @param out The
* PrintWriter ** @param indent The number of spaces to indent ** @param sequence Optional
* sequence value ** @param soapXML True for SOAP XML
*/
public void printXML(PrintWriter out, int indent, int sequence, boolean soapXML) {
if (out != null) {
out.write(this.toXML(null, indent, sequence, soapXML).toString());
out.flush();
}
}
/**
* Remove a quiz from a course. Also deletes all the quiz visualization files from the students'
* folder who is registered in the course. Caution: vizualisation file will be deleted eventhough
* it also relates to anther course if the student is also registered to that course. (FIX ME!)
* Throws InvalidDBRequestException if the quiz is not registered in the course, error occured
* during deletion, or other exception occured.
*
* @param quizName quiz name
* @param courseID course id (course number + instructor name)
* @throws InvalidDBRequestException
*/
public void deleteQuiz(String quizName, String courseID)
throws InvalidDBRequestException, FileFailureException {
try {
Class.forName(GaigsServer.DBDRIVER);
db =
DriverManager.getConnection(GaigsServer.DBURL, GaigsServer.DBLOGIN, GaigsServer.DBPASSWD);
Statement stmt = db.createStatement();
ResultSet rs;
int count = 0;
// check if quiz is used in the course
rs =
stmt.executeQuery(
"select test_name from courseTest where test_name = '"
+ quizName
+ "' and course_id = '"
+ courseID
+ "'");
if (!rs.next()) throw new InvalidDBRequestException("Quiz is not registered for the course");
else {
// remove quiz from course
count =
stmt.executeUpdate(
"delete from courseTest where course_id = '"
+ courseID
+ "' and test_name = '"
+ quizName
+ "'");
if (count != 1) throw new InvalidDBRequestException("Error occured during deletion");
else {
// delete quiz visualization files
rs =
stmt.executeQuery(
"select distinct unique_id, scores.user_login from scores, courseRoster "
+ "where courseRoster.user_login = scores.user_login "
+ "and course_id = '"
+ courseID
+ "' "
+ "and test_name = '"
+ quizName
+ "'");
while (rs.next()) {
deleteVisualization(rs.getString(1), rs.getString(2), quizName);
count =
stmt.executeUpdate(
"delete from scores where unique_id = " + rs.getString(1).trim());
}
// rewrite the menu for the course
rs =
stmt.executeQuery(
"select distinct menu_text, name, script_type, visual_type from test t, courseTest c "
+ "where t.name = c.test_name "
+ "and course_id = '"
+ courseID
+ "'");
PrintWriter fileOStream =
new PrintWriter(new FileOutputStream("./html_root/cat/" + courseID + ".list"));
while (rs.next()) {
if (debug)
System.out.println(
rs.getString(1).trim()
+ "\n"
+ rs.getString(2).trim()
+ " "
+ rs.getString(3).trim()
+ " "
+ rs.getString(4).trim().toLowerCase()
+ "\n****\n");
fileOStream.print(
rs.getString(1).trim()
+ "\n"
+ rs.getString(2).trim()
+ " "
+ rs.getString(3).trim()
+ " "
+ rs.getString(4).trim().toLowerCase()
+ "\n****\n");
}
fileOStream.flush();
fileOStream.close();
}
}
rs.close();
stmt.close();
db.close();
} catch (SQLException e) {
System.err.println("Invalid SQL in addQuiz: " + e.getMessage());
throw new InvalidDBRequestException("??? ");
} catch (ClassNotFoundException e) {
System.err.println("Driver Not Loaded");
throw new InvalidDBRequestException("Internal Server Error");
} catch (Exception e) {
System.err.println("Error in recreating menu for course: " + courseID);
System.err.println(e.getMessage());
throw new FileFailureException();
}
}
/**
* Add a quiz to a course if not already so. Also write the menu file for the course. Throws
* InvalidDBRequestException if quiz already in the course, error occured during insertion, or
* other exception occured. Throws FileFailureException if fail to append quiz to the menu.
*
* @param quizname the quiz name
* @param courseID the course id (course number + instructor name)
* @throws InvalidDBRequestException
*/
public void addQuiz(String quizName, String courseID)
throws InvalidDBRequestException, FileFailureException {
try {
Class.forName(GaigsServer.DBDRIVER);
db =
DriverManager.getConnection(GaigsServer.DBURL, GaigsServer.DBLOGIN, GaigsServer.DBPASSWD);
Statement stmt = db.createStatement();
Statement cstmt = db.createStatement();
ResultSet rs, courseRS;
int count = 0;
// get quiz info
courseRS =
cstmt.executeQuery(
"select menu_text, script_type, visual_type from test where name = '"
+ quizName
+ "'");
// check if quiz in the database
if (!courseRS.next())
throw new InvalidDBRequestException("Quiz is not registered in the database");
else {
// check if quiz already in the course
rs =
stmt.executeQuery(
"select test_name from courseTest where test_name = '"
+ quizName
+ "' and course_id = '"
+ courseID
+ "'");
if (rs.next()) throw new InvalidDBRequestException("Quiz is already added for the course");
else {
count =
stmt.executeUpdate(
"insert into courseTest (course_id, test_name) values ('"
+ courseID
+ "', '"
+ quizName
+ "')");
if (count != 1) throw new InvalidDBRequestException("Error occured during insertion");
else {
// append quiz info to the course menu
try {
PrintWriter fileOStream =
new PrintWriter(
new FileOutputStream("./html_root/cat/" + courseID + ".list", true));
if (debug)
System.out.println(
courseRS.getString(1).trim()
+ "\n"
+ quizName
+ " "
+ courseRS.getString(2).trim()
+ " "
+ courseRS.getString(3).trim().toLowerCase()
+ "\n****\n");
fileOStream.print(
courseRS.getString(1).trim()
+ "\n"
+ quizName
+ " "
+ courseRS.getString(2).trim()
+ " "
+ courseRS.getString(3).trim().toLowerCase()
+ "\n****\n");
fileOStream.flush();
fileOStream.close();
} catch (Exception e) {
System.err.println("Error in creating the menu: " + e.getMessage());
throw new FileFailureException("Error in creating the menu: " + e.getMessage());
}
}
}
}
courseRS.close();
rs.close();
stmt.close();
cstmt.close();
db.close();
} catch (SQLException e) {
System.err.println("Invalid SQL in addQuiz: " + e.getMessage());
throw new InvalidDBRequestException("??? ");
} catch (ClassNotFoundException e) {
System.err.println("Driver Not Loaded");
throw new InvalidDBRequestException("Internal Server Error");
}
}
private void doUpdate(PrintWriter out) {
Connection con1 = null; // init DB objects
Connection con2 = null;
PreparedStatement pstmt = null;
Statement stmt1 = null;
Statement stmt1a = null;
Statement stmt2 = null;
Statement stmt3 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
out.println("<HTML><HEAD><TITLE>Database Query</TITLE></HEAD>");
out.println("<BODY><H3>Starting Job to Check for Clubster Users</H3>");
out.flush();
String club = "";
String name = "";
try {
con1 = dbConn.Connect(rev);
} catch (Exception exc) {
// Error connecting to db....
out.println("<BR><BR>Unable to connect to the DB.");
out.println("<BR>Exception: " + exc.getMessage());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
return;
}
//
// Get the club names from the 'clubs' table
//
// Process each club in the table
//
int x1 = 0;
int x2 = 0;
int i = 0;
boolean skip = true;
try {
stmt1 = con1.createStatement();
rs1 = stmt1.executeQuery("SELECT clubname, fullname FROM clubs ORDER BY clubname");
while (rs1.next()) {
x1++;
club = rs1.getString(1); // get a club name
name = rs1.getString(2); // get full club name
con2 = dbConn.Connect(club); // get a connection to this club's db
stmt2 = con2.createStatement();
rs2 = stmt2.executeQuery("SELECT date FROM sessionlog WHERE msg LIKE '%clubster'");
if (rs2.next()) {
out.println("<br><br>");
out.print("Club found: " + club + ", " + name);
}
stmt2.close();
con2.close();
}
stmt1.close();
con1.close();
} catch (Exception e) {
// Error connecting to db....
out.println("<BR><BR><H3>Fatal Error!</H3>");
out.println("Error performing update to club '" + club + "'.");
out.println("<BR>Exception: " + e.getMessage());
out.println("<BR>Message: " + e.toString());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
out.close();
Connect.close(stmt2, con2);
Connect.close(stmt1, con1);
return;
}
Connect.close(stmt2, con2);
Connect.close(stmt1, con1);
out.print("<BR><BR>Done, " + x1 + "clubs checked.");
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>");
out.println("</CENTER></BODY></HTML>");
// out.flush();
// out.close();
}
public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
String support = "support"; // valid username
HttpSession session = null;
session = req.getSession(false); // Get user's session object (no new one)
if (session == null) {
invalidUser(out); // Intruder - reject
return;
}
String userName = (String) session.getAttribute("user"); // get username
if (!userName.equals(support)) {
invalidUser(out); // Intruder - reject
return;
}
Connection con1 = null; // init DB objects
Connection con2 = null;
Statement stmt1 = null;
Statement stmt2 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
out.println("<HTML><HEAD><TITLE>Database Query</TITLE></HEAD>");
out.println("<BODY><H3>List Each Club With a Custom Style Sheet</H3>");
out.println(
"<table border=1><tr><td><b>Site</b></td><td><b>Club Name</b></td><td><b>Style Sheet</b></td></tr>");
out.flush();
String club = "";
String fullname = "";
String styles = "";
try {
con1 = Connect.getCon(rev); // connect to v5
} catch (Exception exc) {
// Error connecting to db....
out.println("<BR><BR>Unable to connect to the DB.");
out.println("<BR>Exception: " + exc.getMessage());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
return;
}
//
// Get the club names from the 'clubs' table
//
// Process each club in the table
//
try {
stmt1 = con1.createStatement();
rs1 =
stmt1.executeQuery(
"SELECT clubname, fullname FROM v5.clubs WHERE inactive=0 ORDER BY clubname");
while (rs1.next()) {
club = rs1.getString(1); // get a club name
fullname = rs1.getString(2); // get club's full name
if (!club.startsWith("demo")) { // if NOT a demo site
con2 = Connect.getCon(club); // get a connection to this club's db
stmt2 = con2.createStatement(); // create a statement
try {
rs2 = stmt2.executeQuery("SELECT custom_styles FROM club5");
if (rs2.next()) {
styles = rs2.getString("custom_styles"); // get the custom styles name, if any
if (!styles.equals("")) {
out.println(
"<tr><td>"
+ club
+ "</td><td>"
+ fullname
+ "</td><td>"
+ styles
+ "</td></tr>");
}
}
} catch (Exception exc) {
out.println(club + " failed!!!!!!!!!!!!!!!!!!!! " + exc.toString());
}
stmt2.close();
con2.close();
}
} // end if WHILE clubs
out.println("</table>");
} catch (Exception exc) {
// Error connecting to db....
out.println("<BR><BR>Unable to connect to the DB.");
out.println("<BR>Exception: " + exc.getMessage());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
return;
}
try {
stmt1.close();
con1.close();
} catch (Exception ignore) {
}
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
out.close();
}