%
String legal = (String)session.getAttribute("UserName");
if(legal==null)
{
%>
User logged out,sign in again Index
<%
}
else
{
%>
<%@ include file="include/connection.jsp" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.io.File" %>
<%!
ResultSet rs,rs1,rs2;
Statement stmt1;
int flag=0;
int i=0;
String Name=null;
String fname=null;
String mname=null;
String lname=null;
String password=null;
String alt_email=null;
String user_flag=null;
String Company=null;
String ss=null;
String jdate=null;
String rollno=null;
int y=0;
String year=null;
String day=null;
String month=null;
Date today=new Date();
String months[]={"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"};
%>
<%
if(request.getParameter("status")!=null && request.getParameter("status").equals("new") )
{
if(request.getParameter("MName")!=null)
{
mname=request.getParameter("MName").toUpperCase();
}else{
mname="";
}
if(request.getParameter("Alt_Email")!=null)
{
alt_email=request.getParameter("Alt_Email").toUpperCase();
}else{
alt_email="";
}
if(request.getParameter("Company")!=null)
{
Company=request.getParameter("Company").toUpperCase();
}else{
Company="";
}
String jdate=request.getParameter("yy1") + "-" + request.getParameter("mm1") + "-" + request.getParameter("dd1");
try
{
String data=null;
String s=null;
String e_code=null;
int id=0;
String query1 = "select username from anandu_mails.user_info where username='" + request.getParameter("UName") + "'";
rs2 = stmt.executeQuery(query1);
if(rs2.next())
{
ss = "Username: " + request.getParameter("UName") + " already Exists";
}
else
{
String qry = "insert into anandu_mails.user_info(firstname,middlename,lastname,username,password,company,alt_email,user_flag,rollno,j_date) values ('" + request.getParameter("FName").toUpperCase() + "','" + request.getParameter("MName").toUpperCase() + "','" + request.getParameter("LName").toUpperCase() + "','" +request.getParameter("UName") + "','" +request.getParameter("Password") + "','" + Company + "','" + alt_email + "','" + request.getParameter("Uflag") + "','" + request.getParameter("Roll") + "','" + jdate+"')" ;
stmt.executeQuery(qry);
String dirname="/home/anandu/public_html/userdirs/" + request.getParameter("UName");
File f1=new File(dirname);
f1.mkdir();
if(request.getParameter("Uflag").equals("S"))
{
query1 = "select username from anandu_mails.user_info where user_flag='F'";
rs2 = stmt.executeQuery(query1);
while(rs2.next())
{
dirname="/home/anandu/public_html/userdirs/" + rs2.getString("username") +"/" + request.getParameter("UName");
File f2=new File(dirname);
f2.mkdir();
}
}
if(request.getParameter("Uflag").equals("F"))
{
query1 = "select username from anandu_mails.user_info where user_flag='S'";
rs2 = stmt.executeQuery(query1);
while(rs2.next())
{
dirname="/home/anandu/public_html/userdirs/" + request.getParameter("UName") +"/" + rs2.getString("username");
File f2=new File(dirname);
f2.mkdir();
}
}
response.sendRedirect("userlist.jsp");
}
}
catch(Exception e)
{
System.out.println("Exception caught lower is:"+e.getMessage());
}
}
%>
<%
if(request.getParameter("status")!=null && request.getParameter("status").equals("update") )
{
if(request.getParameter("MName")!=null)
{
mname=request.getParameter("MName").toUpperCase();
}else{
mname="";
}
if(request.getParameter("Alt_Email")!=null)
{
alt_email=request.getParameter("Alt_Email");
}else{
alt_email="";
}
if(request.getParameter("Company")!=null)
{
Company=request.getParameter("Company").toUpperCase();
}else{
Company="";
}
String jdate=request.getParameter("yy1") + "-" + request.getParameter("mm1") + "-" + request.getParameter("dd1");
try
{
String qry = "Update anandu_mails.user_info set firstname='" + request.getParameter("FName").toUpperCase() + "',middlename='" + request.getParameter("MName").toUpperCase() + "',lastname='" + request.getParameter("LName").toUpperCase() + "',password='" + request.getParameter("Password")+ "',company='" + Company + "',alt_email='" + alt_email + "',user_flag='" + request.getParameter("Uflag") + "',rollno='" + request.getParameter("Roll") + "',j_date='" + jdate +"' where username='" + request.getParameter("UName") + "'";
stmt.executeQuery(qry);
response.sendRedirect("userlist.jsp");
}
catch(Exception e)
{
System.out.println("Exception caught lower is:"+e.getMessage());
}
}
%>
Untitled Document
|
|
<%
if(request.getParameter("Edit")!=null)
{
try
{
String query1 = "select * from anandu_mails.user_info where username='" + request.getParameter("Edit") + "'";
rs2 = stmt.executeQuery(query1);
if(rs2.next())
{
flag=1;
user_flag=rs2.getString("user_flag");
fname=rs2.getString("firstname");
mname=rs2.getString("middlename");
lname=rs2.getString("lastname");
alt_email=rs2.getString("alt_email");
password=rs2.getString("password");
Company=rs2.getString("company");
rollno=rs2.getString("rollno");
jdate=rs2.getString("j_date");
}
else
{
flag=0;
}
}
catch(Exception e)
{
System.out.println("Exception caught lower is:"+e.getMessage());
}
%>
<%}else{%>
<%}%>
| |
|
<%}%>