ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joanthan_Inf <mzjf...@gmail.com>
Subject Re: HashMap keys
Date Mon, 22 Oct 2007 19:34:01 GMT



neverov_dg wrote:
> 
> Hi, I have statement:
> 
>   <statement id="getSA" parameterClass="java.util.HashMap"
> resultClass="java.util.HashMap">
>     <![CDATA[
>     select t11.nplv_old as nplv,
>            nvl(t21.sname, ' ') as marka,
>            t41.conc as conc1,
>            t42.conc as conc2,
>            abs(to_number(t41.conc,
> '99.9999')-to_number(t42.conc,'99.9999')) as razn,
>            i.id as interval
>     from him_head t11, sp_name_nsi t21, him_dev t31, him_an t41, him_head
> t12, him_an t42, him_dev t32, sp_name_nsi t22, sp_interval i
>     where t11.id_mark = t21.id(+)
>     and t31.id_head = t11.id_head
>     and t31.dt_dev between to_date(#dataN#, 'dd.mm.yyyy hh24:mi') and
> to_date(#dataK#, 'dd.mm.yyyy hh24:mi') 
>     and t31.id_dev = 78
>     and t41.id_analiz = t31.id_analiz
>     and t41.id_elem = #elementId:NUMERIC# 
>     and t11.id_prob = #probaId1# 
> 
>     and t12.id_mark = t22.id(+)
>     and t32.id_head = t12.id_head
>     and t32.dt_dev between to_date(#dataN#, 'dd.mm.yyyy hh24:mi') and
> to_date(#dataK#, 'dd.mm.yyyy hh24:mi') 
>     and t32.id_dev = 78
>     and t42.id_analiz = t32.id_analiz
>     and t42.id_elem = #elementId:NUMERIC# 
>     and t12.id_prob = #probaId2# 
> 
>     and t11.nplv_old = t12.nplv_old    
> 
>     and abs(to_number(t41.conc, '99.9999')-to_number(t42.conc, '99.9999'))
> > to_number(i.conc_ot, '999.9999')
>     and abs(to_number(t41.conc, '99.9999')-to_number(t42.conc, '99.9999'))
> <= to_number(i.conc_do, '999.9999')
>     ]]>
>   </statement>
> 
> 
>   As result I get a HashMap, but all keys of it in UpperCase: NPLV,
>   MARKA, CONC1... Can I get keys in lowercase?
>   
> -- 
> Thanks.
> mailto:neverov_dg@nkmk.ru
> 
> 
> your can implement me the class of Dao, for I Know about de HashMap
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/HashMap-keys-tf397919.html#a13350829
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message