springboot+mybatis 查询一下

实现一下springboot Controller查询一段数据

application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/taotao?characterEncoding=utf-8&useSSL=falsespring.datasource.username=rootspring.datasource.password=123123spring.datasource.driver-class-name=com.mysql.jdbc.Driver

启动类

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

Dao层

@Mapperpublic interface Search {    @Select("select item_desc from tb_item_desc where item_id = #{itemId};")    String search(String itemId);}

Controller控制器

@RestControllerpublic class ViewController {    @Autowired    Search search;    @RequestMapping("/View")    public String getSearchItemResultList( String itemId){        String result = search.search(itemId);        return result;    }}

POJO类

public class SearchItem implements Serializable {    private String id ;    private String title ;    private String sell_point ;    private long price ;    private String image ;    private String category_name ;    private String item_desc ;    public String getId() {        return id;    }    public void setId(String id) {        this.id = id;    }    public String getTitle() {        return title;    }    public void setTitle(String title) {        this.title = title;    }    public String getSell_point() {        return sell_point;    }    public void setSell_point(String sell_point) {        this.sell_point = sell_point;    }    public long getPrice() {        return price;    }    public void setPrice(long price) {        this.price = price;    }    public String getImage() {        return image;    }    public void setImage(String image) {        this.image = image;    }    public String getCategory_name() {        return category_name;    }    public void setCategory_name(String category_name) {        this.category_name = category_name;    }    public String getItem_desc() {        return item_desc;    }    public void setItem_desc(String item_desc) {        this.item_desc = item_desc;    }    @Override    public String toString() {        return "SearchItem [id=" + id + ", title=" + title + ", sell_point=" + sell_point + ", price=" + price                + ", image=" + image + ", category_name=" + category_name + ", item_desc=" + item_desc + "]";    }   }

pom.xml

<parent>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-starter-parent</artifactId>    <version>1.5.9.RELEASE</version></parent><properties>    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>    <java.version>1.8</java.version></properties><dependencies>    <dependency>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-starter</artifactId>    </dependency>    <dependency>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-starter-test</artifactId>        <scope>test</scope>    </dependency>    <dependency>        <groupId>org.mybatis.spring.boot</groupId>        <artifactId>mybatis-spring-boot-starter</artifactId>        <version>1.3.0</version>    </dependency>    <dependency>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-starter-web</artifactId>    </dependency>    <dependency>        <groupId>mysql</groupId>        <artifactId>mysql-connector-java</artifactId>        <version>6.0.6</version>    </dependency>       <dependency>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-devtools</artifactId>        <optional>true</optional><!-- optional=true,依赖不会传递，该项目依赖devtools；之后依赖myboot项目的项目如果想要使用devtools，需要重新引入 -->    </dependency></dependencies><build>    <plugins>        <plugin>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-maven-plugin</artifactId>        </plugin>        <plugin>            <groupId>org.apache.maven.plugins</groupId>            <artifactId>maven-surefire-plugin</artifactId>            <configuration>                <skip>true</skip>            </configuration>        </plugin>    </plugins></build>