在yml下配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/cs
username: root
password: root
创建实体类测试
@ToString
@Data
public class User {
private int ida;
private String loginPwd;
private String loginEmail;
}
创建Dao层
@Mapper
public interface UserDao {
@Select("select * from aoao where ida =#{id}")
public User getById(Integer id);
}
执行
package com.example;
import com.example.dao.UserDao;
import com.example.domain.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
@SpringBootTest
class SpringbootMybatis01ApplicationTests {
@Autowired
private UserDao UserDao;
@Test
void contextLoads() {
System.out.println(UserDao.getById(1));
}
}
