com.centit.support.database.jsonmaptable.SqlSvrJsonObjectDao Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of centit-database Show documentation

数据库操作通用方法和函数，从以前的util包中分离出来，并且整合了部分sys-module中的函数

There is a newer version: 5.3.2302

package com.centit.support.database.jsonmaptable;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang3.StringUtils;
import org.apache.commons.lang3.tuple.Pair;

import com.alibaba.fastjson.JSONArray;
import com.centit.support.database.DatabaseAccess;
import com.centit.support.database.QueryUtils;
import com.centit.support.database.metadata.TableInfo;

public class SqlSvrJsonObjectDao extends GeneralJsonObjectDao {
	
	public SqlSvrJsonObjectDao(){
		
	}
	
	public SqlSvrJsonObjectDao(Connection conn) {
		super(conn);
	}	
	
	public SqlSvrJsonObjectDao(TableInfo tableInfo) {
		super(tableInfo);
	}
	
	public SqlSvrJsonObjectDao(Connection conn,TableInfo tableInfo) {
		super(conn,tableInfo);
	}
	
	@Override
	public JSONArray listObjectsByProperties(final Map properties,
			final int startPos,final int maxSize)
	throws SQLException, IOException {		
		TableInfo tableInfo = this.getTableInfo();		
		Pair q = buildFieldSql(tableInfo,null);
		String filter = buildFilterSql(tableInfo,null,properties.keySet());
		String sql = "select " + q.getLeft() +" from " +tableInfo.getTableName();
		if(StringUtils.isNotBlank(filter))
			sql = sql + " where " + filter;	
		return DatabaseAccess.findObjectsByNamedSqlAsJSON(
					getConnect(),
					QueryUtils.buildSqlServerLimitQuerySQL(
							sql,
							startPos, maxSize),
				 properties,
				 q.getRight());
	}
	
	/**
	 * create table sequence_table (sequence_Name varchar(100) not null primary key, current_value integer);
	 */
	@Override
	public Long getSequenceNextValue(final String sequenceName) throws SQLException, IOException {
		return getSimulateSequenceNextValue(sequenceName);
	}
	
	@Override
	public List findObjectsBySql(final String sSql, final Object[] values, 
			final int pageNo, final int pageSize)
			throws SQLException, IOException {
		int startPos=pageNo>1?(pageNo-1)*pageSize:0;
		return DatabaseAccess.findObjectsBySql(
				getConnect(),
				QueryUtils.buildSqlServerLimitQuerySQL(
						sSql,
						startPos, pageSize),
				values);
	}	

	@Override
	public List findObjectsByNamedSql(final String sSql, final Map values, 
			final int pageNo,final int pageSize) throws SQLException, IOException {
		int startPos=pageNo>1?(pageNo-1)*pageSize:0;
		return DatabaseAccess.findObjectsByNamedSql(
				getConnect(),
				QueryUtils.buildSqlServerLimitQuerySQL(
						sSql,
						startPos, pageSize),
				values);
	}

	@Override
	public JSONArray findObjectsAsJSON(final String sSql, final Object[] values, final String[] fieldnames,
			final int pageNo, final int pageSize)
			throws SQLException, IOException {
		int startPos=pageNo>1?(pageNo-1)*pageSize:0;
		return DatabaseAccess.findObjectsAsJSON(
				getConnect(),
				QueryUtils.buildSqlServerLimitQuerySQL(
						sSql,
						startPos, pageSize),
				values,fieldnames);
	}

	@Override
	public JSONArray findObjectsByNamedSqlAsJSON(final String sSql, final Map values,
			final String[] fieldnames, final int pageNo, final int pageSize) throws SQLException, IOException {
		int startPos=pageNo>1?(pageNo-1)*pageSize:0;
		return DatabaseAccess.findObjectsByNamedSqlAsJSON(
				getConnect(),
				QueryUtils.buildSqlServerLimitQuerySQL(
						sSql,
						startPos, pageSize),
				values,fieldnames);
	}
}