springboot整合通用mapper操作数据库

1. 建表sql

create table user (
 `id` int PRIMARY KEY auto_increment COMMENT '用户id',
`name`  VARCHAR(255) not null   COMMENT '用户名字',
`age` TINYINT(3) COMMENT '年龄',
`tel` VARCHAR(255) COMMENT '电话',
`create_time` TIMESTAMP  NOT NULL  COMMENT '创建时间',
`update_time` TIMESTAMP NOT NULL      COMMENT '更新时间'

)ENGINE = INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用户表';

2.pom.xml引入依赖

 <!-- jdbc -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        
        <!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        
        <!-- druid连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.14</version>
        </dependency>
        
        <!-- boot整合mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>
        
        <!--mybatis通用mapper依赖-->
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.0.2</version>
        </dependency>

3.配置文件

server.port=8081
//数据源配置
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/local?useUnicode=true&characterEncoding=utf-8&useSSL=false

//如果通用mapper不够用，有复杂sql还要加上mybatis的扫描xml

4.创建文件

4.1创建实体类

public class User  {
 //使用通用mapper必须要加上@Id注解，否则selectByPrimikey查询方法无效
    @Id  
    private  Integer id;
    private  String name;
    private Integer age;
    private String tel;
}

4.2 创建Mapper

//Mapper是基础的增删改查，根据Example查询等
//MySqlMapper是对mysql的一些操作
public interface BaseMapper<T> extends Mapper<T>, MySqlMapper<T> {
}

@Repository
public interface UserMapper extends BaseMapper<User> {
//虽然什么都没写，但是相当于拥有了通用mapper的基础增删该查功能
}

4.3 创建sevice和impl

public interface UserService {
    List<User> getAll();
    User getUserById(Integer id );
    int insertUser(User user);
    int deleteById(String id);
}

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    UserMapper userMapper;

    @Override
    public List<User> getAll() {
        return userMapper.selectAll();
    }

4.4 创建Controller方法

@CrossOrigin
@RestController()
public class UserController {

    @Autowired
    private UserService userService;


    @GetMapping(value = "get/all")
    @ResponseBody
    public List<User> getAll(){
        List<User> users = userService.getAll();

        return users ;
    }

4.5 主启动类加扫描和跨域

//如果没有不想要数据库，可以加上排除数据库操作
//@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
@SpringBootApplication
@EnableScheduling
@MapperScan(basePackages = {"com.example.demo.mapper"})
@CrossOrigin(origins = "*")
public class DemoApplication {

    public static void main(String[] args) {
		ApplicationContext applicationContext = SpringApplication.run(WeixinPlatformApplication.class, args);
}

完成！！