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
|
rs=st.executeQuery("select cc.subno, cc.FIRST_NAME,cc.last_NAME, cc.contno, cc.type, cc.requested_item, cc.cost_price, cc.point_price, nvl(bb.name_item,'not changed')offered_item,cc.category, nvl(cc.adress,'_')adress, nvl(cc.wilaya,'_')wilaya, nvl(cc.note,'_')note, cc.code_agent, cc.creation_date, cc.status_def, cc.CODE_DEMAND from (select a.subno, c.FIRST_NAME,c.last_NAME,c.contno,c.type, a.creation_date, a.code_agent, (b.name_item) requested_item, b.cost_price,b.point_price, a.ITEM_OFFERED,a.category ,a.adress, a.wilaya, a.note,d.status_def,a.CODE_DEMAND from demand a, item b, status_description d, clients c where c.subno=a.subno and a.code_item=b.code_item and a.current_status=d.code_status and a.current_status='5' or c.subno=a.subno and a.code_item=b.code_item and a.current_status=d.code_status and a.current_status='8' or c.subno=a.subno and a.code_item=b.code_item and a.current_status=d.code_status and a.current_status='7')cc , item bb where cc.ITEM_OFFERED = bb.code_item (+) and cc.subno='"+num+"' ");
while (rs.next()){
//first name est enregistré dans lla 3eme ligne et la dernieres ligne(celle du param id)
Tablehist tablehist= new Tablehist();
tablehist.setMsisdn(rs.getString(1).trim());
tablehist.setFirstname(rs.getString(2).trim());
tablehist.setLastname(rs.getString(3).trim());
tablehist.setContractno(rs.getString(4).trim());
tablehist.setType(rs.getString(5).trim());
tablehist.setItem(rs.getString(6).trim());
tablehist.setPricedz(rs.getString(7).trim());
tablehist.setPricept(rs.getString(8).trim());
tablehist.setItemoff(rs.getString(9).trim());
tablehist.setCategory(rs.getString(10).trim());
tablehist.setAdress(rs.getString(11).trim());
tablehist.setWilaya(rs.getString(12).trim());
tablehist.setNote(rs.getString(13).trim());
tablehist.setAgentcode(rs.getString(14).trim());
tablehist.setDate(rs.getString(15).trim());
tablehist.setStatus(rs.getString(16).trim());
tablehist.setCd(rs.getString(17).trim());
tablehist.setFn(rs.getString(2).trim());
list.add(tablehist);
}pretraitementForm.setResulhist(list); |
Partager