springbooot配置mybatis

springbooot-mybatis

我用的sts开发工具

1.建项目，选中MyBatis,MySql,Web

2. 建包如下

3.建实体

package com.mwk.myproject.entity;

import java.io.Serializable;

public class User implements Serializable {

	/**
	 * 
	 */
	private static final long serialVersionUID = -6985974461399240023L;
	private int id;
	private String name;
	private int age;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public User(int id, String name, int age) {
		super();
		this.id = id;
		this.name = name;
		this.age = age;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
	}
	
	
}

4.如下

5.配置application.properties

##################################################################################
#数据库连接配置
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
###################################################################################
#mybatis配置
mybatis.type-aliases-package=com.mwk.myproject.entity
mybatis.mapper-locations=classpath:com/mwk/myproject/mapper/*.xml
###################################################################################
#端口
server.port=80
###################################################################################

ps.application.properties中文如果乱码，选中application.properties右键->properties->

6.运行sql

/*
Navicat MySQL Data Transfer

Source Server         : 本地数据库
Source Server Version : 50638
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50638
File Encoding         : 65001

Date: 2018-03-22 21:44:24
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('5', '凯凯', '23');
INSERT INTO `user` VALUES ('6', 'aa', '23');
INSERT INTO `user` VALUES ('7', 'bb', '24');
INSERT INTO `user` VALUES ('8', 'cc', '25');
INSERT INTO `user` VALUES ('9', 'dd', '26');
INSERT INTO `user` VALUES ('10', 'ee', '27');

7.打开浏览器运行

http://localhost/findAll

成功

Demo码云下载