package?dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

/*
?*???Jdbc????oracle????
?*/
public?class?OracleConnection?{
?????private?Connection?conn=null;
?????private?Statement?s=null;
?????private?ResultSet?rs=null;
?????public?Connection?getConn（）{
????	?try?{
			Class.forName（“oracle.jdbc.driver.OracleDriver“）;
			conn?=?DriverManager.getConnection（“jdbc:oracle:thin:mes/mes@//127.0.0.1:1521/orcl““mes““mes“）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
????	?return?conn;
?????}
?????/*
??????*??????????????
??????*?
??????*/
?????public?List?getUser（）{
????	?List?list?=?null;
????	?User?u?=?null;
????	String?sql?=?“select?*?from?ut_user“;
????	try?{
			s?=?this.getConn（）.createStatement（）;
			rs?=?s.executeQuery（sql）;
			list?=?new?ArrayList（）;
			while（rs.next（））{
				
				u=?new?User（）;
				u.setUserId（rs.getString（1））;
				u.setUserName（rs.getString（2））;
				u.setRoleId（rs.getString（3））;
				u.setUserPwd（rs.getString（4））;
				u.setDept（rs.getString（5））;
				u.setIsActive（rs.getString（6））;
				list.add（u）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			
			this.closeAll（）;
		}
		return?list;?
????	?
?????}
?????public?void?closeAll（）{
????	?
????	?if（conn!=null）{
????		?try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
????		?
????	?}
????	?if（s!=null）{
????		?try?{
				s.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
????		?
????	?}if（rs!=null）{
????		?try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
????		?
????	?}
?????}
}

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

?????文件????????908??2011-12-23?23:31??test\.classpath

?????文件???????1037??2011-11-29?15:09??test\.project

?????文件????????503??2011-11-29?15:09??test\.settings\.jsdtscope

?????文件????????125??2011-12-08?14:04??test\.settings\org.eclipse.core.resources.prefs

?????文件????????629??2011-12-23?23:31??test\.settings\org.eclipse.jdt.core.prefs

?????文件????????466??2011-11-29?15:09??test\.settings\org.eclipse.wst.common.component

?????文件????????331??2011-11-29?15:09??test\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2011-11-29?15:09??test\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-11-29?15:09??test\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2590??2011-12-24?15:21??test\build\classes\dao\OracleConnection.class

?????文件???????1750??2011-12-24?15:21??test\build\classes\dao\User.class

?????文件???????1335??2011-12-26?09:18??test\build\classes\test\TestServlet.class

?????文件???????2065??2011-12-23?23:42??test\src\dao\OracleConnection.java

?????文件???????1358??2011-12-06?11:27??test\src\dao\User.java

?????文件???????1326??2011-12-26?09:18??test\src\test\TestServlet.java

?????文件????????656??2011-12-26?09:56??test\WebContent\downloadFile.jsp

?????文件?????123870??2010-12-30?09:54??test\WebContent\ext-3.2.1\adapter\ext\ext-base-debug-w-comments.js

?????文件??????78560??2010-12-30?09:54??test\WebContent\ext-3.2.1\adapter\ext\ext-base-debug.js

?????文件??????33069??2010-12-30?09:54??test\WebContent\ext-3.2.1\adapter\ext\ext-base.js

?????文件??????86979??2010-12-30?09:54??test\WebContent\ext-3.2.1\adapter\jquery\ext-jquery-adapter-debug.js

?????文件??????20170??2010-12-30?09:54??test\WebContent\ext-3.2.1\adapter\jquery\ext-jquery-adapter.js

?????文件??????87981??2010-12-30?09:54??test\WebContent\ext-3.2.1\adapter\prototype\ext-prototype-adapter-debug.js

?????文件??????21105??2010-12-30?09:54??test\WebContent\ext-3.2.1\adapter\prototype\ext-prototype-adapter.js

?????文件??????80481??2010-12-30?09:54??test\WebContent\ext-3.2.1\adapter\yui\ext-yui-adapter-debug.js

?????文件??????17665??2010-12-30?09:54??test\WebContent\ext-3.2.1\adapter\yui\ext-yui-adapter.js

?????文件???????1672??2010-12-30?09:54??test\WebContent\ext-3.2.1\docs\index.html

?????文件???????3447??2010-12-30?09:54??test\WebContent\ext-3.2.1\docs\output\Array.html

?????文件??????46504??2010-12-30?09:54??test\WebContent\ext-3.2.1\docs\output\Date.html

?????文件??????21605??2010-12-30?09:54??test\WebContent\ext-3.2.1\docs\output\Ext.Action.html

?????文件??????46941??2010-12-30?09:54??test\WebContent\ext-3.2.1\docs\output\Ext.Ajax.html

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