%
// Prepared By : Anup Kumar
// Prepared Date : 17-04-2007
// Logic : To enter the user feedback for Barrackpore Cantonment Board details
// Client Name : Barrackpore Cantonment Board.
// Company Name : Descon Ltd,kolkata
// Updated By :
// Update Date :
%>
<%@page import="com.cb.cbbean.*,java.sql.*,java.util.*"%>
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%!
ResultSet rs=null;//to store records
int i=0;//for increment value
int count=0;//to count records in table
String check="";//to store value of val
%>
<%
check=request.getParameter("val");
if(check!=null)// && check.equals("post"))
{
String name=request.getParameter("name");//fetch visitor name
String address=request.getParameter("address");//fetch address
String phoneNo=request.getParameter("phoneno");//fetch phone no
String mobNo=request.getParameter("mobile");//fetch mobile no of visitor
String mailId=request.getParameter("email");//fetch mail id
String comment=request.getParameter("comments");//fetch user comments
try
{
cb.makeConnection();//establish connection
cb.setSql("insert into tbl_user_feedback(name,address,phone,mobile,email,comments) values(?,?,?,?,?,?)");
cb.setResultSet(0);
cb.setSPara(1,name);
cb.setSPara(2,address);
cb.setSPara(3,phoneNo);
cb.setSPara(4,mobNo);
cb.setSPara(5,mailId);
cb.setSPara(6,comment);
cb.insertData();
check=null;
response.sendRedirect("Thanks.jsp");
}
catch(Exception e)
{
check=null;
System.out.print("exception is :"+e.toString());
}
}
%>
: : WELCOME TO BARRACKPORE CANTONMENT BOARD WEBSITE : :
� Copyright Cantonment Board,
Barrackpore 2005, This site can be best viewed
at 800 x 600 resolution
Site developed, hosted & maintained by descon Limited,
Kolkata, India. Call us at 91 033-2357 4308/4309/4310 Fax: 91 033 2357
3758