引入spring和junit4的依赖dependency groupIdorg.springframework/groupId artifactIdspring-context/artifactId version6.0.4/version /dependency !-- spring对junit支持的依赖spring6既支持junit4也支持junit5 -- dependency groupIdorg.springframework/groupId artifactIdspring-test/artifactId version6.0.4/version /dependency dependency groupIdjunit/groupId artifactIdjunit/artifactId version4.13.2/version scopetest/scope /dependency2.编写测试类RunWith(SpringJUnit4ClassRunner.class) // 加载spring.xml配置文件 加载spring容器 ContextConfiguration(classpath:spring.xml) public class SpringJunit4Test { Autowired private Account account; Test public void testSpringJunit4(){ System.out.println(account.getActno()); } }spring对junit5的支持引入依赖dependency groupIdorg.springframework/groupId artifactIdspring-context/artifactId version6.0.4/version /dependency !-- spring对junit支持的依赖-- dependency groupIdorg.springframework/groupId artifactIdspring-test/artifactId version6.0.4/version /dependency dependency groupIdorg.junit.jupiter/groupId artifactIdjunit-jupiter/artifactId version5.9.2/version scopetest/scope /dependency2.编写测试类ExtendWith(SpringExtension.class) ContextConfiguration(classpath:spring.xml) public class SpringJunit5Test { Autowired private Account account; org.junit.jupiter.api.Test public void testSpringJunit5(){ System.out.println(account.getActno()); } }spring集成mybatis引入依赖dependency groupIdorg.springframework/groupId artifactIdspring-context/artifactId version6.0.21/version /dependency dependency groupIdorg.springframework/groupId artifactIdspring-jdbc/artifactId version7.0.2/version /dependency dependency groupIdmysql/groupId artifactIdmysql-connector-java/artifactId version8.0.30/version /dependency dependency groupIdorg.mybatis/groupId artifactIdmybatis/artifactId version3.5.19/version /dependency dependency groupIdorg.mybatis/groupId artifactIdmybatis-spring/artifactId version4.0.0/version /dependency dependency groupIdcom.alibaba/groupId artifactIddruid/artifactId version1.1.20/version /dependency dependency groupIdjunit/groupId artifactIdjunit/artifactId version4.13.2/version scopetest/scope /dependency创建三层架构需要的包mapper、pojo、service编写pojo类public class Account { private String actno; private double balance; Override public String toString() { return Account{ actno actno \ , balance balance }; } public Account() { } public Account(String actno, double balance) { this.actno actno; this.balance balance; } public String getActno() { return actno; } public void setActno(String actno) { this.actno actno; } public double getBalance() { return balance; } public void setBalance(double balance) { this.balance balance; } }编写mapper接口// 该接口不需要写实现类mybatis会根据动态代理机制自动生成实现类 public interface AccountMapper { int update(Account getAccount); int insert(Account getAccount); int delete(String actno); Account getAccount(String actno); ListAccount getAllAccount(); }编写mapper配置文件?xml version1.0 encodingUTF-8 ? !DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//EN http://mybatis.org/dtd/mybatis-3-mapper.dtd mapper namespacecom.ali.mapper.AccountMapper insert idinsert parameterTypecom.ali.pojo.Account insert into t_act(actno, balance) values(#{actno}, #{balance}) /insert delete iddelete delete from t_act where actno #{actno} /delete update idupdate parameterTypecom.ali.pojo.Account update t_act set name #{name}, money #{money} where actno #{actno} /update select idgetAccount resultTypecom.ali.pojo.Account select actno, balance from t_act where actno #{actno} /select select idgetAllAccount resultTypecom.ali.pojo.Account select actno, balance from t_act /select /mapper编写service和service的实现类public interface AccountService { int addAccount(Account account); int updateAccount(Account account); int deleteAccount(String actno); Account getAccount(String actno); ListAccount getAllAccount(); }Service(accountService) public class AccountServiceImpl implements com.ali.service.AccountService { Autowired private AccountMapper accountMapper; Override public int addAccount(Account account) { return accountMapper.insert(account); } Override public int updateAccount(Account account) { return accountMapper.update(account); } Override public int deleteAccount(String actno) { return accountMapper.delete(actno); } Override public Account getAccount(String actno) { return accountMapper.getAccount(actno); } Override public ListAccount getAllAccount() { return accountMapper.getAllAccount(); } }编写jdbc.properties配置文件jdbc.drivercom.mysql.cj.jdbc.Driver jdbc.urljdbc:mysql://localhost:3306/spring6?useSSLfalseserverTimezoneUTC jdbc.usernameroot jdbc.passwordyourpassword编写mybaits-config.xml配置文件?xml version1.0 encodingUTF-8 ? !DOCTYPE configuration PUBLIC -//mybatis.org//DTD Config 3.0//EN http://mybatis.org/dtd/mybatis-3-config.dtd configuration !-- 打印mybatis的日志信息sql语句等-- settings setting namelogImpl valueSTDOUT_LOGGING/ /settings /configuration编写spring.xml配置文件
