-
大小: 15.57MB文件類型: .zip金幣: 1下載: 0 次發(fā)布日期: 2023-07-21
- 語(yǔ)言: Java
- 標(biāo)簽: 純JavaWeb??網(wǎng)上書店??初學(xué)者??
資源簡(jiǎn)介
最初接觸JavaWeb時(shí)做的一個(gè)基礎(chǔ)Web項(xiàng)目，無(wú)框架，包含大量CSS樣式，HTML頁(yè)面，java后臺(tái)操作以及少量的ajax驗(yàn)證（對(duì)用戶賬號(hào)注冊(cè)的驗(yàn)證）和少量js代碼，非常適用于初學(xué)者。本資源還提供了MySQL數(shù)據(jù)庫(kù)資源以及項(xiàng)目功能界面的簡(jiǎn)單說(shuō)明，希望對(duì)您有幫助。
代碼片段和文件信息
package?dao;
import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.Date;
import?entity.Admin;
import?entity.User;
import?util.DatabaseConnection;
public?class?AdminDao?{
Connection?conn;//用于數(shù)據(jù)庫(kù)的連接
Statement?stmt;//用于將SQL語(yǔ)句發(fā)送到數(shù)據(jù)庫(kù)中
ResultSet?rs;//用于保存所有符合SQL語(yǔ)句條件的所有數(shù)據(jù)項(xiàng)
public?boolean?checkAdmin（Admin?admin）{
boolean?checkResult=false;
String?id?=?admin.getId（）;
String?password?=?admin.getPassword（）;
System.out.println（id）;
System.out.println（password）;
try?{
//連接上數(shù)據(jù)庫(kù)
conn?=?DatabaseConnection.getConnection（）;
stmt=conn.createStatement（）;
String?selectSql?=?“select?*?from?admin?where?id=‘“+id+“‘?and?password=‘“+password+“‘“;
rs=stmt.executeQuery（selectSql）;
while（rs.next（））{
checkResult=true;
}
System.out.println（checkResult）;
}?catch?（Exception?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}finally{
//關(guān)閉數(shù)據(jù)庫(kù)連接
DatabaseConnection.close（rsconn）;
}
return?checkResult;
}
public?boolean?insertAdmin（Admin?admin）{
boolean?insertResult=false;
String?id?=?admin.getId（）;
String?password?=?admin.getPassword（）;
String?insertSql?=?“insert?into?admin?（idpassword）?values?（‘“+id+“‘‘“+password+“‘）“;
try?{
//連接上數(shù)據(jù)庫(kù)
conn?=?DatabaseConnection.getConnection（）;
stmt=conn.createStatement（）;
stmt.executeUpdate（insertSql）;
insertResult=true;
}?catch?（Exception?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}finally{
//關(guān)閉數(shù)據(jù)庫(kù)連接
DatabaseConnection.close（rsconn）;
}
return?insertResult;
}
public?boolean?updateAdminPwdById（String?adminIdString?adminPassword）{
boolean?updateResult=false;
try?{
//連接上數(shù)據(jù)庫(kù)
conn?=?DatabaseConnection.getConnection（）;
stmt=conn.createStatement（）;
String?updateSql?=?“update?admin?set?password?=?‘“+adminPassword+“‘?where?id?=?‘“+adminId+“‘“;
stmt.executeUpdate（updateSql）;
updateResult=true;
}?catch?（Exception?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}finally{
//關(guān)閉數(shù)據(jù)庫(kù)連接
DatabaseConnection.close（rsconn）;
}
return?updateResult;
}
/**
?*?通過(guò)adminId刪除管理員
?*?@param?adminId
?*?@return
?*/
public?boolean?deleteAdminById（String?adminId）{
boolean?deleteResult?=?false;
try?{
//連接上數(shù)據(jù)庫(kù)
conn?=?DatabaseConnection.getConnection（）;
stmt=conn.createStatement（）;
String?deleteSql?=?“delete?from?admin?where?id?=?‘“+adminId+“‘“;
stmt.executeUpdate（deleteSql）;
deleteResult=true;
}?catch?（Exception?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}finally{
//關(guān)閉數(shù)據(jù)庫(kù)連接
DatabaseConnection.close（rsconn）;
}
return?deleteResult;
}
public?Admin?selectAdminById（String?adminId）{
Admin?admin?=?null;
try?{
//連接上數(shù)據(jù)庫(kù)
conn?=?DatabaseConnection.getConnection（）;
stmt=conn.createStatement（）;
String?selectSql?=?“selec ?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項(xiàng)目\
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\
?????文件??????663091??2018-01-12?19:08??軟件15175129+趙媛媛+期末web項(xiàng)目\Book.war
?????文件???????19573??2018-01-12?18:57??軟件15175129+趙媛媛+期末web項(xiàng)目\bookstore.sql
?????文件?????????903??2018-01-02?11:15??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.classpath
?????文件????????1037??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.project
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.settings\
?????文件?????????567??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.settings\.jsdtscope
?????文件?????????245??2018-01-01?16:49??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.settings\org.eclipse.jdt.core.prefs
?????文件?????????464??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.settings\org.eclipse.wst.common.component
?????文件?????????345??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\dao\
?????文件????????3900??2018-01-09?16:28??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\dao\AdminDao.class
?????文件????????9044??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\dao\BookDao.class
?????文件????????4188??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\dao\CategoryDao.class
?????文件????????4386??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\dao\CustomerDao.class
?????文件????????7442??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\dao\IndentDao.class
?????文件?????????755??2018-01-09?16:28??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\dao\Test.class
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\entity\
?????文件?????????776??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\entity\Admin.class
?????文件????????3788??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\entity\Book.class
?????文件?????????886??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\entity\Category.class
?????文件????????2944??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\entity\Indent.class
?????文件????????1456??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\entity\Items.class
?????文件????????1437??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\entity\User.class
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項(xiàng)目\Book\build\classes\service\
............此處省略218個(gè)文件信息
評(píng)論
共有 條評(píng)論
川公網(wǎng)安備 51152502000135號(hào)