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

    • com.github.giantray.compositesSelectSql.SelectSql Maven / Gradle / Ivy

    package com.github.giantray.compositesSelectSql;

import java.util.ArrayList;
import java.util.List;

/**
 * Select SQL generate result set
 */
public class SelectSql {
	/**
	 * sql like 'select * from xxx where xxx order by xxx limit x,x'
	 */
	private String selectAll;
	/**
	 * sql like 'select count(*) from xxx where xxx order by xxx limit x,x'
	 */
	private String selectCount;
	/**
	 * where segment like 'where xxx'
	 */
	private String where;
	/**
	 * limit segment like 'limit x,y'
	 */
	private String limit;
	/**
	 * order segment like 'order by xx desc'
	 */
	private String order;

	/**
	 * sql like 'select * from xxx where a =? and b =? order by xxx limit x,x'
	 */
	private String selectAllForPreparedstatement;

	/**
	 * sql like 'select count(*) from xxx where a =? and b =? order by xxx limit
	 * x,x'
	 */
	private String selectCountForPreparedstatement;

	/**
	 * para for preparedstatement sql where condition
	 */
	private List whereParaListForPreparedstatement = new ArrayList();

	/**
	 * 
	 * @return sql like 'select * from xxx where xxx order by xxx limit x,x'
	 */
	public String getSelectAll() {
		return selectAll;
	}

	public void setSelectAll(String selectAll) {
		this.selectAll = selectAll;
	}

	/**
	 * 
	 * @return sql like 'select count(*) from xxx where xxx order by xxx limit
	 *         x,x'
	 */
	public String getSelectCount() {
		return selectCount;
	}

	public void setSelectCount(String selectCount) {
		this.selectCount = selectCount;
	}

	/**
	 * 
	 * @return where segment like 'where xxx'
	 */
	public String getWhere() {
		return where;
	}

	public void setWhere(String where) {
		this.where = where;
	}

	/**
	 * 
	 * @return limit segment like 'limit x,y'
	 */
	public String getLimit() {
		return limit;
	}

	public void setLimit(String limit) {
		this.limit = limit;
	}

	/**
	 * 
	 * @return order segment like 'order by xx desc'
	 */
	public String getOrder() {
		return order;
	}

	public void setOrder(String order) {
		this.order = order;
	}

	/**
	 * 
	 * @return sql like 'select count(*) from xxx where a =? and b =? order by
	 *         xxx limit
	 */
	public String getSelectAllForPreparedstatement() {
		return selectAllForPreparedstatement;
	}

	public void setSelectAllForPreparedstatement(String selectAllForPreparedstatement) {
		this.selectAllForPreparedstatement = selectAllForPreparedstatement;
	}

	/**
	 * 
	 * @return sql like 'select count(*) from xxx where a =? and b =? order by
	 *         xxx limit x,x'
	 */
	public String getSelectCountForPreparedstatement() {
		return selectCountForPreparedstatement;
	}

	public void setSelectCountForPreparedstatement(String selectCountForPreparedstatement) {
		this.selectCountForPreparedstatement = selectCountForPreparedstatement;
	}

	/**
	 * 
	 * @return para for preparedstatement sql where condition
	 */
	public List getWhereParaListForPreparedstatement() {
		return whereParaListForPreparedstatement;
	}

	public void setWhereParaListForPreparedstatement(List whereParaListForPreparedstatement) {
		this.whereParaListForPreparedstatement = whereParaListForPreparedstatement;
	}

}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy