springboot集成mybatis(二)

       简介&＃xff1a;以前写过一篇关于spring boot集成mybatis的文章&＃xff0c;不过那篇文章是基于注解的&＃xff0c;没有以xml的形式加载&＃xff0c;这片文章比较通俗&＃xff0c;完全是基于部分xml风格的&＃xff0c;现在简单介绍下&＃xff0c;以前那篇文章的地址在https://blog.csdn.net/xhf852963/article/details/98724831。

org.mybatis.spring.bootmybatis-spring-boot-starter1.1.1mysqlmysql-connector-java
第二步&＃xff1a;在application.properties配置相关信息

spring.mvc.view.prefix&＃61;/WEB-INF/views/
spring.mvc.view.suffix&＃61;.jspspring.datasource.url&＃61;jdbc:mysql://localhost:3306/zlits_user?useSSL&＃61;false
spring.datasource.username&＃61;root
spring.datasource.password&＃61;Rfid123456
spring.datasource.driver-class-name&＃61;com.mysql.jdbc.Driverspring.jpa.properties.hibernate.hbm2ddl.auto&＃61;update
spring.jpa.properties.hibernate.dialect&＃61;org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.show-sql&＃61; true#是否检查配置文件
mybatis.check-config-location &＃61;true
#mybatis的配置文件的位置
mybatis.config-location&＃61;classpath:mybatis-config.xml
#mybatis的mapper文件的位置
mybatis.mapper-locations&＃61;classpath*:mapper/*Mapper.xml
第三步&＃xff1a;建库建表

DROP DATABASE IF EXISTS zlits_user;
CREATE DATABASE zlits_user;
USE zlits_user;
SET FOREIGN_KEY_CHECKS&＃61;0;
DROP TABLE IF EXISTS &＃96;user&＃96;;
CREATE TABLE &＃96;user&＃96; (&＃96;ID&＃96; bigint(20) NOT NULL AUTO_INCREMENT COMMENT &＃39;ID&＃39;,&＃96;NAME&＃96; varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT &＃39;名字&＃39;,&＃96;PASSWORD&＃96; varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT &＃39;密码&＃39;,&＃96;AGE&＃96; bigint(20) DEFAULT NULL COMMENT &＃39;年龄&＃39;,PRIMARY KEY (&＃96;ID&＃96;)
) ENGINE&＃61;InnoDB DEFAULT CHARSET&＃61;utf8 COMMENT&＃61;&＃39;人员信息表&＃39;;
第四步&＃xff1a;工程代码结构如下 

       UserMapper类

&＃64;Mapper
public interface UserMapper {int deleteByPrimaryKey(Long id);int insert(User record);int insertSelective(User record);User selectByPrimaryKey(Long id);int updateByPrimaryKeySelective(User record);int updateByPrimaryKey(User record);List selectAll();
}

       User类

public class User implements Serializable {private Long id;private String name;private String password;private Long age;private static final long serialVersionUID &＃61; 1L;public Long getId() {return id;}public void setId(Long id) {this.id &＃61; id;}public String getName() {return name;}public void setName(String name) {this.name &＃61; name &＃61;&＃61; null ? null : name.trim();}public String getPassword() {return password;}public void setPassword(String password) {this.password &＃61; password &＃61;&＃61; null ? null : password.trim();}public Long getAge() {return age;}public void setAge(Long age) {this.age &＃61; age;}&＃64;Overridepublic String toString() {StringBuilder sb &＃61; new StringBuilder();sb.append(getClass().getSimpleName());sb.append(" [");sb.append("Hash &＃61; ").append(hashCode());sb.append(", id&＃61;").append(id);sb.append(", name&＃61;").append(name);sb.append(", password&＃61;").append(password);sb.append(", age&＃61;").append(age);sb.append(", serialVersionUID&＃61;").append(serialVersionUID);sb.append("]");return sb.toString();}
}

       UserMapper.xml配置文件



ID, NAME, PASSWORD, AGEselect from userwhere ID &＃61; #{id,jdbcType&＃61;BIGINT}select from userdelete from userwhere ID &＃61; #{id,jdbcType&＃61;BIGINT}SELECT LAST_INSERT_ID()insert into user (NAME, PASSWORD, AGE)values (#{name,jdbcType&＃61;VARCHAR}, #{password,jdbcType&＃61;VARCHAR}, #{age,jdbcType&＃61;BIGINT})SELECT LAST_INSERT_ID()insert into userNAME,PASSWORD,AGE,#{name,jdbcType&＃61;VARCHAR},#{password,jdbcType&＃61;VARCHAR},#{age,jdbcType&＃61;BIGINT},update userNAME &＃61; #{name,jdbcType&＃61;VARCHAR},PASSWORD &＃61; #{password,jdbcType&＃61;VARCHAR},AGE &＃61; #{age,jdbcType&＃61;BIGINT},where ID &＃61; #{id,jdbcType&＃61;BIGINT}update userset NAME &＃61; #{name,jdbcType&＃61;VARCHAR},PASSWORD &＃61; #{password,jdbcType&＃61;VARCHAR},AGE &＃61; #{age,jdbcType&＃61;BIGINT}where ID &＃61; #{id,jdbcType&＃61;BIGINT}


       UserService接口及实现类

public interface UserService {public List findAll();}&＃64;Service
public class UserServiceImpl implements UserService {&＃64;AutowiredUserMapper mapper;public List findAll() {System.out.println("执行了DAO层");return mapper.selectAll();}
}

       UserController类

&＃64;Controller
public class UserController {&＃64;AutowiredUserService userService;//查询&＃64;RequestMapping("/listUserCommon")public String listUser(Model model) {List users &＃61; userService.findAll();for (User user : users) {System.out.println(user.toString());}model.addAttribute("users", users);return "listUser";}
}

       jsp界面

<%&＃64; page language&＃61;"java" contentType&＃61;"text/html; charset&＃61;UTF-8"%>






<%&＃64; taglib uri&＃61;"http://java.sun.com/jsp/jstl/core" prefix&＃61;"c"%>

       在浏览器输入http://localhost:8080/listUserCommon

       简要说明&＃xff1a;如果在UserMapper类上不添加&＃64;Mapper类,那么就得在 启动类上添加&＃64;MapperScan 注解&＃xff0c;一般情况下都是在启动类上添加&＃64;MapperScan注解&＃xff0c;如果类比较多的话统一加一个标签就够了&＃xff0c;加这个注解的标签主要是为了让spring进行管理&＃xff0c;如果有多个dao&＃xff0c;用逗号隔开即可&＃64;MapperScan({"com.zit.cac.dao","com.zit.epms.dao"})