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
成功