<%@ page language="java" import="java.util.Properties,com.p2w.util.Init,com.p2w.util.IduDB_Change,com.p2w.util.VectoringChange,com.p2w.web.listener.SessionCounter,java.util.Enumeration,java.io.*,java.sql.SQLException,com.p2w.connection.DBConnectionManager"%> <%@ page import="java.util.*,com.p2w.util.VectoringChange,java.text.*" %> <%@ page import = "java.sql.*"%> <%@ page import = "java.io.*"%> <%@ page import = "org.apache.commons.io.*"%> <% String branch=((String)request.getParameter("branchname")==null)?"":request.getParameter("branchname"); String state=((String)request.getParameter("stateid")==null)?"":request.getParameter("stateid"); %> <% Init prop1 = new Init(); prop1.read("config.properties"); String propyear=prop1.get("acyear"); //System.out.println("acyear prop1=="+prop1.get("acyear")); HttpSession zforce = request.getSession(false); String str1 =((String)zforce.getValue("Error")== null)?"noError":(String)zforce.getValue("Error"); %> <% zforce = request.getSession(true); try { DBConnectionManager dbm = DBConnectionManager.getInstance(); } catch(SQLException sql) { System.out.println("main:" + sql); } catch(IOException ee) { System.out.println("classException:" + ee); } zforce.putValue("user_status","31"); %>
<% String branchstate=""; if (state.equals("1")) branchstate="Tamil Nadu"; else if (state.equals("2")) branchstate="Kerala"; else if (state.equals("3")) branchstate="Andhrapradesh"; else if (state.equals("4")) branchstate="Karnataka"; else if (state.equals("5")) branchstate="Maharashtra"; else if (state.equals("6")) branchstate="New Delhi"; else if (state.equals("7")) branchstate="Haryna"; %>

<%=branchstate%>  Branches

 
 
<% String brn=""; String brnid=""; String brqry=""; if (branch.equals("")) brqry="select hbrnid,hbrnname from gokul.ghbranchmast where state ='"+state+"' and hbrnid not like 'G%' and hbrnid not like 'H%' and hbrnid not like 'N%' and hbrnid not like 'R%' and hbrnid not in (select companyname from contacts where logtype='CRD') order by hbrnname"; else brqry="select hbrnid,hbrnname from gokul.ghbranchmast where state ='"+state+"' and upper(hbrnname) like upper('"+branch+"%') and hbrnid not like 'G%' and hbrnid not like 'H%' and hbrnid not like 'N%' and hbrnid not like 'R%' and hbrnid not in (select companyname from contacts where logtype='CRD') order by hbrnname"; System.out.println("brqry"+brqry); Vector brvec=(new VectoringChange(brqry)).getRead(request,response); if (brvec.size()>0) { int i=0; int a=brvec.size(); int b=a/5; //b=b+1; System.out.println("a"+a); System.out.println("b"+b); for (int r=0;r<=b;r++) { %> <% for (int c=0;c<5;c++) { if (i <%}%> <%}}%>
<%=brnid%> - <%=brn%>