spring 集成 mybatis

spring 集成 mybatis

环境配置

1>先创建maven的quickstart项目;并且创建dao层,service层,controller层,po层,mapper,resources以及下面的配置文件(db.properties,log4j.properties,mybatis.xml,spring.xml).

2>配置pom.xml

​ 修改jdk版本;

​ 添加依赖:

​ junit版本改为4.12;spring-context;spring-test;spring-jdbc;spring-tx(事务);aspectjweaver(切面编程);c3p0(连接池);mybatis;mybatis-spring;mysql-connector-java(mysql驱动包);slf4j-log4j12,slf4j-api(日志打印);

​ 设置资源目录和插件

​

 <build>
  <!--
   Maven 项目:如果源代码(src/main/java)存在xml、properties、tld 等文件
   Maven 默认不会自动编译该文件到输出目录,如果要编译源代码中xml properties tld 等文件
   需要显式配置 resources 标签
 -->
  <resources>
   <resource>
    <directory>src/main/resources</directory>
   </resource>
   <resource>
    <directory>src/main/java</directory>
    <includes>
     <include>**/*.xml</include>
     <include>**/*.properties</include>
     <include>**/*.tld</include>
    </includes>
    <filtering>false</filtering>
   </resource>
  </resources>
 </build>

3>配置spring.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:context="http://www.springframework.org/schema/context"
   xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx.xsd">
    <!-- 扫描基本包 -->
    <context:component-scan base-package="com.xxxx" />

    <!-- 加载properties 配置文件 -->
    <context:property-placeholder location="classpath:db.properties" />

    <!-- aop -->
    <aop:aspectj-autoproxy />

    <!-- 配置c3p0 数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

    <!-- 配置事务管理器 -->
    <bean id="txManager"
          class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 设置事物增强 -->
    <tx:advice id="txAdvice" transaction-manager="txManager">
        <tx:attributes>
            <tx:method name="add*" propagation="REQUIRED" />
            <tx:method name="insert*" propagation="REQUIRED" />
            <tx:method name="update*" propagation="REQUIRED" />
            <tx:method name="delete*" propagation="REQUIRED" />
        </tx:attributes>
    </tx:advice>

    <!-- aop 切面配置 -->
    <aop:config>
        <aop:pointcut id="servicePointcut" expression="execution(* com.xxxx.service..*.*(..))" />
        <aop:advisor advice-ref="txAdvice" pointcut-ref="servicePointcut" />
    </aop:config>

    <!-- 配置 sqlSessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="configLocation" value="classpath:mybatis.xml" />
        <property name="mapperLocations" value="classpath:com/xxxx/mapper/*.xml" />
    </bean>

    <!-- 配置扫描器 -->
    <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- 扫描com.xxxx.dao这个包以及它的子包下的所有映射接口类 -->
        <property name="basePackage" value="com.xxxx.dao" />
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
    </bean>
</beans>

4>配置 mybatis.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="com.xxxx.po"/>
  </typeAliases>
</configuration>

5>配置 db.properties

jdbc.url中?前面的spring_mybatis是数据库名字,注意要修改下

password是密码,也是要修改下的

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/spring_mybatis?
useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false
jdbc.username=root
jdbc.password=root 

6>添加日志 log4j.properties

log4j.rootLogger=DEBUG, Console
# Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

添加源代码

1>在po 包下创建 JavaBean 文件 User.java

public class User {
  private Integer userId;
  private String userName;
  private String userPwd;
  private String userEmail;
  private Date createDate;
  private Date updateDate;
 
  /**
   set get toString 方法省略
  **/
}

2>在dao层添加UserDao接口

public interface UserDao {
  User queryUserByUserId(Integer userId);
}

3>在mapper包添加UserMapper.xml 映射文件

sql代码写在这地方

<?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.xxxx.dao.UserDao">
   <select id="queryUserByUserId" parameterType="int"
resultType="com.xxxx.po.User">
     select user_id as userId,user_name as userName,user_pwd as userPwd
     from tb_user
     where user_id = #{userId}
   </select>
</mapper>

4>添加 UserService.java

@Service
public class UserService {
  @Autowired
  private UserDao userDao;
  public User queryUserByUserId(Integer userId){
    return userDao.queryUserByUserId(userId);
 }
}

5>添加 UserController.java

@Controller
public class UserController {
  // 注入userService
  @Resource
  private UserService userService;
  /**
  * 通过用户ID查询用户对象
  * @param userId
  * @return
  */
  public User queryUserByUserId(Integer userId) {
    User user = userService.queryUserByUserId(userId);
    return user;
 }
}

执行测试

public class App {
  public static void main(String[] args) {
    // 加载Spring的配置
    BeanFactory factory = new ClassPathXmlApplicationContext("spring.xml");
    // 得到UserController对象
    UserController userController = (UserController)
factory.getBean("userController");
    // 调用方法
    User user = userController.queryUserByUserId(1);
System.out.println(user.toString());
 }
}