1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Data Retrieval-Separated JSP and HTML files (How to?)

Discussion in 'JSP' started by IamNew, Aug 16, 2012.

  1. IamNew

    IamNew New Member

    Joined:
    Nov 29, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    Hi there,

    I am currently developing a web application. I have created one file with .jsp extension which combining both JSP and HTML codes. But for some purposes, I need to separate them into .jps and .html file accordingly without affection their function. How I possibly do that?

    Here is my codes: (Example.jsp)
    Code:
    <%@ page language = "java" contentType = "text/html; charset = ISO-8859-1"
             import = "java.lang.*, java.util.*, java.text.*, java.sql.*"
    %>
    <jsp:useBean id="utilObj" class="beanPackage.UtilBean" scope="page"/>
    <jsp:useBean id="dbObj" class="beanPackage.DatabaseBean" scope="page"/>
    <jsp:useBean id="formatObj" class="beanPackage.FormatBean" scope="page"/>
    <%
    
    // mobile app variables
    String strLicNo        = request.getParameter("LicNo");
    
    // variables to display data
    Vector arrLicName  = new Vector();  // to store licensee name
    Vector arrBussName = new Vector();  // to store business name
    Vector arrLicNo = new Vector(); // to store license no
    Vector arrAdd1 = new Vector();      // to store address 1
    Vector arrAdd2 = new Vector();      // to store address 2
    Vector arrAdd3 = new Vector();      // to store address 3
    Vector arrPostcode = new Vector();  // to store postcode
    Vector arrCityName = new Vector();  // to store city name
    Vector arrStateName = new Vector();  // to store state name
    Vector arrCountryName = new Vector();  // to store country name
    Vector arrEffectDate = new Vector();  // to store effective date
    Vector arrLicType  = new Vector();  // to store remarks
    
    
    
    // database parameters
    Connection ocon  = null;
    Statement stmt   = null;
    ResultSet rs     = null;
    String strSQL    = "";
    
    try {
      ocon = dbObj.getConnection();
      stmt = ocon.createStatement();
      
      strSQL = "SELECT T15_00010.LICENSEE_NAME, T15_00020.BUSINESS_NAME, T15_00030.LIC_NO, ";
      strSQL += "T15_00021.ADDRESS1, T15_00021.ADDRESS2, T15_00021.ADDRESS3, ";
      strSQL += "T15_00021.POSTCODE, T_UM_CITY.CITY_NAME, T_UM_STATE.STATE_NAME, T_UM_COUNTRY.COUNTRY_NAME, ";
      strSQL += "T15_00033.PRINCIPAL_LICENSE, T15_00034.EFFECTIVE_DATE, T15_00034.EXPIRY_DATE, T01_15050.DESCRIPTION ";
      strSQL += "FROM T15_00010, T15_00020, T15_00021, T15_00030, T15_00033, T15_00034, T01_15050, T_UM_CITY, T_UM_STATE, T_UM_COUNTRY ";
      strSQL += "WHERE T15_00020.T15_00010_OBJECTID = T15_00010.OBJECTID ";
      strSQL += "AND T15_00021.T15_00020_OBJECTID = T15_00020.OBJECTID ";
      strSQL += "AND T15_00030.T15_00020_OBJECTID = T15_00020.OBJECTID ";
      strSQL += "AND T15_00033.T15_00030_OBJECTID = T15_00030.OBJECTID ";
      strSQL += "AND T15_00033.T01_15050_OBJECTID = T01_15050.OBJECTID ";
      strSQL += "AND T15_00034.T15_00033_OBJECTID = T15_00033.OBJECTID ";
      strSQL += "AND T_UM_CITY.CITY_CODE = T15_00021.CITY ";
      strSQL += "AND T_UM_STATE.STATE_CODE = T15_00021.STATE ";
      strSQL += "AND T_UM_COUNTRY.COUNTRY_CODE = T15_00021.COUNTRY ";
      strSQL += "AND T15_00030.LIC_NO = '"+strLicNo+"' ";
      strSQL += "GROUP BY T01_15050.CODE ";
      System.out.println(strSQL);
      rs = stmt.executeQuery(strSQL);
        
        while (rs.next()){
          arrLicName.add(rs.getString("T15_00010.LICENSEE_NAME"));
          arrBussName.add(rs.getString("T15_00020.BUSINESS_NAME"));
          arrLicNo.add(rs.getString("T15_00030.LIC_NO"));
          arrAdd1.add(rs.getString("T15_00021.ADDRESS1"));
          arrAdd2.add(rs.getString("T15_00021.ADDRESS2"));
          arrAdd3.add(rs.getString("T15_00021.ADDRESS3"));
          arrPostcode.add(rs.getString("T15_00021.POSTCODE"));
          arrCityName.add(rs.getString("T_UM_CITY.CITY_NAME"));
          arrStateName.add(rs.getString("T_UM_STATE.STATE_NAME"));
          arrCountryName.add(rs.getString("T_UM_COUNTRY.COUNTRY_NAME"));
          arrEffectDate.add(formatObj.dateDisplayFormat(rs.getString("T15_00034.EFFECTIVE_DATE")));
          arrLicType.add(rs.getString("T01_15050.DESCRIPTION"));
        }
      }
    
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {        
      // close ResultSet and Statement
      try { if(rs != null) rs.close(); } catch (Exception e) { e.printStackTrace(); }
      try { if(stmt != null) stmt.close(); } catch (Exception e) { e.printStackTrace(); }
      try { if(ocon != null) ocon.close(); } catch (Exception e) { e.printStackTrace(); }
    }
    
    %>
    <html>
      <head>
    	<link rel="stylesheet" href="images/style.css" type="text/css" />
    	<title>Licensing</title>
      </head>
    <body>
     <%-- <tr>
        <div id="topbar">
          <div align="right" style="padding:12px;" class="smallwhitetext"><a href="../home.jsp">Home</a> | <a href="../Outstanding_Bill/outstanding_bill.jsp" title="Outstanding Bill">Outstanding Bill</a> | <a href="license_list.jsp" title="License List">License Listing</a></div>
    		</div>
    	</tr>--%>
      <tr>
        <table width="98%" border="0" cellspacing="1" cellpadding="1">
          <tr>
            <td width="150px">
              <div class="logotext" style="margin:30px"><span class="orangelogotext">Licensing</span></div> 
            </td>
            <td>
              <div id="contenttext">
                <div class="bodytext" style="padding:12px;" align="justify">
                  <%-- License No., Licensee Name and Business Name --%>
                  <%--<table width="98%" border="0" cellspacing="1" cellpadding="1">
                    <tr><td colspan="3" class="TableHeader">License Search</td></tr>
                   <%-- <tr>
                      <td class="TableLabel" width="150px">License No.</td>
                      <td class="TableDetail1" width="500px">
                        <INPUT type="submit" value="Search">
                      </td>
                    </tr>--%>
                    <%--<tr>
                      <td class="TableLabel" width="150px">Licensee Name</td>
                      <td class="TableDetail1" width="500px">
                        <%=formObj.drawTextField("text", "strLicName", "", strTextLen, "", "0", "")%>
                      </td>
                    </tr>
                    <tr>
                      <td class="TableLabel" width="150px">Business Name</td>
                      <td class="TableDetail1" width="500px">
                        <%=formObj.drawTextField("text", "strBusinessName", "", strTextLen, "", "0", "")%>
                        <INPUT type="submit" value="Search">
                      </td>
                    <tr> 
                  </table>--%>
                  <%
            out.print("<table width=\"100%\" border=0 cellspacing=\"1\" cellpadding=\"1\">");
            out.print("<tr><td colspan=\"13\" class=\"TableHeader\"><strong>License List</strong></td></tr>");
            out.print("<tr><td class=\"TableLabel\">No.</td>");
            out.print("<td class=\"TableLabel\">Licensee Name</td>");
            out.print("<td class=\"TableLabel\">Business Name</td>");
            out.print("<td class=\"TableLabel\">License No</td>");
            out.print("<td class=\"TableLabel\">Address 1</td>");
            out.print("<td class=\"TableLabel\">Address 2</td>");
            out.print("<td class=\"TableLabel\">Address 3</td>");
            out.print("<td class=\"TableLabel\">Postcode</td>");
            out.print("<td class=\"TableLabel\">City Name</td>");
            out.print("<td class=\"TableLabel\">State Name</td>");
            out.print("<td class=\"TableLabel\">Country Name</td>");
            out.print("<td class=\"TableLabel\">License Type</td>");
            out.print("<td class=\"TableLabel\">Effective Date</td>");
            out.print("<td>&nbsp</td></tr>");
            
            int intTotKids = arrLicName.size();
                      int rowCount = 1;
                      String segTable;
                      String rowLabel = "";
                          
                      for (int intDraw=0; intDraw<intTotKids; intDraw++) {
                        if (intDraw%2==0) 
                          rowLabel = "rowLabelEven"; 
                        else
                          rowLabel = "rowLabelOdd";
              
              segTable = "<tr>";
              segTable += "<td class=\""+rowLabel+"\">"+rowCount+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrLicName.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrBussName.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrLicNo.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrAdd1.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrAdd2.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrAdd3.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrPostcode.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrCityName.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrStateName.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrCountryName.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrLicType.get(intDraw)+"</td>";
              segTable += "<td class=\""+rowLabel+"\">"+arrEffectDate.get(intDraw)+"</td>";
              segTable += "</tr>";
              out.print(segTable);
              rowCount++;
            }
                  %>
                </div>
              </div>
            </td>
          </tr>
        </table>
      </tr>  
    </body>
    </html>
    
    I wish to separate the code into example.jsp which only does the processing and the .html only display the result. Please advise. Thanks in advance.
     
  2. alia123

    alia123 New Member

    Joined:
    Jan 8, 2016
    Messages:
    65
    Likes Received:
    3
    Trophy Points:
    0

Share This Page