SpringBoot注解开发

开发前提：准备一张mysql表格

 

 

表格准备过后：

1》新建一个SpringBoot项目

在项目下新建4个包(controller,model,dao,service)，并且将application.properties重命名为application.yml

2》配置pom.xml(引入操作是需要的3个包)

1）SpringBoot同Mybatis整合的依赖。

2）SpringBoot操作数据库需要数据库的jar包（如mysql的jar包），还有需要连接池的jar包。

<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
	<groupId>com.ruijc</groupId>
	<artifactId>spring-boot-starter-mybatis</artifactId>
	<version>3.2.2</version>
</dependency>
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<scope>runtime</scope>
</dependency>

3》配置jdbc (在application.yml中)

注意空格，注意空格，注意空格！

server:
  address: 127.0.0.1
  port: 10093
  context-path: /three
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/bookonline
    username: root
    password: 123456

4》建立model层

public class BookType {
    private Integer typeid;
    private String typename;

    public Integer getTypeid() {
        return typeid;
    }
    public void setTypeid(Integer typeid) {
        this.typeid = typeid;
    }
    public String getTypename() {
        return typename;
    }
    public void setTypename(String typename) {
        this.typename = typename;
    }
}

5》在dao包下新建一个接口，通过注解的方式开发Mapper接口

@Mapper
public interface BookTypeMapper {
    @Insert("insert into booktype (typename) values(#{bookType.typename})")
    public int additem(@Param("bookType")BookType bookType);
}

6》service层

bookTypeMapper可能存在报红的情况，暂时不用管，不影响使用。

@Service
public class BookTypeService {
    @Autowired
    private BookTypeMapper bookTypeMapper;

    public int additem(BookType bookType){
        return bookTypeMapper.additem(bookType);
    }
}

7》controller

@Controller
public class BookTypeController {
    @Autowired
    private BookTypeService bookTypeService;
    @RequestMapping(value = "/add",method = RequestMethod.GET)
    @ResponseBody
    public int additem(BookType bookType){
        return bookTypeService.additem(bookType);
    }
}

8》运行程序

 

 

 

9》显示成功后，打开postman

显示回复1后证明数据上传成功，检查mysql