package com.action;
import java.util.List;
import java.util.Map;
import org.apache.struts2.ServletActionContext;
import com.dao.TUserDAO;
import com.model.TUser;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
public class UserAction extends ActionSupport
{
    private int userId;
  private String userName;
  private String userPw;
  private String userRealname;
  private String userAddress;
  private String userTel;
  private String userEmail;
  private String userDel;
  private String message;
  private String path;
  private TUserDAO userDAO;
  public String userReg()
  {
    TUser user=new TUser();
    user.setUserName(userName);
    user.setUserPw(userPw);
    user.setUserAddress(userAddress);
    user.setUserTel(userTel);
    user.setUserRealname(userRealname);
    user.setUserEmail(userEmail);
    user.setUserDel("no");
    userDAO.save(user);
    this.setMessage("注册成功，请登录");
    this.setPath("qiantai/default.jsp");
    return "succeed";
  }
  public String userLogin()
  {
    String sql="from TUser where userName=? and userPw=? and userDel='no'";
    Object[] con={userName,userPw};
    List userList=userDAO.getHibernateTemplate().find(sql,con);
    System.out.println(userList.size()+"%%");
    if(userList.size()==0)
    {
      this.setMessage("用户名或密码错误");
      this.setPath("qiantai/default.jsp");
    }
    else
    {
       Map session= ServletActionContext.getContext().getSession();
       TUser user=(TUser)userList.get(0);
       session.put("user", user);
       session.put("userType", 2);
       this.setMessage("成功登录");
       this.setPath("qiantai/default.jsp");
    }
    return "succeed";
  }
  public String userLogout()
  {
    Map session= ServletActionContext.getContext().getSession();
    session.put("user", null);
    session.put("userType", null);
    this.setMessage("安全退出系统");
    this.setPath("qiantai/default.jsp");
    return "succeed";
  }
  public String userEdit()
  {
    TUser user=userDAO.findById(userId);
    user.setUserName(userName);
    user.setUserPw(userPw);
    user.setUserAddress(userAddress);
    user.setUserTel(userTel);
    user.setUserRealname(userRealname);
    user.setUserEmail(userEmail);
    user.setUserDel("no");
    userDAO.attachDirty(user);
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("msg", "修改成功,重新登陆后生效");
    return "msg";
  }
  public String userMana()
  {
    String sql="from TUser where userDel='no'";
    List userList=userDAO.getHibernateTemplate().find(sql);
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("userList", userList);
    return ActionSupport.SUCCESS;
  }
  public String userDel()
  {
    TUser user=userDAO.findById(userId);
    user.setUserDel("yes");
    userDAO.attachDirty(user);
    this.setMessage("删除成功");
    this.setPath("userMana.action");
    return "succeed";
  }
  public int getUserId()
  {
    return userId;
  }
  public void setUserId(int userId)
  {
    this.userId = userId;
  }
  public String getUserName()
  {
    return userName;
  }
  public void setUserName(String userName)
  {
    this.userName = userName;
  }
  public String getUserPw()
  {
    return userPw;
  }
  public void setUserPw(String userPw)
  {
    this.userPw = userPw;
  }
  public String getUserRealname()
  {
    return userRealname;
  }
  public void setUserRealname(String userRealname)
  {
    this.userRealname = userRealname;
  }
  public String getUserAddress()
  {
    return userAddress;
  }
  public void setUserAddress(String userAddress)
  {
    this.userAddress = userAddress;
  }
  public String getUserTel()
  {
    return userTel;
  }
  public void setUserTel(String userTel)
  {
    this.userTel = userTel;
  }
  public String getUserEmail()
  {
    return userEmail;
  }
  public void setUserEmail(String userEmail)
  {
    this.userEmail = userEmail;
  }
  public String getUserDel()
  {
    return userDel;
  }
  public void setUserDel(String userDel)
  {
    this.userDel = userDel;
  }
  public String getMessage()
  {
    return message;
  }
  public void setMessage(String message)
  {
    this.message = message;
  }
  public String getPath()
  {
    return path;
  }
  public void setPath(String path)
  {
    this.path = path;
  }
  public TUserDAO getUserDAO()
  {
    return userDAO;
  }
  public void setUserDAO(TUserDAO userDAO)
  {
    this.userDAO = userDAO;
  }
}

