資源簡介
一個純粹的面向Servlet+Jsp+Jdbc+jQuery+Ajax+面向接口編程的商城項目,適合初學者學習和參考。
詳情描述請查看博客:https://blog.csdn.net/CDWLX/article/details/97248530

代碼片段和文件信息
package?com.hr.dao;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
public?class?basedao?{
static{
try?{
Class.forName(“com.mysql.jdbc.Driver“);
}?catch?(ClassNotFoundException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
public?static?Connection?getconn(){
Connection?conn=null;
?try?{
conn=DriverManager.getConnection(“jdbc:mysql://127.0.0.1:3306/my_ebuy?useUnicode=true&characterEncoding=utf-8““root““123456“);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?conn;
}
public?static?void?closeall(ResultSet?rsStatement?psConnection?conn){
try?{
if(rs!=null)
???rs.close();
if(ps!=null)
ps.close();
if(conn!=null)
conn.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
public?static?int?exectuIUD(String?sqlobject[]?params){
int?count=0;
??Connection?conn=basedao.getconn();
??PreparedStatement?ps=null;
??try?{
ps=conn.prepareStatement(sql);
System.out.println(“sql:“?+?sql);
if(params!=null){
for?(int?i?=?0;?i? ps.setobject(i+1?params[i]);
}
}
count=ps.executeUpdate();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
finally{
basedao.closeall(null?ps?conn);
}
return?count;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1307??2019-07-05?22:28??java?web商城\my_ebuy\.classpath
?????文件????????294??2019-07-05?22:28??java?web商城\my_ebuy\.myme
?????文件???????1750??2019-07-05?22:28??java?web商城\my_ebuy\.project
?????文件????????500??2019-07-05?22:28??java?web商城\my_ebuy\.settings\.jsdtscope
?????文件????????167??2019-07-05?22:28??java?web商城\my_ebuy\.settings\com.genuitec.eclipse.core.prefs
?????文件????????382??2019-07-05?22:28??java?web商城\my_ebuy\.settings\com.genuitec.eclipse.migration.prefs
?????文件?????????55??2019-07-05?22:28??java?web商城\my_ebuy\.settings\org.eclipse.core.resources.prefs
?????文件????????598??2019-07-05?22:28??java?web商城\my_ebuy\.settings\org.eclipse.jdt.core.prefs
?????文件????????637??2019-07-05?22:28??java?web商城\my_ebuy\.settings\org.eclipse.wst.common.component
?????文件????????412??2019-07-05?22:28??java?web商城\my_ebuy\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2019-07-05?22:28??java?web商城\my_ebuy\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2019-07-05?22:28??java?web商城\my_ebuy\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????1571??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\ba
?????文件???????6847??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\EASYBUY_COMMENTDao.java
?????文件???????1194??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\EASYBUY_DdanDao.java
?????文件???????1016??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\EASYBUY_DDDao.java
?????文件???????3629??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\EASYBUY_NEWSDao.java
?????文件???????5014??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\EASYBUY_ORDERDao.java
?????文件???????2385??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\EASYBUY_ORDER_DETAILDao.java
?????文件??????16076??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\EASYBUY_PRODUCTDao.java
?????文件???????4883??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\EASYBUY_PRODUCT_CATEGORYDao.java
?????文件???????7512??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\EASYBUY_USERDao.java
?????文件???????4553??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\dao\ESDao.java
?????文件???????1425??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\entity\EASYBUY_COMMENT.java
?????文件???????1042??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\entity\EASYBUY_DD.java
?????文件???????1452??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\entity\EASYBUY_Ddan.java
?????文件????????918??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\entity\EASYBUY_NEWS.java
?????文件???????2037??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\entity\EASYBUY_ORDER.java
?????文件????????997??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\entity\EASYBUY_ORDER_DETAIL.java
?????文件???????1678??2019-07-05?22:28??java?web商城\my_ebuy\src\com\hr\entity\EASYBUY_PRODUCT.java
............此處省略339個文件信息
評論
共有 條評論