package?cn.jredu.dao;

	import?java.lang.reflect.Field;
	import?java.lang.reflect.InvocationTargetException;
	import?java.lang.reflect.Method;
	import?java.sql.Connection;
	import?java.sql.DriverManager;
	import?java.sql.PreparedStatement;
	import?java.sql.ResultSet;
	import?java.sql.SQLException;
	import?java.util.ArrayList;
	import?java.util.List;

	public?class?baseDao?{
		
		//1?提供鏈接
		public?static?final?String?URL=“jdbc:oracle:thin:@192.168.199.135:1521:orcl“;
		//2?提供驅動類
		public?static?final?String?DRIVER=“oracle.jdbc.driver.OracleDriver“;
		
		//3?提供賬號密碼
		public?static?final?String?USER=“scott“;
		public?static?final?String?PWD=“tiger“;
				
		/**********************	全局屬性****************************/
		private?Connection?conn=null;
		private?PreparedStatement?pstmt=null;
		private?ResultSet?rs=null;
				
		/***
		?*?獲取數據庫連接
		?*/
		?private?void?getConnect（）{
			//加載驅動類
			try?{
				Class.forName（DRIVER）;
				//建立連接
				if（conn==null）conn=DriverManager.getConnection（URLUSERPWD）;
			}?catch?（ClassNotFoundException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		?
		?
	
		public?int?executeUpdate（String?sqlListject>?params）?throws?SQLException{
			getConnect（）;
			
			//1?創建句柄
			pstmt=conn.prepareStatement（sql）;
			
			//2?設置參數
			if（params!=null）{
				for（int?i=0;i					pstmt.setobject（i+1?params.get（i））;
				}
			}
			
			//3?執行語句
			return?pstmt.executeUpdate（）;
		}
				
	
		public?ResultSet?executeQuery（String?sqlListject>?params）?throws?SQLException{
			getConnect（）;
			
			//1?創建句柄
			pstmt=conn.prepareStatement（sql）;
			
			//2?設置參數
			if（params!=null）{
				for（int?i=0;i					pstmt.setobject（i+1?params.get（i））;
				}
			}
			?rs=pstmt.executeQuery（）;
			//3?執行語句
			return?rs;
		}		
		/***
		?*?返回對象的集合list
		?*?@param?sql
		?*?@param?params
		?*?@param?t
		?*?@return
		?*?@throws?SQLException?
		?*?@throws?IllegalAccessException?
		?*?@throws?InstantiationException?
		?*?@throws?InvocationTargetException?
		?*?@throws?IllegalArgumentException?
		?*/
		public??List?getModelListByResultSet（String?sqlListject>?paramsT?t）?throws?SQLException?InstantiationException?IllegalAccessException?IllegalArgumentException?InvocationTargetException{
			//1?查詢
			ResultSet?rs=executeQuery（sql?params）;
			//1.5初始化集合列表
			List?list=new?ArrayList（）;
			
			//獲取T的類本質類型
			Class?C?=t.getClass（）;
			
			//2?遍歷結果集封裝對象
			while（rs.next（））{
				//初始化一個模型對象
				@SuppressWarnings（“unchecked“）
				T?obj=（T）?C.newInstance（）;
				//往對象obj里面存值
				//1>獲取當前obj到底有多少個屬性啊
				Field[]?fields=?C.getDeclaredFields（）;
				for（int?i=0;i					Field?f=fields[i];
					//獲取當前的屬性名
					String?fname=f.getName（）;
					//獲取當前的屬性的類型名
					String?t

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1324??2017-10-20?22:38??messagg\.classpath

?????文件???????1057??2017-10-20?14:30??messagg\.project

?????文件????????564??2017-10-20?09:24??messagg\.settings\.jsdtscope

?????文件????????364??2017-10-20?09:24??messagg\.settings\org.eclipse.jdt.core.prefs

?????文件????????557??2017-10-20?22:37??messagg\.settings\org.eclipse.wst.common.component

?????文件????????414??2017-10-20?09:24??messagg\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-10-20?09:24??messagg\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-10-20?09:24??messagg\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????648??2017-10-20?22:38??messagg\config\applicationContext-annotation.xml

?????文件????????137??2017-10-20?23:44??messagg\config\db.properties

?????文件????????755??2017-11-04?09:31??messagg\sql.txt

?????文件???????5990??2017-10-23?19:07??messagg\src\cn\jredu\dao\baseDao.java

?????文件???????2978??2017-10-27?10:37??messagg\src\cn\jredu\dao\impl\MessageDaoImpl.java

?????文件????????793??2017-10-25?15:59??messagg\src\cn\jredu\dao\impl\UserDaoImpl.java

?????文件???????1111??2017-10-27?09:34??messagg\src\cn\jredu\dao\MessageDao.java

?????文件????????431??2017-10-25?15:58??messagg\src\cn\jredu\dao\UserDao.java

?????文件???????2011??2017-10-25?18:42??messagg\src\cn\jredu\model\Message.java

?????文件???????1244??2017-10-25?13:24??messagg\src\cn\jredu\model\User.java

?????文件???????4309??2017-10-27?09:34??messagg\src\cn\jredu\service\impl\MessageImpl.java

?????文件???????2085??2017-10-26?10:56??messagg\src\cn\jredu\service\impl\UserServiceImpl.java

?????文件????????803??2017-10-27?09:34??messagg\src\cn\jredu\service\MessageService.java

?????文件????????322??2017-10-26?09:01??messagg\src\cn\jredu\service\UserService.java

?????文件???????2037??2017-10-23?13:40??messagg\src\cn\jredu\servlet\loginServlet.java

?????文件???????4757??2017-10-27?14:32??messagg\src\cn\jredu\servlet\MessageServlet.java

?????文件???????3377??2017-10-26?09:17??messagg\src\cn\jredu\servlet\UpLoadServlet.java

?????文件???????3419??2017-10-26?10:56??messagg\src\cn\jredu\servlet\UserServlet.java

?????文件???????1208??2017-10-24?19:04??messagg\WebRoot\css\css\messagelist.css

?????文件???????7031??2017-10-20?13:41??messagg\WebRoot\css\css\style.css

?????文件??????65927??2017-10-20?11:08??messagg\WebRoot\css\images\bg.jpg

?????文件??????24224??2017-10-20?10:30??messagg\WebRoot\css\images\g.jpg

............此處省略97個文件信息