## 環境搭建 為了方便快速演示，使用Spring單元測試。 在src/test下創建一個java類SimpleApplication，如下 ```java package org.beetl.sql.springboot.simple; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.context.annotation.PropertySource; @PropertySource(value = { "classpath:application-simple.properties" }, encoding = "utf-8") @SpringBootApplication public class SimpleApplication { public static void main(String[] args) { SpringApplication.run(SimpleApplication.class, args); } } ``` application-simple.properties 是springboot的配置文件（參考`BeetlSqlConfig`，內容如下 ```properties spring.datasource.url=jdbc:h2:mem:dbtest;DB_CLOSE_ON_EXIT=FALSE spring.datasource.username=sa spring.datasource.password= spring.datasource.driver-class-name=org.h2.Driver # beetlsql = sqlManager1 舊版的配置 beetlsql.sqlManagers=sqlManager1 # 新版配置 beetlsql.sqlManager1.ds=ds1 beetlsql.sqlManager1.basePackage=org.beetl.sql.springboot.simple ``` ```yml beetlsql: sqlManagers: sqlManager1,sqlManager2 sqlManager1: ds: dataSource basePackage: org.beetl.sql.springboot.simple daoSuffix: Dao ``` Spring配置需要配置如下Bean * datasource，這里使用H2庫，這個是在`SimpleDataSourceConfig` 類里配置的數據源，命名為ds1 * beetlsql 配置一個名為sqlManager1的SQLManager實例，其后的配置`beetlsql.sqlManager1.ds` 配置了關聯的數據源ds1 ? 并配置了mapper的包名是org.beetl.sql.springboot.simple，BeetlSQL將會掃描其下的所有的Mapper接口，并為其自動生成代理類，注冊為Spring的Bean SimpleDataSourceConfig定義如下，會配置一個叫ds1的數據源 ```java @Configuration public class SimpleDataSourceConfig { @Autowired ApplicationContext ctx; @Primary @Bean(name = "ds1") public DataSource datasource(Environment env) { HikariDataSource ds = new HikariDataSource(); ds.setJdbcUrl(env.getProperty("spring.datasource.url")); ds.setUsername(env.getProperty("spring.datasource.username")); ds.setPassword(env.getProperty("spring.datasource.password")); ds.setDriverClassName(env.getProperty("spring.datasource.driver-class-name")); return ds; } @Bean public SQLManagerCustomize mySQLManagerCustomize(){ return new SQLManagerCustomize(){ @Override public void customize(String sqlMangerName, SQLManager manager) { //初始化sql，這里也可以對sqlManager進行修改 DBInitHelper.executeSqlScript(manager,"db/schema.sql"); } }; } } ``` SQLManagerCustomize類可以在配置的基礎上，定制SQLManager，這里不做任何修改，僅僅調用初始化數據庫，以方便測試 有了以上準備，現在可以編寫一個單元測試 ```java @RunWith(SpringRunner.class) @SpringBootTest(classes = SimpleApplication.class) @Transactional public class SimpleTest { @Autowired SQLManager sqlManager; @Autowired SimpleUserInfoMapper userInfoMapper; @Test public void test(){ sqlManager.single(UserInfo.class,1); userInfoMapper.single(1); } } ``` SimpleUserInfoMapper 是一個BeetlSQL3的Mapper，定義如下 ```java public interface SimpleUserInfoMapper extends BaseMapper<UserInfo> { } ``` UserInfo定義如下 ```java @Table(name="sys_user") @Data public class UserInfo { @AssignID private Long id; private String name; } ``` UserService是一個Spring的Service，簡單的調用`userMapper.insert` ```java @Service @Transactional public class UserService { @Autowired UserMapper userMapper; public void addUser(UserInfo userInfo){ userMapper.insert(userInfo); } } ``` UserMapper是一個BeetlSQL3的Mapper,我們使用BaseMapper提供的內置insert方法操作 ```java public interface UserMapper extends BaseMapper<UserInfo> { } ```