<% 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
  User Registration
<% 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{%> <%}%>
 Username : <%=request.getParameter("Edit")%> ">
 First Name  Roll No
 Middle Name  Date
 Last Name
 Password
 Confirm Password
 Company
 Email
 User Type checked <%}%> > Student checked <%}%> > Faculty
       
 Username <%if(ss!=null){%>     <%=ss%><%}%>
 First Name value="<%=request.getParameter("FName")%>" <%}%> size="30" style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; FONT-SIZE: 12px; BORDER-LEFT: #000000 1px solid; COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Tahoma, Verdana, Arial; BACKGROUND-COLOR: #ffffff">  Roll No value="<%=request.getParameter("FName")%>" <%}%> size="20" style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; FONT-SIZE: 12px; BORDER-LEFT: #000000 1px solid; COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Tahoma, Verdana, Arial; BACKGROUND-COLOR: #ffffff">
 Middle Name value="<%=request.getParameter("MName")%>" <%}%> size="30" style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; FONT-SIZE: 12px; BORDER-LEFT: #000000 1px solid; COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Tahoma, Verdana, Arial; BACKGROUND-COLOR: #ffffff">  Date
 Last Name value="<%=request.getParameter("LName")%>" <%}%> size="30" style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; FONT-SIZE: 12px; BORDER-LEFT: #000000 1px solid; COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Tahoma, Verdana, Arial; BACKGROUND-COLOR: #ffffff">
 Password
 Confirm Password
 Company
 Email value="<%=request.getParameter("Alt_Email")%>" <%}%> size="30" onblur="return mail_chk()" style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; FONT-SIZE: 12px; BORDER-LEFT: #000000 1px solid; COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Tahoma, Verdana, Arial; BACKGROUND-COLOR: #ffffff">
 User Type Student Faculty
       
<%}%>