package?com.tsari.dao;

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



public?class?baseDAO?{
	public?Connection?con?=?null;
	private?PreparedStatement?pstm?=?null;
	private?ResultSet?rs?=?null;
	
	/**
	?*?增刪改操作
	?*?@param?sql
	?*?@return?（增刪改操作）狀態
	?*/
	
	public?boolean?excuteUpdate（String?sql）?throws?SQLException{
		con?=?SimpleConnetionPool.getConnection（）;
		try{
				pstm?=?con.prepareStatement（sql）;
				pstm.execute（）;
				return?true;
		}catch（SQLException?e）{
			e.printStackTrace（）;
			System.out.println（“數據更新失敗！“）;
			if（con?!=?null）{
				//con.rollback（）;
			}
			return?false;		
		}
		finally{
			if（con?!=?null?&&?!con.isClosed（））{
				con.close（）;
			}
		}
	}
	
	public?ResultSet?executeQuery（String?sql）?throws?SQLException{
		con?=?SimpleConnetionPool.getConnection（）;
		try{
			pstm?=?con.prepareStatement（sql）;
			rs?=?pstm.executeQuery（）;
			//System.out.println（“rs“?+?rs）;
			return?rs;
		}catch（SQLException?e）{
			System.out.println（“數據查詢失敗！“）;
			e.printStackTrace（）;
			if（con?!=?null）{
				//con.rollback（）;
			}
			return?null;
		}
	}
	
}

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

?????文件???????1408??2013-07-22?23:56??GpsServer\.classpath

?????文件????????385??2013-07-22?23:56??GpsServer\.project

?????文件????????224??2013-07-22?23:56??GpsServer\.settings\.svn\all-wcprops

?????文件????????349??2013-07-22?23:56??GpsServer\.settings\.svn\entries

?????文件????????598??2013-07-22?23:56??GpsServer\.settings\.svn\text-base\org.eclipse.jdt.core.prefs.svn-base

?????文件?????????88??2013-07-23?00:11??GpsServer\.settings\org.eclipse.core.resources.prefs

?????文件????????598??2013-07-22?23:56??GpsServer\.settings\org.eclipse.jdt.core.prefs

?????文件????????265??2013-07-22?23:56??GpsServer\.svn\all-wcprops

?????文件????????523??2013-07-22?23:56??GpsServer\.svn\entries

?????文件???????1408??2013-07-22?23:56??GpsServer\.svn\text-base\.classpath.svn-base

?????文件????????385??2013-07-22?23:56??GpsServer\.svn\text-base\.project.svn-base

?????文件?????????79??2013-07-22?23:56??GpsServer\bin\.svn\all-wcprops

?????文件????????194??2013-07-22?23:56??GpsServer\bin\.svn\entries

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\antlr-2.7.6.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-attributes-api.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-beanutils.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-codec.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-collections.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-dbcp.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-digester.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-discovery-0.2.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-fileupload.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-httpclient-3.0.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-io.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-lang.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-logging.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\commons-pool.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\jsontools-core-1.7.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\mysql-connector-java.jar.svn-base

?????文件?????????53??2013-07-22?23:56??GpsServer\bin\.svn\prop-base\org.json.jar.svn-base

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