java web项目 银行信贷系统

/**
 * 
 */
package com.zc.BankCreditManagement.BasicDAO;

import java.sql.*;
import java.util.ArrayList;

import org.apache.commons.dbcp2.BasicDataSource;

/**
 * @author ZhangCheng 2019年10月14日
 * @coding UTF-8
 */
public abstract class BasicConntionPoolDAO_DBCP {

	private Connection con;
	private PreparedStatement ps;
	private ResultSet re;
	private String driverName = “com.mysql.jdbc.Driver“;
	private String url = “jdbc:mysql://localhost:3306/bank?useSSL=false“;
	private String user = “root“;
	private String pwd = “root“;

	/**
	 * 将结果集转换成ArrayList集合
	 */
	public abstract ArrayList resultSetToArrayList（ResultSet re）;



	/**
	 * 构造方法 加载数据库驱动 并设置默认数据库连接
	 */

	public BasicConntionPoolDAO_DBCP（） {
		@SuppressWarnings（“resource“）
		BasicDataSource poolSource = new BasicDataSource（）;
		poolSource.setDriverClassName（this.driverName）;
		poolSource.setUrl（this.url）;
		poolSource.setUsername（this.user）;
		poolSource.setPassword（this.pwd）;
		try {
			this.con = poolSource.getConnection（）;
		} catch （SQLException e） {
			// TODO Auto-generated catch block
			e.printStackTrace（）;
		}
	
	}



	/**
	 * 用预编译查询获取信息
	 * 
	 * @throws SQLException
	 */
	public ArrayList getInfoFromDB（String sql） {
		return getInfoFromDB（sql new object[0]）;
	}

	/**
	 * 通过数组传递参数
	 * 
	 * @throws SQLException
	 */
	public ArrayList getInfoFromDBByArray（String sql object[] obj） {
		return getInfoFromDB（sql obj）;
	}

	/**
	 * 通过可变参数传递参数
	 * 
	 * @throws SQLException
	 */
	public ArrayList getInfoFromDB（String sql object... obj） {
				try {
			this.ps = this.con.prepareStatement（sql）;// 获得预编译对象
			
			if （obj.length > 0） {
				for （int i = 0; i < obj.length; i++） {
					this.ps.setobject（i + 1 obj[i]）;
				}
			}
			this.re = this.ps.executeQuery（）;// 进行预编译查询
			System.out.println（this.ps.toString（））;
		} catch （SQLException e） {

			e.printStackTrace（）;
		}

		return resultSetToArrayList（this.re）;
	}

	/**
	 * 无参 进行DML查询
	 * 
	 * @throws SQLException
	 */
	public int updateDML（String sql） throws SQLException {
		return updateDML（sql new object[0]）;
	}

	/**
	 * 通过数组传递参数 并进行DML操作
	 * 
	 * @throws SQLException
	 */
	public int updateDMLByArray（String sql object[] obj） throws SQLException {
		return updateDML（sql obj）;
	}

	/**
	 * 通过可变参数传递参数 并进行DML操作
	 * 
	 * @throws SQLException
	 */
	public int updateDML（String sql object... obj） throws SQLException {
	
		this.ps = this.con.prepareStatement（sql）;// 获得预编译对象
		if （obj.length > 0） {
			for （int i = 0; i < obj.length; i++） {
				this.ps.setobject（i + 1 obj[i]）;
			}
		}
		int count = this.ps.executeUpdate（）;// 进行预编译查询
		System.out.println（this.ps.toString（））;
		closeAll（）;
		System.out.println（“影响了“ + count + “条数据“）;
		return count;
	}

	/**
	 * 关闭所有连接
	 * 
	 * @throws SQLException
	 */
	public void closeAll（） {
		try {
			if （this.re != null） {
				this.re.close（）;
			}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2020-01-18 12:19  bank1
     目录           0  2020-01-13 23:02  bank1.idea
     目录           0  2020-01-13 10:31  bank1.ideaartifacts
     文件         495  2020-01-13 10:31  bank1.ideaartifactsank1_war_exploded.xml
     文件         227  2020-01-13 10:59  bank1.ideaencodings.xml
     目录           0  2020-01-13 10:51  bank1.idealibraries
     文件         461  2020-01-13 10:51  bank1.idealibrarieslib.xml
     文件         376  2020-01-13 11:19  bank1.ideamisc.xml
     文件         250  2020-01-13 10:31  bank1.ideamodules.xml
     文件       50711  2020-01-13 23:02  bank1.ideaworkspace.xml
     文件       14847  2019-12-02 15:48  bank1README.en.md
     文件         977  2020-01-13 10:51  bank1ank1.iml
     目录           0  2020-01-13 10:51  bank1out
     目录           0  2020-01-13 10:34  bank1outartifacts
     目录           0  2020-01-13 12:01  bank1outartifactsank1_war_exploded
     目录           0  2020-01-13 11:59  bank1outartifactsank1_war_explodedWEB-INF
     目录           0  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclasses
     目录           0  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescom
     目录           0  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzc
     目录           0  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagement
     目录           0  2020-01-13 12:17  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementBasicDAO
     文件        3942  2020-01-13 12:04  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementBasicDAOBasicConntionPoolDAO_DBCP.class
     文件        4079  2020-01-13 12:17  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementBasicDAOBasicDAO.class
     目录           0  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementDAO
     文件        6741  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementDAOContractDAO.class
     文件        7182  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementDAOCustomerCreditLoanDAO.class
     文件        6673  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementDAOCustomerDAO.class
     文件        8587  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementDAODepositDetailsDAO.class
     文件        4442  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementDAOEmailVerifyDAO.class
     文件        5451  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementDAOLevelGradeDAO.class
     文件        5304  2020-01-13 11:07  bank1outartifactsank1_war_explodedWEB-INFclassescomzcBankCreditManagementDAOManagerDAO.class
............此处省略4894个文件信息