我学习这个技术除了它是国人自己开发的之外,
还因为它的性能确实比mybatis和thymeleaf更胜一筹,
而且因为是国人开发,所以看官网文档学习的速度更快,

1. 创建一个springboot项目
   

2. 数据库导入sql文件

/*
Navicat Premium Data TransferSource Server         : one
Source Server Type    : MySQL
Source Server Version : 80020
Source Host           : localhost:3306
Source Schema         : menuTarget Server Type    : MySQL
Target Server Version : 80020
File Encoding         : 65001Date: 12/08/2020 10:38:24
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for meat
-- ----------------------------
DROP TABLE IF EXISTS `meat`;
CREATE TABLE `meat`  (`id` int(0) NOT NULL AUTO_INCREMENT,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of meat
-- ----------------------------
INSERT INTO `meat` VALUES (0, '可乐焖猪肉');
INSERT INTO `meat` VALUES (1, '干炒猪肉丝');
INSERT INTO `meat` VALUES (2, '宫保猪肉丁');
INSERT INTO `meat` VALUES (3, '黑胡椒猪肉炒笋片');
INSERT INTO `meat` VALUES (4, '蕃茄猪肉片菠菜蛋花汤');
INSERT INTO `meat` VALUES (5, '葱爆牛肉');
INSERT INTO `meat` VALUES (6, '土豆烧牛肉');
INSERT INTO `meat` VALUES (7, '水煮牛肉');
INSERT INTO `meat` VALUES (8, '山药牛肉粒');
INSERT INTO `meat` VALUES (9, '金针牛肉卷');
INSERT INTO `meat` VALUES (10, '红烧鸡腿');
INSERT INTO `meat` VALUES (11, '茄汁松茸鸡胸肉');
INSERT INTO `meat` VALUES (12, '蒜香鸡翅');
INSERT INTO `meat` VALUES (13, '新奥尔良鸡翅');
INSERT INTO `meat` VALUES (14, '炖牛筋土豆小萝卜');-- ----------------------------
-- Table structure for vegetable
-- ----------------------------
DROP TABLE IF EXISTS `vegetable`;
CREATE TABLE `vegetable`  (`id` int(0) NOT NULL AUTO_INCREMENT,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of vegetable
-- ----------------------------
INSERT INTO `vegetable` VALUES (0, '醋溜白菜');
INSERT INTO `vegetable` VALUES (1, '白菜炖豆腐');
INSERT INTO `vegetable` VALUES (2, '白菜木耳炖粉丝');
INSERT INTO `vegetable` VALUES (3, '蒜茸油麦菜');
INSERT INTO `vegetable` VALUES (4, '素炒小白菜');
INSERT INTO `vegetable` VALUES (5, '韭菜炒鸡蛋');
INSERT INTO `vegetable` VALUES (6, '小白菜烩金针菇');
INSERT INTO `vegetable` VALUES (7, '蒜泥菠菜');
INSERT INTO `vegetable` VALUES (8, '蒜苗炒肉');
INSERT INTO `vegetable` VALUES (9, '蒜苗烧豆腐\r\n');
INSERT INTO `vegetable` VALUES (10, '蚝油生菜');
INSERT INTO `vegetable` VALUES (11, '白灼生菜\r\n');
INSERT INTO `vegetable` VALUES (12, '上汤娃娃菜');
INSERT INTO `vegetable` VALUES (13, '培根炒娃娃菜');
INSERT INTO `vegetable` VALUES (14, '清炒香菇大白菜');SET FOREIGN_KEY_CHECKS = 1;

3. pom文件插入代码如下:

<dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId><exclusions><!-- 去掉springboot默认logging配置 --><exclusion><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-logging</artifactId></exclusion></exclusions></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-devtools</artifactId><scope>runtime</scope><optional>true</optional></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope><exclusions><exclusion><groupId>org.junit.vintage</groupId><artifactId>junit-vintage-engine</artifactId></exclusion></exclusions></dependency>
<!--        beelt和beeltsql集合包--><dependency><groupId>com.ibeetl</groupId><artifactId>beetl-framework-starter</artifactId><version>1.2.33.RELEASE</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.21</version></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><dependency> <!-- 引入log4j2依赖，非必要，可自行选择logging组件 --><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-log4j2</artifactId></dependency></dependencies>

4. application.properties配置Mysql

spring.datasource.url=jdbc:mysql://localhost:3306/menu?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=****
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver#beetl读取html后缀文件
beetl.suffix=html

5. 创建一个配置类来配置beeltsql(在项目下创建一个conf包,在包中创建配置类)

@Configuration
public class DataSourceConfig {@Bean(name = "dataSource")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;}@Beanpublic BeetlSqlDataSource beetlSqlDataSource(@Qualifier("dataSource") DataSource dataSource){BeetlSqlDataSource source = new BeetlSqlDataSource();source.setMasterSource(dataSource);return source;}@Beanpublic BeetlSqlCustomize beetlSqlCustomize() {return new BeetlSqlCustomize() {@Overridepublic void customize(SqlManagerFactoryBean sqlManager) {sqlManager.setDbStyle(new MySqlStyle());}};}
}

6. 创建一个beeltsql自动生成pojo代码文件

public class BeetlSqlTest {public static void main(String[] args) throws Exception {String driver="com.mysql.cj.jdbc.Driver";String url="jdbc:mysql://localhost:3306/menu?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&useSSL=false";String userName="root";String password="xt19970726";ConnectionSource source = ConnectionSourceHelper.getSimple(driver, url, userName, password);DBStyle mysql = new MySqlStyle();
// sql语句放在classpagth的/sql 目录下SQLLoader loader = new ClasspathLoader("/sql");
// 数据库命名跟java命名一样，所以采用DefaultNameConversion，还有一个是UnderlinedNameConversion，下划线风格的，UnderlinedNameConversion nc = new  UnderlinedNameConversion();
// 最后，创建一个SQLManager,DebugInterceptor 不是必须的，但可以通过它查看sql执行情况SQLManager sqlManager = new SQLManager(mysql,loader,source,nc,new Interceptor[]{new DebugInterceptor()});GenConfig config = new GenConfig();config.preferBigDecimal(true);config.setBaseClass("");sqlManager.genPojoCode("meat","com.example.demobeetlsql.entity",config);sqlManager.genPojoCode("Vegetable","com.example.demobeetlsql.pojo",config);}}

7. 创建MeatDao和VegetableDao(不需要任何注解,只需要继承BaseMapper,可以直接使用制作者写好的Mapper应对基础CRUD)

public interface MeatDao extends BaseMapper<Meat> {public List<Meat> selectSample(Meat query);
}

public interface VegetableDao extends BaseMapper<Vegetable> {public List<Vegetable> selectSample(Vegetable query);
}

8. 创建MeatService和VegetableService,以及他们的实现类

public interface MeatService {public Meat getMeatById(Integer id);public List<Meat> select(String name);}

@Service
public class MeatServiceImpl implements MeatService {@AutowiredMeatDao meatDao;public Meat getMeatById(Integer id) {return meatDao.unique(id);}@Overridepublic List<Meat> select(String name) {Meat paras = new Meat();paras.setName(name);return meatDao.selectSample(paras);}
}

public interface VegetableService {public Vegetable getvegetableById(Integer id);public List<Vegetable> select(String name);}

@Service
public class VegetableServiceImpl implements VegetableService {@AutowiredVegetableDao vegetableDao;public Vegetable getvegetableById(Integer id) {return vegetableDao.unique(id);}@Overridepublic List<Vegetable> select(String name) {Vegetable paras = new Vegetable();paras.setName(name);return vegetableDao.selectSample(paras);}
}

9. 创建IndexController

@Controller
public class IndexController {private String date = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));@Autowiredprivate MeatService meatService;@Autowiredprivate VegetableService vegetableService;@GetMapping(path = {"", "/", "/index"})public ModelAndView index() {Map<String, Object> data = new HashMap<>();Set<Integer> sets = new LinkedHashSet<>();List<Meat> meats = new ArrayList<>();List<Vegetable> vegetables = new ArrayList<>();Random random = new Random();int randInt;Meat name;Vegetable name2;while (sets.size() < 3){sets.add(random.nextInt(14));}for (Integer set : sets) {name = meatService.getMeatById(set);meats.add(name);name2 = vegetableService.getvegetableById(set);vegetables.add(name2);}data.put("meats",meats);data.put("vegetables", vegetables);return new ModelAndView("index.html", data);}}

10. 在resources/templates中创建一个index.html

<!DOCTYPE html>
<html>
<head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1"><meta name="description" content="SpringBoot Beetl"/><meta name="author" content="Summer"/><meta name="viewport" content="width=device-width, initial-scale=1.0"/><title> SpringBoot Beetl Demo</title><link rel="stylesheet" href="index.css"/>
</head>
<body><div><div class="title">今日菜品</div><div class="sign">荤菜选择 </div><%for(meat in meats){%><div class="content"> ${meat.name}</div><%}%><br/><div class="sign">素菜选择 </div><%for(vegetable in vegetables){%><div class="content"> ${vegetable.name}</div><%}%><br/></div>
</body>
</html>

11. 在resources/static中创建一个index.css

.title {color: #c00;font-weight: normal;font-size: 2em;
}.content {color: darkblue;font-size: 1.2em;
}.sign {color: black;font-size: 0.8em;font-style: italic;
}

12. 在网页输入localhost:8080测试网页
    
    beelt的语法十分简单,而beetlsql还有很多强大的功能,运行成功的小伙伴可以去beelt的官网学习~