 |
<%!
public String escapequote(String str)
{
String str1 = str.replace('\'','\"');
return str1;
}
%>
<%
boolean flag = false;
if (request.getParameter("confirm") != null && !request.getParameter("confirm").equals(""))
{
%>
Thanks for registering as an Alumni.
<% flag = true;
}
%>
<%
String alumni_no = "";
String title = "";
String first_name = "";
String last_name = "";
String bed = "";
String yop_bed = "";
String med = "";
String yop_med = "";
String date_of_birth = "";
String present_address = "";
String country_code_res = "";
String std_code_res = "";
String phone_residence = "";
String e_mail = "";
String organization = "";
String present_designation = "";
String country_code_off = "";
String std_code_off = "";
String phone_office = "";
String prev_service_record = "";
String other_achvments = "";
if (request.getParameter("toDo") != null && !request.getParameter("toDo").equals(""))
{
alumni_no = request.getParameter("alumni_id");
title = request.getParameter("title1");
first_name = request.getParameter("first_name1");
last_name = request.getParameter("last_name1");
bed = request.getParameter("bed1");
if (bed == "" || bed.equals("null"))
{
bed = "";
}
yop_bed = request.getParameter("yop_bed1");
if (yop_bed == "" || yop_bed.equals("null"))
{
yop_bed = "";
}
med = request.getParameter("med1");
if (med == "" || med.equals("null"))
{
med = "";
}
yop_med = request.getParameter("yop_med1");
if (yop_med == "" || yop_med.equals("null"))
{
yop_med = "";
}
date_of_birth = request.getParameter("date_of_birth1");
present_address = request.getParameter("present_address1");
country_code_res = request.getParameter("country_code_res1");
std_code_res = request.getParameter("std_code_res1");
phone_residence = request.getParameter("phone_res1");
e_mail = request.getParameter("e_mail1");
organization = request.getParameter("organization1");
present_designation = request.getParameter("present_designation1");
country_code_off = request.getParameter("country_code_off1");
std_code_off = request.getParameter("std_code_off1");
phone_office = request.getParameter("phone_off1");
prev_service_record = request.getParameter("previous_service_record1");
other_achvments = request.getParameter("other_achievements1");
}
%>
<% if (request.getParameter("update_alumni") != null && !request.getParameter("update_alumni").equals(""))
{
response.sendRedirect("../ui/alumni_update.jsp?alumni_id=" + alumni_no + "&title="+ request.getParameter("title")+"&first_name="+ request.getParameter("first_name")+"&last_name="+ request.getParameter("last_name")+"&bed="+ request.getParameter("bed")+"&yop_bed="+ request.getParameter("yop_bed")+"&med="+ request.getParameter("med")+"&yop_med="+ request.getParameter("yop_med")+"&date_of_birth="+ request.getParameter("date_of_birth")+"&present_address="+ request.getParameter("present_address")+"&country_code_res="+ request.getParameter("country_code_res")+"&std_code_res="+ request.getParameter("std_code_res")+"&phone_res="+ request.getParameter("phone_res")+"&e_mail="+ request.getParameter("e_mail")+"&organization="+ request.getParameter("organization")+"&present_designation="+ request.getParameter("present_designation")+"&country_code_off="+ request.getParameter("country_code_off")+"&std_code_off="+ request.getParameter("std_code_off")+"&phone_off="+ request.getParameter("phone_off")+"&previous_service_record="+ request.getParameter("previous_service_record")+"&other_achievements="+ request.getParameter("other_achievements"));
}
%>
<% if (request.getParameter("submit_alumni") != null && !request.getParameter("submit_alumni").equals(""))
{
String qualification1 = "";
String qualification2 = "";
String previous_service_record = "";
String other_achievements = "";
if ((request.getParameter("bed") != "") && (request.getParameter("med") == null || request.getParameter("med").equals("")))
{
qualification1 = "B.Ed";
qualification2 = "";
}
if ((request.getParameter("med") != "") && (request.getParameter("bed") == null || request.getParameter("bed").equals("")))
{
qualification1 = "";
qualification2 = "M.Ed";
}
if ((request.getParameter("bed") != null || !request.getParameter("bed").equals("")) && (request.getParameter("med") != null && !request.getParameter("med").equals("")))
{
qualification1 = "B.Ed";
qualification2 = "M.Ed";
}
if (qualification1 != "")
{
yop_bed = "-" + request.getParameter("yop_bed");
}
else
{
yop_bed = "";
}
if (qualification2 != "")
{
yop_med = "-" + request.getParameter("yop_med");
}
else
{
yop_med = "";
}
String phone_res = request.getParameter("country_code_res") + "-" + request.getParameter("std_code_res") + "-" + request.getParameter("phone_res");
String phone_off = request.getParameter("country_code_off") + "-" + request.getParameter("std_code_off") + "-" + request.getParameter("phone_off");
if (request.getParameter("previous_service_record") != null && !request.getParameter("previous_service_record").equals(""))
{
previous_service_record = request.getParameter("previous_service_record");
}
else
{
previous_service_record = "--";
}
if (request.getParameter("other_achievements") != null && !request.getParameter("other_achievements").equals(""))
{
other_achievements = request.getParameter("other_achievements");
}
else
{
other_achievements = "--";
}
%>
| 1. Name: |
<%=request.getParameter("title")%><%=request.getParameter("first_name")%> <%=request.getParameter("last_name")%> |
| 2. Educational Qualification: |
<%=qualification1%>
<% if (qualification1 != "")
{
%> - <%=request.getParameter("yop_bed")%>
<% }
%>
<%=qualification2%>
<% if (qualification2 != "")
{
%> - <%=request.getParameter("yop_med")%>
<% }
%>
|
| 3. Date of Birth: |
<%=request.getParameter("date_of_birth")%> |
| 4. Current Address: |
<%=request.getParameter("present_address")%> |
| 5. Phone No:(Residence) |
<%=request.getParameter("country_code_res")%> - <%=request.getParameter("std_code_res")%> - <%=request.getParameter("phone_res")%> |
| 6. E-mail: |
<%=request.getParameter("e_mail")%> |
| 7. Present Employment Record: |
<%=request.getParameter("organization")%> - <%=request.getParameter("present_designation")%> |
| 8. Phone No:(Office) |
<%=request.getParameter("country_code_off")%> - <%=request.getParameter("std_code_off")%> - <%=request.getParameter("phone_off")%> |
| 9. Previous Service Record: |
<% if (request.getParameter("previous_service_record") != null && !request.getParameter("previous_service_record").equals(""))
{
%> <%=request.getParameter("previous_service_record")%> |
<% }
else
{
%> -- |
<% }
%>
| 10. Other Achievements: |
<% if (request.getParameter("other_achievements") != null && !request.getParameter("other_achievements").equals(""))
{
%> <%=request.getParameter("other_achievements")%> |
<% }
else
{
%> -- |
<% }
%>
<%@ page import="java.sql.*" %>
<%@ page language="java" import="java.util.*,javax.mail.*,javax.mail.internet.*,javax.activation.*"%>
<%
String connectionURL = "jdbc:mysql://localhost/sldaveducation_org?user=sldavedu&password=sdvedu88"; // SLDAV
// String connectionURL = "jdbc:mysql://localhost/sldaveducation_org?user=kiran&password=mysql"; // CT
Connection connection = null;
Statement statement = null;
ResultSet getMaxAlumniDetailRS = null;
PreparedStatement pstmt=null;
int insertResult=0;
int alumni_id = 0;
%>
<%
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); // MySQL Driver Loaded
connection = DriverManager.getConnection(connectionURL, "", ""); // Connected to Database
String insertAlumniDetails = "insert into alumni_reg(title,first_name,last_name,eq1,eq1_yop,eq2,eq2_yop,date_of_birth,present_address,phone_off,phone_res,e_mail,present_org,present_desig,prev_service_record,other_achvments) values('" +
request.getParameter("title") + "','" +
request.getParameter("first_name") + "','" +
request.getParameter("last_name") + "','" +
qualification1 + "'," +
request.getParameter("yop_bed") + ",'" +
qualification2 + "'," +
request.getParameter("yop_med") + ",'" +
request.getParameter("date_of_birth") + "','" +
escapequote(request.getParameter("present_address")) + "','" +
phone_off + "','" +
phone_res + "','" +
request.getParameter("e_mail") + "','" +
escapequote(request.getParameter("organization")) + "','" +
escapequote(request.getParameter("present_designation")) + "','" +
escapequote(request.getParameter("previous_service_record")) + "','" +
escapequote(request.getParameter("other_achievements")) + "')";
pstmt=connection.prepareStatement(insertAlumniDetails);
insertResult=pstmt.executeUpdate(); //Inserted into database
statement = connection.createStatement();
String getMaxAlumniDetail = "select max(alumni_id) as alumni_id from alumni_reg "; // get Details of Latest Alumni
getMaxAlumniDetailRS = statement.executeQuery(getMaxAlumniDetail);
while(getMaxAlumniDetailRS.next())
{ // while loop starts
alumni_id = getMaxAlumniDetailRS.getInt("alumni_id");
} // end of while
}
catch(Exception e)
{
System.out.println("error in inserting:::::::"+e);
}
finally
{
try
{
if(pstmt!=null)pstmt.close(); // Close the Statement
if(connection!=null)connection.close(); // Close the Connection
}
catch(Exception er){}
}
/**********************START OF SEND MAIL********************/
String user_email="admin@sldaveducation.org"; // From Address
String subject="New Alumni Registration"; // Subject
String to="sldav@emmtel.com"; // To Address
// String to="kiran.gobbur@vardhmansoft.com"; // To Address
String bcc="alka.gupta@vardhmansoft.com"; // Bcc Address
try
{//try block starts
String host="64.62.154.65"; // IP Address of the mail server to whom u want to send mail
boolean sessionDebug=false;
Properties props=System.getProperties();
props.put("mail.smtp.host",host);//mail.smtp.host
props.put("mail.transport.protocol","smtp");
Session mailsession=Session.getDefaultInstance(props,null);
mailsession.setDebug(sessionDebug);
Message msg=new MimeMessage(mailsession);
msg.setFrom(new InternetAddress(user_email));
InternetAddress inaddress=new InternetAddress();
InternetAddress[] inn=inaddress.parse(to); // To Address
InternetAddress[] inn2=inaddress.parse(bcc); // Bcc Address
msg.setRecipients(Message.RecipientType.TO,inn); // To Address
msg.setRecipients(Message.RecipientType.BCC,inn2); // Bcc Address
msg.setSubject(subject);
msg.setSentDate(new java.util.Date());
//Sending Mail in HTML Format
msg.setContent("A New Alumni has been registered with the following details: | Name : | " + request.getParameter("title") + " " + request.getParameter("first_name") + " " + request.getParameter("last_name") + " | | Educational Qualification : | " + qualification1 + " " + yop_bed + "
"+ qualification2 + " " + yop_med +" | | Date of Birth : | " + request.getParameter("date_of_birth") + " | | Current Address : | " + request.getParameter("present_address") + " | | Phone No:(Residence) | " + phone_res + " | | E-mail : | " + request.getParameter("e_mail") + " | | Present Employment Record : | " + request.getParameter("organization") + " - " + request.getParameter("present_designation") + " | | Phone No:(Office) | " + phone_off + " | | Previous Service Record : | " + previous_service_record + " | | Other Achievements : | " + other_achievements + " |
Please Confirm by logging on to http://www.sldaveducation.org/alumni_admin.jsp ", "text/html");
Transport.send(msg); // Mail Sent
}//try block ends
catch(Exception e)
{
System.out.println(e);
}
/**********************END OF SEND MAIL ********************/
%>
<%
}
else if (!flag)
{ // border="1" bordercolorlight="#E4EAF5" bordercolordark="#FFFFFF"
%>
Fields marked with * are mandatory
<% }
%>
|
© Copyright 2003 Sohan Lal DAV College of Education, Ambala. | Privacy
Policy |
Site Designed and Maintained by VardhmanSoft, Ambala, India. |