此次数据来源于
数据库链接: 数据库技术:省市县三级联动的SQL语句-猴子技术宅
项目架构
首先配置application.yml文件 设置端口和数据库这些应该不用解释了=-=
server:
port: 80
spring:
mvc:
view:
suffix: .html
prefix:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC
username: root
password: xjy
mybatis-plus:
global-config:
db-config:
id-type: auto
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
实体类
创建三个实体类(毕竟三表联动)
城市类
package com.domain;
import lombok.Data;
@Data
public class city {
Integer id;
String code1;
String name1;
String name;
String provincecode;
}
省份类
package com.domain;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
@Data
@TableName("t_address_province")//与数据库表名一致
public class province {
@TableId(ty