在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称:fluentsql开源软件地址:https://gitee.com/artlongs/fluentsql开源软件介绍:Fluent-SQL我们不生产SQL,我们只是SQL的搬运工! Lambda 风格的流式 SQL 查询工具,支持多表 lefjoin,from(子表),sum case , iif ,group by(子表属性)...集成了SQL2O,JDBCTEMPLATE实现CRUD,分页查询等. 自我感觉良好,有了这个小工具,可以忘却 Hibernate,Mybatis... Fluent-SQL 优势所在:
开发思历世面上有的 ORM 我多数都用过,用得最多的是 Hibernate,Mybatis.日子久了我就在想有没有一种 ORM 既易用而又高性能的呢?鱼与掌真的不能兼得吗?要说高性能,原生SQL肯定是性能最高,可是原生SQL却有硬代码,并且因为前端的查询条件的可选性,自己手动拼接查询条件时,必然会有许许多多的 IF(null!=xx){sql}... , 这个缺点 Hibernate,Mybatis 一样也会有.这催发了我 开发出 fluent-sql 这个项目, 这只是一个工具类, 却绝对会让你大叫: SHUANG! SHUANG! SHUANG! fluent-sql + sql2o ,就是性能与易用的经典示范! SQL2O 项目地址 : https://github.com/aaberg/sql2o 约定:
性能测试 v0.0.8 新增加FluentSql 自己的基于原生JAVA JDBC的底层数据访问,可以完全不依赖第三方ORM实现CRUD,查询效率得到重大的提升。测试结果如下(同一批数据,各ORM随机查询1000次):======================================================================RUNNING 1000 ITERATIONS THAT LOAD UP A POST ENTITYSelect Results-------------------------HandCoded took 11msFluentSql took 13ms (18.18% slower)Sql2oTypical took 15ms (36.36% slower)ApacheDbUtilsTypical took 19ms (72.73% slower)Sql2oNameType took 22ms (100.00% slower)BeetlSqlTypical took 25ms (127.27% slower)FluentSqlNameType took 32ms (190.91% slower)JDBI took 44ms (300.00% slower)MyBatis took 51ms (363.64% slower)SpringJdbcTemplateTypical took 56ms (409.09% slower)SpringJdbcTemplateNameType took 60ms (445.45% slower)HibernateTypical took 66ms (500.00% slower)JOOQ took 81ms (636.36% slower)======================================================================测试用例在:fluentsql-core包test目录下的PojoPerformanceTest.class 语法示例:SELECT user.user_name AS userName,dept.dept_name AS deptName FROM `user` AS user LEFT JOIN `dept` ON user.dept_id = dept.id WHERE (LOCATE (user.user_name,'jack')>0)GROUP BY user.dept_id HAVING (user.dept_id>0) ORDER BY user.dept_id ASC,user.user_name DESC 等同与: String sql = new Lq<>(User.class) .select(User::getUserName) .select(Attr.parse(Dept::getDeptName)) .leftJoin(Dept.class) .andLike(User::getUserName, "jack") .group(User::getDeptId) .having(User::getDeptId, Qe.Opt.GT, 0) .asc(User::getDeptId) .desc(User::getUserName) .build(); MAVEN增加对本项目的使用,您可以按自己项目需求只选择对子项目的依赖 fluentsql-core | fluentsql-sql2o | fluentsql-jdbctemplate <dependency> <groupId>com.artfii.fluentsql</groupId> <artifactId>fluentsql-core</artifactId> <version>0.0.10</version></dependency><dependency> <groupId>com.artfii.fluentsql</groupId> <artifactId>fluentsql-jdbctemplate</artifactId> <version>0.0.10</version></dependency><!-- 或 fluentsql-sql2o --><dependency> <groupId>com.artfii.fluentsql</groupId> <artifactId>fluentsql-sql2o</artifactId> <version>0.0.10</version></dependency> Version更新内容0.0.10 完善读写分离以及 SQL 注入排查 |
请发表评论