資源簡介
團購網網站源代碼(JAVA)團購網網站源代碼(JAVA)團購網網站源代碼(JAVA)團購網網站源代碼(JAVA)團購網網站源代碼(JAVA)

代碼片段和文件信息
package?Info;
import?java.sql.*;
public?class?baseDao?{
//?連接數據庫
public?static?Connection?getCon()?{
Connection?con?=?null;
try?{
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver“);
con?=?DriverManager.getConnection(“jdbc:odbc:tgnet“?“sa“?““);
}?catch?(Exception?ex)?{
System.out.println(“getCon:“?+?ex.getMessage());
}
return?con;
}
//?刪除、修改
public?static?int?execUpdateSql(String?strSql)?{
Connection?con?=?null;
Statement?stmt?=?null;
int?rvalue?=?0;
try?{
con?=?getCon();
stmt?=?con.createStatement();
rvalue?=?stmt.executeUpdate(strSql);
}?catch?(Exception?ex)?{
System.out.println(“execUpdateSql:“?+?ex.getMessage());
}
closeAll(null?stmt?con);
return?rvalue;
}
//?查詢
public?static?ResultSet?execSelectSql(String?strSql)?{
Connection?con?=?null;
Statement?stmt?=?null;
ResultSet?rs?=?null;
try?{
con?=?getCon();
stmt?=?con.createStatement();
rs?=?stmt.executeQuery(strSql);
}?catch?(Exception?ex)?{
System.out.println(“execSelectSql:“?+?ex.getMessage());
}
return?rs;
}
//增加
?public?static?int?execUpdateSql(String?strSqlString?[]para)
??{
??int?rvalue=0;
??PreparedStatement?prestm=null;
??Connection?con=null;
??try
??{
??con=getCon();
??prestm=con.prepareStatement(strSql);
??for(int?i=0;i ??{
??prestm.setString(i+1?para[i]);
??} ??
??rvalue=prestm.executeUpdate();
??}
??catch(Exception?ex)
??{
??System.out.print(“execUpdateSql:“+ex.getMessage());
??}
??finally
??{
??closeAll(nullprestmcon);
??}
??return?rvalue;
??}
//?關閉連接
public?static?void?closeAll(ResultSet?rs?Statement?stmt?Connection?con)?{
if?(rs?!=?null)?{
try?{
rs.close();
}?catch?(Exception?ex)?{
}
}
if?(stmt?!=?null)?{
try?{
stmt.close();
}?catch?(Exception?ex)?{
}
}
if?(con?!=?null)?{
try?{
con.close();
}?catch?(Exception?ex)?{
}
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????13637??2008-05-20?08:39??項目ACCPG201\tgnetDB.sql
?????文件????????362??2008-05-06?16:26??項目ACCPG201\TgNetT92G2\TgnetG2\.classpath
?????目錄??????????0??2008-05-19?13:08??項目ACCPG201\TgNetT92G2\TgnetG2\.myeclipse
?????文件????????294??2008-05-20?08:42??項目ACCPG201\TgNetT92G2\TgnetG2\.myme
?????文件???????1225??2008-05-06?18:00??項目ACCPG201\TgNetT92G2\TgnetG2\.project
?????文件???????2053??2008-05-17?14:11??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info\ba
?????文件????????378??2008-05-07?16:34??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info\lodgeDao.java
?????文件????????925??2008-05-07?16:32??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info\LodgeInfo.java
?????文件???????1585??2008-05-13?11:19??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info\ProductsInfo.java
?????文件???????1633??2008-05-16?13:56??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info\SuppliersInfo.java
?????文件???????1692??2008-05-18?13:05??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info\TgMessInfo.java
?????文件???????1391??2008-05-17?15:13??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info\TgUserInfo.java
?????文件???????9678??2008-05-18?14:08??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info\Userba
?????文件???????1254??2008-05-07?09:02??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info\userInfo.java
?????目錄??????????0??2008-05-19?13:08??項目ACCPG201\TgNetT92G2\TgnetG2\src\Info
?????文件???????1807??2008-05-15?11:32??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\adInfo.java
?????文件???????2722??2008-05-19?14:36??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\adInfoDao.java
?????文件???????3372??2008-05-13?13:41??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\ba
?????文件????????856??2008-05-06?17:28??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\Categories.java
?????文件???????1339??2008-05-15?17:10??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\CategoriesDao.java
?????文件???????2668??2008-05-14?17:08??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\lodgeDao.java
?????文件???????1262??2008-05-14?16:49??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\LodgeInfo.java
?????文件???????1998??2008-05-19?15:18??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\Products.java
?????文件??????11174??2008-05-19?17:45??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\ProductsDao.java
?????文件???????2306??2008-05-09?11:52??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\Suppliers.java
?????文件???????8834??2008-05-19?15:24??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\SuppliersDao.java
?????文件???????1889??2008-05-15?19:07??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\TgInfo.java
?????文件???????5903??2008-05-18?10:44??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\TgInfoDao.java
?????文件???????1476??2008-05-18?13:45??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\TgUserInfo.java
?????文件???????2511??2008-05-18?16:26??項目ACCPG201\TgNetT92G2\TgnetG2\src\Tgnet\TgUserInfoDao.java
............此處省略538個文件信息
- 上一篇:小區物業管理系統源程序javaB/S模式
- 下一篇:Java報刊訂閱管理系統
評論
共有 條評論