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
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......