在2018年参与的项目里面用了beetlsql这个持久层框架,感觉这个框架挺不错的,国人写的框架
在mybatis、hibernate、beetlsql三个中,作者比较过,是beetlsql的速度最快
比其他两个得分更高,在前面开发的项目中感觉都可以,因为项目还不是很大。
beetlsql的单个表的查询支持lambda表达式查询,个人感觉非常的爽,非常的好用。
使用
依赖
单单beetlsql的依赖
<dependency>
<groupId>com.ibeetl</groupId>
<artifactId>beetlsql</artifactId>
<version>2.10.43</version>
</dependency>
配置
首先用jdbc、hikariCP配置好数据库连接
https://blog.csdn.net/qq_36712111/article/details/87630545 这里可以参考下
这里我用的是java的配置
package com.wys.read.config;
import org.beetl.sql.core.ClasspathLoader;
import org.beetl.sql.core.Interceptor;
import org.beetl.sql.core.UnderlinedNameConversion;
import org.beetl.sql.core.db.MySqlStyle;
import org.beetl.sql.ext.DebugInterceptor;
import org.beetl.sql.ext.spring4.BeetlSqlDataSource;
import org.beetl.sql.ext.spring4.BeetlSqlScannerConfigurer;
import org.beetl.sql.ext.spring4.SqlManagerFactoryBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
/**
* @author wys
* created in 16:46 2019/1/4
*/
@Configuration
public class BeetlsqlConfig {
// 配置的是beetlsql的框架配置
@Bean
public BeetlSqlScannerConfigurer sqlScannerConfigurer(){
BeetlSqlScannerConfigurer beetlSqlScannerConfigurer = new BeetlSqlScannerConfigurer();
beetlSqlScannerConfigurer.setBasePackage("com.demo.dao"); // beetlsql扫描的dao层包
beetlSqlScannerConfigurer.setSqlManagerFactoryBeanName("sqlManagerFactoryBean");
return beetlSqlScannerConfigurer;
}
// 配置的是beetlsql需要使用的据库源和md文件路径
@Bean
public SqlManagerFactoryBean sqlManagerFactoryBean(DataSource dataSource) {
SqlManagerFactoryBean sqlManagerFactoryBean = new SqlManagerFactoryBean();
BeetlSqlDataSource beetlSqlDataSource = new BeetlSqlDataSource();
beetlSqlDataSource.setMasterSource(dataSource); // 加载数据源到beetlsql的数据源
sqlManagerFactoryBean.setCs(beetlSqlDataSource);
sqlManagerFactoryBean.setDbStyle(new MySqlStyle());
sqlManagerFactoryBean.setSqlLoader(new ClasspathLoader("/sql/")); // 后面你要写的beetlsql自定义sql语句方法的md文件的路径
sqlManagerFactoryBean.setNc(new UnderlinedNameConversion()); // 下划线匹配加载
sqlManagerFactoryBean.setInterceptors(new Interceptor[]{ new DebugInterceptor() }); // beetlsql debug日志输出
return sqlManagerFactoryBean;
}
}
编写代码
实体
创建一个用户实体为例子
package com.wys.read.entity;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.beetl.sql.core.annotatoin.AutoID;
import java.io.Serializable;
/**
* 用户
* @author wys
* created in 16:29 2019/1/4
*/
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class User implements Serializable {
private static final long serialVersionUID = 4223404153633504854L;
/**
* 自增aid
*/
@AutoID
private Integer aid;
/**
* 账号
*/
private String accountNumber;
/**
* 密码
*/
private String password;
}
用户实体的dao
package com.wys.read.dao;
import com.wys.read.entity.User;
import org.beetl.sql.core.mapper.BaseMapper;
import org.springframework.stereotype.Repository;
/**
* @author wys
* created in 16:35 2019/1/4
*/
@Repository
public interface UserDao extends BaseMapper<User> {
}
service使用
在service中使用dao
service使用dao的lambda表达式查询
package com.wys.read.service;
import cn.hutool.core.util.StrUtil;
import com.wys.read.dao.UserDao;
import com.wys.read.entity.User;
import com.wys.read.exception.FrameErrorCodeEnums;
import com.wys.read.exception.FrameRuntimeException;
import org.beetl.sql.core.query.LambdaQuery;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* @author wys
* created in 23:24 2019/1/4
*/
@Service
public class UserService {
@Autowired
private UserDao userDao;
// 通过名字获取账号
public List<User> getUser(String name) {
if (StrUtil.isBlank(name)) {
throw new FrameRuntimeException(FrameErrorCodeEnums.BIND_ARGS_ERROR);
}
// 获取user的lambda表达式查询
LambdaQuery<User> userLambdaQuery = userDao.createLambdaQuery();
// 使用lambda表达式查询
List<User> userList = userLambdaQuery.andEq(User::getAccountNumber, name).select();
return userList;
}
}
md文件编写自定义的sql语句也是挺方便的
https://blog.csdn.net/qq_36712111/article/details/87633903
目前是这样