Appliction.java
package hello;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.datasource.SimpleDriverDataSource;
@ComponentScan
@EnableAutoConfiguration
public class Application {
private static JdbcTemplate jdbcTemplate;
//查询数据
public static List<Greeting> getData(String name) {
System.out.println("select * from Greetings where content like %"+name+"%;");
List<Greeting> results = jdbcTemplate.query(
"select * from Greetings where content like ? ",
new Object[] { "%"+name+"%" }, new RowMapper<Greeting>() {
@Override
public Greeting mapRow(ResultSet rs, int rowNum)
throws SQLException {
return new Greeting(rs.getLong("id"), rs
.getString("content"));
}
});
System.out.println("size:"+results.size());
return results;
}
//建立表,并插入数据
private static void initTable() {
System.out.println("Creating tables");
jdbcTemplate.execute("create table Greetings("
+ "id serial, content varchar(255))");
String[] names = "John Woo;Jeff Dean;John Woo;Josh Long".split(";");
for (String name : names) {
System.out.printf("Inserting Greeting record for %s\n", name);
jdbcTemplate.update("INSERT INTO Greetings(content) values(?)",
name);
}
}
//初始化数据库链接,得到jdbcTemplate
private static void connectionDB() {
SimpleDriverDataSource dataSource = new SimpleDriverDataSource();
dataSource.setDriverClass(com.mysql.jdbc.Driver.class);
dataSource.setUsername("root");
dataSource.setUrl("jdbc:mysql://localhost:3306/test");
dataSource.setPassword("root");
jdbcTemplate = new JdbcTemplate(dataSource);
}
public static void main(String args[]) {
SpringApplication.run(Application.class, args);
connectionDB();
// initTable();
List<Greeting> results = getData("John");
for (Greeting Greeting : results) {
System.out.println(Greeting);
}
}
}
GreetingController
package hello;
import java.util.List;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class GreetingController {
@RequestMapping("/greeting")
public List<Greeting> greeting(@RequestParam(value="name", required=false, defaultValue="John Woo") String name) {
System.out.println("name"+name);
List<Greeting> res = Application.getData(name);
return res;
}
}
模型Greeting
package hello;
public class Greeting {
private final long id;
private final String content;
public Greeting(long id, String content) {
this.id = id;
this.content = content;
}
public long getId() {
return id;
}
public String getContent() {
return content;
}
}
maven配置
<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/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>testspringmvc</groupId>
<artifactId>testspringmvc</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<name>testspringmvc</name>
<url>http://maven.apache.org</url>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.0.6.RELEASE</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.21</version>
</dependency>
</dependencies>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.1.3.RELEASE</version>
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<start-class>hello.Application</start-class>
</properties>
<build>
<plugins>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>2.3.2</version>
</plugin>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
<repositories>
<repository>
<id>spring-releases</id>
<url>http://repo.spring.io/libs-release</url>
</repository>
</repositories>
<pluginRepositories>
<pluginRepository>
<id>spring-releases</id>
<url>http://repo.spring.io/libs-release</url>
</pluginRepository>
</pluginRepositories>
</project>
演示:
源码下载地址:http://download.csdn.net/detail/chenxiruanhai/7685107