/* (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>Easy Deletion Of Offline Videos 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");
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("Operation For : " + forrole)
+ "<td><h2>"
+ Styles.ccase(tdate));
kout.println(
"<tr><td colspan=75%><blockquote><h2>"
+ Styles.ccase("Operation On : " + " Video")
+ "<td><h2><a href='javascript:history.go(-1)'>Back</a>");
kout.println("</table>");
kout.println(
"<br><br><br>**************************************************************************************************************</center><br>");
st = mycon.createStatement();
ResultSet rs = st.executeQuery("select * from library where status='video'");
String fid = "", lpath = "", ltitle = "", cdate = "";
int c = 1;
kout.println("<body background='myreport1.jpg'>");
kout.println("<center>");
kout.println("<table border=0>");
int k = 0;
while (rs.next()) {
c++;
fid = rs.getString("fid");
lpath = rs.getString("lpath");
ltitle = rs.getString("ltitle");
cdate = rs.getString("cdate");
kout.println("<tr>");
kout.println("<td>");
kout.println(fid);
kout.println("</td>");
kout.println("<td> ");
kout.println("</td>");
kout.println("<td>");
kout.println(
"<a href=\""
+ lpath
+ "\" title=\""
+ ltitle
+ "\" target=\"_blank\">"
+ ltitle
+ "</a>");
kout.println("</td>");
kout.println("<td> ");
kout.println("</td>");
kout.println("<td>");
kout.println(cdate);
kout.println("</td>");
kout.println("</tr>");
kout.println("<tr><td colspan=100%><center>" + Fortable.display(33, "<<->>"));
}
rs.close();
st.close();
kout.println("</table><br>");
if (c == 1) kout.println("<br><br><h1>Sorry No Videos Have Been Uploaded 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 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();
}
}