package com.hx.mybatisTool;
|
|
import com.hx.exception.TipsException;
|
import com.hx.util.SimpleTool;
|
import com.hx.util.StringUtils;
|
|
import java.util.Map;
|
|
/**
|
* mybatis 自定义处理sql语句
|
* @author chenjiahe
|
* @Data: 2020-06-08
|
*/
|
public class SqlSentence {
|
|
/**执行语句*/
|
private String sqlSentence;
|
|
/**新增存在查询判断*/
|
private String whereExist;
|
|
private Map<String,Object> m;
|
/**排序*/
|
private String orderBy;
|
/**开始页数*/
|
private Integer startPage = 0;
|
/**每页数量*/
|
private Integer pageNum = 0;
|
/**条数（当前类使用）*/
|
private Integer pageSize;
|
|
//////////////////////////////////////////////////////////////
|
|
/********************mother****************************/
|
|
public SqlSentence()
|
{
|
|
}
|
|
public SqlSentence(Class c, String where, Map<String, Object> values)
|
{
|
if(StringUtils.isEmpty(where))
|
{
|
throw new TipsException("sql is null");
|
}
|
|
if(values == null)
|
{
|
throw new TipsException("values is null");
|
}
|
|
sqlSentence = "select * from " + c.getSimpleName()+ " where " + where;
|
m = values;
|
}
|
|
public SqlSentence(String where, Map<String, Object> values)
|
{
|
if(StringUtils.isEmpty(where))
|
{
|
throw new TipsException("sql is null");
|
}
|
|
if(values == null)
|
{
|
throw new TipsException("values is null");
|
}
|
|
sqlSentence = where;
|
m = values;
|
}
|
|
|
/**
|
* sql整条语句
|
* @param sql 如：select * from user Where name = #{m.userName} order by age desc
|
* @param values 存放的值如：values.put("userName","ChenJiaHe")
|
*/
|
public void sqlSentence(String sql,Map<String,Object> values) {
|
if(StringUtils.isEmpty(sql))
|
{
|
throw new TipsException("sql is null");
|
}
|
|
if(values == null)
|
{
|
throw new TipsException("values is null");
|
}
|
|
sqlSentence = sql;
|
m = values;
|
}
|
|
/**
|
* sql整条语句-分页
|
* @param sql 如：select * from user Where name = #{m.userName} order by age desc
|
* @param values 存放的值如：values.put("userName","ChenJiaHe")
|
* @param pageNum 当前页数
|
* @param pageSize 当前条数
|
*/
|
public void sqlSentencePage(String sql,Map<String,Object> values,int pageNum,int pageSize) {
|
if(StringUtils.isEmpty(sql)) {
|
throw new TipsException("sql is null");
|
}
|
|
if(values == null) {
|
throw new TipsException("values is null");
|
}
|
if(pageNum < 1){
|
pageNum = 1;
|
}
|
if(pageSize < 1){
|
pageSize = 1;
|
}
|
this.pageNum = pageNum;
|
this.pageSize = pageSize;
|
|
//算起点
|
int pageStart = (pageNum-1)*pageSize;
|
sql = sql+" LIMIT "+pageStart+","+pageSize;
|
sqlSentence = sql;
|
m = values;
|
}
|
|
/**分页组装信息
|
* @param data 装载信息
|
* @param totalNum 总页数
|
* @return 装载信息
|
*/
|
public Map<String,Object> pageAssembleData(Map<String,Object> data,int totalNum){
|
data.put("pageNum",pageNum);
|
data.put("pageSize",pageSize);
|
data.put("total",totalNum);
|
int pages;
|
if(pageSize > 0){
|
if(totalNum%pageSize > 0){
|
pages = totalNum/pageSize+1;
|
}else{
|
pages = totalNum/pageSize;
|
}
|
}else{
|
pages = 0;
|
}
|
data.put("pages",pages);
|
if(pages <= pageNum){
|
data.put("isLastPage",true);
|
}else{
|
data.put("isLastPage",false);
|
}
|
return data;
|
}
|
|
|
/**
|
* 查询的语句
|
* @param sql 如：id = #{m.userId} order by age DESC
|
* @param values 存放的值如：values.put("userId","123456")
|
*/
|
public void sqlWhere(String sql,Map<String,Object> values) {
|
if(!SimpleTool.checkNotNull(values)){
|
throw new TipsException("values is null");
|
}
|
if(!SimpleTool.checkNotNull(sql)) {
|
sql = "1=1";
|
}
|
sqlSentence = sql;
|
m = values;
|
}
|
|
/**
|
* 更新语句的语句
|
* @param sql 如：name = #{m.name},age = ? WHERE id = #{m.id}
|
* @param values 存放的值
|
*/
|
public void sqlUpdate(String sql,Map<String,Object> values) {
|
if(!SimpleTool.checkNotNull(values)){
|
throw new TipsException("values is null");
|
}
|
m = values;
|
sqlSentence = sql;
|
}
|
|
|
/************************************************************************/
|
|
public Map<String, Object> getM() {
|
return m;
|
}
|
|
public void setM(Map<String, Object> m) {
|
this.m = m;
|
}
|
|
public String getSqlSentence() {
|
return sqlSentence;
|
}
|
|
public void setSqlSentence(String sqlSentence) {
|
this.sqlSentence = sqlSentence;
|
}
|
|
public String getOrderBy() {
|
return orderBy;
|
}
|
|
public void setOrderBy(String orderBy) {
|
this.orderBy = orderBy;
|
}
|
|
public Integer getStartPage() {
|
return startPage;
|
}
|
|
public void setStartPage(Integer startPage) {
|
this.startPage = startPage;
|
}
|
|
public Integer getPageNum() {
|
return pageNum;
|
}
|
|
public void setPageNum(Integer pageNum) {
|
this.pageNum = pageNum;
|
}
|
|
public Integer getStartIndex()
|
{
|
return (startPage - 1) * pageNum;
|
}
|
|
public String getWhereExist() {
|
return whereExist;
|
}
|
|
public void setWhereExist(String whereExist) {
|
if(StringUtils.isNull(whereExist)){
|
whereExist = null;
|
}
|
this.whereExist = whereExist;
|
}
|
|
public Integer getPageSize() {
|
return pageSize;
|
}
|
|
public void setPageSize(Integer pageSize) {
|
this.pageSize = pageSize;
|
}
|
}
|
