8.Spring+Mybatis整合(注解方式)

mybatis-config.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
	<!-- 配置别名 -->
	<typeAliases>
		<package name="cn.qf.springandmybatis.pojo"></package>
	</typeAliases>
</configuration>

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
	http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
	http://www.springframework.org/schema/context
	http://www.springframework.org/schema/context/spring-context-3.2.xsd
	http://www.springframework.org/schema/aop
	http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">
	
	<!--1.配置数据源（连接池）  ,destroy-method="close":创建后自动关闭-->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<!-- name是这个bean对象所在类的属性值，是固定值-->
		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
		<property name="url" value="jdbc:mysql://localhost:3306/supermarket"></property>
		<property name="username" value="root"></property>
		<property name="password" value="cuichen975541045"></property>
	</bean>
	
	<!-- 2.通过配置让spring创建sqlSessionFactory,作用：获取一个连接，创建sqlSessionTemplate(相当于mybatis中的sqlSession),来操作数据库 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 2.1设置引用的数据源，通过ref到设置的连接池中获取连接,然后赋给name -->
		<property name="dataSource" ref="dataSource"></property>
		<!-- 2.2设置mybatis的配置文件位置，使用这个bean所对应类中的configLocation(Resource类型)属性来读取配置文件的位置 -->
		<property name="configLocation" value="mybatis-config.xml"></property>
	</bean>
	
	<!-- 加载Mapper映射文件: MapperScannerConfigurer加载,读取mapper文件
		根据Mapper映射文件和对应的接口生成实现类,并且创建实现类的对象
	-->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="cn.qf.springandmybatis.dao"></property>
	</bean>

	<!-- 告诉spring扫描指定的包,按注解执行 -->
	<context:component-scan base-package="cn.qf.springandmybatis.service"></context:component-scan>
	<!-- 启用AOP -->
	<aop:aspectj-autoproxy></aop:aspectj-autoproxy>
</beans>

---

dao层

UserMapper.java

package cn.qf.springandmybatis.dao;

import java.util.List;

import cn.qf.springandmybatis.pojo.User;
//注意!接口的名字一定要和mapper文件的名字一致
public interface UserMapper {
	
	//添加
	public int addUser(User user);
	
	//查询
	public List<User> getUserListBy(User user);
}

UserMapper.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="cn.qf.springandmybatis.dao.UserMapper">
	<insert id="addUser" parameterType="User">
		insert into smbms_user(userCode,userName,userRole)
		values(#{userCode},#{userName},#{userRole2.id}) 
	</insert>
	<select id="getUserListBy" parameterType="User" resultType="User">
		select id,userCode,userName,userPassword from smbms_user
		where userName like CONCAT('%',#{userName},'%') and userRole=#{userRole2.id}
	</select>
</mapper>

---

Service层
UserService.java

package cn.qf.springandmybatis.service;

import java.util.List;

import cn.qf.springandmybatis.pojo.User;

public interface UserService {
	//添加方法
	public boolean addUser(User user);
	
	//查询方法
	public List<User> getUsersBy(User user);
}

UserServiceImpl.java
@Service(“usi”) 指定当前类对象的名字
@Autowired 用自动装配的方式给对象注入值

package cn.qf.springandmybatis.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.qf.springandmybatis.dao.UserMapper;
import cn.qf.springandmybatis.pojo.User;
@Service("usi")
public class UserServiceImpl implements UserService{
	//注入值,用自动装配的方式
	@Autowired
	private UserMapper userDao;
	
	public UserMapper getUserDao() {
		return userDao;
	}

	public void setUserDao(UserMapper userDao) {
		this.userDao = userDao;
	}

	//添加方法
	public boolean addUser(User user) {
		int result = userDao.addUser(user);
		if (result==1) {
			return true;
		}else {
			return false;
		}
	}
	//查询方法
	public List<User> getUsersBy(User user) {
		return userDao.getUserListBy(user);
	}

}

---

controller层