ibatis+spring+struts整合实例【好例子】

步骤：

一、新建工程，添加ibatis、spring和struts的jars；
二、数据库设计.
三、POJO类.
四、pojo类配置文件编写
五、ibatis主配置文件编写【主配置文件只剩下sqlMap了】
六、dao接口和接口实现
七、service接口和接口实现
八、struts action实现及struts-config.xml配置
九、spring配置文件的内容【牵扯到ibatis和struts的整合】
十、测试

一、新建工程，添加ibatis、spring和struts的jars；

二、数据库设计.

mysql数据库：

[sql] view plain copy

1. useibatis;
2. droptableifexistsuser;
4. createtableifnotexistsuser(
5. IDtinyintprimarykeyauto_increment,
6. LOGIN_NAMEvarchar(10)notnull,
7. PASS_WORDvarchar(15)notnull,
8. QXvarchar(10)default'guest'notnull,
9. MEMOtext
10. )
11. type=innodb
12. comment="userinfo";
14. insertintouser(LOGIN_NAME,PASS_WORD,QX)values('leh','888','admin');
15. insertintouser(LOGIN_NAME,PASS_WORD)values('lek','888');
17. commit;

数据源的配置

1）、配置文件db.properties （位置：resources/properties/db.properties，这里resources和src是一类文件）

[html] view plain copy

1. driver=com.mysql.jdbc.Driver
2. url=jdbc\:mysql\://localhost\:3306/ibatis
3. username=root
4. password=54321

2）、注册数据源到spring

[html] view plain copy

1. !--springloaddataSourceconfigurationpropertyfile-->
2. <beanid="propertyConfigurer"class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
3. <propertyname="locations">
4. <list>
5. <value>properties/database.properties</value>
6. </list>
7. </property>
8. </bean>
10. <!--dataSource-->
11. <beanid="dataSource"class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close">
12. <propertyname="driverClassName"value="${driver}"/>
13. <propertyname="url"value="${url}"/>
14. <propertyname="username"value="${username}"/>
15. <propertyname="password"value="${password}"/>
16. </bean>

三、POJO类.

本例是User实例类：

[java] view plain copy

