<%@ page import=" com.zaax.connections.*" %>
<%@ page import= "java.sql.*" %>
<%@ page import= "java.util.*" %>
| Insurance Company Details
|
<%
try{
String UWID=(String)session.getAttribute("UWID");
Connection con = null;
ConnectionDB conDB=null;
conDB = new ConnectionDB();
con=conDB.returnConnection();
String Query1="select upper(name) as name,nvl(ad.address1,' ' ) address1, nvl(ad.address2,' ') address2, nvl(ad.city,' ') city, nvl(ad.pincode,' ') pincode, nvl(ad.contactemail,' ') contactemail, nvl(ad.contactphone,' ') contactphone, nvl(ad.faxno,' ') faxno from underwriters uw inner join addresses ad on uw.addressid=ad.id where uw.id="+UWID;
Statement stmt=con.createStatement();
//out.println(Query1);
ResultSet rs1 = stmt.executeQuery(Query1);
if(rs1.next()){
%>
| Name: |
<%=rs1.getString("name")%> |
| Address1: |
<%=rs1.getString("address1")%> |
| Address2: |
<%=rs1.getString("address2")%> |
| City: |
<%=rs1.getString("city")%> |
| Pincode: |
<%=rs1.getString("pincode")%> |
| Contact Email: |
<%=rs1.getString("contactemail")%> |
| Contact Phone: |
<%=rs1.getString("contactphone")%> |
| Fax No: |
<%=rs1.getString("faxno")%> |
|
<% }
%>
<%
con.close();
} catch(Exception e) {
out.print("
Error :"+e);
}
%>
<%@ include file="footer.jsp" %>