iiswin7,虐爱社区smgay,喷墨打印机论坛
<!---mybatis通用类包含mybatis和连接池 mybatis和连接池就不需要引入-->
<dependency>
<groupid>tk.mybatis</groupid>
<artifactid>mapper-spring-boot-starter</artifactid>
<version>2.1.2</version>
</dependency>
接口类:
package cn.itcast.mapper;
import cn.itcast.pojo.user;
import tk.mybatis.mapper.common.mapper;
public interface usermapper extends mapper<user> {
}
实体类:
package cn.itcast.pojo;
import lombok.data;
import tk.mybatis.mapper.annotation.keysql;
import javax.persistence.id;
import javax.persistence.table;
import java.util.date;
@data
@table(name = "user")
public class user {
@id //id
@keysql(usegeneratedkeys = true) //主键自增
private integer id;
private string mobile;
private string nickname;
private string password;
private string salt;
private string head;
private date registerdate;
private date lastlogindate;
private integer logincount;
}
配置:
server:
port: 8887
spring:
datasource:
driver-class-name: com.mysql.jdbc.driver
url: jdbc:mysql://127.0.0.1:3306/test?characterencoding=utf8&servertimezone=utc
username: root
password:
mybatis:
#configuration:
#map-underscore-to-camel-case: true
mapper-locations: mapper/*.xml
type-aliases-package: cn.itcast.pojo
入口文件:
import tk.mybatis.spring.annotation.mapperscan;
@mapperscan("cn.itcast.mapper")
package cn.itcast;
import cn.itcast.interceptor.myinterceptor;
import org.springframework.boot.springapplication;
import org.springframework.boot.autoconfigure.springbootapplication;
import org.springframework.web.servlet.config.annotation.interceptorregistry;
import org.springframework.web.servlet.config.annotation.webmvcconfigurer;
import tk.mybatis.spring.annotation.mapperscan;
@springbootapplication
@mapperscan("cn.itcast.mapper")
public class bootdemoapplication implements webmvcconfigurer {
//psvm 快速创建main
public static void main(string[] args) {
springapplication.run(bootdemoapplication.class,args);
}
@override
public void addinterceptors(interceptorregistry registry) {
registry.addinterceptor(new myinterceptor()).addpathpatterns("/**");
}
}
userservice:
package cn.itcast.service;
import cn.itcast.pojo.user;
public interface userservice {
public user querybyid(long id);
public integer insertuser(user user);
}
userserviceimpl:
package cn.itcast.service;
import cn.itcast.mapper.usermapper;
import cn.itcast.pojo.user;
import org.springframework.beans.factory.annotation.autowired;
import org.springframework.stereotype.service;
import org.springframework.transaction.annotation.transactional;
@service
public class userserviceimpl implements userservice {
@autowired
private usermapper usermapper;
public user querybyid(long id){
return usermapper.selectbyprimarykey(id);
}
@transactional
public integer insertuser(user user){
return usermapper.insert(user);
}
}
controller文件:
package cn.itcast.web;
import cn.itcast.pojo.user;
import cn.itcast.service.userservice;
import cn.itcast.service.userserviceimpl;
import lombok.extern.slf4j.slf4j;
import org.springframework.beans.factory.annotation.autowired;
import org.springframework.web.bind.annotation.*;
import javax.sql.datasource;
@slf4j
@restcontroller
@requestmapping("user")
public class hellocontroller {
@autowired
private userservice userservice;
/*@autowired
private datasource datasource;
*/
@getmapping("index")
public user hello(@requestparam("id") long id){
return userservice.querybyid(id);
}
}
打开浏览器,访问:
{
"id": 1,
"mobile": "13851848299",
"nickname": "william",
"password": "29ec3cef080fd52f406eb5ec30c7efba",
"salt": "1a2b3c4d",
"head": null,
"registerdate": null,
"lastlogindate": null,
"logincount": null
}
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
浅析我对 String、StringBuilder、StringBuffer 的理解
使用IDEA搭建SSM框架的详细教程(spring + springMVC +MyBatis)
Springboot整合freemarker 404问题解决方案
引入mybatis-plus报 Invalid bound statement错误问题的解决方法
网友评论