spring boot(3) 用mybatis做数据库操作

①配置application.properties

spring.datasource.schema=import.sql

②在同等目录下建立文件import.sql

create table city (id int primary key auto_increment, name varchar, state varchar, country varchar);
insert into city (name, state, country) values ('San Francisco', 'CA', 'US');

③建立文件City.java

public class City implements Serializable {

	private static final long serialVersionUID = 1L;

	private Long id;

	private String name;

	private String state;

	private String country;

	public Long getId() {
		return this.id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public String getName() {
		return this.name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getState() {
		return this.state;
	}

	public void setState(String state) {
		this.state = state;
	}

	public String getCountry() {
		return this.country;
	}

	public void setCountry(String country) {
		this.country = country;
	}

	@Override
	public String toString() {
		return getId() + "," + getName() + "," + getState() + "," + getCountry();
	}
	
}

④创建文件CityMapper.java

@Mapper
public interface CityMapper {

	@Select("select * from city where state = #{state}")
	City findByState(@Param("state") String state);

}

⑤使用

	@Autowired
	private CityMapper cityMapper;

<span style="white-space:pre">	</span>cityMapper.findByState("CA")