Spring整合MyBatis

  4.0.0

  org.example
  Spring_Student
  1.0-SNAPSHOT

  Spring_Student
  
  http://www.example.com

  
    UTF-8
    11
    11
  

  
    
    
      org.springframework
      spring-context
      5.2.9.RELEASE
    
    
    
      org.springframework
      spring-jdbc
      5.2.4.RELEASE
    
    
    
      org.springframework
      spring-tx
      5.2.4.RELEASE
    
    
    
      org.aspectj
      aspectjweaver
      1.8.9
    
    
    
      com.mchange
      c3p0
      0.9.5.2
    
    
    
      org.mybatis
      mybatis
      3.5.3
    
    
    
      org.mybatis
      mybatis-spring
      2.0.3
    
    
    
       mysql
       mysql-connector-java
       8.0.19
    
    
    
      org.slf4j
      slf4j-log4j12
      1.7.2
    
    
      org.slf4j
      slf4j-api
      1.7.2
    
    
    
      org.projectlombok
      lombok
      1.18.0
      provided
    
    

    
      cglib
      cglib
      2.2.2
    

    
      junit
      junit
      4.12
      test
    
    
      org.springframework
      spring-test
      4.3.0.RELEASE
    
    
      org.springframework
      spring-tx
      4.3.0.RELEASE
    
  

  
    
    
      
        src/main/resources
      
      
        src/main/java
        
          ***.properties
          **/*.tld
        
        false
      
    
    
    
  

路径：resources.Spring_Mybatis.xml

路径：resources.db.properties

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=123456

路径：resources.mybatis.xml

resources.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

package org.example.Spring_Mybatis.po;

public class User {
    private Integer userId;
    private String userName;
    private String userPwd;
    private String userEmail;
    private Date createDate;
    private Date updateDate;
    //get set 构造器。。。
}

    
        select user_id as userId,user_name as userName,user_pwd as userPwd
        from tb_user
        where user_id = #{userId}
    

package org.example.Spring_Mybatis.dao;
import org.example.Spring_Mybatis.po.User;
public interface UserDao {
    User queryUserByUserId(Integer userId);
}

package org.example.Spring_Mybatis.service;

import org.example.Spring_Mybatis.dao.UserDao;
import org.example.Spring_Mybatis.po.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class UserService {
    @Autowired
    private UserDao userDao;
    public User queryUserByUserId(Integer userId){
        return userDao.queryUserByUserId(userId);
    }
}

package org.example.Spring_Mybatis.controller;
import org.example.Spring_Mybatis.po.User;
import org.example.Spring_Mybatis.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
@Controller
public class UserController {
    // 注入userService
    @Autowired
    private UserService userService;

    public User queryUserByUserId(Integer userId) {
        User user = userService.queryUserByUserId(userId);
        return user;
    }
}

package org.example.Spring_Mybatis.test;

import org.example.Spring_Mybatis.controller.UserController;
import org.example.Spring_Mybatis.po.User;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.context.support.ClassPathXmlApplicationContext;

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

在spring_mybatis库中
create table tb_user(
	user_id int primary key,
	user_name VARCHAR(20),
	user_pwd  varchar(21),
	user_email varchar(100),
	create_date TIMESTAMP,
	update_date TIMESTAMP
)