一、环境搭建
1.导入spring的orm包;
2.导入mybatis的jar包;
3.导入MySQL数据连接包。
二、配置文件
1.spring-mybatis.xml
<!-- 配置数据源 --> <bean id="jdbcDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="url" value="jdbc:mysql://localhost:3306/am?useUnicode=true&characterEncoding=utf-8"></property> <property name="username" value="root"></property> <property name="password" value="123456"></property> </bean> <!-- 配置会话工厂 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="jdbcDataSource"></property> <property name="mapperLocations" value="classpath:com/am/dao/*.xml"></property> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.am.dao"></property> <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> </bean>2.UserDao.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="com.am.dao.UserDao"> <resultMap type="com.am.model.User" id="userMap"> <id column="c_id" property="id" /> <result column="c_account" property="account"/> <result column="c_password" property="password"/> </resultMap> <select id="getUser" parameterType="com.am.model.User" resultMap="userMap"> SELECT * FROM t_user WHERE c_account=#{account} AND c_password=#{password} </select> </mapper>