package?com.home.util;

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

public?class?ConnectionManager?{
	public?static?final?String?DRIVER?=?“com.mysql.jdbc.Driver“;
	public?static?final?String?URL?=?“jdbc:mysql://localhost:3306/easyui“;
	public?static?final?String?USERNAME?=?“root“;
	public?static?final?String?PASSWORD?=?“root“;

	/**
	?*?通過靜態(tài)代碼塊?注冊數(shù)據(jù)庫驅(qū)動
	?*/
	static{
		try?{
			Class.forName（DRIVER）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
	}

	/**
	?*?獲得Connection
	?*?
	?*?@return
	?*/
	public?static?Connection?getConnection（）?{
		Connection?conn?=?null;
		try?{
			conn?=?DriverManager.getConnection（URL?USERNAME?PASSWORD）;
		}catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?conn;
	}
	/**
	?*?獲得總記錄數(shù)
	?*?@return
	?*/
	public?static?int?getRows（）{
		int?rows?=?0;
		Statement?sta?=?null;
		ResultSet?rs?=?null;
		Connection?conn?=?getConnection（）;
		try?{
			sta?=?conn.createStatement（）;
			rs?=?sta.executeQuery（“select?*?from?e_user“）;
			rs.last（）;
			rows?=?rs.getRow（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?rows;
		
	}
	public?static?void?main（String[]?args）?{
		//System.out.println（getRows（））;
	}

	/**
	?*?關(guān)閉ResultSet
	?*?@param?rs
	?*/
	public?static?void?closeResultSet（ResultSet?rs）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}

	/**
	?*?關(guān)閉Statement
	?*?@param?st
	?*/
	public?static?void?closeStatement（Statement?st）?{
		if?（st?!=?null）?{
			try?{
				st.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}

	/**
	?*?關(guān)閉Connection
	?*?@param?conn
	?*/
	public?static?void?closeConnection（Connection?conn）?{
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}
	/**
	?*?關(guān)閉全部
	?*?@param?rs
	?*?@param?sta
	?*?@param?conn
	?*/
	public?static?void?closeAll（ResultSet?rsStatement?staConnection?conn）{
		closeResultSet（rs）;
		closeStatement（sta）;
		closeConnection（conn）;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-07-08?23:21??EasyUI_DataGrid\
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\
?????文件????????1153??2014-07-08?11:13??EasyUI_DataGrid\easyui_dg\.classpath
?????文件?????????301??2014-07-08?13:54??EasyUI_DataGrid\easyui_dg\.mymetadata
?????文件????????1415??2014-07-08?13:53??EasyUI_DataGrid\easyui_dg\.project
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\
?????文件?????????823??2014-07-07?11:56??EasyUI_DataGrid\easyui_dg\WebRoot\home.jsp
?????文件????????4033??2014-07-08?14:15??EasyUI_DataGrid\easyui_dg\WebRoot\index.jsp
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\
?????文件?????????709??2014-07-08?10:43??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\web.xml
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\lib\
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\classes\
?????文件????????1524??2014-07-08?14:17??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\classes\init.sql
?????文件?????????668??2014-07-08?11:02??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\classes\struts.xml
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\classes\com\home\
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\classes\com\home\web\
?????文件????????3749??2014-07-08?13:56??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\classes\com\home\web\UserAction.class
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\classes\com\home\util\
?????文件????????2659??2014-07-08?13:53??EasyUI_DataGrid\easyui_dg\WebRoot\WEB-INF\classes\com\home\util\ConnectionManager.class
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\ui\
?????文件????????2520??2014-07-08?14:02??EasyUI_DataGrid\easyui_dg\WebRoot\ui\userLayout.jsp
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\meta-INF\
?????文件??????????36??2014-06-18?17:13??EasyUI_DataGrid\easyui_dg\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\js\
?????文件???????92556??2014-06-17?11:23??EasyUI_DataGrid\easyui_dg\WebRoot\js\jquery-1.8.0.min.js
?????文件??????332467??2014-06-24?14:13??EasyUI_DataGrid\easyui_dg\WebRoot\js\jquery.easyui.min.js
?????目錄???????????0??2014-07-08?23:22??EasyUI_DataGrid\easyui_dg\WebRoot\img\
?????文件??????364694??2014-06-20?13:29??EasyUI_DataGrid\easyui_dg\WebRoot\img\back.jpg
?????文件???????20909??2014-06-20?13:27??EasyUI_DataGrid\easyui_dg\WebRoot\img\head.jpg
?????文件??????352417??2014-06-20?11:04??EasyUI_DataGrid\easyui_dg\WebRoot\img\top.jpg
............此處省略315個文件信息