1.导包:
org.mybatis.spring.boot mybatis-spring-boot-starter2.2.2 mysql mysql-connector-javaruntime
2.编写实体类:
public class Source {
String name;
int score;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getScore() {
return score;
}
public void setScore(int score) {
this.score = score;
}
}
3.编写mapper接口(没写更新操作)
import com.example.mybatismy.db.Source;
import org.apache.ibatis.annotations.*;
@Mapper
public interface UserMapper {
@Insert("insert into source(name,score) values(#{name},#{score})")
public void insert(Source source);
@Select("select * from source where name=#{name}")
public Source select(String name);
@Delete("delete from source where name=#{name}")
public Boolean delete(String name);
}
4.数据库连接配置文件
spring.datasource.url = jdbc:mysql://localhost:3306/mydb?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true spring.datasource.username = root spring.datasource.password= 123456 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
5.完成,接下来就可以直接调用mapper中的方法进行数据库的操作了



