<% String legal = (String)session.getAttribute("UserName"); if(legal==null) { %> Session expired, Sign-In again <% } else { %> <%@ include file="include/connection.jsp" %> <%@ page import="java.io.File" %> <%! ResultSet rs,rs1,rs2; Statement stmt1; String Leave=null; int hq=0; int town=0; int Days=0; int flag=0; int i=0; String user_flag=null; String fname=null; String mname=null; String lname=null; %> <% if(request.getParameter("news")!=null) { try { String filename=null; StringTokenizer stt = new StringTokenizer(request.getParameter("news"),"," ); while(stt.hasMoreTokens()) { int id=Integer.parseInt(stt.nextToken(),10); String qry="select news_file from anandu_mails.newsletter where id="+ id ; rs=stmt.executeQuery(qry); if(rs.next())filename=rs.getString("news_file"); qry = "Delete from anandu_mails.newsletter where id=" + id; stmt.executeQuery(qry); String dirname="/home/anandu/public_html/userdirs/Newsletter"; File f=new File(dirname,filename); f.delete(); } } catch(Exception e) { System.out.println("Exception caught lower is:"+e.getMessage()); } } %>

Newsletter List

S.No.

Date

Title

Created By

<% try { int sno=1; int count=0; String day=null,year=null,month=null; String query = "select newsletter.*,user_info.firstname,user_info.middlename,user_info.lastname from anandu_mails.newsletter,anandu_mails.user_info where newsletter.news_from=user_info.username order by newsletter.id"; rs = stmt.executeQuery(query); while(rs.next()) count++; %> <%while(count>0){ String stdate = rs.getString("date"); StringTokenizer st1 = new StringTokenizer(stdate," " ); String ne = st1.nextToken(); StringTokenizer stt1 = new StringTokenizer(ne,"-" ); while(stt1.hasMoreTokens()) { year = stt1.nextToken(); month = stt1.nextToken(); day = stt1.nextToken(); } stdate = day+ "-" + month + "-" + year; if(sno%2!=0) { %> <% }else{%> <%}sno++; count--; rs.previous();}%> <% } catch(Exception e) { System.out.println("Exception caught lower is:"+e.getMessage()); } %>

<%=sno%>	<%=stdate%>	" ><%=rs.getString("title")%>	<%=rs.getString("firstname")%> <%=rs.getString("middlename")%> <%=rs.getString("lastname")%>
<%=sno%>	<%=stdate%>	" ><%=rs.getString("title")%>	<%=rs.getString("firstname")%> <%=rs.getString("middlename")%> <%=rs.getString("lastname")%>

<%}%>