-
大小: 4.07MB文件類(lèi)型: .zip金幣: 2下載: 0 次發(fā)布日期: 2023-10-02
- 語(yǔ)言: Java
- 標(biāo)簽:
資源簡(jiǎn)介
這個(gè)是我大一的時(shí)候的一個(gè)練習(xí)的項(xiàng)目,使用的是Servlet+JSP的方法,比較適合初學(xué)的人員參考一下,當(dāng)然代碼中還有不完善的地方,畢竟當(dāng)時(shí)寫(xiě)的代碼還是有些稚嫩,不過(guò)學(xué)習(xí)的價(jià)值還是有的。喜歡的小伙伴可以拿去參考學(xué)習(xí)!

代碼片段和文件信息
package?cn.edu.bit.business;
import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.ArrayList;
import?cn.edu.bit.DBQuery.DataProcess;
import?cn.edu.bit.object.Manager;
/**
?*?
?*?@author?liuyu?2007-7-21
?*/
public?class?Admin_Manager?{
public?static?boolean?CheckAdmin(String?username?String?password)?{
String?query?=?“select?count(*)?from?admin?where?admin.name=‘“
+?username?+?“‘?and?admin.password=‘“?+?password?+?“‘“;
int?count?=?DataProcess.nCount(query);
if?(count?>?0)?{
return?true;
}?else
return?false;
}
/**
?*?
?*?@param?username
?*?@return
?*/
public?static?boolean?HasAdmin(String?username)?{
String?query?=?“select?count(*)?from?admin?where?admin.name=‘“
+?username?+?“‘“;
int?count?=?DataProcess.nCount(query);
if?(count?>?0)?{
return?true;
}?else
return?false;
}
/**
?*?
?*?@param?username
?*?@param?password
?*/
public?static?void?add_Admin(String?username?String?password)?{
String?query?=?“insert?into?admin(admin.nameadmin.password)?values(‘“
+?username?+?“‘‘“?+?password?+?“‘)“;
try?{
DataProcess.ExeQuery(query);
}?catch?(Exception?e)?{
e.printStackTrace();
}
}
public?static?void?Edit_Admin(String?username?String?password)?{
String?query?=?“update?admin?set?admin.password=‘“?+?password
+?“‘?where?admin.name=‘“?+?username?+?“‘“;
try?{
DataProcess.ExeQuery(query);
}?catch?(Exception?e)?{
e.printStackTrace();
}
}
/**
?*?
?*?@param?username
?*/
public?static?void?Delete_Admin(String?username)?{
String?query?=?“delete?from?admin?where?admin.name=‘“?+?username?+?“‘“;
System.out.println(query);
try?{
DataProcess.ExeQuery(query);
}?catch?(Exception?e)?{
e.printStackTrace();
}
}
/**
?*?
?*?@param?username
?*?@return
?*/
public?static?Manager?getManager(String?username)?{
String?selectStr?=?“select?*?from?admin?where?admin.name=‘“?+?username
+?“‘“;
Connection?con?=?DataProcess.getConnection();
Manager?ma?=?Manager.getInstance();
try?{
Statement?stmt?=?con.createStatement();
ResultSet?rs?=?stmt.executeQuery(selectStr);
if?(rs.next())?{
String?password?=?rs.getString(“admin.password“);
ma.setUsername(username);
ma.setPassword(password);
}
rs.close();
stmt.close();
con.close();
return?ma;
}?catch?(Exception?e)?{
e.printStackTrace();
return?null;
}
}
/**
?*?
?*?@return
?*/
public?static?ArrayList?getManagerList()?{
String?query?=?“select?*?from?admin“;
Connection?con?=?DataProcess.getConnection();
ArrayList?al?=?new?ArrayList();
try?{
Statement?stmt?=?con.createStatement();
ResultSet?rs?=?stmt.executeQuery(query);
while?(rs.next())?{
String?username?=?rs.getString(“admin.name“);
String?password?=?rs.getString(“admin.pa
?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\
?????文件????????1766??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\.classpath
?????目錄???????????0??2014-10-26?12:58??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\.myeclipse\
?????文件?????????282??2019-05-29?10:30??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\.myme
?????文件????????1276??2019-05-29?10:30??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\.project
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\.settings\
?????文件??????????88??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\.settings\org.eclipse.core.resources.prefs
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\business\
?????文件????????3308??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\business\Admin_Manager.java
?????文件????????1729??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\business\Grade_Manager.java
?????文件????????1764??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\business\News_Manager.java
?????文件????????2337??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\business\Note_Manager.java
?????文件????????2928??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\business\Project_Manager.java
?????文件????????3581??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\business\Student_Manager.java
?????文件????????3932??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\business\Teacher_Manager.java
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\DBQuery\
?????文件????????2243??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\DBQuery\DataProcess.java
?????目錄???????????0??2019-01-02?11:04??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\ob
?????文件?????????637??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\ob
?????文件?????????791??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\ob
?????文件????????3259??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\ob
?????文件????????1333??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\ob
?????文件????????3496??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\ob
?????文件????????1096??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\ob
?????文件????????1178??2007-11-19?10:18??java項(xiàng)目實(shí)例子-科研信息發(fā)布平臺(tái)\03\Lab\src\cn\edu\bit\ob
............此處省略272個(gè)文件信息
評(píng)論
共有 條評(píng)論