mybatis有两种方式,一种是基于XML,一种是基于注解
springboot集成mybatis
首先先创建表,这里都简化了
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `user` VALUES ('1', 'lijia');
然后创建maven项目,在pom.xml中添加
org.springframework.boot
spring-boot-parent
1.5.4.RELEASE
1.8
UTF-8
UTF-8
org.springframework.boot
spring-boot-starter-web
org.mybatis.spring.boot
mybatis-spring-boot-starter
1.3.0
mysql
mysql-connector-java
runtime
org.springframework.boot
spring-boot-devtools
true
com.alibaba
fastjson
1.2.31
org.projectlombok
lombok
provided
org.springframework.boot
spring-boot-maven-plugin
true
XML形式
目录结构是
application.properties
# jdbc_config
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://172.16.255.69:3306/test?characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=root
# Mybatis
#mybatis.typeAliasesPackage对应的是实体类位置
mybatis.typeAliasesPackage=org.lijia.bean
#myb