SpringBoot_Mapper_Mybatis_Oracle

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.11</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.ishangu</groupId>
    <artifactId>MySpringBoot_mapper_MyBatis</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>MySpringBoot_mapper_MyBatis</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0.1.0</version>
        </dependency>
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper</artifactId>
            <version>4.1.5</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <!--配置通用mapper，数据库驱动等信息-->
                <configuration>
                    <configurationFile>${project.basedir}/src/main/resources/generatorConfiguration.xml</configurationFile>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

application.properties

#spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
#spring.datasource.url=jdbc:mysql:///house
#spring.datasource.password=123456
#spring.datasource.username=root
#spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#spring.jpa.show-sql=true
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl
spring.datasource.username=SCOTT
spring.datasource.password=123456
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.max-idle=10
spring.datasource.max-wait=10000
spring.datasource.min-idle=5
spring.datasource.initial-size=5
spring.jpa.show-sql=true

mybatis.mapper-locations=mappers/*.xml

mapper.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.ishangu.dao.GoodMapper" >
  <resultMap id="BaseResultMap" type="com.ishangu.model.Good" >
    <!--
      WARNING - @mbg.generated
    -->
    <constructor >
      <idArg column="id" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="parentid" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="typeno" jdbcType="VARCHAR" javaType="java.lang.String" />
      <arg column="typename" jdbcType="VARCHAR" javaType="java.lang.String" />
    </constructor>
  </resultMap>

  <select id="findByIdAndParentid" resultMap="BaseResultMap">
    select *
    from good
    where id=#{id} and parentid=#{parentid}
  </select>
</mapper>

model

package com.ishangu.model;

import javax.persistence.*;

//@Entity
@Table(name = "good")
public class Good {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY, generator = "jdbc")
    private Integer id;

    private Integer parentid;

    private String typeno;

    private String typename;

    public Good(Integer id, Integer parentid, String typeno, String typename) {
        this.id = id;
        this.parentid = parentid;
        this.typeno = typeno;
        this.typename = typename;
    }

    public Good() {
        super();
    }

    /**
     * @return id
     */
    public Integer getId() {
        return id;
    }

    /**
     * @param id
     */
    public void setId(Integer id) {
        this.id = id;
    }

    /**
     * @return parentid
     */
    public Integer getParentid() {
        return parentid;
    }

    /**
     * @param parentid
     */
    public void setParentid(Integer parentid) {
        this.parentid = parentid;
    }

    /**
     * @return typeno
     */
    public String getTypeno() {
        return typeno;
    }

    /**
     * @param typeno
     */
    public void setTypeno(String typeno) {
        this.typeno = typeno;
    }

    /**
     * @return typename
     */
    public String getTypename() {
        return typename;
    }

    /**
     * @param typename
     */
    public void setTypename(String typename) {
        this.typename = typename;
    }
}

dao

package com.ishangu.dao;

import com.ishangu.model.Good;
import org.apache.ibatis.annotations.Param;
import tk.mybatis.mapper.common.Mapper;

public interface GoodMapper extends Mapper<Good> {
    Good findByIdAndParentid(@Param("id") Integer id, @Param("parentid") Integer parentid);
}

service

package com.ishangu.service;

import com.ishangu.model.Good;

import java.util.List;

public interface GoodService {
    void save(Good good);
    void update(Good good);
    void delete(Integer id);
    Good login(Integer id,Integer parentid);
    Good login2(Integer id,Integer parentid);
    List<Good> findByTypenameLike(String typename);
    List<Good> findAll();

}

serviceimpl

package com.ishangu.service.impl;

import com.ishangu.dao.GoodMapper;
import com.ishangu.model.Good;
import com.ishangu.service.GoodService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import tk.mybatis.mapper.entity.Example;

import java.util.List;

@Service
public class GoodServiceImpl implements GoodService {
    @Autowired()
    GoodMapper repository;
    @Override
    public void save(Good good) {
        repository.insert(good);
        //repository.save(good);
    }

    @Override
    public void update(Good good) {
        repository.updateByExample(good,null);
        //repository.save(good);
    }

    @Override
    public void delete(Integer id) {
        //repository.deleteById(id);
    }

    @Override
    public Good login(Integer id, Integer parentid) {

        return repository.findByIdAndParentid(id,parentid);
        //return null;
    }

    @Override
    public Good login2(Integer id, Integer parentid) {
        Example example = new Example(Good.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("id",id);
        criteria.andEqualTo("parentid",parentid);
        return repository.selectOneByExample(example);
    }

    @Override
    public List<Good> findByTypenameLike(String typename) {

        //return repository.findByTypenameLike(typename);
        return null;
    }

    @Override
    public List<Good> findAll() {
        //return (List<Good>) repository.findAll();

        return repository.selectAll();
    }
}

controller

package com.ishangu.controller;

import com.ishangu.model.Good;
import com.ishangu.service.GoodService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class GoodController {

    @Autowired
    GoodService service;

    @RequestMapping("save")
    public String save(Good good){
        service.save(good);
        return "ok";
    }

    @RequestMapping("update")
    public String update(Good good){
        service.update(good);
        return "ok";
    }

    @RequestMapping("delete")
    public String delete(Integer id){
        service.delete(id);
        return "ok";
    }

    @RequestMapping("login")
    public Good login(Integer id,Integer parentid){

        return service.login(id,parentid);
    }

    @RequestMapping("login2")
    public Good login2(Integer id,Integer parentid){

        return service.login2(id,parentid);
    }
    
    @RequestMapping("like")
    public List<Good> findByTypenameLike(String typename){

        return service.findByTypenameLike(typename);
    }

    @RequestMapping("findAll")
    public List<Good> findAll(){

        return service.findAll();
    }
}

@SpringBootApplication

package com.ishangu;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import tk.mybatis.spring.annotation.MapperScan;

@SpringBootApplication
@MapperScan("com.ishangu.dao")
public class MySpringBootMapperMyBatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(MySpringBootMapperMyBatisApplication.class, args);
    }

}