基于JSP實(shí)現(xiàn)私人牙科診所管理系統(tǒng)
?
作者主頁(yè)：編程指南針
?簡(jiǎn)介：Java領(lǐng)域優(yōu)質(zhì)創(chuàng)作者、CSDN博客專(zhuān)家? Java項(xiàng)目、簡(jiǎn)歷模板、學(xué)習(xí)資料、面試題庫(kù)、技術(shù)互助
文末獲取源碼
項(xiàng)目編號(hào)：BS-YL-004
本系統(tǒng)基于JSP/SERVLET實(shí)現(xiàn)開(kāi)發(fā)，數(shù)據(jù)庫(kù)采用MYSQL，開(kāi)發(fā)工具采用IDEA或ECLIPSE。
系統(tǒng)分兩個(gè)角色：系統(tǒng)管理員和前端用戶(hù)。前臺(tái)用戶(hù)可以實(shí)現(xiàn)注冊(cè)，預(yù)約掛號(hào)，個(gè)人信息管理，公告管理，留言;后臺(tái)管理人員可以管理科室，醫(yī)院人員，收費(fèi)統(tǒng)計(jì)，預(yù)約管理，留言管理，公告管理等。運(yùn)行無(wú)誤。
管理員登陸： admin / 123
前端用戶(hù)登陸：xm / 123
系統(tǒng)部分功能展示如下：
系統(tǒng)管理員登陸
用戶(hù)管理
公告管理
留言管理
科室管理
藥品處置管理
統(tǒng)計(jì)報(bào)表之收費(fèi)統(tǒng)計(jì)
掛號(hào)統(tǒng)計(jì)
修改個(gè)人信息
前端用戶(hù)登陸注冊(cè)：
留言板
登陸后預(yù)約掛號(hào)
個(gè)人信息修改
本系統(tǒng)功能完整，運(yùn)行無(wú)誤，比較適合作畢業(yè)設(shè)計(jì)使用。
部分核心代碼如下：
package control;import java.io.BufferedInputStream;import java.io.BufferedOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import java.io.PrintWriter;import java.io.UnsupportedEncodingException;import java.net.URLEncoder;import java.text.DecimalFormat;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import org.apache.commons.fileupload.FileItem;import org.apache.commons.fileupload.FileUpload;import org.apache.commons.fileupload.RequestContext;import org.apache.commons.fileupload.disk.DiskFileItemFactory;import org.apache.commons.fileupload.servlet.ServletFileUpload;import org.apache.commons.fileupload.servlet.ServletRequestContext;import util.Info;import dao.CommDAO;public class MainCtrl extends HttpServlet { public MainCtrl() { super();
} public void destroy() { super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { this.doPost(request, response);
} public void go(String url,HttpServletRequest request, HttpServletResponse response)
{ try {
request.getRequestDispatcher(url).forward(request, response);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public void gor(String url,HttpServletRequest request, HttpServletResponse response)
{ try {
response.sendRedirect(url);
} catch (IOException e) { // TODO Auto-generated catch block
e.printStackTrace();
}
} public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
? ? ? ?response.setContentType("text/html"); PrintWriter out = response.getWriter(); HttpSession session = request.getSession(); HashMap admin = (HashMap)session.getAttribute("admin"); HashMap user = (HashMap)session.getAttribute("user"); String ac = request.getParameter("ac"); if(ac==null)ac=""; CommDAO dao = new CommDAO(); String date = Info.getDateStr(); String today = date.substring(0,10); String tomonth = date.substring(0,7);
//登錄
if(ac.equals("login"))
{ String utype = request.getParameter("utype"); String username = request.getParameter("uname"); String password = request.getParameter("upass"); String sql = "select * from sysuser where uname='"+username+"' and upass='"+password+"' ";
List<HashMap> userlist = dao.select(sql); if(userlist.size()!=1)
{
request.setAttribute("error", "");
go("/admin/login.jsp", request, response);
}else{
request.getSession(). setAttribute("admin", userlist.get(0));
gor("/srykzsblmis/admin/index.jsp", request, response);
}
}
//添加用戶(hù)
if(ac.equals("sysuseradd")){ String uname = request.getParameter("uname"); String cksql = "select * from sysuser where uname='"+uname+"'"; ArrayList cklist = (ArrayList)dao.select(cksql); if(cklist.size()!=0){
request.getParameter("no");
go("/admin/sysuseradd.jsp", request, response);
}else{ String upass = request.getParameter("upass"); String tname = request.getParameter("tname"); String utype = request.getParameter("utype"); String sex = request.getParameter("sex"); String birth = request.getParameter("birth"); String tel = request.getParameter("tel"); String ismarage = request.getParameter("ismarage"); String addr = request.getParameter("addr"); String email = request.getParameter("email"); String idcard = request.getParameter("idcard"); String byschool = request.getParameter("byschool"); String dept = request.getParameter("dept"); if(!utype.equals("醫(yī)生")){
dept = "";
} String sql = "insert into sysuser (uname,upass,tname,utype,sex,dept,birth,tel,ismarage,addr,email,idcard,byschool)values" + " ('"+uname+"','"+upass+"','"+tname+"','"+utype+"','"+sex+"','"+dept+"','"+birth+"','"+tel+"','"+ismarage+"'" + " ,'"+addr+"','"+email+"','"+idcard+"','"+byschool+"')";
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/sysuseradd.jsp", request, response);
}
} //編輯用戶(hù)
if(ac.equals("sysuseredit")){ String id = request.getParameter("id"); String upass = request.getParameter("upass"); String tname = request.getParameter("tname"); String utype = request.getParameter("utype"); String sex = request.getParameter("sex"); String dept = request.getParameter("dept"); String birth = request.getParameter("birth"); String tel = request.getParameter("tel"); String ismarage = request.getParameter("ismarage"); String addr = request.getParameter("addr"); String email = request.getParameter("email"); String idcard = request.getParameter("idcard"); String byschool = request.getParameter("byschool"); if(!utype.equals("醫(yī)生")){
dept = "";
} String sql = "update sysuser set upass='"+upass+"',tname='"+tname+"',utype='"+utype+"',sex='"+sex+"',dept='"+dept+"' " + " ,birth='"+birth+"',tel='"+tel+"',ismarage='"+ismarage+"',addr='"+addr+"',email='"+email+"'" + " ,idcard='"+idcard+"',byschool='"+byschool+"' where id="+id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/sysuseradd.jsp", request, response);
}
//修改個(gè)人信息
if(ac.equals("stuedit1")){ String id = request.getParameter("id"); String upass = request.getParameter("upass"); String tname = request.getParameter("tname"); String sfcard = request.getParameter("sfcard"); String sex = request.getParameter("sex"); String tel = request.getParameter("tel"); String yx = request.getParameter("yx"); String bj = request.getParameter("bj"); String sql = "update student set upass='"+upass+"',tname='"+tname+"',sfcard='"+sfcard+"',sex='"+sex+"',tel='"+tel+"',yx='"+yx+"',bj='"+bj+"' where id="+id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/stuinfo.jsp", request, response);
}
//添加科室
if(ac.equals("deptadd")){ String deptname = request.getParameter("deptname"); String tel = request.getParameter("tel"); String addr = request.getParameter("addr"); String delstatus = "0"; String sql = "insert into dept (deptname,tel,addr,delstatus) values('"+deptname+"','"+tel+"','"+addr+"','"+delstatus+"')";
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/deptadd.jsp", request, response);
} //修改科室
if(ac.equals("deptedit")){ String id = request.getParameter("id"); String tel = request.getParameter("tel"); String addr = request.getParameter("addr"); String deptname = request.getParameter("deptname");
String sql = "update dept set deptname='"+deptname+"',tel='"+tel+"',addr='"+addr+"' where id= "+id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/deptadd.jsp", request, response);
} //添加藥品、處置
if(ac.equals("ypcfadd")){ String yno = request.getParameter("yno"); String cksql = "select * from ypcf where yno='"+yno+"'"; ArrayList cklist = (ArrayList)dao.select(cksql); if(cklist.size()!=0){
request.getParameter("no");
go("/admin/ypcfadd.jsp", request, response);
}else{ String yname = request.getParameter("yname"); String price = request.getParameter("price"); String type = request.getParameter("type"); String gg = request.getParameter("gg"); String company = request.getParameter("company"); if(!type.equals("藥品")){
gg = "";
company = "";
} String delstatus = "0"; String sql = "insert into ypcf (yno,yname,gg,price,company,delstatus,type)values('"+yno+"','"+yname+"','"+gg+"','"+price+"','"+company+"','"+delstatus+"','"+type+"')";
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/ypcfadd.jsp", request, response);
}
} //編輯藥品、處置
if(ac.equals("ypcfedit")){ String id = request.getParameter("id"); String yname = request.getParameter("yname"); String price = request.getParameter("price"); String type = request.getParameter("type"); String gg = request.getParameter("gg"); String company = request.getParameter("company"); if(!type.equals("藥品")){
gg = "";
company = "";
} String sql = "update ypcf set yname='"+yname+"',gg='"+gg+"',price='"+price+"',company='"+company+"',type='"+type+"' where id="+id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/ypcfadd.jsp", request, response);
}
//修改密碼
if(ac.equals("uppass")){ String id = request.getParameter("id"); String upass = request.getParameter("upass"); String tname = request.getParameter("tname"); String sex = request.getParameter("sex"); String birth = request.getParameter("birth"); String tel = request.getParameter("tel"); String ismarage = request.getParameter("ismarage"); String addr = request.getParameter("addr"); String email = request.getParameter("email"); String idcard = request.getParameter("idcard"); String byschool = request.getParameter("byschool"); String sql = "update sysuser set upass='"+upass+"',tname='"+tname+"',sex='"+sex+"' ?,birth='"+birth+"',tel='"+tel+"',ismarage='"+ismarage+"',addr='"+addr+"',email='"+email+"'" + " ,idcard='"+idcard+"',byschool='"+byschool+"' where id="+id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/uppass.jsp", request, response);
} //退出
if(ac.equals("exit")){
session.removeAttribute("admin");
request.setAttribute("suc", "");
go("/admin/login.jsp", request, response);
} //新增掛號(hào)
if(ac.equals("ghadd")){ String ghno = request.getParameter("ghno"); String tname = request.getParameter("tname"); String sex = request.getParameter("sex"); String age = request.getParameter("age"); String idcard = request.getParameter("idcard"); String tel = request.getParameter("tel"); String addr = request.getParameter("addr"); String ghdept = request.getParameter("ghdept"); String price = request.getParameter("price"); String status = "待問(wèn)診";
String delstatus = "0"; String oper = admin.get("uname").toString(); String savetime = Info.getDateStr();
dao.commOper("insert into ghinfo (ghno,tname,sex,age,idcard,tel,addr,ghdept,price,status,delstatus,oper,savetime) " + " values('"+ghno+"','"+tname+"','"+sex+"','"+age+"','"+idcard+"','"+tel+"','"+addr+"','"+ghdept+"','"+price+"','"+status+"','"+delstatus+"','"+oper+"','"+savetime+"') ?");
request.setAttribute("suc", "");
go("/admin/ghadd.jsp", request, response);
} //藥品入庫(kù)
if(ac.equals("yprk")){ String yno = request.getParameter("yno"); String num = request.getParameter("num"); String type = "in"; String oper = admin.get("uname").toString(); String savetime = Info.getDateStr();
dao.commOper("insert into kcrecord (yno,num,type,savetime,oper) values ('"+yno+"','"+num+"','"+type+"','"+savetime+"','"+oper+"') ");
request.setAttribute("suc", "");
go("/admin/yprk.jsp", request, response);
}
if(ac.equals("export")){
String sql = "select * from zd where fkstatus='已付款' ";
sql += "order by ghno desc";
ArrayList<HashMap> list = (ArrayList)dao.select(sql);
List<List> rlist ?= new ArrayList(); DecimalFormat decimal = new DecimalFormat("#.#"); for(HashMap map:list)
? ?{
HashMap am = dao.select("select * from ghinfo where ghno='"+map.get("ghno")+"'").get(0); HashMap mstu = dao.select("select * from zd where ghno='"+map.get("ghno")+"'").get(0); String info = mstu.get("info").toString(); String numinfo = mstu.get("numinfo").toString(); String yinfo = "";
String a[] = info.split("\\$");
String b[] = numinfo.split("\\$"); for(int i=0;i<a.length;i++){
yinfo += a[i]+" 數(shù)量:"+b[i]+"<br/>";
} List mlist ?= new ArrayList();
mlist.add(map.get("ghno"));
mlist.add(am.get("tname"));
mlist.add(am.get("sex"));
mlist.add(am.get("age"));
mlist.add(mstu.get("bq"));
mlist.add(mstu.get("zd"));
mlist.add(yinfo);
mlist.add(decimal.format(Double.valueOf(map.get("totalprice").toString()))+"元");
mlist.add(map.get("sfoper"));
mlist.add(map.get("sfsavetime"));
rlist.add(mlist);
? ?} //String[] pros = {"掛號(hào)編號(hào)","患者姓名","收費(fèi)金額","收費(fèi)人","收費(fèi)時(shí)間"};
String[] pros = {"掛號(hào)編號(hào)","患者姓名","性別","年齡","病情","診斷","藥品處置","收費(fèi)金額","收費(fèi)人","收費(fèi)時(shí)間"};
Info.writeExcel(request.getRealPath("/upfile/")+"/sfexport.xls", pros, rlist, request, response);
}
if(ac.equals("ghexport")){
String sql = "select * from ghinfo where 1=1 and delstatus='0'";
sql += "order by id desc";
ArrayList<HashMap> list = (ArrayList)dao.select(sql);
List<List> rlist ?= new ArrayList(); DecimalFormat decimal = new DecimalFormat("#.#"); for(HashMap map:list)
? ?{ List mlist ?= new ArrayList();
mlist.add(map.get("ghno"));
mlist.add(decimal.format(Double.valueOf(map.get("price").toString()))+"元"); HashMap dm = dao.select("select * from dept where id="+map.get("ghdept")).get(0);
mlist.add(dm.get("deptname"));
mlist.add(map.get("oper"));
mlist.add(map.get("savetime"));
rlist.add(mlist);
? ?}
String[] pros = {"掛號(hào)編號(hào)","掛號(hào)金額","掛號(hào)科室","操作人","操作時(shí)間"};
Info.writeExcel(request.getRealPath("/upfile/")+"/ghexport.xls", pros, rlist, request, response);
}
if(ac.equals("test")){ String str = request.getParameter("str"); String sql = "select * from sysuser where uname like '%"+str+"%' or tname like '%"+str+"%' "; if(str.equals("")){
sql = "select * from sysuser";
}
System.out.println(sql); String returnStr = "";
ArrayList<HashMap> list = (ArrayList<HashMap> )dao.select(sql);
System.out.println("aa-="+list.size()); if(list.size()!=0){ for(HashMap map:list){
returnStr += ?map.get("uname")+"-"+map.get("tname")+"$";
}
out.println(returnStr); ?
}else{
out.println(""); ?
}
} if(ac.equals("testadd")){ String Hidden1 = request.getParameter("Hidden1"); //String str[] = Hidden1.split("\\$");
String cfno = "czd001"; //for(int i=0;i<str.length;i++){
// System.out.println("aaa="+str[i]);
//}
System.out.println("Hidden1=="+Hidden1); String sql = "update czd set info='"+Hidden1+"' where cfno='"+cfno+"' ";
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/testadd1.jsp?cfno="+cfno, request, response);
} //自動(dòng)補(bǔ)全藥品
if(ac.equals("ajaxsearch")){ String str = request.getParameter("str");
System.out.println("aaaaaaaaaaaa=="+str); String sql = "select * from ypcf where (yno like '%"+str+"%' or yname like '%"+str+"%') and delstatus='0' ?"; if(str.equals("")){
sql = "select * from ypcf";
}
System.out.println(sql); String returnStr = "";
ArrayList<HashMap> list = (ArrayList<HashMap> )dao.select(sql);
System.out.println("aa-="+list.size()); if(list.size()!=0){ for(HashMap map:list){
returnStr += ?map.get("yno")+"-"+map.get("yname")+"-"+map.get("price")+"元$";
}
out.println(returnStr); ?
}else{
out.println(""); ?
}
} //問(wèn)診添加
if(ac.equals("wzadd")){ String ghno = request.getParameter("ghno"); String bq = request.getParameter("bq"); String zd = request.getParameter("zd"); String info = request.getParameter("Hidden1"); String numinfo = request.getParameter("Hidden2"); String oper = admin.get("uname").toString(); String savetime = Info.getDateStr(); String qystatus = "未取藥"; String fkstatus = "未付款";
dao.commOper("update ghinfo set status='已問(wèn)診' where ghno='"+ghno+"'"); String sql = "insert into zd (ghno,bq,zd,info,numinfo,oper,savetime,qystatus,fkstatus) values" + " ('"+ghno+"','"+bq+"','"+zd+"','"+info+"','"+numinfo+"','"+oper+"','"+savetime+"','"+qystatus+"','"+fkstatus+"') ";
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/brwz.jsp?ghno="+ghno, request, response);
}
//修改問(wèn)診
if(ac.equals("wzedit")){ String ghno = request.getParameter("ghno"); String bq = request.getParameter("bq"); String zd = request.getParameter("zd"); String info = request.getParameter("Hidden1"); String numinfo = request.getParameter("Hidden2");
System.out.println("numinfo=="+numinfo); String sql = "update zd set bq='"+bq+"',zd='"+zd+"',info='"+info+"',numinfo='"+numinfo+"' where ghno='"+ghno+"'";
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/brwzedit.jsp?ghno="+ghno, request, response);
} //取藥
if(ac.equals("qy")){ String ghno = request.getParameter("ghno"); HashMap zdm = dao.select("select * from zd where ghno='"+ghno+"'").get(0); String yinfo = zdm.get("info").toString(); String numinfo = zdm.get("numinfo").toString();
String a[] = yinfo.split("\\$");
String b[] = numinfo.split("\\$"); String is = "yes"; int m = 0; for(int i=0;i<a.length;i++){
String ynos[] = a[i].split("\\-"); ArrayList amlist = (ArrayList)dao.select("select * from ypcf where yno='"+ynos[0]+"' and type='藥品' "); if(amlist.size()!=0){ HashMap am = dao.select("select * from ypcf where yno='"+ynos[0]+"' and type='藥品' ").get(0); String yno = am.get("yno").toString();//藥品編號(hào)
int num = Integer.parseInt(b[i]);//購(gòu)買(mǎi)藥品數(shù)量
//查藥品數(shù)量
HashMap inmap = dao.select("select sum(num) as innum from kcrecord where type='in' and yno='"+ynos[0]+"' ").get(0); HashMap outmap = dao.select("select sum(num) as outnum from kcrecord where type='out' and yno='"+ynos[0]+"' ").get(0); int innum = 0; int outnum = 0; if(inmap.get("innum")!=null){
innum = Integer.parseInt(inmap.get("innum").toString());
}if(outmap.get("outnum")!=null){
outnum =Integer.parseInt(outmap.get("outnum").toString());
} int kc = innum-outnum; if(num>kc){
m++;
} //
}
} if(m==0){ for(int i=0;i<a.length;i++){
String ynos[] = a[i].split("\\-"); ArrayList amlist = (ArrayList)dao.select("select * from ypcf where yno='"+ynos[0]+"' and type='藥品' "); if(amlist.size()!=0){ HashMap am = dao.select("select * from ypcf where yno='"+ynos[0]+"' and type='藥品' ").get(0); String yno = am.get("yno").toString();//藥品編號(hào)
int num = Integer.parseInt(b[i]);//購(gòu)買(mǎi)藥品數(shù)量
//查藥品數(shù)量
HashMap inmap = dao.select("select sum(num) as innum from kcrecord where type='in' and yno='"+ynos[0]+"' ").get(0); HashMap outmap = dao.select("select sum(num) as outnum from kcrecord where type='out' and yno='"+ynos[0]+"' ").get(0); int innum = 0; int outnum = 0; if(inmap.get("innum")!=null){
innum = Integer.parseInt(inmap.get("innum").toString());
}if(outmap.get("outnum")!=null){
outnum =Integer.parseInt(outmap.get("outnum").toString());
} int kc = innum-outnum;
dao.commOper("insert into kcrecord (yno,num,type,savetime,oper) values ('"+yno+"','"+num+"','out','"+Info.getDateStr()+"','"+admin.get("uname")+"') ");
}
}
dao.commOper("update zd set fyoper='"+admin.get("uname")+"',fysavetime='"+Info.getDateStr()+"',qystatus='已取藥' ?where ghno='"+ghno+"'");
request.setAttribute("suc", "");
go("/admin/dfy.jsp", request, response);
}else{
request.setAttribute("no", "");
go("/admin/dfy.jsp", request, response);
}
}
//注冊(cè)
if(ac.equals("regedit")){
System.out.println("123123"); String uname = request.getParameter("uname"); String upass = request.getParameter("upass"); String tname = request.getParameter("tname"); String sex = request.getParameter("sex"); String age = request.getParameter("age"); String idcard = request.getParameter("idcard"); String tel = request.getParameter("tel"); String addr = request.getParameter("addr"); String delstatus = "0"; ArrayList cklist = (ArrayList)dao.select("select * from patient where delstatus='0' and uname='"+uname+"' "); if(cklist.size()>0){
request.setAttribute("no", "");
}else{
dao.commOper("insert into patient (uname,upass,tname,sex,age,idcard,tel,addr,delstatus) values " + "('"+uname+"','"+upass+"','"+tname+"','"+sex+"','"+age+"','"+idcard+"','"+tel+"','"+addr+"','"+delstatus+"') ");
request.setAttribute("suc", "");
go("/regedit.jsp", request, response);
}
} //患者修改個(gè)人信息
if(ac.equals("userinfo")){ String id = request.getParameter("id"); String upass = request.getParameter("upass"); String tname = request.getParameter("tname"); String sex = request.getParameter("sex"); String age = request.getParameter("age"); String idcard = request.getParameter("idcard"); String tel = request.getParameter("tel"); String addr = request.getParameter("addr");
dao.commOper("update patient set upass='"+upass+"',tname='"+tname+"',sex='"+sex+"',age='"+age+"'," + " idcard='"+idcard+"',tel='"+tel+"',addr='"+addr+"' where id="+id);
request.setAttribute("suc", "");
go("/userinfo.jsp", request, response);
}
//用戶(hù)登陸
if(ac.equals("plogin")){ String uname = request.getParameter("uname"); String upass = request.getParameter("upass"); ArrayList list = (ArrayList)dao.select("select * from patient where uname='"+uname+"' and upass='"+upass+"' and delstatus='0' "); if(list.size()==1)
? ? {
? ? session.setAttribute("user", list.get(0));
? ? request.setAttribute("suc", "");
? ? gor("index.jsp", request, response);
? ? }else{
? ? request.setAttribute("no", "");
? ? go("index.jsp", request, response);
? ? }
}
//預(yù)約
if(ac.equals("yy")){ String uid = user.get("id").toString(); String ?type = request.getParameter("type"); String ?dept = request.getParameter("id"); String savetime = Info.getDateStr();
dao.commOper("insert into yy (uid,type,dept,ghno,savetime) values ('"+uid+"','"+type+"','"+dept+"','','"+savetime+"') ");
request.setAttribute("suc", "");
? ? go("yy.jsp?id="+dept, request, response);
} //掛號(hào)受理
if(ac.equals("yysl")){
System.out.println("aa"); String id = request.getParameter("id"); HashMap map = dao.select("select * from yy where id="+id).get(0); HashMap mm = dao.select("select * from patient where id="+map.get("uid")).get(0); String ghno = Info.AutoID(); String tname = mm.get("tname").toString(); String sex = mm.get("sex").toString(); String age = mm.get("age").toString(); String idcard = mm.get("idcard").toString(); String tel = ?mm.get("tel").toString(); String addr = ?mm.get("addr").toString(); String ghdept = map.get("dept").toString(); String price = map.get("type").toString(); String status = "待問(wèn)診";
String delstatus = "0"; String oper = "網(wǎng)上預(yù)約"; String savetime = Info.getDateStr();
dao.commOper("update yy set ghno ='"+ghno+"' where id="+id);
dao.commOper("insert into ghinfo (ghno,tname,sex,age,idcard,tel,addr,ghdept,price,status,delstatus,oper,savetime) " + " values('"+ghno+"','"+tname+"','"+sex+"','"+age+"','"+idcard+"','"+tel+"','"+addr+"','"+ghdept+"','"+price+"','"+status+"','"+delstatus+"','"+oper+"','"+savetime+"') ?");
request.setAttribute("suc", "");
? ? go("admin/yy.jsp", request, response);
} //前臺(tái)退出
if(ac.equals("frontexit")){
session.removeAttribute("user");
go("index.jsp", request, response);
}
//添加公告
if(ac.equals("noticeadd")){ String title = request.getParameter("title"); String note = request.getParameter("note"); String savetime = Info.getDateStr(); String sql = "insert into notice (title,note,savetime) values('"+title+"','"+note+"','"+savetime+"')";
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/noticeadd.jsp", request, response);
} //修改公告
if(ac.equals("noticeedit")){ String id = request.getParameter("id"); String title = request.getParameter("title"); String note = request.getParameter("note"); String sql = "update notice set title='"+title+"',note='"+note+"' where id= "+id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/noticeadd.jsp", request, response);
}
//添加留言
if(ac.equals("chatadd")){ String msg = request.getParameter("msg"); String hfmsg = ""; String savetime = Info.getDateStr(); String uid = user.get("id").toString(); String sql = "insert into chat (msg,hfmsg,savetime,uid) values('"+msg+"','"+hfmsg+"','"+savetime+"','"+uid+"')";
dao.commOper(sql);
request.setAttribute("suc", "");
go("chat.jsp", request, response);
} //回復(fù)留言
if(ac.equals("chathf")){ String id = request.getParameter("id"); String hfmsg = request.getParameter("hfmsg"); String sql = "update chat set hfmsg='"+hfmsg+"' where id= "+id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/chathf.jsp?id="+id, request, response);
}
?
dao.close();
out.flush();
out.close();
} public void init() throws ServletException { // Put your code here
}
}
