-
大小: 14.31MB文件類型: .rar金幣: 1下載: 0 次發布日期: 2023-07-02
- 語言: Java
- 標簽:
資源簡介
(基于jsp+sql server 2008 + java的網上訂餐系統，壓縮文件夾中存放了數據庫文件夾還有myeclipse運行的文件
代碼片段和文件信息
package?org.eat.dao;
import?java.io.IOException;
import?java.io.InputStream;
import?java.lang.reflect.Field;
import?java.lang.reflect.Method;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;
import?java.util.Properties;
import?java.util.ResourceBundle;
import?org.apache.commons.beanutils.ConvertUtils;
public?abstract??class?DBUtil?{
protected?Connection?conn?=?null;
protected?PreparedStatement?ps?=?null;
protected?ResultSet?rs?=?null;
/***
?*?連接數據庫
?*?
?*?@return
?*?@throws?ClassNotFoundException
?*?@throws?SQLException?
protected??Connection?getConn（）?throws?ClassNotFoundException?SQLException?{
//?1.加載驅動
Class.forName（driverClass）;
//?2.連接數據庫參數1：連接字符串
conn?=?DriverManager.getConnection（urlusernamepassword）;
return?conn;
}?
*/
/***
?*?使用數據庫連接池連接
*/
protected?Connection?getConn（）?throws?ClassNotFoundException?SQLException?{
Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
this.conn?=?DriverManager.getConnection（“jdbc:sqlserver://localhost:1434;databaseName=eat““sa“““）;
return?conn;
}?
/***
?*?釋放資源
?*/
protected?void?closeAll（）{
try?{
if（rs?!=?null）{
rs.close（）;
}
if（ps?!=?null）{
ps.close（）;
}
if（conn?!=?null）{
conn.close（）;
}
}?catch?（SQLException?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}finally{
conn?=?null;
ps?=?null;
rs?=?null;
}
}
/***
?*?執行增刪改
?*?@param?sql
?*?@param?params
?*?@return
?*/
protected?int?executeUpdate（String?sqlobject[]?params）{
try?{
this.getConn（）;
ps?=?conn.prepareStatement（sql）;
//判斷SQL語句中是否存在？號占位符
if（params!=null?&&?params.length!=0）{
//設置?號占位符的值
for（int?i=0;iject（i+1?params[i]）;
}
}
return?ps.executeUpdate（）;
}?catch?（ClassNotFoundException?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}?catch?（SQLException?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}finally{
this.closeAll（）;
}
return?0;
}
/***
?*?執行增刪改支持事務
?*?@param?sql
?*?@param?params
?*?@param?boolean?是否為事務處理（true表示事務）
?*?@return
?*?@throws?SQLException?
protected?int?executeUpdate（String?sqlobject[]?paramsboolean?boo）?throws?SQLException{
System.out.println（conn.hashCode（））;
ps?=?conn.prepareStatement（sql）;
//判斷SQL語句中是否存在？號占位符
if（params!=null?&&?params.length!=0）{
//設置?號占位符的值
for（int?i=0;iject（i+1?params[i]）;
}
}
return?ps.executeUpdate（）;
}
?*/
/***
?*?查詢方法
?*?@param?sql??sql語句
?*?@param?params????SQL語句中?號占位符的值
?*?@param?cla???字節碼對象（應該是SQL語句中表所對應的類的字節碼對象）
?*?@retu ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????3145728??2016-12-29?18:54??基于jsp+sql?server?2008?+?java的網上訂餐系統\databa
?????文件????1048576??2016-12-29?18:54??基于jsp+sql?server?2008?+?java的網上訂餐系統\databa
?????文件???????1200??2016-12-25?22:29??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.classpath
?????文件???????1355??2016-12-29?08:13??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.myeclipse\profiler\eat?on?MyEclipse?Tomcat?7.xm
?????文件???????1354??2016-12-26?08:45??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.myeclipse\profiler\eat?on?MyEclipse?Tomcat.xm
?????文件????????282??2016-12-25?10:55??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.myme
?????文件???????1746??2016-12-25?15:38??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.project
?????文件????????500??2016-12-25?10:55??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.settings\.jsdtscope
?????文件?????????73??2016-12-29?10:38??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.settings\com.genuitec.eclipse.core.prefs
?????文件????????247??2016-12-25?22:29??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.settings\com.genuitec.eclipse.migration.prefs
?????文件?????????65??2016-12-28?13:47??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.settings\org.eclipse.core.resources.prefs
?????文件????????364??2016-12-25?10:55??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.settings\org.eclipse.jdt.core.prefs
?????文件????????535??2016-12-25?22:29??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.settings\org.eclipse.wst.common.component
?????文件????????359??2016-12-25?22:29??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2016-12-25?10:55??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2016-12-25?10:55??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件?????????25??2016-12-25?22:29??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\me
?????文件???????5194??2016-12-28?21:22??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\dao\DBUtil.java
?????文件????????187??2016-12-26?13:08??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\dao\Dishinf.java
?????文件????????211??2016-12-27?10:54??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\dao\OrderInf.java
?????文件????????405??2016-12-25?17:57??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\dao\Test.java
?????文件????????275??2016-12-29?10:15??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\dao\UserInf.java
?????文件????????371??2016-12-26?19:02??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\entity\Car.java
?????文件???????1492??2016-12-26?20:46??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\entity\Dish.java
?????文件???????1450??2016-12-27?10:44??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\entity\Order.java
?????文件????????708??2016-12-27?10:45??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\entity\OrderDetail.java
?????文件???????1553??2016-12-25?11:13??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\entity\User.java
?????文件????????656??2016-12-26?13:12??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\imply\DishImply.java
?????文件????????932??2016-12-27?13:57??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\imply\OrderImply.java
?????文件???????1573??2016-12-29?10:59??基于jsp+sql?server?2008?+?java的網上訂餐系統\eat1\src\org\eat\imply\UserImply.java
............此處省略265個文件信息
評論
共有 條評論
川公網安備 51152502000135號