資源簡介
最初接觸JavaWeb時做的一個基礎Web項目，無框架，包含大量CSS樣式，HTML頁面，java后臺操作以及少量的ajax驗證（對用戶賬號注冊的驗證）和少量js代碼，非常適用于初學者。本資源還提供了MySQL數據庫資源以及項目功能界面的簡單說明，希望對您有幫助。
代碼片段和文件信息
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;//用于數據庫的連接
Statement?stmt;//用于將SQL語句發送到數據庫中
ResultSet?rs;//用于保存所有符合SQL語句條件的所有數據項
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?{
//連接上數據庫
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{
//關閉數據庫連接
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?{
//連接上數據庫
conn?=?DatabaseConnection.getConnection（）;
stmt=conn.createStatement（）;
stmt.executeUpdate（insertSql）;
insertResult=true;
}?catch?（Exception?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}finally{
//關閉數據庫連接
DatabaseConnection.close（rsconn）;
}
return?insertResult;
}
public?boolean?updateAdminPwdById（String?adminIdString?adminPassword）{
boolean?updateResult=false;
try?{
//連接上數據庫
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{
//關閉數據庫連接
DatabaseConnection.close（rsconn）;
}
return?updateResult;
}
/**
?*?通過adminId刪除管理員
?*?@param?adminId
?*?@return
?*/
public?boolean?deleteAdminById（String?adminId）{
boolean?deleteResult?=?false;
try?{
//連接上數據庫
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{
//關閉數據庫連接
DatabaseConnection.close（rsconn）;
}
return?deleteResult;
}
public?Admin?selectAdminById（String?adminId）{
Admin?admin?=?null;
try?{
//連接上數據庫
conn?=?DatabaseConnection.getConnection（）;
stmt=conn.createStatement（）;
String?selectSql?=?“selec ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項目\
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項目\Book\
?????文件??????663091??2018-01-12?19:08??軟件15175129+趙媛媛+期末web項目\Book.war
?????文件???????19573??2018-01-12?18:57??軟件15175129+趙媛媛+期末web項目\bookstore.sql
?????文件?????????903??2018-01-02?11:15??軟件15175129+趙媛媛+期末web項目\Book\.classpath
?????文件????????1037??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項目\Book\.project
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項目\Book\.settings\
?????文件?????????567??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項目\Book\.settings\.jsdtscope
?????文件?????????245??2018-01-01?16:49??軟件15175129+趙媛媛+期末web項目\Book\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項目\Book\.settings\org.eclipse.jdt.core.prefs
?????文件?????????464??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項目\Book\.settings\org.eclipse.wst.common.component
?????文件?????????345??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項目\Book\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項目\Book\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-12-22?20:38??軟件15175129+趙媛媛+期末web項目\Book\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項目\Book\build\
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項目\Book\build\classes\
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項目\Book\build\classes\dao\
?????文件????????3900??2018-01-09?16:28??軟件15175129+趙媛媛+期末web項目\Book\build\classes\dao\AdminDao.class
?????文件????????9044??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\dao\BookDao.class
?????文件????????4188??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\dao\CategoryDao.class
?????文件????????4386??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\dao\CustomerDao.class
?????文件????????7442??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\dao\IndentDao.class
?????文件?????????755??2018-01-09?16:28??軟件15175129+趙媛媛+期末web項目\Book\build\classes\dao\Test.class
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項目\Book\build\classes\entity\
?????文件?????????776??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\entity\Admin.class
?????文件????????3788??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\entity\Book.class
?????文件?????????886??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\entity\Category.class
?????文件????????2944??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\entity\Indent.class
?????文件????????1456??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\entity\Items.class
?????文件????????1437??2018-01-09?11:30??軟件15175129+趙媛媛+期末web項目\Book\build\classes\entity\User.class
?????目錄???????????0??2018-05-25?08:07??軟件15175129+趙媛媛+期末web項目\Book\build\classes\service\
............此處省略218個文件信息
評論
共有 條評論
川公網安備 51152502000135號