package?bean;

import?java.sql.*;

//????????
public?class?OracleBean?{
	
	//??b????l??
	public?static?Connection?getConn（）{
		
			Connection?conn?=?null;
		try?{
			Class.forName（“oracle.jdbc.driver.OracleDriver“）;
			?conn?=?DriverManager.getConnection（“jdbc:oracle:thin:@10.19.41.27:1521:orcl““scott““tiger“）;
		}?catch?（ClassNotFoundException?e）?{
			
			e.printStackTrace（）;
		}catch（SQLException?e）{
			e.printStackTrace（）;
		}
		
		return?conn;
	}
	
	//???Statement
	public?static?Statement?getStmt（Connection?conn）{
		Statement?stmt?=?null;
		try?{
			stmt?=?conn.createStatement（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?stmt;
	}
	
	//??в??????????
	public?static?ResultSet?executeQuery（Statement?stmtString?sql）{
		ResultSet?rs?=?null;
		try?{
			rs?=?stmt.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			
			e.printStackTrace（）;
		}
		return?rs;
	}
	
	//??и??2???
	public?static?int?executeUpdate（Connection?connString?sql）{
		int?ret?=?0;
		Statement?stmt?=?null;
		try?{
			stmt?=?conn.createStatement（）;
			ret?=?stmt.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			
			e.printStackTrace（）;
		}finally{
			close（stmt）;
		}
		
		return?ret;
	}

	//???PreparedStatement
	public?static?PreparedStatement?getPstmt（Connection?connString?sql）{
			
		PreparedStatement?pstmt?=?null;
		try{
			pstmt?=?conn.prepareStatement（sql）;
			
		}catch（SQLException?e）{
			e.printStackTrace（）;
		}
		return?pstmt;
		
	}
	
	//???????l??
	public?static?void?close（Connection?conn）?{
		
		if（conn?!=?null）{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				
				e.printStackTrace（）;
			}
			conn?=?null;
		}
	}
	//???Statement
	public?static?void?close（Statement?stmt）?{
		
		if（stmt?!=?null）{
			try?{
				stmt.close（）;
			}?catch?（SQLException?e）?{
				
				e.printStackTrace（）;
			}
			stmt?=?null;
		}
	}
	//?????
	public?static?void?close（ResultSet?rs）?{
		
		if（rs?!=?null）{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				
				e.printStackTrace（）;
			}
			rs?=?null;
		}
	}
	
}

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

?????文件????????627??2011-07-31?16:49??TeleGram\.classpath

?????文件????????297??2011-09-09?09:02??TeleGram\.mymetadata

?????文件???????1414??2011-09-08?21:20??TeleGram\.project

?????文件????????500??2011-09-08?21:20??TeleGram\.settings\.jsdtscope

?????文件????????286??2011-08-01?13:02??TeleGram\.settings\org.eclipse.core.resources.prefs

?????文件?????????49??2011-09-08?21:20??TeleGram\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-09-08?21:20??TeleGram\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1435??2011-08-01?19:40??TeleGram\src\bean\adminiServlet\AdDeleteServlet.java

?????文件???????2824??2011-08-02?12:08??TeleGram\src\bean\adminiServlet\AdInsertServlet.java

?????文件???????2239??2011-08-01?19:31??TeleGram\src\bean\adminiServlet\AdSearchServlet.java

?????文件???????2513??2011-08-01?19:54??TeleGram\src\bean\adminiServlet\AdUpdateServlet.java

?????文件???????1421??2011-08-02?12:09??TeleGram\src\bean\cardInputServlet\CardDeleteServlet.java

?????文件???????1811??2011-08-02?12:09??TeleGram\src\bean\cardInputServlet\CardInsertServlet.java

?????文件???????2770??2011-08-02?12:09??TeleGram\src\bean\cardInputServlet\CardSearchServlet.java

?????文件???????2938??2011-08-02?12:09??TeleGram\src\bean\cardInputServlet\CardUpdateServlet.java

?????文件???????2230??2011-08-02?12:10??TeleGram\src\bean\checkServlet\CheckSearchServlet.java

?????文件???????2359??2011-08-01?18:00??TeleGram\src\bean\checkServlet\CheckServlet.java

?????文件???????2551??2011-08-01?21:44??TeleGram\src\bean\dataServlet\DataExportServlet.java

?????文件???????3082??2011-08-01?10:38??TeleGram\src\bean\dataServlet\DataSearchServlet.java

?????文件???????2691??2011-08-02?12:12??TeleGram\src\bean\loginServlet\LoginCheckServlet.java

?????文件???????2137??2011-08-02?12:14??TeleGram\src\bean\logServlet\LogSearchServlet.java

?????文件???????2303??2011-08-02?12:18??TeleGram\src\bean\OracleBean.java

?????文件???????1834??2011-08-01?17:37??TeleGram\src\bean\saleServlet\SaleByDayServlet.java

?????文件???????1629??2011-08-01?09:20??TeleGram\src\bean\saleServlet\SaleGotoServlet.java

?????文件???????2235??2011-08-02?09:01??TeleGram\src\bean\saleServlet\SaleOutputServlet.java

?????文件???????1390??2011-08-02?12:14??TeleGram\src\bean\saleServlet\SaleRebackServlet.java

?????文件???????2490??2011-07-31?11:37??TeleGram\src\bean\saleServlet\SaleSearchServlet.java

?????文件???????6543??2011-07-30?17:41??TeleGram\src\common\Card.java

?????文件???????1259??2011-07-27?17:11??TeleGram\src\common\City.java

?????文件???????5303??2011-07-28?13:59??TeleGram\src\common\Ingather.java

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