maven项目 spring-boot 整合 mybatis 实现查询功能demo

整个项目的结构

直接贴代码

spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8spring.datasource.username=rootspring.datasource.password=123456spring.datasource.driver-class-name=com.mysql.jdbc.Driverserver.port=1111

下面这个是启动类 运行时只需 run as --> java Application 即可

package org.shenlan;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplicationpublic class Application {public static void main(String[] args) {SpringApplication.run(Application.class, args);}}

package org.shenlan.web;/** * Created by wangwei on 2016/9/2. */public class User {private Integer id;private String name;private Integer age;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}}

package org.shenlan.web;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import org.springframework.web.bind.annotation.RestController;/** * Created by wangwei on 2016/9/2. */@RestController@RequestMapping({ "/home" })public class UserController {@AutowiredUserMapper userMapper;@RequestMapping(value = "/user/{userName}")@ResponseBodypublic String user(@PathVariable("userName") String userName) {User user = userMapper.findUserByName(userName);if (user == null) return userName+"不存在" ;else return user.getName()+"年龄："+user.getAge() ;}}

package org.shenlan.web;import org.apache.ibatis.annotations.Mapper;import org.apache.ibatis.annotations.Param;import org.apache.ibatis.annotations.Select;/** * Created by Administrator on 2016/9/2. */@Mapperpublic interface UserMapper {@Select("select * from user where name = #{name}")User findUserByName(@Param("name") String name);}

pom.xml

<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 http://maven.apache.org/maven-v4_0_0.xsd"><modelVersion>4.0.0</modelVersion><groupId>spring-boot</groupId><artifactId>spring-boot</artifactId><packaging>war</packaging><version>0.0.1-SNAPSHOT</version><name>spring-boot Maven Webapp</name><url>http://maven.apache.org</url><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>1.3.2.RELEASE</version><relativePath /></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.1.1</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>5.1.21</version></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></project>

数据库的表为

启动项目后浏览器打开   http://localhost:1111/home/user/张三 

项目下载地址：http://download.csdn.net/detail/qq_27292113/9810370

转载地址：http://www.jb51.net/article/91800.htm