資源簡介
本系統的用戶分為管理員、員工兩個角色,管理員的主要功能有:管理部門信息、員工信息、會議室信息及系統公告信息;員工的主要功能有:查看系統公告,預訂會議室及取消相關預訂操作。

代碼片段和文件信息
package?com.action;
import?java.io.IOException;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;
import?javax.servlet.RequestDispatcher;
import?javax.servlet.ServletConfig;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?com.dao.DB;
import?com.orm.TAdmin;
public?class?admin_servlet?extends?HttpServlet
{
public?void?service(HttpServletRequest?reqHttpServletResponse?res)throws?ServletException?IOException?
{
????????String?type=req.getParameter(“type“);
if(type.endsWith(“adminMana“))
{
adminMana(req?res);
}
if(type.endsWith(“adminAdd“))
{
adminAdd(req?res);
}
if(type.endsWith(“adminDel“))
{
adminDel(req?res);
}
}
public?void?adminMana(HttpServletRequest?reqHttpServletResponse?res)?throws?ServletException?IOException
{
List?adminList=new?ArrayList();
String?sql=“select?*?from?t_admin“;
object[]?params={};
DB?mydb=new?DB();
try
{
mydb.doPstm(sql?params);
ResultSet?rs=mydb.getRs();
while(rs.next())
{
TAdmin?admin=new?TAdmin();
admin.setUserId(rs.getInt(“userId“));
admin.setUserName(rs.getString(“userName“));
admin.setUserPw(rs.getString(“userPw“));
adminList.add(admin);
????}
rs.close();
}
catch(Exception?e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute(“adminList“?adminList);
req.getRequestDispatcher(“admin/admin/adminMana.jsp“).forward(req?res);
}
public?void?adminAdd(HttpServletRequest?reqHttpServletResponse?res)
{
String?userName=req.getParameter(“userName“);
String?userPw=req.getParameter(“userPw“);
String?sql=“insert?into?t_admin?values(??)“;
object[]?params={userNameuserPw};
DB?mydb=new?DB();
mydb.doPstm(sql?params);
mydb.closed();
req.setAttribute(“message“?“操作成功“);
req.setAttribute(“path“?“admin?type=adminMana“);
????????String?targetURL?=?“/common/success.jsp“;
dispatch(targetURL?req?res);
}
public?void?adminDel(HttpServletRequest?reqHttpServletResponse?res)
{
System.out.println(req.getParameter(“userId“)+“**“);
String?sql=“delete?from?t_admin?where?userId=“+Integer.parseInt(req.getParameter(“userId“));
object[]?params={};
DB?mydb=new?DB();
mydb.doPstm(sql?params);
mydb.closed();
req.setAttribute(“message“?“操作成功“);
req.setAttribute(“path“?“admin?type=adminMana“);
????????String?targetURL?=?“/common/success.jsp“;
dispatch(targetURL?req?res);
}
public?void?dispatch(String?targetURIHttpServletRequest?requestHttpServletResponse?response)?
{
RequestDispatcher?dispatch?=?getServletContext().getRequestDispatcher(targetURI);
try?
{
????dispatch.forward(request?response);
????return;
}?
catch?(ServletException?e)?
{
????????????????????e.printStackTrace();
}?
ca
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-02-28?16:54??JSP+MYSQL會議預約系統\
?????文件????????2290??2019-02-28?16:54??JSP+MYSQL會議預約系統\db_hysyd.sql
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\
?????文件????????1632??2015-02-14?08:01??JSP+MYSQL會議預約系統\hysyd\.classpath
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\.externalToolBuilders\
?????文件?????????552??2015-02-14?08:05??JSP+MYSQL會議預約系統\hysyd\.externalToolBuilders\org.eclipse.wst.common.project.facet.core.builder?(2).launch
?????文件?????????548??2015-02-14?08:05??JSP+MYSQL會議預約系統\hysyd\.externalToolBuilders\org.eclipse.wst.jsdt.core.ja
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\.myeclipse\
?????文件?????????288??2015-02-14?08:06??JSP+MYSQL會議預約系統\hysyd\.myme
?????文件????????2218??2015-02-14?08:05??JSP+MYSQL會議預約系統\hysyd\.project
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\.settings\
?????文件?????????500??2015-02-14?08:01??JSP+MYSQL會議預約系統\hysyd\.settings\.jsdtscope
?????文件?????????629??2015-02-14?08:03??JSP+MYSQL會議預約系統\hysyd\.settings\org.eclipse.jdt.core.prefs
?????文件?????????453??2015-02-14?08:01??JSP+MYSQL會議預約系統\hysyd\.settings\org.eclipse.wst.common.component
?????文件?????????252??2015-02-14?08:01??JSP+MYSQL會議預約系統\hysyd\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2015-02-14?08:01??JSP+MYSQL會議預約系統\hysyd\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-02-14?08:01??JSP+MYSQL會議預約系統\hysyd\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\src\
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\src\com\
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\src\com\action\
?????文件????????3217??2015-02-14?08:01??JSP+MYSQL會議預約系統\hysyd\src\com\action\admin_servlet.java
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\src\com\dao\
?????文件????????2124??2015-02-14?08:06??JSP+MYSQL會議預約系統\hysyd\src\com\dao\DB.java
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\src\com\orm\
?????文件?????????477??2015-02-14?08:01??JSP+MYSQL會議預約系統\hysyd\src\com\orm\Huiyishi.java
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\src\com\service\
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\src\com\util\
?????文件????????1214??2015-02-14?08:01??JSP+MYSQL會議預約系統\hysyd\src\com\util\EncodingFilter.java
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\WebRoot\
?????目錄???????????0??2019-03-02?17:56??JSP+MYSQL會議預約系統\hysyd\WebRoot\admin\
?????目錄???????????0??2019-02-27?15:16??JSP+MYSQL會議預約系統\hysyd\WebRoot\admin\gonggao\
............此處省略830個文件信息
評論
共有 條評論