Ebean指南，操纵数据库，增删改查，包教包会，就是这么简单粗暴

就是这么简单粗暴，学不会你来找我

1. 入门使用

在IDEA的plugins里,下载如图所示插件

每次在启动项目前,先在build里把Ebean11的对号,打上,不然项目无法启动
当出现下面这样的query抱错时,可以编译下项目或者刷新下maven就可以了,或者直接运行项目也可以.

import  cn.kop.uma.model.query.QExtraParametersModel;

Maven添加依赖

  <dependency>
            <groupId>io.ebean</groupId>
            <artifactId>ebean</artifactId>
            <version>12.3.1</version>
        </dependency>
        <dependency>
            <groupId>io.ebean</groupId>
            <artifactId>ebean-querybean</artifactId>
            <version>12.3.1</version>
            <exclusions>
                <exclusion>
                    <groupId>io.ebean.tile</groupId>
                    <artifactId>enhancement</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>io.ebean</groupId>
            <artifactId>querybean-generator</artifactId>
            <version>12.3.1</version>
            <scope>provided</scope>
        </dependency>

2. 增

WorkModel model = new WorkModel();
model.setName(name.getText());
model.setMaterial(passWordl.getText());
model.save();

3. 删

WorkModel model = new QWorkpieceModel().id.eq(tableModel.getId()).findOne();
model.deletePermanent();

4. 改

KopModel updateModel = new QKopModel().id.eq(id).findOne();
updateModel.setName(12);
updateModel.update();

5. 查

1. 根据id查

WorkModel model = new QWorkModel().id.eq(tableModel.getId()).findOne();

2. 根据条件查

List<Lop> list = new QKopModel().mate.eq(input.getMate()).
        thic.between((float) input.getThic() - (float) 0.01, (float) input.getThic() + (float) 0.01).groove.eq((float) input.getAngle()). gapMin.lessOrEqualTo(input.getGap()).gapMax.greaterThan(input.getGap()).offsetsMin.lessOrEqualTo(input.getMisalignment()).offsetsMax.greaterThan(input.getMisa()).findList();