Download - matrimony sample abstract
-
7/30/2019 matrimony sample abstract
1/66
-
7/30/2019 matrimony sample abstract
2/66
Application for Temporary connection
/* TempPhoneConnControler.java */
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class TempPhoneConnControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
TempConnectionDetailsModel cdm=new TempConnectionDetailsModel();
cdm.setName(request.getParameter("name"));
cdm.setAddress(request.getParameter("address"));
cdm.setGender(Integer.parseInt(request.getParameter("gender")));
cdm.setPassword(request.getParameter("pass"));
cdm.setPurpose(Integer.parseInt(request.getParameter("purpose")));
cdm.setFacility(Integer.parseInt(request.getParameter("facility")));
cdm.setFromDate(request.getParameter("fday")+"-"+request.getParameter("fmonth")+"-
"+request.getParameter("fyear"));
cdm.setToDate(request.getParameter("tday")+"-"+request.getParameter("tmonth")+"-
"+request.getParameter("tyear"));
-
7/30/2019 matrimony sample abstract
3/66
DemandDraftModel ddm=new DemandDraftModel();
ddm.setName(request.getParameter("bank_name"));
ddm.setBranch(request.getParameter("branch"));
ddm.setDate(request.getParameter("day")+"-"+request.getParameter("month")+"-
"+request.getParameter("year"));
ddm.setAmount(Double.parseDouble(request.getParameter("amount")));
ddm.setDraft_no(request.getParameter("ddno"));
if(ddm.insert())
{
System.out.println("DD insert");
cdm.setDD_id(ddm.getDD_id());
if (cdm.insert())
{
request.setAttribute("request_id",cdm.getReq_id()+"");
RequestDispatcher rd=request.getRequestDispatcher("NewPhoneConnConfirm.jsp");
rd.forward(request,response);
}
else
{
ddm.remove();
request.setAttribute("error","Unable to create the record");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
}
else
-
7/30/2019 matrimony sample abstract
4/66
{
request.setAttribute("error","Unable to create the DD record");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
/*
* TempConnectionDetailsModel.java
*/
package com.telecom;
-
7/30/2019 matrimony sample abstract
5/66
import java.sql.*;
public class TempConnectionDetailsModel implements java.io.Serializable {
private int reg_id;
private String name;
private String password;
private int gender;
private String address;
private int purpose;
private int facility;
private int dd_id;
private String confirmed,from_date,to_date;
public TempConnectionDetailsModel() {
}
public void setReq_id(int s) {
reg_id=s;
}
public void setName(String s) {
name=s;
}
public void setPassword(String s) {
password=s;
}
public void setGender(int s) {
gender=s;
}
-
7/30/2019 matrimony sample abstract
6/66
public void setAddress(String s) {
address=s;
}
public void setPurpose(int s) {
purpose=s;
}
public void setFacility(int s) {
facility=s;
}
public void setDD_id(int s) {
dd_id=s;
}
public void setConfirmed(String s) {
confirmed=s;
}
public void setFromDate(String s) {
from_date=s;
}
public void setToDate(String s) {
to_date=s;
}
public int getReq_id() {
return reg_id;
-
7/30/2019 matrimony sample abstract
7/66
}
public String getName() {
return name;
}
public String getPassword() {
return password;
}
public int getGender() {
return gender;
}
public String getAddress() {
return address;
}
public int getPurpose() {
return purpose;
}
public int getFacility() {
return facility;
}
public int getDD_id() {
return dd_id;
}
public String getConfirmed() {
return confirmed;
}
-
7/30/2019 matrimony sample abstract
8/66
public String getFromDate() {
return from_date;
}
public String getToDate() {
return to_date;
}
public boolean update()
{
try
{
Connection con=MyDriver.getConnection();
PreparedStatement ps=con.prepareStatement("update temp_connections_details set
purpose=?,facility=? where req_id=?)");
ps.setInt(1,getPurpose());
ps.setInt(2,getFacility());
ps.setInt(3,getReq_id());
int i=ps.executeUpdate();
if (i==1)
return true;
}
catch(Exception e)
{e.printStackTrace();}
return false;
-
7/30/2019 matrimony sample abstract
9/66
}
public boolean insert()
{
try
{
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select max(req_id) from temp_connections_details");
rs.next();
setReq_id(rs.getInt(1)+1);
rs.close();
st.close();
PreparedStatement ps=con.prepareStatement("insert into temp_connections_details
values(?,?,?,?,?,?,?,?,?,?,?)");
ps.setInt(1,getReq_id());
ps.setString(2,getName());
ps.setString(3,getPassword());
ps.setInt(4,getGender());
ps.setString(5,getAddress());
ps.setInt(6,getPurpose());
ps.setInt(7,getFacility());
ps.setInt(8,getDD_id());
ps.setString(9,getConfirmed());
ps.setString(10,getFromDate());
-
7/30/2019 matrimony sample abstract
10/66
ps.setString(11,getToDate());
int i=ps.executeUpdate();
if (i==1)
return true;
}
catch(Exception e)
{e.printStackTrace();}
return false;
}
public void load()
{
try
{
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
ResultSet ps=st.executeQuery("select * from temp_connections_details where
req_id="+getReq_id());
if(ps.next())
{
setName(ps.getString(2));
setPassword(ps.getString(3));
setGender(ps.getInt(4));
setAddress(ps.getString(5));
setPurpose(ps.getInt(6));
-
7/30/2019 matrimony sample abstract
11/66
setFacility(ps.getInt(7));
setDD_id(ps.getInt(8));
setConfirmed(ps.getString(9));
setFromDate(ps.getString(10));
setToDate(ps.getString(11));
}
}
catch(Exception e)
{e.printStackTrace();}
}
}
Related Links
-
7/30/2019 matrimony sample abstract
12/66
TELECOM SERVICES
Home
Applications
-
7/30/2019 matrimony sample abstract
13/66
src="images/buttonright.gif" width=10>
Entries
Enquiries
Complaints
-
7/30/2019 matrimony sample abstract
14/66
vAlign=center background=images/buttonmiddle.gif class=tabs>About
US
Confirmation for New Phone
-
7/30/2019 matrimony sample abstract
15/66
Connection Request
Your Application has been accepted and will be processed.
Your Request ID is .
Use this Request ID and Password (Entered in the application
form) for further enquiries.
-
7/30/2019 matrimony sample abstract
16/66
Thank You
Home
Applications
-
7/30/2019 matrimony sample abstract
17/66
src="images/bullet.gif" width=15>
Entries
Enquiries
Complaints
About US
-
7/30/2019 matrimony sample abstract
18/66
/*
* MyDriver.java
*/
package com.telecom;
import java.sql.*;
public class MyDriver {
/** Creates a new instance of MyDriver */
private MyDriver() {}
static Connection con;
public static Connection getConnection()throws Exception
{
if (con==null)
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","man");
}
else
{
if(con.isClosed())
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system", "man");
}
-
7/30/2019 matrimony sample abstract
19/66
}
return con;
}
}
TempPhoneConnection.jsp
Related Links
TELECOM SERVICES
-
7/30/2019 matrimony sample abstract
20/66
Home
Applications
Entries
-
7/30/2019 matrimony sample abstract
21/66
src="images/buttonright.gif" width=10>
Enquiries
Complaints
About
US
-
7/30/2019 matrimony sample abstract
22/66
width=9>
Error
-
7/30/2019 matrimony sample abstract
23/66
Message :
Home
-
7/30/2019 matrimony sample abstract
24/66
href="Applications.html">Applications
Entries
Enquiries
Complaints
About US
-
7/30/2019 matrimony sample abstract
25/66
Application for NewConnection
/* * NewPhoneConnControler.java */
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class NewPhoneConnControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
ConnectionDetailsModel cdm=new ConnectionDetailsModel();
cdm.setName(request.getParameter("name"));
cdm.setAddress(request.getParameter("address"));
cdm.setGender(Integer.parseInt(request.getParameter("gender")));
cdm.setPassword(request.getParameter("pass"));
cdm.setPurpose(Integer.parseInt(request.getParameter("purpose")));
cdm.setFacility(Integer.parseInt(request.getParameter("facility")));
DemandDraftModel ddm=new DemandDraftModel();
ddm.setName(request.getParameter("bank_name"));
-
7/30/2019 matrimony sample abstract
26/66
ddm.setBranch(request.getParameter("branch"));
ddm.setDate(request.getParameter("day")+"-"+request.getParameter("month")+"-
"+request.getParameter("year"));
ddm.setAmount(Double.parseDouble(request.getParameter("amount")));
ddm.setDraft_no(request.getParameter("ddno"));
if(ddm.insert())
{
System.out.println("DD insert");
cdm.setDD_id(ddm.getDD_id());
if (cdm.insert())
{
request.setAttribute("request_id",cdm.getReq_id()+"");
RequestDispatcher rd=request.getRequestDispatcher("NewPhoneConnConfirm.jsp");
rd.forward(request,response);
}
else
{
ddm.remove();
request.setAttribute("error","Unable to create the record");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
-
7/30/2019 matrimony sample abstract
27/66
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
-
7/30/2019 matrimony sample abstract
28/66
Application for modification
/*
* UpdateConnControler.java
*/
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class UpdateConnControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
ConnectionDetailsModel cdm=new ConnectionDetailsModel();
cdm.setReq_id(Integer.parseInt(request.getParameter("id")));
cdm.load();
if(cdm.getName().equals(request.getParameter("name"))&&cdm.getPassword().equals(request.getParameter("pass")))
{
request.setAttribute("id",cdm.getReq_id()+"");
request.setAttribute("name",cdm.getName()+"");
-
7/30/2019 matrimony sample abstract
29/66
request.setAttribute("phoneno",request.getParameter("phoneno")+"");
RequestDispatcher rd=request.getRequestDispatcher("Modifications.jsp");
rd.forward(request,response);
}
else
{
request.setAttribute("error","Name or Password is in correct");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
-
7/30/2019 matrimony sample abstract
30/66
/*
* UpdateConnControler1.java
*/
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class UpdateConnControler1 extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
ConnectionDetailsModel cdm=new ConnectionDetailsModel();
cdm.setReq_id(Integer.parseInt(request.getParameter("id")));
cdm.setPurpose(Integer.parseInt(request.getParameter("purpose")));
cdm.setPurpose(Integer.parseInt(request.getParameter("facility")));
if (cdm.update())
{
RequestDispatcher rd=request.getRequestDispatcher("ModificationsConfirm.html");
rd.forward(request,response);
}
-
7/30/2019 matrimony sample abstract
31/66
else
{
request.setAttribute("error","Problem while Updating Data try again");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
-
7/30/2019 matrimony sample abstract
32/66
Application for Phone Transfer
/* * PhoneTransferControler.java */
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class PhoneTransferControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
TransferModel cdm=new TransferModel();
cdm.setName(request.getParameter("name"));
cdm.setPhone_no(Integer.parseInt(request.getParameter("phoneno")));
cdm.setPresent_address(request.getParameter("p_address"));
cdm.setNew_address(request.getParameter("n_address"));
DemandDraftModel ddm=new DemandDraftModel();
ddm.setName(request.getParameter("bank_name"));
ddm.setBranch(request.getParameter("branch"));
-
7/30/2019 matrimony sample abstract
33/66
ddm.setDate(request.getParameter("day")+"-"+request.getParameter("month")+"-
"+request.getParameter("year"));
ddm.setAmount(Double.parseDouble(request.getParameter("amount")));
ddm.setDraft_no(request.getParameter("ddno"));
if(ddm.insert())
{
System.out.println("DD insert");
cdm.setBankDeatilsID(ddm.getDD_id());
if (cdm.insert())
{
request.setAttribute("request_id",cdm.getReq_id()+"");
RequestDispatcher rd=request.getRequestDispatcher("PhoneTransferConfirm.jsp");
rd.forward(request,response);
}
else
{
ddm.remove();
request.setAttribute("error","Unable to create the record");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
}
else
{
-
7/30/2019 matrimony sample abstract
34/66
request.setAttribute("error","Unable to create the DD record");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
-
7/30/2019 matrimony sample abstract
35/66
/*
* TransferModel.java
*/
package com.telecom;
import java.sql.*;
public class TransferModel {
public TransferModel() {
}
private int req_id;
private int phone_no;
private String name;
private String present_address;
private String new_address;
private int bank_details_id;
private String status;
public void setReq_id(int s)
{
req_id=s;
}
public void setPhone_no(int s)
{
phone_no=s;
}
-
7/30/2019 matrimony sample abstract
36/66
public void setName(String s)
{
name=s;
}
public void setPresent_address(String s)
{
present_address=s;
}
public void setNew_address(String s)
{
new_address=s;
}
public void setBankDeatilsID(int i)
{
bank_details_id=i;
}
public void setStatus(String s)
{
status=s;
}
public int getReq_id()
{
-
7/30/2019 matrimony sample abstract
37/66
return req_id;
}
public int getPhone_no()
{
return phone_no;
}
public String getName()
{
return name;
}
public String getPresent_address()
{
return present_address;
}
public String getNew_address()
{
return new_address;
}
public int getBankDeatilsID()
{
return bank_details_id;
}
public String getStatus()
{
-
7/30/2019 matrimony sample abstract
38/66
return status;
}
public boolean insert()
{
try
{
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select max(req_id) from phone_transfer_request");
rs.next();
setReq_id(rs.getInt(1)+1);
rs.close();
st.close();
PreparedStatement ps=con.prepareStatement("insert into phone_transfer_request
values(?,?,?,?,?,?,?)");
ps.setInt(1,getReq_id());
ps.setInt(2,getPhone_no());
ps.setString(3,getName());
ps.setString(4,getPresent_address());
ps.setString(5,getNew_address());
ps.setInt(6,getBankDeatilsID());
ps.setString(7,getStatus());
-
7/30/2019 matrimony sample abstract
39/66
int i=ps.executeUpdate();
if (i==1)
return true;
}
catch(Exception e)
{e.printStackTrace();}
return false;
}
public void load()
{
try
{
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
ResultSet ps=st.executeQuery("select * from phone_transfer_request where
req_id="+getReq_id());
if(ps.next())
{
setPhone_no(ps.getInt(2));
setName(ps.getString(3));
setPresent_address(ps.getString(4));
setNew_address(ps.getString(5));
-
7/30/2019 matrimony sample abstract
40/66
setBankDeatilsID(ps.getInt(6));
setStatus(ps.getString(7));
}
}
catch(Exception e)
{e.printStackTrace();}
}
}
-
7/30/2019 matrimony sample abstract
41/66
Application for phone cancellation
/*
* CancellationControler.java
*/
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CancellationControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
CancellationModel cdm=new CancellationModel();
cdm.setReq_Id(Integer.parseInt(request.getParameter("id")));
cdm.setName(request.getParameter("name"));
cdm.setPhoneNo(Integer.parseInt(request.getParameter("phoneno")));
if (cdm.insert())
{
-
7/30/2019 matrimony sample abstract
42/66
request.setAttribute("request_id",cdm.getCancle_Id()+"");
RequestDispatcher
rd=request.getRequestDispatcher("PhoneCancellationConfirm.jsp");
rd.forward(request,response);
}
else
{
request.setAttribute("error","Error while processing the request");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
-
7/30/2019 matrimony sample abstract
43/66
/*
* CancellationModel.java
*/
package com.telecom;
import java.sql.*;
public class CancellationModel {
public CancellationModel() {
}
private int req_id,cancle_id,phone_no;
public void setReq_Id(int i)
{
req_id=i;
}
public void setCancle_Id(int i) {
cancle_id=i;
}
public void setPhoneNo(int i) {
phone_no=i;
}
public int getReq_Id()
{
return req_id;
}
public int getCancle_Id()
-
7/30/2019 matrimony sample abstract
44/66
{
return cancle_id;
}
public int getPhoneNo()
{
return phone_no;
}
public boolean insert()
{
try {
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select max(cancle_id) from phone_cancellation");
rs.next();
setCancle_Id(rs.getInt(1)+1);
rs.close();
st.close();
PreparedStatement ps=con.prepareStatement("insert into phone_cancellation
values(?,?,?)");
ps.setInt(1,getCancle_Id());
ps.setInt(2,getReq_Id());
-
7/30/2019 matrimony sample abstract
45/66
ps.setInt(3,getPhoneNo());
int i=ps.executeUpdate();
if (i==1)
return true;
}
catch(Exception e)
{e.printStackTrace();}
return false;
}
public void load() {
try {
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
ResultSet ps=st.executeQuery("select * from phone_cancellation where
cancle_id="+getCancle_Id());
if(ps.next()) {
setReq_Id(ps.getInt(2));
setPhoneNo(ps.getInt(3));
} }
catch(Exception e)
{e.printStackTrace();}
}
}
-
7/30/2019 matrimony sample abstract
46/66
ENTRIES
CHANGED NUMBER ENTRIES
/* * ChangedNumberEntryControler.java */
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ChangedNumberEntryControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
try
{
Connection con=MyDriver.getConnection();
-
7/30/2019 matrimony sample abstract
47/66
Statement st=con.createStatement();
int i=st.executeUpdate("insert into changedNumbers values
("+request.getParameter("old_no")+","+request.getParameter("new_no")+")");
if (i!=1)
{
request.setAttribute("error","Wrong Details");
RequestDispatcher rd=request.getRequestDispatcher("Error.html");
rd.forward(request,response);
return;
}
RequestDispatcher rd=request.getRequestDispatcher("ChangedNumberEntryConfirm.html");
rd.forward(request,response);
}
catch (Exception w)
{
w.printStackTrace();
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
-
7/30/2019 matrimony sample abstract
48/66
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
BILL ENTRY SYSTEM
/*
* BillEntryControler.java
*/
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class BillEntryControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
-
7/30/2019 matrimony sample abstract
49/66
try
{
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
int i=st.executeUpdate("insert into billdetails values
("+request.getParameter("phone_no")+","+request.getParameter("bill_no")+","+request.getPa
rameter("amount")+")");
if (i!=1)
{
request.setAttribute("error","Wrong Details");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
return;
}
RequestDispatcher rd=request.getRequestDispatcher("BillEntryConfirm.html");
rd.forward(request,response);
}
catch (Exception w)
{
w.printStackTrace();
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
-
7/30/2019 matrimony sample abstract
50/66
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
-
7/30/2019 matrimony sample abstract
51/66
ENQUIRES
APPLICATION ENQUIRY
Application enquiry for new connection:
* EnquiryForNewConnectionControler.java */
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class EnquiryForNewConnectionControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
ConnectionDetailsModel cdm=new ConnectionDetailsModel();
cdm.setReq_id(Integer.parseInt(request.getParameter("id")));
cdm.load();
request.setAttribute("name",cdm.getName()+"");
-
7/30/2019 matrimony sample abstract
52/66
request.setAttribute("address",cdm.getAddress()+"");
if ("y".equalsIgnoreCase(cdm.getConfirmed()))
request.setAttribute("status","Your application has been varified
.");
else
request.setAttribute("status","Your application has not been
varified.");
RequestDispatcher rd=request.getRequestDispatcher("EnquiryForNewConnectionConfirm.jsp");
rd.forward(request,response);
}
/** Handles the HTTP GET method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
/** Handles the HTTP POST method.
* @param request servlet request
* @param response servlet response
*/
-
7/30/2019 matrimony sample abstract
53/66
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
}
ENQUIRY FOR PHONE TRANSEFOR
/*
* EnquiryForPhoneTransferControler.java
*/
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class EnquiryForPhoneTransferControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
-
7/30/2019 matrimony sample abstract
54/66
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
TransferModel cdm=new TransferModel();
cdm.setReq_id(Integer.parseInt(request.getParameter("id")));
cdm.load();
request.setAttribute("tele_no",cdm.getPhone_no()+"");
request.setAttribute("name",cdm.getName()+"");
request.setAttribute("present_address",cdm.getPresent_address()+"");
request.setAttribute("new_address",cdm.getNew_address()+"");
if (cdm.getStatus()==null)
request.setAttribute("status","No Status Available");
else
request.setAttribute("status",cdm.getStatus()+"");
RequestDispatcher
rd=request.getRequestDispatcher("EnquiryForPhoneTransferConfirm.jsp");
rd.forward(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
-
7/30/2019 matrimony sample abstract
55/66
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
ENQIRY FOR TEMPORARY PHONE CONNECTION
/*
* EnquiryForTempPhoneConnectionControler.java
*/
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class EnquiryForTempPhoneConnectionControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
-
7/30/2019 matrimony sample abstract
56/66
throws ServletException, java.io.IOException {
response.setContentType("text/html");
TempConnectionDetailsModel cdm=new TempConnectionDetailsModel();
cdm.setReq_id(Integer.parseInt(request.getParameter("id")));
cdm.load();
request.setAttribute("name",cdm.getName()+"");
request.setAttribute("address",cdm.getAddress()+"");
if ("y".equalsIgnoreCase(cdm.getConfirmed()))
request.setAttribute("status","Your application has been varified and
a phone number has been allocated.");
else
request.setAttribute("status","Your application has not been
varified.");
request.setAttribute("fdate",cdm.getFromDate());
request.setAttribute("tdate",cdm.getToDate());
RequestDispatcher
rd=request.getRequestDispatcher("EnquiryForTempPhoneConnectionConfirm.jsp");
rd.forward(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
-
7/30/2019 matrimony sample abstract
57/66
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
BILL ENQUIRY
BillEnquiryControler.java
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class BillEnquiryControler extends HttpServlet
{
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
-
7/30/2019 matrimony sample abstract
58/66
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException
{
response.setContentType("text/html");
try
{
request.setAttribute("phone_no",request.getParameter("phone_no")+"");
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from billdetails where
phone_no="+request.getParameter("phone_no"));
if (rs.next())
{
request.setAttribute("billno",rs.getInt(2)+"");
request.setAttribute("billamount",rs.getDouble(3)+"");
}
else
{
request.setAttribute("error","Wrong Number");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
-
7/30/2019 matrimony sample abstract
59/66
RequestDispatcher rd=request.getRequestDispatcher("BillEnquiryConfirm.jsp");
rd.forward(request,response);
}
catch (Exception w)
{
w.printStackTrace();
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
-
7/30/2019 matrimony sample abstract
60/66
COMPLAINTS
/*
* ComplaintsControler.java
*/
package com.telecom;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ComplaintsControler extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
ComplaintsModel cdm=new ComplaintsModel();
cdm.setClientName(request.getParameter("client_name"));
cdm.setSubject(request.getParameter("subject"));
cdm.setMessage(request.getParameter("message"));
cdm.setPhoneNo(Integer.parseInt(request.getParameter("phoneno")));
if (cdm.insert())
{
-
7/30/2019 matrimony sample abstract
61/66
request.setAttribute("complaint_id",cdm.getComp_Id()+"");
RequestDispatcher rd=request.getRequestDispatcher("ComplaintsConfirm.jsp");
rd.forward(request,response);
}
else
{
request.setAttribute("error","Error while processing the request");
RequestDispatcher rd=request.getRequestDispatcher("Error.jsp");
rd.forward(request,response);
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
-
7/30/2019 matrimony sample abstract
62/66
/*
* ComplaintsModel.java
*/
package com.telecom;
import java.sql.*;
public class ComplaintsModel {
public ComplaintsModel() {
}
private int comp_id,phone_no;
private String subject,client_name,message;
public void setComp_Id(int i)
{
comp_id=i;
}
public void setPhoneNo(int i)
{
phone_no=i;
}
public void setSubject(String i)
{
subject=i;
}
public void setClientName(String i)
-
7/30/2019 matrimony sample abstract
63/66
{
client_name=i;
}
public void setMessage(String i)
{
message=i;
}
public int getComp_Id()
{
return comp_id;
}
public int getPhoneNo()
{
return phone_no;
}
public String getSubject()
{
return subject;
}
public String getClientName()
{
return client_name;
}
-
7/30/2019 matrimony sample abstract
64/66
public String getMessage()
{
return message;
}
public boolean insert()
{
try
{
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select max(comlaint_id) from complaints");
rs.next();
setComp_Id(rs.getInt(1)+1);
rs.close();
st.close();
PreparedStatement ps=con.prepareStatement("insert into complaints values(?,?,?,?,?)");
ps.setInt(1,getComp_Id());
ps.setString(2,getSubject());
ps.setInt(3,getPhoneNo());
ps.setString(4,getClientName());
ps.setString(5,getMessage());
-
7/30/2019 matrimony sample abstract
65/66
int i=ps.executeUpdate();
if (i==1)
return true;
}
catch(Exception e)
{e.printStackTrace();}
return false;
}
public void load()
{
try
{
Connection con=MyDriver.getConnection();
Statement st=con.createStatement();
ResultSet ps=st.executeQuery("select * from phone_cancellation where
comlaint_id="+getComp_Id());
if(ps.next())
{
setSubject(ps.getString(2));
setPhoneNo(ps.getInt(3));
setClientName(ps.getString(4));
setMessage(ps.getString(5));
}
-
7/30/2019 matrimony sample abstract
66/66
}
catch(Exception e)
{e.printStackTrace();}
}
}