SSI整合 示例

create table user_c (id varchar(10) primary key,name varchar(20),age int ,address varchar(30);)

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE mapper
 3 PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 4 "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 5 
 6 <mapper namespace="cn.itcast.mybatis.domain.User">
 7     <sql id="cols">
 8         id,name,age,address
 9     </sql>
10     <sql id="ucols">
11         name=#{name},age=#{age},address=#{address}
12     </sql>
13 
14     <!-- 查询所有记录 -->
15     <select id="listAll" resultType="aliasesUser">
16         select <include refid="cols"/> from user_c
17     </select>
18     
19     <!-- 按条件查询 -->
20     <select id="find" parameterType="aliasesUser" resultType="aliasesUser">
21         select * from user_c 
22         <where>
23         <if test="name!=null">
24             and name like "%"#{name}"%"
25         </if>
26         <if test="age!=null">
27             and age=#{age}
28         </if>
29         </where>
30     </select>
31     
32     <!-- 查询一个用户 -->
33     <select id="get" parameterType="string" resultType="aliasesUser">
34         select <include refid="cols"/> from user_c where id=#{id}
35     </select>
36     
37     <!-- 新增 -->
38     <insert id="create" parameterType="aliasesUser">
39         insert into user_c (id,name,age,address) values(#{id},#{name},#{age},#{address})
40     </insert>
41     
42     <!-- 修改 -->
43     <update id="update" parameterType="aliasesUser">
44         update user_c
45          <set>
46              <if test="name!=null">
47                  name=#{name},
48              </if>
49              <if test="age!=null">
50                  age=#{age},
51              </if>
52              <if test="address!=null">
53                  address=#{address},
54              </if>
55          </set>
56          
57         where id=#{id}
58     </update>
59     
60     <!-- 删除 -->
61     <delete id="delete" parameterType="string">
62         delete from user_c where id=#{id}
63     </delete>
64 </mapper>

 1 package cn.itcast.mybatis.dao;
 2 
 3 import java.util.List;
 4 
 5 import org.mybatis.spring.support.SqlSessionDaoSupport;
 6 
 7 import cn.itcast.mybatis.domain.User;
 8 
 9 public class UserDaoImpl extends SqlSessionDaoSupport implements IUserDao {
10     
11     //删除
12     public int deleteById(String id) {
13         return this.getSqlSession().delete("cn.itcast.mybatis.domain.User.delete",id);
14     }
15 
16     //新增
17     public int insert(User u) {
18         return this.getSqlSession().insert("cn.itcast.mybatis.domain.User.create", u);
19     }
20 
21     //列表
22     public List<User> list() {
23         return this.getSqlSession().selectList("cn.itcast.mybatis.domain.User.listAll");
24     }
25 
26     //修改
27     public int update(User u) {
28         return this.getSqlSession().update("cn.itcast.mybatis.domain.User.update",u);
29     }
30 
31     //获取对象
32     public User get(String id) {
33         return (User) this.getSqlSession().selectOne("cn.itcast.mybatis.domain.User.get", id);
34     }
35 
36 }

 1 package cn.itcast.mybatis.action;
 2 
 3 import java.util.List;
 4 
 5 import cn.itcast.mybatis.domain.User;
 6 import cn.itcast.mybatis.service.IUserService;
 7 
 8 import com.opensymphony.xwork2.ActionContext;
 9 import com.opensymphony.xwork2.ActionSupport;
10 import com.opensymphony.xwork2.ModelDriven;
11 
12 public class UserAction extends ActionSupport implements ModelDriven<User> {
13     private User model = new User();
14     public User getModel() {
15         return model;
16     }
17 
18     private IUserService userService;
19     public IUserService getUserService() {
20         return userService;
21     }
22 
23     public void setUserService(IUserService userService) {
24         this.userService = userService;
25     }
26     
27     public String list(){
28         List<User> dataList = userService.list();
29         ActionContext.getContext().put("dataList", dataList);
30         
31         return "plist";
32     }
33     
34     public String tocreate(){
35         
36         return "pcreate";
37     }
38     
39     public String toupdate(){
40         User u = userService.get(model.getId());
41         ActionContext.getContext().getValueStack().push(u);
42         
43         return "pupdate";
44     }
45     
46     public String toview(){
47         User u = userService.get(model.getId());
48         ActionContext.getContext().getValueStack().push(u);
49         
50         return "pview";
51     }
52     
53     public String createSave(){
54         userService.insert(model);
55         
56         return "actlist";
57     }
58     
59     public String updateSave(){
60         userService.update(model);
61         
62         return "actlist";
63     }
64     
65     public String delete(){
66         userService.deleteById(model.getId());
67         
68         return "actlist";
69     }
70 }

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE configuration
 3 PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
 4 "http://mybatis.org/dtd/mybatis-3-config.dtd">
 5 <configuration>
 6     
 7    <typeAliases>
 8         <typeAlias type="cn.itcast.mybatis.domain.User" alias="aliasesUser"></typeAlias>
 9     </typeAliases>
10  <environments default="development">
11         
12         <environment id="development">
13             <transactionManager type="JDBC"/>
14             <dataSource type="POOLED">
15                 <property name="driver" value="com.mysql.jdbc.Driver"/>
16                 <property name="url" value="jdbc:mysql://localhost:3306/mybatisdb?characterEncoding=UTF-8"/>
17                 <property name="username" value="root"/>
18                 <property name="password" value="friends"/>
19             </dataSource>
20         </environment>
21 <!--         产品    可用于多个配置的 -->
22         <environment id="product">
23             <transactionManager type="JDBC"/>
24             <dataSource type="POOLED">
25                 <property name="driver" value="com.mysql.jdbc.Driver"/>
26                 <property name="url" value="jdbc:mysql://localhost:3306/mybatisdb?characterEncoding=UTF-8"/>
27                 <property name="username" value="root"/>
28                 <property name="password" value="friends"/>
29             </dataSource>
30         </environment>
31     </environments>
32     <mappers>
33         <mapper resource="cn/itcast/mybatis/domain/MyUser.xml"/>
34     </mappers>
35 </configuration>

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans"
 3     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 4     xmlns:context="http://www.springframework.org/schema/context"
 5     xmlns:aop="http://www.springframework.org/schema/aop"
 6     xmlns:tx="http://www.springframework.org/schema/tx"
 7     xsi:schemaLocation="http://www.springframework.org/schema/beans 
 8                          http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
 9                          http://www.springframework.org/schema/context
10                          http://www.springframework.org/schema/context/spring-context-3.0.xsd
11                          http://www.springframework.org/schema/tx
12                          http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
13                          http://www.springframework.org/schema/aop 
14                          http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
15     
16     <!-- 数据源 -->
17     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
18         <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
19         <property name="url" value="jdbc:mysql://localhost/mybatisdb?characterEncoding=utf-8"></property>
20         <property name="username" value="root"></property>
21         <property name="password" value="friends"></property>
22     </bean>
23     
24     <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
25         <property name="configLocation" value="classpath:sqlMapConfig.xml"></property>
26         <property name="dataSource" ref="dataSource"></property>
27 
28     </bean>
29     
30     <!-- 事务相关控制 -->
31     <bean name="transactionManager"
32         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
33         <property name="dataSource" ref="dataSource"/>
34     </bean>
35 
36     <!-- 通知 -->
37     <tx:advice id="tx"
38         transaction-manager="transactionManager">
39         <tx:attributes>
40             <tx:method name="delete*" propagation="REQUIRED" />
41             <tx:method name="insert*" propagation="REQUIRED" />
42             <tx:method name="update*" propagation="REQUIRED" />
43             <tx:method name="find*" read-only="true" />
44             <tx:method name="get*" read-only="true" />
45             <tx:method name="select*" read-only="true" />
46         </tx:attributes>
47     </tx:advice>
48 
49     <aop:config>
50         <aop:pointcut id="pc" expression="execution(* cn.itcast.mybatis.service.*.*(..))" />
51         <!--把事务控制在Service层-->
52         <aop:advisor pointcut-ref="pc" advice-ref="tx" />
53     </aop:config>
54     
55     <bean id="userDao" class="cn.itcast.mybatis.dao.UserDaoImpl">
56         <property name="sqlSessionFactory" ref="sessionFactory"></property>
57     </bean>
58     
59     <bean id="userService" class="cn.itcast.mybatis.service.UserServiceImpl">
60         <property name="userDao" ref="userDao"></property>
61     </bean>
62     
63     
64     <bean id="userAction" class="cn.itcast.mybatis.action.UserAction" scope="prototype">
65         <property name="userService" ref="userService">
66 <!--         一样    <ref bean="userService"/> -->
67         </property>
68     </bean>
69 </beans>

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE struts PUBLIC
 3      "-//Apache Software Foundation//DTD Struts Configuration 2.1.7//EN"
 4      "http://struts.apache.org/dtds/struts-2.3.dtd">
 5 <struts>
 6      <constant name="struts.ui.theme" value="simple"></constant>
 7      <constant name="struts.devMode" value="true"></constant>
 8      <constant name="struts.objectFactory" value="spring"></constant>
 9      
10      <package name="user" namespace="/user" extends="struts-default">
11           <action name="userAction_*" class="userAction" method="{1}">
12                <result name="pview">/WEB-INF/jsps/user/jUserView.jsp</result>
13                <result name="plist">/WEB-INF/jsps/user/jUserList.jsp</result>
14                <result name="pcreate">/WEB-INF/jsps/user/jUserCreate.jsp</result>
15                <result name="pupdate">/WEB-INF/jsps/user/jUserUpdate.jsp</result>
16                <result name="actlist" type="redirectAction">/user/userAction_list</result>
17           </action>
18      </package>
19 </struts>