cn.schoolwow.quickdao.builder.dml

接口 DMLBuilder

所有已知实现类:

AbstractDMLBuilder

public interface DMLBuilder

负责数据库增删改操作

方法概要

限定符和类型	方法和说明
ConnectionExecutorItem	clear(Class clazz) 清空表
ConnectionExecutorItem	clear(String tableName) 清空表
ConnectionExecutorItem	deleteByProperty(Class clazz, String property, Object value) 根据字段值删除
ConnectionExecutorItem	deleteByProperty(String tableName, String property, Object value) 根据字段值删除
ConnectionExecutorItem	insert(Object instance) 插入语句
ConnectionExecutorItem[]	insert(Object[] instances) 批量插入语句(返回自增id)
int	insertBatch(Object[] instances) 批量插入语句
ConnectionExecutorItem	updateById(Object instance) 根据id更新
ConnectionExecutorItem	updateById(Object[] instances) 根据id更新
ConnectionExecutorItem	updateByUniqueKey(Object instance) 根据唯一性约束更新
ConnectionExecutorItem	updateByUniqueKey(Object[] instances) 根据唯一性约束更新

方法详细资料

insert

ConnectionExecutorItem insert(Object instance)
                       throws Exception

插入语句

抛出:

Exception

insert

ConnectionExecutorItem[] insert(Object[] instances)
                         throws Exception

批量插入语句(返回自增id)

抛出:

Exception

insertBatch

int insertBatch(Object[] instances)
         throws Exception

批量插入语句

抛出:

Exception

updateByUniqueKey

ConnectionExecutorItem updateByUniqueKey(Object instance)
                                  throws Exception

根据唯一性约束更新

抛出:

Exception

updateByUniqueKey

ConnectionExecutorItem updateByUniqueKey(Object[] instances)
                                  throws Exception

根据唯一性约束更新

抛出:

Exception

updateById

ConnectionExecutorItem updateById(Object instance)
                           throws Exception

根据id更新

抛出:

Exception

updateById

ConnectionExecutorItem updateById(Object[] instances)
                           throws Exception

根据id更新

抛出:

Exception

deleteByProperty

ConnectionExecutorItem deleteByProperty(Class clazz,
                                        String property,
                                        Object value)
                                 throws SQLException

根据字段值删除

抛出:

SQLException

deleteByProperty

ConnectionExecutorItem deleteByProperty(String tableName,
                                        String property,
                                        Object value)
                                 throws SQLException

根据字段值删除

抛出:

SQLException

clear

ConnectionExecutorItem clear(Class clazz)
                      throws SQLException

清空表

抛出:

SQLException

clear

ConnectionExecutorItem clear(String tableName)
                      throws SQLException

清空表

抛出:

SQLException