package?cn.smbms.dao;

import?java.io.IOException;
import?java.io.InputStream;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.Properties;

/**
?*?操作數據庫的基類--靜態類
?*?@author?Administrator
?*
?*/
public?class?baseDao?{
	
	static{//靜態代碼塊在類加載的時候執行
		init（）;
	}
	
	private?static?String?driver;
	private?static?String?url;
	private?static?String?user;
	private?static?String?password;
	
	//初始化連接參數從配置文件里獲得
	public?static?void?init（）{
		Properties?params=new?Properties（）;
		String?configFile?=?“database.properties“;
		InputStream?is=baseDao.class.getClassLoader（）.getResourceAsStream（configFile）;
		try?{
			params.load（is）;
		}?catch?（IOException?e）?{
			e.printStackTrace（）;
		}
		driver=params.getProperty（“driver“）;
		url=params.getProperty（“url“）;
		user=params.getProperty（“user“）;
		password=params.getProperty（“password“）;

	}???
	
	
	/**
	?*?獲取數據庫連接
	?*?@return
	?*/
	public?static?Connection?getConnection（）{
		Connection?connection?=?null;
		try?{
			Class.forName（driver）;
			connection?=?DriverManager.getConnection（url?user?password）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		return?connection;
	}
	/**
	?*?查詢操作
	?*?@param?connection
	?*?@param?pstm
	?*?@param?rs
	?*?@param?sql
	?*?@param?params
	?*?@return
	?*/
	public?static?ResultSet?execute（Connection?connectionPreparedStatement?pstmResultSet?rs
			String?sqlobject[]?params）?throws?Exception{
		pstm?=?connection.prepareStatement（sql）;
		for（int?i?=?0;?i?			pstm.setobject（i+1?params[i]）;
		}
		rs?=?pstm.executeQuery（）;
		return?rs;
	}
	/**
	?*?更新操作
	?*?@param?connection
	?*?@param?pstm
	?*?@param?sql
	?*?@param?params
	?*?@return
	?*?@throws?Exception
	?*/
	public?static?int?execute（Connection?connectionPreparedStatement?pstm
			String?sqlobject[]?params）?throws?Exception{
		int?updateRows?=?0;
		pstm?=?connection.prepareStatement（sql）;
		for（int?i?=?0;?i?			pstm.setobject（i+1?params[i]）;
		}
		updateRows?=?pstm.executeUpdate（）;
		return?updateRows;
	}
	
	/**
	?*?釋放資源
	?*?@param?connection
	?*?@param?pstm
	?*?@param?rs
	?*?@return
	?*/
	public?static?boolean?closeResource（Connection?connectionPreparedStatement?pstmResultSet?rs）{
		boolean?flag?=?true;
		if（rs?!=?null）{
			try?{
				rs.close（）;
				rs?=?null;//GC回收
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				flag?=?false;
			}
		}
		if（pstm?!=?null）{
			try?{
				pstm.close（）;
				pstm?=?null;//GC回收
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				flag?=?false;
			}
		}
		if（connection?!=?null）{
			try?{
				connection.close（）;
				connection?=?null;//GC回收
			}?catch?（SQLException?e）?{
			

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

?????文件???????3184??2017-12-11?14:56??SMBMS\.classpath

?????文件????????288??2016-06-21?15:44??SMBMS\.mymetadata

?????文件???????1619??2017-12-06?14:36??SMBMS\.project

?????文件????????500??2015-06-30?10:05??SMBMS\.settings\.jsdtscope

?????文件????????134??2015-07-08?06:25??SMBMS\.settings\com.genuitec.eclipse.core.prefs

?????文件????????161??2017-12-07?10:38??SMBMS\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2015-06-30?10:09??SMBMS\.settings\org.eclipse.jdt.core.prefs

?????文件????????531??2017-12-07?10:46??SMBMS\.settings\org.eclipse.wst.common.component

?????文件????????252??2015-06-30?10:09??SMBMS\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-06-30?10:05??SMBMS\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-06-30?10:05??SMBMS\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2584??2017-12-12?18:03??SMBMS\resources\applicationContext.xml

?????文件????????231??2017-12-12?09:09??SMBMS\resources\database.properties

?????文件???????1805??2017-12-12?08:56??SMBMS\resources\log4j.properties

?????文件????????418??2017-12-12?11:02??SMBMS\resources\mybatis-config.xml

?????文件???????2343??2017-12-12?08:56??SMBMS\resources\springmvc-servlet.xml

?????文件???????3252??2016-04-14?13:32??SMBMS\src\cn\smbms\dao\baseDao.java

?????文件???????1353??2017-12-12?17:12??SMBMS\src\cn\smbms\dao\bill\BillDao.java

?????文件???????5598??2017-12-12?17:47??SMBMS\src\cn\smbms\dao\bill\BillDaoImpl.java

?????文件???????2295??2017-12-12?18:10??SMBMS\src\cn\smbms\dao\bill\BillDaoMapper.xml

?????文件???????1232??2017-12-12?16:42??SMBMS\src\cn\smbms\dao\provider\ProviderDao.java

?????文件???????4607??2017-12-12?16:40??SMBMS\src\cn\smbms\dao\provider\ProviderDaoImpl.java

?????文件???????1731??2017-12-12?17:04??SMBMS\src\cn\smbms\dao\provider\ProviderDaoMapper.xml

?????文件????????173??2017-12-12?09:52??SMBMS\src\cn\smbms\dao\role\RoleDao.java

?????文件????????795??2017-12-12?10:06??SMBMS\src\cn\smbms\dao\role\RoleDaoImpl.java

?????文件????????301??2017-12-12?10:06??SMBMS\src\cn\smbms\dao\role\RoleDaoMapper.xml

?????文件???????1944??2017-12-12?15:36??SMBMS\src\cn\smbms\dao\user\UserDao.java

?????文件???????7556??2017-12-12?15:36??SMBMS\src\cn\smbms\dao\user\UserDaoImpl.java

?????文件???????2645??2017-12-12?15:47??SMBMS\src\cn\smbms\dao\user\UserDaoMapper.xml

?????文件????????864??2015-07-02?11:48??SMBMS\src\cn\smbms\filter\CharacterEncoding.java

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