[TOC]
（SpringMVC+Spring+ mybatis）
配置内容：
导入jar插件
spring 管理连接文件
sessionFactory 管理session工厂
dataSource 管理数据源
MappingScannerCongigurer 管理映射文件
实现UserDao属性注入 实现属性注入
具体操作
- spring 管理连接文件
<bean class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
<property name="location" value="classpath:db.properties"> </property>
</bean>
- sessionFactory
<!--创建sessionFactory -->
<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="mapperLocations" value="classpath:com/wxb/mapper/*.xml"></property>
</bean>
- dataSource
<!-- 数据源 dbcp c3p0 jndi -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="url" value="${url}"></property>
<property name="username" value="${username}"></property>
<property name="password" value=""></property>
<property name="driverClassName" value="${driver}"></property>
</bean>
- MappingScannerCongigurer
<bean id="mcf" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.wxb.dao"></property>
<property name="sqlSessionFactoryBeanName" value="sessionFactory"></property>
</bean>
- 实现UserDao属性注入
@Autowired
private UserDao userDao;
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
管理流程
控制层 管理service层
@Autowired
private UserServiceImp us;
public void setUs(UserServiceImp us) {
this.us = us;
}
注意：都需要注解
service层管理dao层
@Autowired
private UserDao userDao;
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
注意：都需要注解
dao层 管理映射文件
public ArrayList<User> list(User user) ;
public void save(User user);
public void update(User user);
public void delete(User user);
public int count();
通过构造方法同映射文件中的sql语句相关联（方法名）
<mapper namespace="com.wxb.dao.UserDao">
<select id="list" resultType="com.wxb.model.User" parameterType="com.wxb.model.User" >
select uid,name from user
<where>
<if test="uid!=0">
and uid=#{uid}
</if>
<if test="null!=name and ''!=name">
and name like CONCAT('%',#{name},'%')
</if>
</where>
limit #{pageIndex},#{size}
</select>
<insert id="save" parameterType="com.wxb.model.User">
insert into user (name) values(#{name})
</insert>
<delete id="delete" parameterType="com.wxb.model.User" >
delete from user <include refid="byId"></include>
</delete>
<update id="update" parameterType="com.wxb.model.User">
update user set name=#{name} <include refid="byId"></include>
</update>
<select id="count" resultType="java.lang.Integer">
select count(*) from user
</select>
<sql id="byId" >
where uid=#{uid}
</sql>
</mapper>
转发到show.jsp 页面
@RequestMapping("/show")
public String show(HttpServletRequest request, User user) {
System.out.println("我是show（）方法");
// String name = request.getParameter("name");
System.out.println(user.getName());
request.getSession().setAttribute("name", user.getName());
return "/show.jsp";
回调show方法
return "redirect:show";
重定向到show.jsp 页面
return "redirect:/show.jsp";
}
