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
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....
ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡
½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......