All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • 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.8.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 org.apache.commons.lang3.tuple.Pair;

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.
    
	 * 查询多条
	 *
	 * @return a {@link java.util.List} object.
	 * @throws DbException if any.
	 */
	Pair> findAllWithCount() 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