All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.bixuebihui.db.Record Maven / Gradle / Ivy

Go to download

a fast small database connection pool and a active record flavor mini framework

There is a newer version: 1.15.3.3
Show newest version
package com.bixuebihui.db;

import com.bixuebihui.DbException;
import com.bixuebihui.jdbc.entity.CountObject;
import com.bixuebihui.jdbc.entity.CountValue;

import java.util.List;

/**
 * 
Record interface.

 *
 * @author xingwx
 * @version $Id: $Id
 */
public interface Record {
	/**
	 * 
getVector.
 获得单个字段
	 *
	 * @param field a {@link java.lang.String} object.
	 * @return a {@link java.util.List} object.
	 * @throws DbException if any.
	 */
	List getVector(String field) throws DbException;


	/**
	 * 
findAll.

	 * 查询多条
	 *
	 * @return a {@link java.util.List} object.
	 * @throws DbException if any.
	 */
	List findAll() throws DbException;

	/**
	 * 
findAll.

	 *
	 * @param clz the custom return type, for example a entity type that exclude return for blob/clob fields,
	 *            used in combination with the .fields() method.
	 * @return a {@link java.util.List} object.
	 * @throws DbException if any.
	 */
	 List findAll(Class clz) throws DbException;


	/**
	 * select one record from db
	 * @return a T object.
	 * @throws DbException if any.
	 */
	T find() throws DbException;


	/**
	 * 
delete.

	 * 删除
	 * @return a boolean.
	 * @throws DbException if any.
	 */
	boolean delete() throws DbException;


	/**
	 * 
get.

	 * 获得单个字段
	 * @param field a {@link java.lang.String} object.
	 * @return a {@link java.lang.Object} object.
	 * @throws DbException if any.
	 */
	Object get(String field) throws DbException;

	/**
	 * 
count.
 获得数量
	 *
	 * @return a int.
	 * @throws DbException if any.
	 */
	int count() throws DbException;

	/**
	 * 
countValue.
 获得数量
	 *
	 * @param field a {@link java.lang.String} object.
	 * @param fun   a {@link GroupFunction} object.
	 * @return a {@link CountValue} object.
	 * @throws DbException if any.
	 */
	CountValue countValue(String field, GroupFunction fun) throws DbException;

	/**
	 * 
countObject.

	 *
	 * @param field      a {@link java.lang.String} object.
	 * @param fun        a {@link GroupFunction} object.
	 * @param objectType a {@link java.lang.Class} object.
	 * @param         a K object.
	 * @return a {@link CountObject} object.
	 * @throws DbException if any.
	 */
	 CountObject countObject(String field, GroupFunction fun, Class objectType) throws DbException;

	 List> countList(String returnField, String[] groupByFields, String having, GroupFunction fun, Class objectType);

	/**
	 * 
countSum.
 获得数量
	 *
	 * @param field a {@link java.lang.String} object.
	 * @return a {@link CountValue} object.
	 * @throws DbException if any.
	 */
	CountValue countSum(String field) throws DbException;

	/**
	 * 
getSql.
 获得生产的sql
	 *
	 * @return a {@link SqlPocket} object.
	 * @throws DbException if any.
	 */
	SqlPocket getSql() throws DbException;


	/**
	 * 是否存在至少一条符合条件的记录
	 *
	 * @return true 存在
	 * @throws DbException 数据库异常
	 */
	boolean exists() throws DbException;

	/**
	 * 
getStringVector.
 获得单个字段
	 *
	 * @param field a {@link java.lang.String} object.
	 * @return a {@link java.util.List} object.
	 * @throws DbException if any.
	 */
	List getStringVector(String field) throws DbException;

	/**
	 * 获取字段field的长整型列表
	 *
	 * @param field 字段名
	 * @return List<Long> 长整形列表
	 * @throws DbException 数据库执行出错
	 */
	List getLongVector(String field) throws DbException;

	/**
	 * field = field +1
	 *
	 * @param field 字段名
	 * @return 影响的行数
	 * @throws DbException 数据库异常
	 */
	int inc(String field) throws DbException;

	/**
	 * 更新字段fields为values指定值
	 *
	 * @param fields 表字段名
	 * @param values 字段值， 如果values是SqlString 类型，将不参与形成预编译语句的占位符，而是原样输出
	 * @return 影响的行数
	 * @throws DbException  数据库异常
	 */
	int update(String[] fields, Object[] values) throws DbException;

	/**
	 * 
update.

	 *
	 * @param fields a {@link java.lang.String} object.
	 * @param values a {@link java.lang.Object} object.
	 * @return a int.
	 * @throws DbException if any.
	 */
	int update(String fields, Object values)throws DbException;

}
    

    

    

            

    

            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy