package?rcm.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?DatabaseUtils?{
	public?static?Connection?getConnection（）{
		?
		Connection?conn?=?null;
		try?
		{
			try?{
				Class.forName（“com.mysql.cj.jdbc.Driver“）.newInstance（）;
			}?catch?（InstantiationException?e）?{e.printStackTrace（）;
			}?catch?（IllegalAccessException?e）?{e.printStackTrace（）;}
			conn=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/db?useSSL=false&serverTimezone=UTC&characterEncoding=utf-8““root““1101121833“）;//1q2w3e4r5t?
			
		}catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?conn;
	}
	
	public?static?Statement?createStmt（Connection?conn）?{
		Statement?stmt?=?null;
		try?
		{
			stmt?=?conn.createStatement（）;
		}?
		catch?（SQLException?e）?
		{
			e.printStackTrace（）;
		}
		return?stmt;
	}
	
	public?static?ResultSet?executeQuery（Statement?stmt?String?sql）?{
		ResultSet?rs?=?null;
		try?
		{
			rs?=?stmt.executeQuery（sql）;
		}?
		catch?（SQLException?e）?
		{
			e.printStackTrace（）;
		}
		return?rs;
	}
	
	public?static?ResultSet?executeQuery（PreparedStatement?preparedstmt）
	{
		ResultSet?rs?=?null;
		try?{
			rs?=?preparedstmt.executeQuery（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		return?rs;
	}
	
	public?static?PreparedStatement?prepareStmt（Connection?conn?String?sql）?{
		PreparedStatement?pstmt?=?null;
		try?{
			pstmt?=?（PreparedStatement）?conn.prepareStatement（sql）;
		}catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?pstmt;
	}
	public?static?void?close（Connection?conn）?{
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}
	
	public?static?void?close（Statement?stmt）?{
		if?（stmt?!=?null）?
		{
			try?
			{
				stmt.close（）;
			}?
			catch?（SQLException?e）?
			{
				e.printStackTrace（）;
			}
		}
	}
	
	public?static?void?close（ResultSet?rs）?
	{
		if?（rs?!=?null）?
		{
			try?{
				rs.close（）;
				}
			catch?（SQLException?e）?
				{
				e.printStackTrace（）;
				}
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????4781??2019-12-22?13:09??db.sql
?????目錄???????????0??2019-12-29?10:13??rcm\
?????目錄???????????0??2019-12-29?10:13??rcm\.idea\
?????目錄???????????0??2019-12-29?10:13??rcm\.idea\artifacts\
?????文件?????????487??2019-12-22?18:34??rcm\.idea\artifacts\rcm_war_exploded.xml
?????文件?????????138??2019-12-22?18:34??rcm\.idea\encodings.xml
?????文件?????????278??2019-12-22?18:34??rcm\.idea\misc.xml
?????文件?????????253??2019-12-22?18:34??rcm\.idea\modules.xml
?????文件???????11834??2019-12-23?22:36??rcm\.idea\workspace.xml
?????目錄???????????0??2019-12-29?10:13??rcm\out\
?????目錄???????????0??2019-12-29?10:13??rcm\out\artifacts\
?????目錄???????????0??2019-12-29?10:13??rcm\out\artifacts\rcm_war_exploded\
?????目錄???????????0??2019-12-29?10:13??rcm\out\artifacts\rcm_war_exploded\css\
?????文件?????????991??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\css\context.css
?????文件????????4158??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\css\order.css
?????文件????????9182??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\css\shopping_vehicle.css
?????文件???????15342??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\css\T2_common.css
?????文件????????4109??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\css\T2_main.css
?????目錄???????????0??2019-12-29?10:13??rcm\out\artifacts\rcm_war_exploded\images\
?????文件?????????318??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\add_1.gif
?????文件?????????145??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\bar-bg.png
?????文件?????????308??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\book_btn.png
?????文件?????????942??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\btn.png
?????文件?????????970??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\buybtn.jpg
?????文件????????1414??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\checkout_btn.png
?????文件?????????262??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\end.png
?????文件?????????781??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\loading.gif
?????文件????????3569??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\logo.png
?????文件???????48834??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\map.png
?????目錄???????????0??2019-12-29?10:13??rcm\out\artifacts\rcm_war_exploded\images\product\
?????文件????????9553??2019-12-22?18:39??rcm\out\artifacts\rcm_war_exploded\images\product\18_dtl_lyq.jpg
............此處省略201個文件信息