91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

完整的銀行信貸系統(tǒng)，mysql數(shù)據(jù)，前端HTML，后端都很齊全，可以看文件大小，前端也是很細，但是web層是servlet的，已被我修改完成，能直接跑出來，想了解這個java項目或信貸的 可以參考。。

資源截圖

代碼片段和文件信息 

/**
?*?
?*/
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）;



	/**
	?*?構造方法?加載數(shù)據(jù)庫驅動?并設置默認數(shù)據(jù)庫連接
	?*/

	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]）;
	}

	/**
	?*?通過數(shù)組傳遞參數(shù)
	?*?
	?*?@throws?SQLException
	?*/
	public?ArrayList?getInfoFromDBByArray（String?sql?object[]?obj）?{
		return?getInfoFromDB（sql?obj）;
	}

	/**
	?*?通過可變參數(shù)傳遞參數(shù)
	?*?
	?*?@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?					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]）;
	}

	/**
	?*?通過數(shù)組傳遞參數(shù)?并進行DML操作
	?*?
	?*?@throws?SQLException
	?*/
	public?int?updateDMLByArray（String?sql?object[]?obj）?throws?SQLException?{
		return?updateDML（sql?obj）;
	}

	/**
	?*?通過可變參數(shù)傳遞參數(shù)?并進行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?				this.ps.setobject（i?+?1?obj[i]）;
			}
		}
		int?count?=?this.ps.executeUpdate（）;//?進行預編譯查詢
		System.out.println（this.ps.toString（））;
		closeAll（）;
		System.out.println（“影響了“?+?count?+?“條數(shù)據(jù)“）;
		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\.idea\artifacts\
?????文件?????????495??2020-01-13?10:31??bank1\.idea\artifacts\bank1_war_exploded.xml
?????文件?????????227??2020-01-13?10:59??bank1\.idea\encodings.xml
?????目錄???????????0??2020-01-13?10:51??bank1\.idea\libraries\
?????文件?????????461??2020-01-13?10:51??bank1\.idea\libraries\lib.xml
?????文件?????????376??2020-01-13?11:19??bank1\.idea\misc.xml
?????文件?????????250??2020-01-13?10:31??bank1\.idea\modules.xml
?????文件???????50711??2020-01-13?23:02??bank1\.idea\workspace.xml
?????文件???????14847??2019-12-02?15:48??bank1\README.en.md
?????文件?????????977??2020-01-13?10:51??bank1\bank1.iml
?????目錄???????????0??2020-01-13?10:51??bank1\out\
?????目錄???????????0??2020-01-13?10:34??bank1\out\artifacts\
?????目錄???????????0??2020-01-13?12:01??bank1\out\artifacts\bank1_war_exploded\
?????目錄???????????0??2020-01-13?11:59??bank1\out\artifacts\bank1_war_exploded\WEB-INF\
?????目錄???????????0??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\
?????目錄???????????0??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\
?????目錄???????????0??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\
?????目錄???????????0??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\
?????目錄???????????0??2020-01-13?12:17??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\BasicDAO\
?????文件????????3942??2020-01-13?12:04??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\BasicDAO\BasicConntionPoolDAO_DBCP.class
?????文件????????4079??2020-01-13?12:17??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\BasicDAO\BasicDAO.class
?????目錄???????????0??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\DAO\
?????文件????????6741??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\DAO\ContractDAO.class
?????文件????????7182??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\DAO\CustomerCreditLoanDAO.class
?????文件????????6673??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\DAO\CustomerDAO.class
?????文件????????8587??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\DAO\DepositDetailsDAO.class
?????文件????????4442??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\DAO\EmailVerifyDAO.class
?????文件????????5451??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\DAO\LevelGradeDAO.class
?????文件????????5304??2020-01-13?11:07??bank1\out\artifacts\bank1_war_exploded\WEB-INF\classes\com\zc\BankCreditManagement\DAO\ManagerDAO.class
............此處省略4894個文件信息

評論

共有 條評論