在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称:minidao开源软件地址:https://gitee.com/jeecg/minidao开源软件介绍:MiniDao当前最新版本: 1.8.3 (发布日期:20210809) MiniDao 简介及特征An powerful enhanced toolkit of SpringJdbc for simplify development MiniDao 是一款轻量级JAVA持久层框架,基于 SpringJdbc + freemarker 实现,具备Mybatis一样的SQL分离和逻辑标签能力。Minidao产生的初衷是为了解决Hibernate项目,在复杂SQL具备Mybatis一样的灵活能力,同时支持事务同步。 具有以下特征:
如何快速集成minidao?<dependency> <groupId>org.jeecgframework</groupId> <artifactId>minidao-pe</artifactId> <version>1.8.3</version></dependency> 技术交流
项目介绍
支持28种数据库
代码体验1. 接口定义[EmployeeDao.java]@MiniDaopublic interface EmployeeDao { @Arguments({ "employee"}) @Sql("select * from employee") List<Map<String,Object>> getAll(Employee employee); @Sql("select * from employee where id = :id") Employee get(@Param("id") String id); @Sql("select * from employee where empno = :empno and name = :name") Map getMap(@Param("empno")String empno,@Param("name")String name); @Sql("SELECT count(*) FROM employee") Integer getCount(); int update(@Param("employee") Employee employee); void insert(@Param("employee") Employee employee); @ResultType(Employee.class) public MiniDaoPage<Employee> getAll(@Param("employee") Employee employee,@Param("page") int page,@Param("rows") int rows); } 2. SQL文件[EmployeeDao_getAllEmployees.sql]SELECT * FROM employee where 1=1 <#if employee.age ?exists>and age = :employee.age</#if><#if employee.name ?exists>and name = :employee.name</#if><#if employee.empno ?exists>and empno = :employee.empno</#if> 3. 接口和SQL文件对应目录4. 测试代码public class Client {public static void main(String args[]) { BeanFactory factory = new ClassPathXmlApplicationContext("applicationContext.xml"); EmployeeDao employeeDao = (EmployeeDao) factory.getBean("employeeDao"); Employee employee = new Employee(); String id = UUID.randomUUID().toString().replaceAll("-", "").toUpperCase(); employee.setId(id); employee.setEmpno("A001"); employee.setSalary(new BigDecimal(5000)); employee.setBirthday(new Date()); employee.setName("scott"); employee.setAge(25); //调用minidao方法插入 employeeDao.insert(employee);}} |
请发表评论