经过上一章的学习,咱们已经对SpringBoot有简单的入门,接下来咱们深刻学习一下SpringBoot,咱们知道任何一个网站的数据大多数都是动态的,也就是说数据是从数据库提取出来的,而非静态数据,那么咱们接下来就是要链接数据库,如今咱们常常使用的数据库的种类能够大体分为两种,关系型数据库和非关系型数据库,而MySQL数据库,Oracle数据库SQL Server数据库等都是关系型数据库,而Redis,Mongodb等都是非关系型数据库。java
<?xml version="1.0" encoding="UTF-8"?> <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> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.1.3.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.demo02</groupId> <artifactId>demo_02</artifactId> <version>0.0.1-SNAPSHOT</version> <name>demo_02</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <!--mybatis-spring适配器--> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> <!--mysql驱动包--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.30</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
#建立商品信息表 create table product ( pid int primary key not null auto_increment COMMENT"商品编号", pname varchar(50) COMMENT"商品名称", pprice DECIMAL(10,2) COMMENT"商品价格", ptime varchar(50) COMMENT"入库时间", pcount int COMMENT"库存", pstatus int COMMENT"商品状态" #0 表明下架,1表明上架 )COMMENT"商品信息表" insert into product(pname,pprice,ptime,pcount,pstatus)VALUES ("苹果",11,"2019-10-1",11,1) SELECT * from product
package com.ssm.entity; /* * 商品实体类 * */ public class Product { private long pid;//编号 private String pname;//名称 private double pprice;//价格 private String ptime;//入库时间 private long pcount;//数量 private long pstatus;//状态 //无参构造方法 public Product() {} //带参构造方法 public Product(long pid, String pname, double pprice, String ptime, long pcount, long pstatus) { this.pid = pid; this.pname = pname; this.pprice = pprice; this.ptime = ptime; this.pcount = pcount; this.pstatus = pstatus; } public long getPid() { return pid; } public void setPid(long pid) { this.pid = pid; } public String getPname() { return pname; } public void setPname(String pname) { this.pname = pname; } public double getPprice() { return pprice; } public void setPprice(double pprice) { this.pprice = pprice; } public String getPtime() { return ptime; } public void setPtime(String ptime) { this.ptime = ptime; } public long getPcount() { return pcount; } public void setPcount(long pcount) { this.pcount = pcount; } public long getPstatus() { return pstatus; } public void setPstatus(long pstatus) { this.pstatus = pstatus; } @Override public String toString() { return "Product{" + "pid=" + pid + ", pname='" + pname + '\'' + ", pprice=" + pprice + ", ptime='" + ptime + '\'' + ", pcount=" + pcount + ", pstatus=" + pstatus + '}'; } }
#链接数据库的驱动 spring.datasource.driver-class-name=com.mysql.jdbc.Driver #链接数据库的url spring.datasource.url=jdbc:mysql://localhost:3306/ssm?characterEncoding=utf-8 #用户名 spring.datasource.username=root #密码 spring.datasource.password=123456
package com.ssm.dao; import com.ssm.entity.Product; import org.apache.ibatis.annotations.Select; import java.util.List; public interface ProductDao { @Select("select * from product") List<Product> findAllProduct(); }
package com.ssm.service; import com.ssm.entity.Product; import java.util.List; public interface ProductService { List<Product> findAllProduct(); }
package com.ssm.service.imple; import com.ssm.dao.ProductDao; import com.ssm.entity.Product; import com.ssm.service.ProductService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class ProductImple implements ProductService { @Autowired private ProductDao productDao; @Override public List<Product> findAllProduct() { return productDao.findAllProduct(); } }
package com.ssm.controller; import com.ssm.entity.Product; import com.ssm.service.ProductService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; @RestController public class ProductController { @Autowired private ProductService productService; //查询所有的商品信息 @GetMapping("/product") public List<Product> findAllProduct(){ return productService.findAllProduct(); } }
package com.demo02.demo_02; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.context.annotation.ComponentScan; @SpringBootApplication @ComponentScan(basePackages = {"com.ssm.controller","com.ssm.service"}) @MapperScan(basePackages = {"com.ssm.dao"}) public class Demo02Application { public static void main(String[] args) { SpringApplication.run(Demo02Application.class, args); } }
server: port: 8801 eureka: client: registerWithEureka: false fetchRegistry: false serviceUrl: defaultZone: http://localhost:8801/eureka/
spring: datasource: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/ssm?characterEncoding=utf-8 username: root password: 123456 mybatis: typeAliasesPackage: com.ssm.entity mapperLocations: classpath:mapper/*Mapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ssm.dao.ProductDao">
<!--查询所有商品信息-->
<select id="findAllProduct" resultType="product"> select * from product </select> </mapper>
package com.ssm.dao; import com.ssm.entity.Product; import org.apache.ibatis.annotations.Select; import java.util.List; public interface ProductDao { // @Select("select * from product") List<Product> findAllProduct(); }
package com.ssm.service; import com.ssm.entity.Product; import java.util.List; public interface ProductService { List<Product> findAllProduct(); }
package com.ssm.service.imple; import com.ssm.dao.ProductDao; import com.ssm.entity.Product; import com.ssm.service.ProductService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class ProductImple implements ProductService { @Autowired private ProductDao productDao; @Override public List<Product> findAllProduct() { return productDao.findAllProduct(); } }
package com.ssm.controller; import com.ssm.entity.Product; import com.ssm.service.ProductService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; @RestController public class ProductController { @Autowired private ProductService productService; //查询所有的商品信息 @GetMapping("/product") public List<Product> findAllProduct(){ return productService.findAllProduct(); } }
package com.demo02.demo_02; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.context.annotation.ComponentScan; @SpringBootApplication @ComponentScan(basePackages = {"com.ssm.controller","com.ssm.service"}) @MapperScan(basePackages = {"com.ssm.dao"}) public class Demo02Application { public static void main(String[] args) { SpringApplication.run(Demo02Application.class, args); } }