資源簡介
采用桌面應用程序模式,開發一個醫院掛號系統,管理包括人員、號種及其掛號費用,掛號退號等信息,完成登錄、掛號、查詢和統計打印功能。

代碼片段和文件信息
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);
}
if(type.endsWith(“adminToUpd“))
{
adminToUpd(req?res);
}
if(type.endsWith(“adminUpd“))
{
adminUpd(req?res);
}
}
public?void?adminToUpd(HttpServletRequest?reqHttpServletResponse?res)?throws?ServletException?IOException{
int?id?=?Integer.parseInt(req.getParameter(“id“));
TAdmin?admin?=?new?TAdmin();
String?sql=“select?*?from?t_admin?where?userId?=??“;
object[]?params={id};
DB?mydb=new?DB();
try
{
mydb.doPstm(sql?params);
ResultSet?rs=(ResultSet)?mydb.getRs();
while(rs.next())
{
admin.setUserId(rs.getInt(“userId“));
admin.setUserName(rs.getString(“userName“));
admin.setUserPw(rs.getString(“userPw“));
admin.setRole(rs.getInt(“role“));
}
rs.close();
}
catch(Exception?e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute(“admin“?admin);
req.getRequestDispatcher(“admin/admin/adminEdit.jsp“).forward(req?res);
}
public?void?adminUpd(HttpServletRequest?reqHttpServletResponse?res){
String?loginName=req.getParameter(“name“);
String?loginPass=req.getParameter(“pass“);
String?role=req.getParameter(“role“);
String?id?=?req.getParameter(“id“);
String?sql=“update?t_admin?set?userName=???userPw=??role=??where?userId=?“;
object[]?params={loginNameloginPassroleid};
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);
}
/**
?*?管理員信息管理
?*?@param?req
?*?@param?res
?*?@throws?ServletException
?*?@throws?IOException
?*/
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“));
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1200??2019-06-04?16:50??yuyueguahao\.classpath
?????文件????????306??2019-06-04?16:50??yuyueguahao\.myme
?????文件???????1754??2019-06-04?16:50??yuyueguahao\.project
?????文件????????500??2019-06-04?16:50??yuyueguahao\.settings\.jsdtscope
?????文件????????247??2019-06-04?16:50??yuyueguahao\.settings\com.genuitec.eclipse.migration.prefs
?????文件?????????57??2019-06-04?16:50??yuyueguahao\.settings\org.eclipse.core.resources.prefs
?????文件????????364??2019-06-04?16:50??yuyueguahao\.settings\org.eclipse.jdt.core.prefs
?????文件????????559??2019-06-04?16:50??yuyueguahao\.settings\org.eclipse.wst.common.component
?????文件????????359??2019-06-04?16:50??yuyueguahao\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2019-06-04?16:50??yuyueguahao\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2019-06-04?16:50??yuyueguahao\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????7992??2019-06-04?16:50??yuyueguahao\db_yuyueguahao.sql
?????文件???????5182??2019-06-04?16:50??yuyueguahao\src\com\action\admin_servlet.java
?????文件??????14795??2019-06-04?16:50??yuyueguahao\src\com\action\doctor_servlet.java
?????文件???????2204??2019-06-04?16:50??yuyueguahao\src\com\action\index_servlet.java
?????文件???????5418??2019-06-04?16:50??yuyueguahao\src\com\action\keshi_servlet.java
?????文件???????5293??2019-06-04?16:50??yuyueguahao\src\com\action\liuyan_servlet.java
?????文件???????6667??2019-06-04?16:50??yuyueguahao\src\com\action\order_servlet.java
?????文件??????10944??2019-06-04?16:50??yuyueguahao\src\com\action\user_servlet.java
?????文件???????1990??2019-06-04?16:50??yuyueguahao\src\com\dao\ba
?????文件???????2204??2019-06-04?16:50??yuyueguahao\src\com\dao\DB.java
?????文件????????650??2019-06-04?16:50??yuyueguahao\src\com\orm\TAdmin.java
?????文件???????1510??2019-06-04?16:50??yuyueguahao\src\com\orm\TDoctor.java
?????文件????????289??2019-06-04?16:50??yuyueguahao\src\com\orm\TKeshi.java
?????文件???????1152??2019-06-04?16:50??yuyueguahao\src\com\orm\Tliuyan.java
?????文件???????1580??2019-06-04?16:50??yuyueguahao\src\com\orm\TOrder.java
?????文件???????1753??2019-06-04?16:50??yuyueguahao\src\com\orm\Tuser.java
?????文件???????5605??2019-06-04?16:50??yuyueguahao\src\com\service\loginService.java
?????文件???????1054??2019-06-04?16:50??yuyueguahao\src\com\service\luoService.java
?????文件????????941??2019-06-04?16:50??yuyueguahao\src\com\util\DateTools.java
............此處省略935個文件信息
- 上一篇:CISA認證講解及備考輔導
- 下一篇:DSP C55x 復習題
評論
共有 條評論