[TOC]
（SpringMVC+Spring+ mybatis）
配置內(nèi)容：
導(dǎo)入jar插件
spring 管理連接文件
sessionFactory 管理session工廠
dataSource 管理數(shù)據(jù)源
MappingScannerCongigurer 管理映射文件
實(shí)現(xiàn)UserDao屬性注入 實(shí)現(xiàn)屬性注入
具體操作
- spring 管理連接文件
<bean class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
<property name="location" value="classpath:db.properties"> </property>
</bean>
- sessionFactory
<!--創(chuàng)建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
<!-- 數(shù)據(jù)源 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>
- 實(shí)現(xiàn)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();
通過構(gòu)造方法同映射文件中的sql語句相關(guān)聯(lián)（方法名）
<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>
轉(zhuǎn)發(fā)到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";
回調(diào)show方法
return "redirect:show";
重定向到show.jsp 頁面
return "redirect:/show.jsp";
}
