SpringBoot（四）创建一个三层结构SpringBootJDBC

怼烎@ 2022-04-02 19:39 112阅读 0赞

**1. 新建一个maven工程**  
参照SpringBoot（二）  
**2. 配置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/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
      <groupId>it.source</groupId>
      <artifactId>SpringBootJDBC</artifactId>
      <packaging>war</packaging>
      <version>0.0.1-SNAPSHOT</version>
      <name>SpringBootJDBC Maven Webapp</name>
      <url>http://maven.apache.org</url>
      
      <parent>
      	<groupId>org.springframework.boot</groupId>
      	<artifactId>spring-boot-starter-parent</artifactId>
      	<version>1.4.1.RELEASE</version>
      </parent>
      
      <properties>
      	<java.version>1.8</java.version>
      </properties>
    
      <dependencies>
      
     	 
      	<dependency>
      		<groupId>org.springframework.boot</groupId>
      		<artifactId>spring-boot-starter-web</artifactId>
      	</dependency>
        
        <dependency>
        	<groupId>mysql</groupId>
        	<artifactId>mysql-connector-java</artifactId>
        	
        </dependency>
        
        <dependency>
        	<groupId>org.springframework.boot</groupId>
        	<artifactId>spring-boot-starter-jdbc</artifactId>
        	 
        </dependency>
        
        <dependency>
        	<groupId>org.springframework.boot</groupId>
        	<artifactId>spring-boot-starter-data-jpa</artifactId>
        
        </dependency>
      </dependencies>
      
    </project>

**3. 配置application.properties**  
主要配置数据库信息

server.port=80
    spring.datasource.url=jdbc:mysql://locahost:3306/test
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.driverClassName=com.mysql.jdbc.Driver
    
    
    
    spring.datasource.dbcp.max-active=20
    spring.datasource.dbcp.max-idle=8
    spring.datasource.dbcp.min-idle=8
    spring.datasource.dbcp.initial-size=10

**4. Dao层代码（UserDao.java）**

package com.dao;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.BeanPropertyRowMapper;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.jdbc.core.RowMapper;
    import org.springframework.stereotype.Repository;
    
    import com.itsource.domain.User;
    @Repository
    public class UserDao {
    	@Autowired
    	private JdbcTemplate jdbcTemplate;
    	
    	public void save(User user) {
    		jdbcTemplate.update("insert into t_user(name) values(?)", user.getName());
    	}
    	
    	public User get(Long id) {
    		RowMapper<User> rowMapper = new BeanPropertyRowMapper<User>(User.class);
    		User user = jdbcTemplate.queryForObject("select * from t_user where id = ?",rowMapper,id);
    		return user;
    	}
    }

**5. Domain代码（User.java）**

package com.domain;
    
    public class User {
    	private long id;
    	private String name;
    	
    	public User() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    	
    	public User(String name) {
    		super();
    		this.name = name;
    	}
    
    	public long getId() {
    		return id;
    	}
    	public void setId(long id) {
    		this.id = id;
    	}
    	public String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	
    }

**6. Service层代码（接口和实现类）**

接口

package com.service;
    
    import com.itsource.domain.User;
    
    public interface UserService {
    	void save(User user);
    	User get(Long id);
    }

实现类

package com.service;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.itsource.dao.UserDao;
    import com.itsource.domain.User;
    @Service
    public class UserServiceImpl implements UserService{
        @Autowired
        private UserDao dao;
    	@Override
    	public void save(User user) {
    		dao.save(user);
    		
    	}
    
    	@Override
    	public User get(Long id) {
    		
    		return dao.get(id);
    	}
    
    }

**7. Controller层代码（UserController.java）**

package com.controller;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import com.itsource.domain.User;
    import com.itsource.service.UserService;
    
    @RestController
    public class UserController {
    	@Autowired
    	private UserService userService;
    	@RequestMapping("/user/save")
    	public String save(String name) {
    		User user = new User(name);
    		userService.save(user);
    		return "save successfully";
    	}
    	@RequestMapping("/user/get")
    	public User get(Long id) {
    		User user = userService.get(id);
    		return user;
    	}
    }

**8. 建数据库**  
t\_user ，id ，name两个字段即可。

**9. 测试代码（App.java）**

package com;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication//标记为springboot应用
    public class App {
    	public static void main(String[] args) {
    		//启动应用
    		SpringApplication.run(App.class,args);
    	}
    }