package com.action;
import java.util.List;
import java.util.Map;
import org.apache.struts2.ServletActionContext;
import com.dao.TYiyuanDAO;
import com.dao.TZhuanjiaDAO;
import com.model.TYiyuan;
import com.opensymphony.xwork2.ActionSupport;
public class yiyuanAction extends ActionSupport
{
  private Integer id;
  private String mingcheng;
  private String dizhi;
  private String dianhua;
  private String del;
  private String message;
  private String path;
  private TYiyuanDAO yiyuanDAO;
  public String yiyuanAdd()
  {
    TYiyuan yiyuan=new TYiyuan();
    yiyuan.setMingcheng(mingcheng);
    yiyuan.setDizhi(dizhi);
    yiyuan.setDianhua(dianhua);
    yiyuan.setDel("no");
    yiyuanDAO.save(yiyuan);
    this.setMessage("操作成功");
    this.setPath("yiyuanMana.action");
    return "succeed";
  }
  public String yiyuanMana()
  {
    String sql="from TYiyuan where del='no'";
    List yiyuanList=yiyuanDAO.getHibernateTemplate().find(sql);
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("yiyuanList", yiyuanList);
    return ActionSupport.SUCCESS;
  }
  public String yiyuanDel()
  {
    TYiyuan yiyuan=yiyuanDAO.findById(id);
    yiyuan.setDel("yes");
    yiyuanDAO.attachDirty(yiyuan);
    this.setMessage("操作成功");
    this.setPath("yiyuanMana.action");
    return "succeed";
  }
  public String yiyuanAll()
  {
    String sql="from TYiyuan where del='no'";
    List yiyuanList=yiyuanDAO.getHibernateTemplate().find(sql);
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("yiyuanList", yiyuanList);
    return ActionSupport.SUCCESS;
  }
  public Integer getId()
  {
    return id;
  }
  public void setId(Integer id)
  {
    this.id = id;
  }
  public String getMingcheng()
  {
    return mingcheng;
  }
  public void setMingcheng(String mingcheng)
  {
    this.mingcheng = mingcheng;
  }
  public String getDizhi()
  {
    return dizhi;
  }
  public void setDizhi(String dizhi)
  {
    this.dizhi = dizhi;
  }
  public String getDianhua()
  {
    return dianhua;
  }
  public void setDianhua(String dianhua)
  {
    this.dianhua = dianhua;
  }
  public String getDel()
  {
    return del;
  }
  public void setDel(String del)
  {
    this.del = del;
  }
  public String getMessage()
  {
    return message;
  }
  public void setMessage(String message)
  {
    this.message = message;
  }
  public String getPath()
  {
    return path;
  }
  public void setPath(String path)
  {
    this.path = path;
  }
  public TYiyuanDAO getYiyuanDAO()
  {
    return yiyuanDAO;
  }
  public void setYiyuanDAO(TYiyuanDAO yiyuanDAO)
  {
    this.yiyuanDAO = yiyuanDAO;
  }
}

