<%-- schenkungsvertrag-immobilien.html --%> <%@ page contentType="text/html; charset=iso-8859-1" %> <% int i_db = 189; %> <%@ include file="/util/variable.jsp" %> <% synchronized(this) { String s_referrer = (String)session.getAttribute("jnVertrag.Referrer") == null ? "" : (String)session.getAttribute("jnVertrag.Referrer"); if (s_pid.equals("") && s_referrer.equals("")) { s_referrer = request.getHeader("Referer"); session.setAttribute("jnVertrag.Referrer", s_referrer); } String s_sid = (String)session.getAttribute("jnVertrag.sid"); if (s_sid == null) { s_sid = (String)session.getId() + "_" + request.getRemoteAddr(); session.setAttribute("jnVertrag.sid", s_sid); } int i_imsi = 0; String s_imsi = ""; String s_groupCode = "B"; String s_description = ""; Vector v_moduleCode = new Vector(); Vector v_moduleName = new Vector(); Vector v_groupCode = new Vector(); Vector v_amount = new Vector(); int i_discountCode01 = 0; String s_discountAmount01 = ""; int i_discountCode02 = 0; String s_discountAmount02 = ""; Vector v_discountCode = new Vector(); Vector v_discountAmount = new Vector(); int i = 0; Vector v_relevantCode = new Vector(); Vector v_relevantName = new Vector(); Vector v_relevantPfad = new Vector(); try { connModule = getConnection("jdbc/jnModule"); sql = "SELECT A.code, A.name, B.groupcode, B.amount " + " FROM Module A, PriceGroup B " + " WHERE A.parentcode = ? " + " AND A.pricegroupcode = B.groupcode " + " ORDER BY B.amount "; pstmt = connModule.prepareStatement(sql); pstmt.setInt(1, i_db); rs = pstmt.executeQuery(); while (rs.next()) { v_moduleCode.add(Integer.toString(rs.getInt(1))); v_moduleName.add(rs.getString(2)); v_groupCode.add(rs.getString(3)); v_amount.add(rs.getString(4)); } } catch(SQLException e) { e.printStackTrace(); } finally { try { rs.close(); pstmt.close(); connModule.close(); } catch (Exception e) {} } try { connModule = getConnection("jdbc/jnModule"); sql = "SELECT DISTINCT(relevantcode) "+ " FROM ModuleRelevantPreface "+ " WHERE modulecode = ? "; pstmt = connModule.prepareStatement(sql); pstmt.setInt(1, i_db); rs = pstmt.executeQuery(); while (rs.next()) { v_relevantCode.add(Integer.toString(rs.getInt(1))); } } catch(SQLException e) { e.printStackTrace(); } finally { try { rs.close(); pstmt.close(); connModule.close(); } catch (Exception e) {} } for (i=0; i < v_relevantCode.size(); i++) { try { connModule = getConnection("jdbc/jnModule"); sql = "SELECT name, pfad "+ " FROM Module "+ " WHERE code = ? "; pstmt = connModule.prepareStatement(sql); pstmt.setInt(1, Integer.parseInt((String)v_relevantCode.elementAt(i))); rs = pstmt.executeQuery(); while (rs.next()) { s_imsi = rs.getString(1); i_imsi = s_imsi.indexOf("plus"); if (i_imsi > 0) { v_relevantName.add(s_imsi.substring(0,i_imsi)); } else { i_imsi = s_imsi.indexOf("standard"); if (i_imsi > 0) { v_relevantName.add(s_imsi.substring(0,i_imsi)); } else { v_relevantName.add(s_imsi); } } v_relevantPfad.add(rs.getString("pfad")); } } catch(SQLException e) { e.printStackTrace(); } finally { try { rs.close(); pstmt.close(); connModule.close(); } catch (Exception e) {} } } String s_vertragName = (String)v_moduleName.elementAt(0); i_imsi = s_vertragName.indexOf("plus"); if (i_imsi > 0) { s_vertragName = s_vertragName.substring(0,i_imsi); } else { i_imsi = s_vertragName.indexOf("standard"); if (i_imsi > 0) { s_vertragName = s_vertragName.substring(0,i_imsi); } } gc = s_groupCode; %> vertrag.net | Muster-Vertrag | Verträge | Muster-Vorlagen <%@ include file="/top.jsp" %>
<%@ include file="/left_menu.jsp" %>
Home >  Vorlagen-Generator >  <% if (s_vertragName.length() <= 25) { %> <%= s_vertragName %> <% } else { %> <%= s_vertragName.substring(0,25) %> ... <% } %>

Informationen zum Produkt
<% if (gc.equals("A")) { %> <% } else if (gc.equals("B")) { %> <% } else if (gc.equals("C")) { %> <% } else if (gc.equals("D")) { %> <% } else if (gc.equals("E")) { %> <% } %> <%= s_vertragName %>

blabla









Vergütung

Urlaub

So geht's...
 

Abfragen beanworten Eingaben abschließen Dokument anfordern  


erstellen    " name="go" style="border:1 solid; font-family:Verdana; font-size:12px;">

Ähnliche Vorlagen
<% if (v_relevantCode.size() == 0) { %>
Keine ähnlichen Produkte gefunden. Eine Übersicht über alle individuellen Dokumente finden Sie hier.
<% } else {%> <% for (i=0; i < v_relevantCode.size(); i++) { %>

<%= (String)v_relevantName.elementAt(i) %>
<% } %>

mehr Vorlagen...   
<% } %>
<%@ include file="/footer.jsp" %>
<%@ include file="/right_menu.jsp" %>
<% } %>