<% String legal = (String)session.getAttribute("UserName"); if(legal==null) { %>
Session expired, Sign-In again
<% } else { %> <%@ include file="include/connection.jsp" %> <%@ page import="java.util.*" %> <%@ page import="java.io.File" %> <%@ page import="java.io.*" %> <%@ page import="java.util.Date" %> <%if(request.getParameter("Title")!=null) { ResultSet rs; String n=request.getParameter("News_Text"); String news=""; char ch; int dp=n.length(); for(int i=0;i"; } else { news=news+ch; } } Date today=new Date(); int id=0; String query=" insert into anandu_mails.newsletter(news_from,date,title,news_file,breif) values('" + (String)session.getAttribute("UserName") + "',CURRENT_DATE,'"+ request.getParameter("Title") + "','try','" + request.getParameter("Breif") + "')"; stmt.executeQuery(query); query="select id from anandu_mails.newsletter where news_file='try'"; rs=stmt.executeQuery(query); if(rs.next()) { id=rs.getInt("id"); } String filename="news" + Integer.toString(id)+".htm"; query="Update anandu_mails.newsletter set news_file='"+filename+"' where id="+id; stmt.executeUpdate(query); String dirname="/home/anandu/public_html/userdirs/Newsletter"; File f1=new File(dirname); if(!f1.isDirectory()) f1.mkdir(); FileWriter f2=new FileWriter(dirname + "/" + filename); String Start="
"; String Title=""; String C_Date=""; String News_Text=""; String End="

"+ request.getParameter("Title") + "

Date : "+(today.getDate() + "-" + (today.getMonth()+1) + "-" + (today.getYear() + 1900)) + "By : "+ (String)session.getAttribute("Name") + "

" + news + "

"; f2.write(Start); f2.write(C_Date); f2.write(Title); f2.write(News_Text); f2.write(End); f2.close(); response.sendRedirect("forwardnews.jsp?filename=" + filename); } %> Create Folder
  Newsletter   <%=(String)session.getAttribute("Name")%>
 Title :
 Breif
 Text :
<%}%>