mybatis和spring简单整合(dao/mapper)
1、导包mybatis-spring-1.3.2.jar
http://repo2.maven.org/maven2/org/mybatis/mybatis-spring/1.3.2/
2、在web.xml引入spring配置文件
<!-- 引入spring其它配置文件 --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:applicationContext-*.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener>
3、在根目录src下创建xml文件applicationContext-dao.xml
<!-- 引入数据库参数文件 --> <context:property-placeholder location=" classpath:resources/database.properties"/>
配置数据源
<!-- spring数据库源 --> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName"> <value>com.mysql.jdbc.Driver</value> </property> <property name="url"> <value>${jdbc.url}</value> </property> <property name="username"> <value>${jdbc.username}</value> </property> <property name="password"> <value>${jdbc.password}</value> </property> </bean>
配置sqlSessionFactory
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!-- 数据库源 --> <property name="dataSource" ref="dataSource"/> <!-- mybatis配置文件 --> <property name="configLocation" value="classpath:/resources/mybatis-config2.xml"/> </bean>
配置dao/mapper扫描器
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <!-- 扫描需要注入所依赖的dao --> <property name="basePackage" value="com.cyh.easydriver.modules.sys.dao"/> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> </bean>
4、修改mybatis的配置文件mybatis-config.xml
以及用spring配置了数据库源了,所以去掉<environments></environments>
5、注解和注入
@Service public interface UserService { public void test(); }
@Service public class UserServiceImpl implements UserService{ @Autowired private UserDao userDao; public void test(){ User user = userDao.selectOneByName("hello"); } }