• Home
• com.bbossgroups
• bboss-persistent
• 6.2.5
• source code
• DBOptionsPreparedDBUtil.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.frameworkset.common.poolman.DBOptionsPreparedDBUtil Maven / Gradle / Ivy

/*
 *  Copyright 2008 biaoping.yin
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.  
 */
package com.frameworkset.common.poolman;

import com.frameworkset.common.poolman.handle.NullRowHandler;
import com.frameworkset.common.poolman.handle.RowHandler;
import com.frameworkset.common.poolman.handle.XMLMark;
import com.frameworkset.common.poolman.sql.PrimaryKey;
import com.frameworkset.common.poolman.util.DBOptions;
import com.frameworkset.common.poolman.util.JDBCPool;
import com.frameworkset.common.poolman.util.SQLManager;
import com.frameworkset.common.poolman.util.StatementParser;
import com.frameworkset.orm.adapter.DB;
import org.frameworkset.persitent.type.BaseTypeMethod;
import org.frameworkset.persitent.util.SQLInfo;
import org.frameworkset.persitent.util.SQLUtil;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.io.*;
import java.math.BigDecimal;
import java.sql.*;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

/**
 * 执行预编sql语句
 * set i parameterIndex the first parameter is 1, the second is 2, ...
 * @author biaoping.yin created on 2005-6-8 version 1.0
 */
public class DBOptionsPreparedDBUtil extends DBUtil {
	private static Logger logger = LoggerFactory.getLogger(DBOptionsPreparedDBUtil.class);
	/**
	 * more分页查询，不会计算总记录数，如果没有记录那么返回的ListInfo的datas的size为0,
	 * 提升性能，同时前台标签库也会做响应的调整
	 */
	private boolean more = false;


	/**
	 * @return the more
	 */
	public boolean isMore() {
		return more;
	}
	/**
	 * @param more the more to set
	 */
	public void setMore(boolean more) {
		this.more = more;
	}
	/**
	 * 执行单条预编译sql时参数封装对象
	 */
	protected Params Params = null;

	/**
	 * 批处理预编译操作参数集，
	 * List
	 */
	protected List batchparams;

//	/**
//	 * 批处理预编译操作参数集，如果在一次批处理预编操作中出现多条
//	 * Map
//	 */
//	private Map batchparamsIDXBySQL;

	/**
	 * 是否需要对预编译批处理进行优化，如果需要则对所有的batchparams按照sql语句是否相同进行排序
	 * 如果语句相同则放到一起，这样避免出现同一条sql语句存在多个preparedstatement句柄
	 * 默认不排序，否则排序
	 */
	protected boolean batchOptimize = false;

	protected static Logger log = LoggerFactory.getLogger(PreparedDBUtil.class);





	protected String prepareDBName = SQLManager.getInstance()
			.getDefaultDBName();






//	protected String[] preparedfields;

	public static final int INSERT = 0;

	public static final int UPDATE = 1;

	public static final int DELETE = 2;

	/**
	 * 分页查询类别
	 */
	public static final int SELECT = 3;

	/**
	 * 通用查询类别
	 */
	public static final int SELECT_COMMON = 4;



	/**
	 * 标识执行预编译的链接是外部传递进来的链接
	 * true标识是外部链接
	 * false标识不是外部链接
	 */
//	protected boolean outcon = true;

	protected long offset;

	protected int pagesize;



	/**
	 * 大数据字段数据信息
	 *
	 * 

	 * bboss workgroup
	 * 
	 * 

	 * Copyright (c) 2007
	 * 
	 *
	 * @Date 2009-6-1 下午08:58:51
	 * @author biaoping.yin
	 * @version 1.0
	 */
	class BigData {
		static final int BLOB = 1;

		static final int CLOB = 2;

		static final int TEXT = 3;
		static final int NUMERIC = 4;

		/** blog 1,clob 2,text 3 */
		int type;

		/**
		 * 字段的值
		 */
		Object bigdata;

		String bigdataField;

		/**
		 * 字段对应的索引
		 */
		int index;
	}

	/**
	 * 更新数据库时的主键信息
	 *
	 * 

	 * bboss workgroup
	 * 
	 * 

	 * Copyright (c) 2007
	 * 
	 *
	 * @Date 2009-6-1 下午08:58:51
	 * @author biaoping.yin
	 * @version 1.0
	 */
	public static class UpdateKeyInfo {
		String tableName;

		String keyName;

		String keyValue;
		String type;

	}

	protected void setUpParams(StatementInfo stmtInfo,Params Params,PreparedStatement statement,List resources) throws SQLException
	{
		setUpParams(  stmtInfo,Params,statement,null,resources);
	}



	private void setUpParams(StatementInfo stmtInfo,Params Params,PreparedStatement statement,PreparedStatement statement_count,List resources)throws SQLException
	{

		for(int i = 0; i < Params.params.size(); i ++)
		{
			Param param = (Param )Params.params.get(i);
			param.method.action(stmtInfo,param,statement,statement_count,resources);

		}
	}
	/*******************************************************************
	 * 通用预编译处理开始
	 *
	 */
	public Object executePrepared(DBOptions dbOptions) throws SQLException {
		if(this.batchparams != null && batchparams.size() > 0)
			throw new SQLException("Can not execute batch prepared operations as single prepared operation,Please call method executePreparedBatch()!");
		return executePrepared(  dbOptions,(Connection)null);
	}
	/**
	 * 如果getCUDResult参数为true，则返回GetCUDResult类型对象，GetCUDResult的属性含义如下：
	 * result：操作结果，如果数据源autoprimarykey为true，并且在tableinfo表中保存了表的主键信息result为自增的主键，反之result为更新的记录数
	 * updateCount:更新的记录数
	 * keys:自动产生的主键，如果只有一条记录则为普通对象，如果有多条记录则为List