reportxml.jsp

噶额外噶外骨骼感广泛高热感 就 啊啊

<%@ page contentType="text/html;charset=UTF-8"%>
<jsp:useBean id="xsql" class="oracle.otnsamples.util.XMLSQLUtil" scope="page"/>
<jsp:useBean id="ctx" class="javax.naming.InitialContext" scope="page"/>
<%! 
String shippingQuery="SELECT o.username, o.shiptoaddress address, u.email, itd.name, "+
        "oi.status, TO_CHAR(o.orderdate, 'DD-Mon-YYYY') as orderdate "+
        " FROM productorder o, customer u, "+
        " vsm_item i, orderitem oi,"+
        " itemdetail itd "+
        "WHERE UPPER(o.username) = UPPER(u.username) AND oi.itemid = i.id and oi.orderid = o.id  "+
        " AND i.id = itd.itemid "+
        " AND oi.shopid = ? "+
        " AND o.orderdate between TO_DATE(?,'DD-MON-YYYY') and TO_DATE(?,'DD-MON-YYYY')    "+
        " AND itd.langID = ?"+
        " AND LTRIM(oi.status) = ? ";

String salesQuery ="SELECT o.username, itd.name, TO_CHAR(o.orderdate,'DD-MON-YYYY') as orderdate, "+
        "oi.quantity, oi.unitprice "+
        " FROM productorder o, vsm_item i, orderitem oi, itemdetail itd "+
        " WHERE o.id = oi.orderid AND i.id = itd.itemID "+
        " AND oi.itemID = i.id "+
        " AND oi.shopid = ? "+
        " AND o.orderdate between TO_DATE(?,'DD-MON-YY') and TO_DATE(?,'DD-MON-YY') "+
        " AND itd.langID = ? ";
%>
<%
javax.sql.DataSource ds= (javax.sql.DataSource)ctx.lookup("jdbc/WebstoreDS");
java.sql.Connection con=ds.getConnection();
String query=salesQuery;
String type=request.getParameter("type");
Object[] vals=null;
if("shipping".equals(type)){
  vals= new Object[5];
  vals[4]=request.getParameter("status");
  query=shippingQuery;
}else{
  vals= new Object[4];
}
vals[0]=request.getParameter("shopID");
vals[1]=request.getParameter("fromDate");
vals[2]=request.getParameter("toDate");
vals[3]=request.getParameter("langID");
%>
<%=xsql.getXML(query,vals,con)%>
<%
con.close();
%>