1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
| <%@ page contentType="text/html;charset=ISO-8859-1" language="java" %>
<%@ page import="java.util.*" errorPage="error.jsp" %>
<% response.setHeader("Pragma", "no-cache");
response.setHeader("Cache-Control", "no-cache");
response.setDateHeader("Expires", 0);
%>
<jsp:useBean id="sqlManager" class="iDealWine.SqlJSPBean" scope="page" />
<% String appellation = request.getParameter("pays");
String statement = "select lot.gpiliblibre||';'||REPLACE(REPLACE(lot.libelle_100_5,Chr(10),' '),Chr(13),' ')||' '||lot.GPICPTRIB||';'||lot.FG11||';'||lot.MT05||';'||lot.MT04||';'||lot.MT01 ,"+
" 'http://www.lkjhlkjh.com/fr/llkjhlkh.jsp?vente='||lot.GPIROLE||'&'||'numLot='||lot.nb01, "+
" TO_CHAR(vente.DATE2_DT,'YYYY-MM-DD hh24:mi:ss')"+
" from g_piece lot,g_information vente,type_vin vin "+
" where vente.refinfo=lot.gpirole "+
" and vin.pays='"+ pays +"' "+
" and vin.id_tvin=lot.gpiliblibre "+
" and nvl(vente.encodeur,'0')='1' "+
" order by vente.refinfo,lot.nb01";
String separator = ";";
String eol="<br>";
int cols=3;
if ( request.getParameter("requete")!=null) statement=request.getParameter("requete");
if ( request.getParameter("sep")!=null) separator=request.getParameter("sep");
if ( request.getParameter("fin")!=null) eol=request.getParameter("fin");
if ( request.getParameter("cnt")!=null) cols=new Integer(request.getParameter("cnt")).intValue();
Vector rs = sqlManager.ExecuteEx(statement, separator, eol, cols);
%><%
if ( !sqlManager.sqlerror ) {
if (rs != null && rs.size() > 0) {
for (int i=0; i<rs.size(); i++) {
String[] data = (String[])rs.elementAt(i);
out.println(data[0]);
}
}
}%> |
Partager