資源簡介
SMBMS.rar
代碼片段和文件信息
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\.myme
?????文件???????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.xm
?????文件?????????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.xm
?????文件????????231??2017-12-12?09:09??SMBMS\resources\databa
?????文件???????1805??2017-12-12?08:56??SMBMS\resources\log4j.properties
?????文件????????418??2017-12-12?11:02??SMBMS\resources\mybatis-config.xm
?????文件???????2343??2017-12-12?08:56??SMBMS\resources\springmvc-servlet.xm
?????文件???????3252??2016-04-14?13:32??SMBMS\src\cn\smbms\dao\ba
?????文件???????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.xm
?????文件???????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.xm
?????文件????????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.xm
?????文件???????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.xm
?????文件????????864??2015-07-02?11:48??SMBMS\src\cn\smbms\filter\CharacterEncoding.java
............此處省略319個文件信息
- 上一篇:大唐任務管理系統(struts+hibernate)
- 下一篇:OpenGL課程設計
評論
共有 條評論