/* (non-Java-doc)
* @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html");
PrintWriter kout = response.getWriter();
kout.println("<html><head><title>Competition Creation Process</title></head>");
HttpSession my = request.getSession();
String taid = "", tsid = "", tsubmittedon = "", tsecuredmarks = "";
String tfid = "", tsubmissionwas = "", query1 = "";
int myear = new Date().getYear() - 100, d = new Date().getDate(), m = new Date().getMonth() + 1;
Connection mycon = null;
Statement st;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
mycon = DriverManager.getConnection("jdbc:odbc:myvcs");
// kout.println("<br><br>**************************************************************************************************************");
// kout.println("<br><h1>Your Connection With Mentioned DataSource Was Established
// Successfully </h1>");
// kout.println("<br><br>**************************************************************************************************************");
if (mycon != null) {
try {
taid = "11comp02";
tsid = "4";
tsubmittedon = "19/10/1989";
tsecuredmarks = "12";
tsubmissionwas = "11/2/2011";
taid = request.getParameter("aid");
tsid = request.getParameter("sid");
tsubmissionwas = request.getParameter("submissionwas");
tsecuredmarks = request.getParameter("securedmarks");
tsubmittedon = request.getParameter("submittedon");
tsubmittedon = m + "/" + d + "/" + (myear + 2000); // access
tsubmittedon = (myear + 2000) + "/" + m + "/" + d; // db2
tfid = request.getAttribute("uid").toString();
st = mycon.createStatement();
ResultSet rs =
st.executeQuery("select * from assign_allocation where aid='" + taid + "'");
int tot = 0;
while (rs.next()) {
tot = rs.getRow();
}
if (tot != 0) {
query1 =
"insert into assign_submitted(aid,sid,submittedon,submissionwas,securedmarks,fid) values('"
+ taid
+ "','"
+ tsid
+ "','"
+ tsubmittedon
+ "','"
+ tsubmissionwas
+ "','"
+ tsecuredmarks
+ "','"
+ tfid
+ "')";
st = mycon.createStatement();
st.executeUpdate(query1);
kout.println(
"<br><br><br><h1>Student's Assignment Marks Are Declared Or Added Successfully");
mystr = "Assignment Marks Are Declared";
} else mystr = "Assignment Does Not Exists";
// kout.println("<br><br><br><h1>Sorry Assignment Does Not Exists");
} catch (Exception e) {
System.err.println(e);
myerror = e.getMessage();
} finally {
mycon.close();
}
} else mystr = "Sorry Connection Is In-Active";
} catch (Exception k) {
System.err.println(k);
myerror = myerror + "<br>" + k.getMessage();
} finally {
kout.println("<html>");
kout.println("<body OnLoad=document.getElementById('vcs').submit();>");
kout.println("<form id=vcs method=post action=/VcsTest/Faculty/FacultyAssignmentMarks.jsp>");
kout.println("<input type=hidden name=common value='" + mystr + "' >");
kout.println("</form>");
kout.println("</body></html>");
kout.println("<html><body background='myreport1.jpg'>");
kout.println("</body></html>");
if (myerror != null) kout.println("There Is A Error From Server-Side=" + myerror);
kout.close();
}
}
/* (non-Java-doc)
* @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html");
PrintWriter kout = response.getWriter();
kout.println("<html><head><title>View Blogs In VCS</title></head>");
HttpSession my = request.getSession(false);
String tdate = new Date().toGMTString().toString(),
forrole = my.getAttribute("urole").toString();
Connection mycon = null;
Statement st;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
mycon = DriverManager.getConnection("jdbc:odbc:myvcs");
// kout.println("<br><br>**************************************************************************************************************");
// kout.println("<br><h1>Your Connection With Mentioned DataSource Was Established
// Successfully </h1>");
// kout.println("<br><br>**************************************************************************************************************");
if (mycon != null) {
try {
kout.println(
"<br><br><center>**************************************************************************************************************");
kout.println("<table border=0>");
kout.println(
"<tr><td colspan=100%><center><h2>"
+ Styles.ccase("Organisation : virtual class room system")
+ "</center>");
kout.println("<tr><td><br>");
kout.println(
"<tr><td colspan=75%><blockquote><h2>"
+ Styles.ccase("Report For : " + forrole)
+ "<td><h2>"
+ Styles.ccase(tdate));
kout.println(
"<tr><td colspan=75%><blockquote><h2>"
+ Styles.ccase("Report Title : " + "View Blogs")
+ "<td><h2><a href='javascript:history.go(-1)'>Back</a>");
kout.println("</table>");
kout.println(
"<br><br><br>**************************************************************************************************************</center><br>");
// kout.println("<br><br><h1>View Blogs In VCS</h1>");
/*String trole,tuserid,tprior;
trole=request.getAttribute("urole").toString();
tuserid=request.getAttribute("uid").toString();
tprior=request.getAttribute("uprior").toString();*/
st = mycon.createStatement();
ResultSet rs = st.executeQuery("select * from blog_master");
int c = 1;
kout.println("<center>");
while (rs.next()) {
kout.println("<center><table width=95% border=2 bordercolor=black>");
String str = rs.getString("bid");
kout.println("<tr><td colspan=100%><center>" + Fortable.display(153, "*"));
if (c % 2 == 1)
kout.println("<tr><td colspan=95%><center><h1>Blog Id :" + str + "</center></h1>");
else kout.println("<tr><td colspan=95%><center><h2>Blog Id :" + str + "</center></h2>");
kout.println(
"<tr><td>Sr No:<td>"
+ c
+ "<tr><td>Given By:<td>"
+ rs.getString("userid")
+ "<tr><td>Blog Date & Time:<td>"
+ rs.getString("bdate")
+ "<tr><td>CourseName<td>"
+ rs.getString("coursename"));
kout.println("<tr><td colspan=11><center>Blog Message:</center>");
kout.println("<tr><td colspan=11>" + rs.getString("bmsg"));
c = c + 1;
kout.println("<tr><td colspan=100%><center>" + Fortable.display(33, "<<->>"));
kout.println("</table><br>");
}
rs.close();
st.close();
if (c == 1)
kout.println("<br><br><h1>Sorry No Blog Have Been Created Or Available At Present");
} catch (Exception k) {
System.err.println(k);
myerror = k.getMessage();
} finally {
mycon.close();
}
} else kout.println("<br><br><h2><center>Sorry Connection Is Not Active Now");
} catch (Exception k) {
System.err.println(k);
myerror = myerror + "<br>" + k.getMessage();
} finally {
kout.println("<html><body background='myreport1.jpg'>");
kout.println("</body></html>");
if (myerror != null) kout.println("There Is A Error From Server-Side=" + myerror);
kout.close();
}
}
/* (non-Java-doc)
* @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html");
PrintWriter kout = response.getWriter();
kout.println("<html><head><title>Management Deletion Only By Admin</title></head>");
String tmid = "", query1 = "";
Connection mycon = null;
Statement st;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
mycon = DriverManager.getConnection("jdbc:odbc:myvcs");
// kout.println("<br><br>**************************************************************************************************************");
// kout.println("<br><h1>Your Connection With Mentioned DataSource Was Established
// Successfully </h1>");
// kout.println("<br><br>**************************************************************************************************************");
if (mycon != null) {
try {
/*kout.println("<br><br><center>**************************************************************************************************************");
kout.println("<br><h1>Management Deletion Only By Admin In VCS</h1>");
kout.println("<br><br><br>**************************************************************************************************************</center><br>");*/
tmid = "11mgt1";
tmid = request.getParameter("mid");
st = mycon.createStatement();
ResultSet rs1 = st.executeQuery("select * from mgt_master where mid='" + tmid + "'");
int tot = 0;
while (rs1.next()) {
tot = rs1.getRow();
}
if (tot != 0) {
st = mycon.createStatement();
query1 = "delete from mgt_master where mid='" + tmid + "'";
st.executeUpdate(query1);
st = mycon.createStatement();
query1 = "delete from login_master where userid='" + tmid + "'";
st.executeUpdate(query1);
// kout.println("<br><br><br><h1>Management Deleted Successfully");
mystr = "Management Info Deleted";
} else mystr = "Management Is Not Deleted";
// kout.println("<br><br><br><h1>Sorry Management Cannot Be Deleted Since Management May
// Not Exists Or Some Other Restriction Are Given");
} catch (Exception k) {
System.err.println(k);
myerror = k.getMessage();
} finally {
mycon.close();
}
} else mystr = "Sorry Connection Is In-Active";
} catch (Exception k) {
System.err.println(k);
myerror = myerror + "<br>" + k.getMessage();
} finally {
kout.println("<html>");
kout.println("<body OnLoad=document.getElementById('vcs').submit();>");
kout.println("<form id=vcs method=post action=/VcsTest/Admin/AdminMgtDelete.jsp>");
kout.println("<input type=hidden name=common value='" + mystr + "' >");
kout.println("</form>");
kout.println("</body></html");
kout.println("<html><body background='myreport1.jpg'>");
kout.println("</body></html>");
if (myerror != null) kout.println("There Is A Error From Server-Side=" + myerror);
kout.close();
}
}