1. packagecom.leadtone.ibatis.domain;
3. importjava.io.Serializable;
5. publicclassUserimplementsSerializable{
7. privateintid;
8. privateStringname;
9. privateStringpassword;
10. privateStringqx;
11. privateStringmemo;
13. publicintgetId(){
14. returnid;
15. }
16. /**
17. *setter和getter方法省略
18. */

四、pojo类配置文件编写

本例是User.xml:(位置：com.leadtone.sqlmap.User.xml)

[html] view plain copy

1. <?xmlversion="1.0"encoding="UTF-8"?>
3. <!DOCTYPEsqlMap
4. PUBLIC"-//ibatis.apache.org//DTDSQLMap2.0//EN"
5. "http://ibatis.apache.org/dtd/sql-map-2.dtd">
7. <sqlMapnamespace="User">
9. <typeAliasalias="user"type="com.leadtone.ibatis.domain.User"/>
11. <resultMapclass="user"id="UserResult">
12. <resultproperty="id"column="ID"/>
13. <resultproperty="name"column="LOGIN_NAME"/>
14. <resultproperty="password"column="PASS_WORD"/>
15. <resultproperty="qx"column="QX"/>
16. <resultproperty="memo"column="MEMO"/>
17. </resultMap>
19. <!--queryallUsers-->
20. <selectid="selectAllUsers"resultMap="UserResult">
21. select*fromuser
22. </select>
24. <!--queryuserbyid-->
25. <selectid="selectUserById"parameterClass="int"resultMap="UserResult">
26. selectID,LOGIN_NAME,PASS_WORD,QX,MEMOfromuserwhereID=#id#
27. </select>
29. <!--queryuserbyuser-->
30. <selectid="selectUserByUser2"parameterClass="map"resultMap="UserResult">
31. selectID,LOGIN_NAME,PASS_WORD,QX,MEMO
32. fromuser
33. <dynamicprepend="where">
34. <isNotEmptyprepend="and"property="name">
35. LOGIN_NAME=#name#
36. </isNotEmpty>
37. <isNotEmptyprepend="and"property="password">
38. PASS_WORD=#password#
39. </isNotEmpty>
40. </dynamic>
41. </select>
44. <selectid="selectUserByUser"parameterClass="user"resultMap="UserResult">
45. selectID,LOGIN_NAME,PASS_WORD,QX,MEMO
46. fromuser
47. <dynamicprepend="where">
48. <isNotEmptyprepend="and"property="name">
49. LOGIN_NAME=#name#
50. </isNotEmpty>
51. <isNotEmptyprepend="and"property="password">
52. PASS_WORD=#password#
53. </isNotEmpty>
54. </dynamic>
55. </select>
57. <selectid="selectUsersByName"parameterClass="String"resultMap="UserResult">
58. selectID,LOGIN_NAME,PASS_WORD,QX,MEMO
59. fromuser
60. <dynamicprepend="where">
61. <isNotEmptyprepend="and"property="value">
62. snamelike'%$value$%'
63. </isNotEmpty>
64. </dynamic>
65. </select>
67. <!--
68. <insertid="addUser"parameterClass="User">
69. insertintouser(LOGIN_NAME,PASS_WORD,QX,MEMO)
70. values(#name#,#birth#,#score#)
71. <selectKeykeyProperty="id"resultClass="int">
72. selectlast_insert_id()
73. </selectKey>
74. </insert>
75. <!--注意这里的keyProperty="id"中的id就是User中的id属性，resultClass就是查询的的返回值-->
76. -->
78. <updateid="updateUser"parameterClass="User">
79. updateusersetLOGIN_NAME=#name#,PASS_WORD=#password#,QX=#qx#,memo=#memo#whereID=#id#
80. </update>
82. <deleteid="deleteUser"parameterClass="int">
83. deletefromuserwhereID=#id#
84. </delete>
86. </sqlMap>

【补充：】动态sql：

一般来说，拼接动态sql是在查询时，指定多个查询条件的情况下用的，所以用到parameterClass= (map或具体类)，

但对于传递过来的参数就一个时，若如下代码就会出错：

[html] view plain copy

1. <selectid="selectUserById"parameterClass="int"resultMap="UserResult">
2. selectsid,sname,smajor,sbirth,scorefromusers
3. <dynamicprepend="where">
4. <isNotEmptyprepend="and"property="id">
5. sid=#id#
6. </isNotEmpty>
7. </dynamic>
8. </select>

会报错误如下：There is no READABLE property named 'id' in class 'java.lang.Integer'

因为你无缘故用了一个莫名其妙的property="id",id对ibatis来说不认识。

这时的解决办法有两种，一个是这里的property="id" 中的id用value来代替，所以下面的sid=#value#，这个value是ibatis内部指定个变量；另一个方法是直接把property="id"删除，不用property这个属性了。

五、ibatis主配置文件编写【主配置文件只剩下sqlMap了，事务和数据源都交给spring进行配置和管理】

本例为sql-map-config.xml:(位置：)

[html] view plain copy

1. <?xmlversion="1.0"encoding="UTF-8"?>
2. <!DOCTYPEsqlMapConfig
3. PUBLIC"-//ibatis.apache.org//DTDSQLMapConfig2.0//EN"
4. "<ahref="http://ibatis.apache.org/dtd/sql-map-config-2.dtd">http://ibatis.apache.org/dtd/sql-map-config-2.dtd</a>">
5. <sqlMapConfig>
6. <sqlMapresource="com/leadtone/ibatis/sqlmap/User.xml"/>
8. <!--
9. <sqlMapresource="com/leadtone/ibatis/sqlmap/User1.xml"/>
10. <sqlMapresource="com/leadtone/ibatis/sqlmap/User2.xml"/>
12. <sqlMapresource="com/leadtone/ibatis/sqlmap/Usern.xml"/>
13. -->
14. </sqlMapConfig>

六、dao接口和接口实现

1）、本例为UserDao：

[java] view plain copy

1. packagecom.leadtone.ibatis.dao;
3. importjava.util.List;
4. importcom.leadtone.ibatis.domain.User;
6. publicinterfaceIUserDao{
7. publicList<User>queryAllUsers();
8. publicUserqueryUserById(intid);
9. publicUserqueryUserByUser(Useruser);
10. publicList<User>queryUserByName(Stringname);
12. publicvoidaddUser(Useruser);
13. publicvoidaddUserBySequence(Useruser);
15. publicvoidupdateUser(Useruser);
17. publicvoiddeleteUser(intid);
18. }

2）、实现类UserDaoImpl：

[java] view plain copy

1. packagecom.leadtone.ibatis.dao.ibatis;
3. importjava.util.List;
4. importorg.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
5. importcom.leadtone.ibatis.dao.IUserDao;
6. importcom.leadtone.ibatis.domain.User;
8. publicclassUserDaoImplextendsSqlMapClientDaoSupportimplementsIUserDao{
10. //注意这里的SqlMapClient接口的声明和下面的static静态代码都不需要了，
14. //因为这里继承了spring提供的ibatis模板template类SqlMapClientDaoSupport，不是用原生的SqlMapClient
18. //privatestaticSqlMapClientsqlMapClient=null;
19. /*
20. static{
21. Readerreader=null;
22. try{
23. reader=Resources.getResourceAsReader("com/leadtone/ibatis/sqlmap/SqlMapConfig.xml");
24. sqlMapClient=SqlMapClientBuilder.buildSqlMapClient(reader);
26. reader.close();
27. }catch(IOExceptione){
28. e.printStackTrace();
29. }
31. }
32. */
33. publicvoidaddUser(Useruser){
34. getSqlMapClientTemplate().insert("addUser",user);
35. }
37. publicUserqueryUserByUser(Useruser){
38. System.out.println("---UserDaoImpl---");
39. return(User)this.getSqlMapClientTemplate().queryForObject("selectUserByUser",user);
41. }
42. /*
43. *这里主要演示一个模拟用户登录系统验证的操作，主要用了queryUserByUser(Useruser)方法
44. */
45. }

3）、在spring配置文件中配置这个bean

[html] view plain copy

1. <!--sqlMapClient-->
2. <beanid="sqlMapClient"class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
3. <propertyname="configLocation"value="sqlmap/sql-map-config.xml"/>
4. <propertyname="dataSource"ref="dataSource"/>
5. </bean>
7. <!--validateloginUser-->
8. <!--dao-->
9. <beanid="userDao"class="com.leadtone.ibatis.dao.ibatis.UserDaoImpl">
10. <propertyname="sqlMapClient"ref="<spanstyle="color:#000000;">sqlMapClient</span>"></property>
11. </bean>

七、service接口和接口实现

1）IUserLoginService接口

[java] view plain copy

1. packagecom.leadtone.ibatis.service;
3. importcom.leadtone.ibatis.domain.User;
5. publicinterfaceIUserLoginService{
6. publicbooleanisLoginUser(Useruser);
7. }

2）UserLoginSerivceImpl实现类

[java] view plain copy

1. packagecom.leadtone.ibatis.service.impl;
3. importcom.leadtone.ibatis.dao.IUserDao;
4. importcom.leadtone.ibatis.domain.User;
5. importcom.leadtone.ibatis.service.IUserLoginService;
7. publicclassUserLoginServiceImplimplementsIUserLoginService{
9. privateIUserDaouserDao;
11. publicIUserDaogetUserDao(){
12. returnuserDao;
13. }
15. publicvoidsetUserDao(IUserDaouserDao){
16. this.userDao=userDao;
17. }
18. publicbooleanisLoginUser(Useruser){
19. returnnull!=userDao.queryUserByUser(user)?true:false;
20. }
22. }

3）在spring中注册这个bean

[html] view plain copy

1. <!--service-->
2. <beanid="userLoginService"class="com.leadtone.ibatis.service.impl.UserLoginServiceImpl">
3. <propertyname="userDao"ref="userDao"></property>
4. </bean>

八、struts action实现及struts-config.xml配置(牵扯到struts和spring的整合)

1）action：

[java] view plain copy

1. packagecom.leadtone.web.struts.action;
3. importjavax.servlet.http.HttpServletRequest;
4. importjavax.servlet.http.HttpServletResponse;
6. importorg.apache.struts.action.Action;
7. importorg.apache.struts.action.ActionForm;
8. importorg.apache.struts.action.ActionForward;
9. importorg.apache.struts.action.ActionMapping;
11. importcom.leadtone.ibatis.domain.User;
12. importcom.leadtone.ibatis.service.IUserLoginService;
13. importcom.leadtone.web.struts.form.LoginForm;
15. publicclassLoginActionextendsAction{
17. privateIUserLoginServiceuserLoginService;
19. publicIUserLoginServicegetUserLoginService(){
20. returnuserLoginService;
21. }
23. publicvoidsetUserLoginService(IUserLoginServiceuserLoginService){
24. this.userLoginService=userLoginService;
25. }
27. publicActionForwardexecute(ActionMappingmapping,ActionFormform,
28. HttpServletRequestrequest,HttpServletResponseresponse){
29. LoginFormloginForm=(LoginForm)form;
30. Stringname=loginForm.getUsername();
31. Stringpassword=loginForm.getPassword();
33. Useruser=newUser();
34. user.setName(name);
35. user.setPassword(password);
36. booleanisLogin=false;
37. isLogin=userLoginService.isLoginUser(user);
38. System.out.println(isLogin);
39. if(isLogin){
40. request.setAttribute("username",name);
41. returnmapping.findForward("success");
42. }
43. else
44. returnmapping.findForward("failure");
45. }
46. }

2）actionForm:

[java] view plain copy

1. publicclassLoginFormextendsActionForm{
3. privateStringusername;
4. privateStringpassword;
5. privateStringgrade;
7. publicActionErrorsvalidate(ActionMappingmapping,
8. HttpServletRequestrequest){
9. returnnull;
10. }
12. publicvoidreset(ActionMappingmapping,HttpServletRequestrequest){
13. }
15. publicStringgetPassword(){
16. returnpassword;
17. }
19. publicvoidsetPassword(Stringpassword){
20. this.password=password;
21. }
23. publicStringgetGrade(){
24. returngrade;
25. }
26. publicvoidsetGrade(Stringgrade){
27. this.grade=grade;
28. }
30. publicStringgetUsername(){
31. returnusername;
32. }
34. publicvoidsetUsername(Stringusername){
35. this.username=username;
36. }
37. }

3）xml：

[html] view plain copy

1. <struts-config>
2. <data-sources/>
3. <form-beans>
4. <form-beanname="loginForm"type="com.leadtone.web.struts.form.LoginForm"/>
6. </form-beans>
8. <global-exceptions/>
9. <global-forwards/>
10. <action-mappings>
11. <action
12. attribute="loginForm"
13. input="/login.jsp"
14. name="loginForm"
15. path="/login"
16. scope="request"
17. type="org.springframework.web.struts.DelegatingActionProxy">
19. <forwardname="failure"path="/failure.jsp"/>
20. <forwardname="success"path="/succ.jsp"/>
21. </action>
24. </action-mappings>
26. <controllerprocessorClass="org.springframework.web.struts.DelegatingRequestProcessor"></controller>
28. <message-resourcesparameter="com.leadtone.web.struts.ApplicationResources"/>
30. <plug-inclassName="org.springframework.web.struts.ContextLoaderPlugIn">
31. <set-propertyproperty="contextConfigLocation"value="classpath:applicationContext.xml"/>
32. </plug-in>
33. </struts-config>

4）页面：

login.jsp

[html] view plain copy

1. <body>
2. <center>
3. <html:formaction="${Pagecontext.request.contextPath}/login"method="post">
4. <tableborder="1px"cellspacing="1px"cellpadding="1px">
5. <tr>
6. <td>username:</td>
7. <td><html:textproperty="username"/></td>
8. <td><html:errorsproperty="username"/></td>
9. </tr>
10. <tr>
11. <td>password:</td>
12. <td><html:passwordproperty="password"/></td>
13. <td><html:errorsproperty="password"/></td>
14. </tr>
15. <tr>
16. <td>grade:</td>
17. <td><html:selectproperty="grade">
18. <html:optionvalue="guest">guest</html:option>
19. <html:optionvalue="admin">admin</html:option>
20. </html:select>
21. </td>
22. <td><html:errorsproperty="grade"/></td>
23. </tr>
24. <tr>
25. <tdcolspan="3"valign="middle"align="center"><html:submit/><html:cancel/></td>
27. </tr>
28. </table>
29. </html:form>
30. </center>
31. </body>

[html] view plain copy

1. succ.jsp
3. <body>
4. welcome${username},<br>
5. loginsuccessfully!
6. </body>
10. falure.jsp
12. <body>
13. sorry,loginerror<ahref="login.jsp">relogin</a>
14. </body>

5)web.xml

[html] view plain copy

1. <?xmlversion="1.0"encoding="UTF-8"?>
2. <web-appxmlns="http://java.sun.com/xml/ns/javaee"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"version="2.5"xsi:schemaLocation="http://java.sun.com/xml/ns/javaeehttp://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
3. <servlet>
4. <servlet-name>action</servlet-name>
5. <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
6. <init-param>
7. <param-name>config</param-name>
8. <param-value>/WEB-INF/struts-config.xml</param-value>
9. </init-param>
10. <init-param>
11. <param-name>debug</param-name>
12. <param-value>3</param-value>
13. </init-param>
14. <init-param>
15. <param-name>detail</param-name>
16. <param-value>3</param-value>
17. </init-param>
18. <load-on-startup>0</load-on-startup>
19. </servlet>
21. <servlet-mapping>
22. <servlet-name>action</servlet-name>
23. <url-pattern>*.do</url-pattern>
24. </servlet-mapping>
25. <welcome-file-list>
26. <welcome-file>login.jsp</welcome-file>
27. </welcome-file-list>
28. </web-app>

九、spring配置文件的内容【牵扯到ibatis和struts的整合】

[html] view plain copy

1. <!--action-->
2. <beanname="/login"class="com.leadtone.web.struts.action.LoginAction"abstract="false"
3. lazy-init="default"autowire="default"dependency-check="default">
4. <propertyname="userLoginService"ref="userLoginService"></property>
5. </bean>

十、测试

这里的测试 包括单元测试。例如对dao层、service层、action层编写完成后都要进行junit4单元测试（Jmock或easyMock等）测试，这里就不添加了。

spring的配置文件中对事物拦截器的配置，也是必须的，这里没有配置