package com.action;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
import com.dao.TKeshiDAO;
import com.dao.TYiyuanDAO;
import com.dao.TZhuanjiaDAO;
import com.model.TZhuanjia;
import com.opensymphony.xwork2.ActionSupport;
public class zhuanjiaAction extends ActionSupport
{
  private Integer id;
  private int yiyuanId;
  private int keshiId;
  private String xingming;
  private String xingbie;
  private Integer nianling;
  private String shanchang;
  private String leixing;//专家门诊--普通门诊
  private String fujian;
  private String del;
  private TZhuanjiaDAO zhuanjiaDAO;
  private TKeshiDAO keshiDAO;
  private TYiyuanDAO yiyuanDAO;
  public String zhuanjiaAdd()
  {
    TZhuanjia zhuanjia=new TZhuanjia();
    //zhuanjia.setId(0);]
    zhuanjia.setYiyuanId(yiyuanId);
    zhuanjia.setKeshiId(keshiId);
    zhuanjia.setXingming(xingming);
    zhuanjia.setXingbie(xingbie);
    zhuanjia.setNianling(nianling);
    zhuanjia.setShanchang(shanchang);
    zhuanjia.setLeixing(leixing);
    zhuanjia.setFujian(fujian);
    zhuanjia.setDel("no");
    zhuanjiaDAO.save(zhuanjia);
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("msg", "信息添加完毕");
    return "msg";
  }
  public String zhuanjiaMana()
  {
    String sql="from TZhuanjia where del='no' order by yiyuanId,keshiId";
    List zhuanjiaList =zhuanjiaDAO.getHibernateTemplate().find(sql);
    for(int i=0;i<zhuanjiaList.size();i++)
    {
      TZhuanjia zhuanjia=(TZhuanjia)zhuanjiaList.get(i);
      zhuanjia.setKeshi(keshiDAO.findById(zhuanjia.getKeshiId()));
      zhuanjia.setYiyuan(yiyuanDAO.findById(zhuanjia.getYiyuanId()));
    }
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("zhuanjiaList", zhuanjiaList);
    return ActionSupport.SUCCESS;
  }
  public String zhuanjiaDel()
  {   
    String sql="update TZhuanjia set del='yes' where id="+id;
    zhuanjiaDAO.getHibernateTemplate().bulkUpdate(sql);
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("msg", "信息删除完毕");
    return "msg";
  }
  public String zhuanjiaAllByYiyuan()
  {
    String sql="from TZhuanjia where del='no' and yiyuanId="+yiyuanId;
    List zhuanjiaList =zhuanjiaDAO.getHibernateTemplate().find(sql);
    for(int i=0;i<zhuanjiaList.size();i++)
    {
      TZhuanjia zhuanjia=(TZhuanjia)zhuanjiaList.get(i);
      zhuanjia.setKeshi(keshiDAO.findById(zhuanjia.getKeshiId()));
      zhuanjia.setYiyuan(yiyuanDAO.findById(zhuanjia.getYiyuanId()));
    }
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("zhuanjiaList", zhuanjiaList);
    return ActionSupport.SUCCESS;
  }
  public String zhuanjiaDetailQian()
  {
    TZhuanjia zhuanjia=zhuanjiaDAO.findById(id);
    zhuanjia.setKeshi(keshiDAO.findById(zhuanjia.getKeshiId()));
    zhuanjia.setYiyuan(yiyuanDAO.findById(zhuanjia.getYiyuanId()));
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("zhuanjia", zhuanjia);
    return ActionSupport.SUCCESS;
  }
  public String zhuanjiaRes()
  {
    StringBuffer sql=new StringBuffer("from TZhuanjia where del='no' and yiyuanId="+yiyuanId);
    sql.append(" and keshiId="+keshiId);
    sql.append(" and leixing like '%"+leixing.trim()+"%'");
    sql.append(" and xingming like '%"+xingming.trim()+"%'");
    List zhuanjiaList =zhuanjiaDAO.getHibernateTemplate().find(sql.toString());
    for(int i=0;i<zhuanjiaList.size();i++)
    {
      TZhuanjia zhuanjia=(TZhuanjia)zhuanjiaList.get(i);
      zhuanjia.setKeshi(keshiDAO.findById(zhuanjia.getKeshiId()));
      zhuanjia.setYiyuan(yiyuanDAO.findById(zhuanjia.getYiyuanId()));
    }
    Map request=(Map)ServletActionContext.getContext().get("request");
    request.put("zhuanjiaList", zhuanjiaList);
    return ActionSupport.SUCCESS;
  }
  public Integer getId()
  {
    return id;
  }
  public void setId(Integer id)
  {
    this.id = id;
  }
  public int getYiyuanId()
  {
    return yiyuanId;
  }
  public void setYiyuanId(int yiyuanId)
  {
    this.yiyuanId = yiyuanId;
  }
  public int getKeshiId()
  {
    return keshiId;
  }
  public void setKeshiId(int keshiId)
  {
    this.keshiId = keshiId;
  }
  public String getXingming()
  {
    return xingming;
  }
  public void setXingming(String xingming)
  {
    this.xingming = xingming;
  }
  public String getXingbie()
  {
    return xingbie;
  }
  public void setXingbie(String xingbie)
  {
    this.xingbie = xingbie;
  }
  public Integer getNianling()
  {
    return nianling;
  }
  public void setNianling(Integer nianling)
  {
    this.nianling = nianling;
  }
  public String getShanchang()
  {
    return shanchang;
  }
  public void setShanchang(String shanchang)
  {
    this.shanchang = shanchang;
  }
  public String getLeixing()
  {
    return leixing;
  }
  public void setLeixing(String leixing)
  {
    this.leixing = leixing;
  }
  public String getFujian()
  {
    return fujian;
  }
  public void setFujian(String fujian)
  {
    this.fujian = fujian;
  }
  public String getDel()
  {
    return del;
  }
  public void setDel(String del)
  {
    this.del = del;
  }
  public TZhuanjiaDAO getZhuanjiaDAO()
  {
    return zhuanjiaDAO;
  }
  public void setZhuanjiaDAO(TZhuanjiaDAO zhuanjiaDAO)
  {
    this.zhuanjiaDAO = zhuanjiaDAO;
  }
  public TKeshiDAO getKeshiDAO()
  {
    return keshiDAO;
  }
  public void setKeshiDAO(TKeshiDAO keshiDAO)
  {
    this.keshiDAO = keshiDAO;
  }
  public TYiyuanDAO getYiyuanDAO()
  {
    return yiyuanDAO;
  }
  public void setYiyuanDAO(TYiyuanDAO yiyuanDAO)
  {
    this.yiyuanDAO = yiyuanDAO;
  }
}