com.github.giantray.compositesSelectSql

类 SelectSql

java.lang.Object

com.github.giantray.compositesSelectSql.SelectSql

public class SelectSql
extends Object

Select SQL generate result set

构造器概要

构造器

构造器和说明
SelectSql()

方法概要

方法

限定符和类型	方法和说明
String	getLimit()
String	getOrder()
String	getSelectAll()
String	getSelectAllForPreparedstatement()
String	getSelectCount()
String	getSelectCountForPreparedstatement()
String	getWhere()
List<Object>	getWhereParaListForPreparedstatement()
void	setLimit(String limit)
void	setOrder(String order)
void	setSelectAll(String selectAll)
void	setSelectAllForPreparedstatement(String selectAllForPreparedstatement)
void	setSelectCount(String selectCount)
void	setSelectCountForPreparedstatement(String selectCountForPreparedstatement)
void	setWhere(String where)
void	setWhereParaListForPreparedstatement(List<Object> whereParaListForPreparedstatement)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

SelectSql

public SelectSql()

方法详细资料

getSelectAll

public String getSelectAll()

返回:

sql like 'select * from xxx where xxx order by xxx limit x,x'

setSelectAll

public void setSelectAll(String selectAll)

getSelectCount

public String getSelectCount()

返回:

sql like 'select count(*) from xxx where xxx order by xxx limit x,x'

setSelectCount

public void setSelectCount(String selectCount)

getWhere

public String getWhere()

返回:

where segment like 'where xxx'

setWhere

public void setWhere(String where)

getLimit

public String getLimit()

返回:

limit segment like 'limit x,y'

setLimit

public void setLimit(String limit)

getOrder

public String getOrder()

返回:

order segment like 'order by xx desc'

setOrder

public void setOrder(String order)

getSelectAllForPreparedstatement

public String getSelectAllForPreparedstatement()

返回:

sql like 'select count(*) from xxx where a =? and b =? order by xxx limit

setSelectAllForPreparedstatement

public void setSelectAllForPreparedstatement(String selectAllForPreparedstatement)

getSelectCountForPreparedstatement

public String getSelectCountForPreparedstatement()

返回:

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

setSelectCountForPreparedstatement

public void setSelectCountForPreparedstatement(String selectCountForPreparedstatement)

getWhereParaListForPreparedstatement

public List<Object> getWhereParaListForPreparedstatement()

返回:

para for preparedstatement sql where condition

setWhereParaListForPreparedstatement

public void setWhereParaListForPreparedstatement(List<Object> whereParaListForPreparedstatement)