sqlÓï¾äÈçºÎ·Åµ½xml spring2.5
¸÷λ´óÏÀ£¬ÔÚÏÂÇë½ÌÒ»¸öÎÊÌ⣬Îʵõͼ¶Á˲»Òª¼ûЦ£¬ÎÒÓõÄÊÇspring2.5£¬À¨ºÅ£¬²»Ê죬ҵÎñ²ãµÄʵÏÖÒ»°ãÊÇÕâÑùдµÄ
public List <Object> checkLogin(User user)
{
String sql=" select * from `user` where loginname=? and password=? and `isdeleted`=0 ";
Object[] object={ user.getLoginname(),user.getPassword() };
return loginDao.selectAll(sql, object, EUser.class);
}
¶¼ÊÇÕâÖÖ¸ñʽ£¬ÎÒÏÖÔÚÏë°ÑsqlÓï¾äÈ«²¿·Åµ½xmlÀïÃæÈ¥£¨²Ù×÷Êý¾Ý¿âÓõÄÊÇJDBC²»ÊÇhibernate£©£¬¸ÃÓøöʲô˼·£¬»òÕß˵Óøöʲô¼¼Êõ£¬¹Ø¼ü¾ÍÊÇÄǸöռλ·û¸ÃÔõô´¦Àí£¬ÎÒÏëÈÃsqlºÍjava·Ö¿ª£¬µ«ÊÇÔõô¸øÕ¼Î»·û¸³Öµ£¬µ¥´¿ÊÇspringÄܲ»ÄÜÓÐÕâ¸ö¹¦ÄÜ£¬Íû¸ßÊÖ²»Áߴͽ̣¡£¡£¡£¡
ibatis+spring
Ϊʲô²»ÓÃhibernateÄØ£¿
ÄãÄǸöÓÃ×¢Èë²»¾ÍµÃÁË£¬ÀàÖÐдһ¸öÊôÐÔ£¬ÔÚÅäÖÃÎļþ×¢ÈëÒ»ÏÂ
ÕýºÃÎÒÏÖÔÚ½Ó´¥µÄÕâ¸öÏîÄ¿ÊÇÍêÈ«ÓÃspring ·ÃÎÊjdbcTemplate×öµÄ£¬sqlÊÇдÔÚspringÀïµÄ£¬Õâ¸öÄãÒªÏȶ¨ÒåÒ»¸öLoginGetSql.java ´¦ÀíÇëÇóÒ²ÊÇÓÃspringµÄ MVCʵÏÖµÄ
±ÈÈçpublic class LoginGetSql{
private String loginsql;
//Éú³ÉgeterºÍsetter
}
springÅäÖÃÎļþÖÐ
<bean id="loginMappingManual"
class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
<property name="interceptors">
<list>
<ref bean="RequestHandlerInterceptor" />
</list>
</prop
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô
select parsen ......
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......