目录
1 效果展示
2 数据实体
3 功能说明
包含医生 和管理员两种角色,对随访信息,科室,病房,病人患者等信息进行管理
4 部分代码
package com.action;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
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 javax.servlet.http.HttpSession;
import org.directwebremoting.WebContext;
import org.directwebremoting.WebContextFactory;
import com.dao.DB;
import com.orm.Yisheng;
public class yisheng_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("yishengAdd"))
{
yishengAdd(req, res);
}
if(type.endsWith("yishengMana"))
{
yishengMana(req, res);
}
if(type.endsWith("yishengDel"))
{
yishengDel(req, res);
}
if(type.endsWith("yishengEdit"))
{
yishengEdit(req, res);
}
if(type.endsWith("yishengSearch"))
{
yishengSearch(req, res);
}
if(type.endsWith("yishengSearch_bianhao"))
{
yishengSearch_bianhao(req, res);
}
if(type.endsWith("yishengQuanxian"))
{
yishengQuanxian(req, res);
}
}
public void yishengAdd(HttpServletRequest req,HttpServletResponse res)
{
String bianhao=req.getParameter("bianhao");
String name=req.getParameter("name");
String sex=req.getParameter("sex");
String age=req.getParameter("age");
String tel=req.getParameter("tel");
String address=req.getParameter("address");
String zhiwei=req.getParameter("zhiwei");
String card=req.getParameter("card");
String keshi=req.getParameter("keshi");
int ruzhinianfei=Integer.parseInt(req.getParameter("ruzhinianfei"));
String sql="insert into t_yisheng values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
Object[] params={null,bianhao,name,sex,age,tel,address,zhiwei,card,ruzhinianfei,0,"","","no",keshi};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "yisheng?type=yishengMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void yishengEdit(HttpServletRequest req,HttpServletResponse res)
{
String bianhao=req.getParameter("bianhao");
String name=req.getParameter("name");
String sex=req.getParameter("sex");
String age=req.getParameter("age");
String tel=req.getParameter("tel");
String address=req.getParameter("address");
String zhiwei=req.getParameter("zhiwei");
String card=req.getParameter("card");
String keshi=req.getParameter("keshi");
String my=req.getParameter("my");
int ruzhinianfei=Integer.parseInt(req.getParameter("ruzhinianfei"));
String sql="update t_yisheng set keshi='"+keshi+"', bianhao='"+bianhao+"',card='"+card+"',ruzhinianfei='"+ruzhinianfei+"', name='"+name+"',sex='"+sex+"',age='"+age+"',tel='"+tel+"',address='"+address+"',zhiwei='"+zhiwei+"' where id="+Integer.parseInt(req.getParameter("id"));
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
if(my==null){
req.setAttribute("message", "操作成功");
req.setAttribute("path", "yisheng?type=yishengMana");
} else {
req.getSession().removeAttribute("yisheng");
Yisheng yisheng=new Yisheng();
yisheng.setId(Integer.parseInt(req.getParameter("id")));
yisheng.setBianhao(bianhao);
yisheng.setKeshi(keshi);
yisheng.setName(name);
yisheng.setSex(sex);
yisheng.setAge(age);
yisheng.setTel(tel);
yisheng.setAddress(address);
yisheng.setZhiwei(zhiwei);
yisheng.setQuanxian(1);
yisheng.setLoginName((String)req.getSession().getAttribute("loginName"));
yisheng.setLoginPw((String)req.getSession().getAttribute("loginPw"));
yisheng.setCard(card);
req.getSession().setAttribute("yisheng",yisheng);
// WebContext ctx = WebContextFactory.get();
// HttpSession session=ctx.getSession();
// session.setAttribute("yisheng", yisheng);
req.setAttribute("message", "操作成功");
req.setAttribute("path", "admin/yisheng/yishengEditMy.jsp");
}
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void yishengDel(HttpServletRequest req,HttpServletResponse res)
{
int id=Integer.parseInt(req.getParameter("id"));
String sql="update t_yisheng set del=? where id=?";
Object[] params={"yes",id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "yisheng?type=yishengMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void yishengMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String id=req.getParameter("yishengId");
String page1=req.getParameter("page");
if(page1==null){
page1="1";
}
//分页设置
int EVERYPAGENUM=10;//每页条数
int page=Integer.parseInt(page1); //传递过来的当前页
int cou = 1;//得到信息总数
int pagecount=1; //总页数
String sql1="select count(*) as cou from t_yisheng where del='no'";
if(id!=null)sql1+=" and id="+id;
Object[] params1={};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
cou= rs.getInt("cou");
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb1.closed();
if (cou % EVERYPAGENUM == 0) {
pagecount= cou / EVERYPAGENUM;
} else {
pagecount=cou / EVERYPAGENUM + 1;
}
req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
req.setAttribute("page", page);
req.setAttribute("cou", cou);
req.setAttribute("pagecount", pagecount);
List yishengList=new ArrayList();
String sql="select * from t_yisheng where del='no'";
if(id!=null)sql+=" and id="+id;
sql1+=" order by bianhao desc";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
Yisheng yisheng=new Yisheng();
yisheng.setId(rs.getInt("id"));
yisheng.setBianhao(rs.getString("bianhao"));
yisheng.setName(rs.getString("name"));
yisheng.setSex(rs.getString("sex"));
yisheng.setAge(rs.getString("age"));
yisheng.setTel(rs.getString("tel"));
yisheng.setAddress(rs.getString("address"));
yisheng.setZhiwei(rs.getString("zhiwei"));
yisheng.setCard(rs.getString("card"));
yisheng.setRuzhinianfei(rs.getInt("ruzhinianfei"));
yisheng.setGongling(new Date().getYear()+1900-rs.getInt("ruzhinianfei"));
yisheng.setQuanxian(rs.getInt("quanxian"));
yisheng.setLoginName(rs.getString("loginName"));
yisheng.setLoginPw(rs.getString("loginPw"));
yisheng.setKeshi(rs.getString("keshi"));
yishengList.add(yisheng);
} else {
break; //减少空循环的时间
}
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("yishengList", yishengList);
req.getRequestDispatcher("admin/yisheng/yishengMana.jsp").forward(req, res);
}
public void yishengSearch(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String name=req.getParameter("name");
String page1=req.getParameter("page");
if(page1==null){
page1="1";
}
//分页设置
int EVERYPAGENUM=10;//每页条数
int page=Integer.parseInt(page1); //传递过来的当前页
int cou = 1;//得到信息总数
int pagecount=1; //总页数
String sql1="select count(*) as cou from t_yisheng where del='no' and name like '%"+name.trim()+"%'";
Object[] params1={};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
cou= rs.getInt("cou");
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb1.closed();
if (cou % EVERYPAGENUM == 0) {
pagecount= cou / EVERYPAGENUM;
} else {
pagecount=cou / EVERYPAGENUM + 1;
}
req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
req.setAttribute("page", page);
req.setAttribute("cou", cou);
req.setAttribute("pagecount", pagecount);
List yishengList=new ArrayList();
String sql="select * from t_yisheng where del='no' and name like '%"+name.trim()+"%'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
Yisheng yisheng=new Yisheng();
yisheng.setId(rs.getInt("id"));
yisheng.setBianhao(rs.getString("bianhao"));
yisheng.setName(rs.getString("name"));
yisheng.setSex(rs.getString("sex"));
yisheng.setAge(rs.getString("age"));
yisheng.setTel(rs.getString("tel"));
yisheng.setAddress(rs.getString("address"));
yisheng.setZhiwei(rs.getString("zhiwei"));
yisheng.setRuzhinianfei(rs.getInt("ruzhinianfei"));
yisheng.setCard(rs.getString("card"));
yisheng.setGongling(new Date().getYear()+1900-rs.getInt("ruzhinianfei"));
yisheng.setQuanxian(rs.getInt("quanxian"));
yisheng.setLoginName(rs.getString("loginName"));
yisheng.setLoginPw(rs.getString("loginPw"));
yisheng.setKeshi(rs.getString("keshi"));
yishengList.add(yisheng);
} else {
break; //减少空循环的时间
}
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("yishengList", yishengList);
req.getRequestDispatcher("admin/yisheng/yishengMana.jsp").forward(req, res);
}
public void yishengSearch_bianhao(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String bianhao=req.getParameter("bianhao");
String page1=req.getParameter("page");
if(page1==null){
page1="1";
}
//分页设置
int EVERYPAGENUM=10;//每页条数
int page=Integer.parseInt(page1); //传递过来的当前页
int cou = 1;//得到信息总数
int pagecount=1; //总页数
String sql1="select count(*) as cou from t_yisheng where del='no' and bianhao like '%"+bianhao.trim()+"%'";
Object[] params1={};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
cou= rs.getInt("cou");
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb1.closed();
if (cou % EVERYPAGENUM == 0) {
pagecount= cou / EVERYPAGENUM;
} else {
pagecount=cou / EVERYPAGENUM + 1;
}
req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
req.setAttribute("page", page);
req.setAttribute("cou", cou);
req.setAttribute("pagecount", pagecount);
List yishengList=new ArrayList();
String sql="select * from t_yisheng where del='no' and bianhao like '%"+bianhao.trim()+"%'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
Yisheng yisheng=new Yisheng();
yisheng.setId(rs.getInt("id"));
yisheng.setBianhao(rs.getString("bianhao"));
yisheng.setName(rs.getString("name"));
yisheng.setSex(rs.getString("sex"));
yisheng.setAge(rs.getString("age"));
yisheng.setTel(rs.getString("tel"));
yisheng.setAddress(rs.getString("address"));
yisheng.setZhiwei(rs.getString("zhiwei"));
yisheng.setRuzhinianfei(rs.getInt("ruzhinianfei"));
yisheng.setCard(rs.getString("card"));
yisheng.setGongling(new Date().getYear()+1900-rs.getInt("ruzhinianfei"));
yisheng.setQuanxian(rs.getInt("quanxian"));
yisheng.setLoginName(rs.getString("loginName"));
yisheng.setLoginPw(rs.getString("loginPw"));
yisheng.setKeshi(rs.getString("keshi"));
yishengList.add(yisheng);
} else {
break; //减少空循环的时间
}
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("yishengList", yishengList);
req.getRequestDispatcher("admin/yisheng/yishengMana.jsp").forward(req, res);
}
public void yishengQuanxian(HttpServletRequest req,HttpServletResponse res)
{
int id=Integer.parseInt(req.getParameter("id"));
int quanxian=Integer.parseInt(req.getParameter("quanxian"));
String loginName=req.getParameter("loginName");
String loginPw=req.getParameter("loginPw");
String sql="update t_yisheng set quanxian=?,loginName=?,loginPw=? where id="+id;
Object[] params={quanxian,loginName,loginPw};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "yisheng?type=yishengMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}