CREATE TABLE t_admin
(id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘管理员id’,username
varchar(255) DEFAULT NULL COMMENT ‘账号’,password
varchar(255) DEFAULT NULL COMMENT ‘密码’,PRIMARY KEY (id
)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT=‘管理员’;
DROP TABLE IF EXISTS t_bingren
;
CREATE TABLE t_bingren
(id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘病人id’,username
varchar(255) DEFAULT NULL COMMENT ‘账号’,password
varchar(255) DEFAULT NULL COMMENT ‘密码’,mingzi
varchar(255) DEFAULT NULL COMMENT ‘名字’,PRIMARY KEY (id
)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT=‘病人’;
DROP TABLE IF EXISTS t_bingli
;
CREATE TABLE t_bingli
(id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘病历id’,biaoti
varchar(255) DEFAULT NULL COMMENT ‘标题’,neirong
varchar(500) DEFAULT NULL COMMENT ‘内容’,shijian
varchar(255) DEFAULT NULL COMMENT ‘时间’,yisheng
varchar(255) DEFAULT NULL COMMENT ‘医生’,yishengid
int(11) DEFAULT NULL COMMENT ‘医生id’,PRIMARY KEY (id
)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT=‘病历’;
DROP TABLE IF EXISTS t_yisheng
;
CREATE TABLE t_yisheng
(id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘医生id’,mingzi
varchar(255) DEFAULT NULL COMMENT ‘名字’,username
varchar(255) DEFAULT NULL COMMENT ‘账号’,password
varchar(255) DEFAULT NULL COMMENT ‘密码’,keshi
varchar(255) DEFAULT NULL COMMENT ‘科室’,jianjie
varchar(500) DEFAULT NULL COMMENT ‘简介’,PRIMARY KEY (id
)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT=‘医生’;
[/cc]
添加医生模块:
在yishengController中定义addyishengact接收页面传入的医生参数,定义为yisheng。其中yisheng包含字段:名字,账号,密码,科室,简介,使用addyishengact将该医生对象存入数据库中,在yishengMapper中定义了insert方法,匹配数据库中的insert into yisheng语句实现将医生数据存入数据库的操作。该部分核心代码如下:
通过yishengdao的insert方法将页面传输的医生添加到数据库中yishengdao.insert(yisheng);
将添加医生成功信息,保存到request的message中,在页面中给出用户提示request.setAttribute("message", "添加医生成功");
返回医生管理界面
return “forward:/addyisheng.action”;
修改医生模块:
点击修改按钮,可以跳转到医生修改页面。在医生修改页面中,将初始化该医生的所有信息,并将信息一一对应填充到对应编辑栏中。编辑完医生信息后,页面通过post方法将数据封装为一个医生实体,传入到yishengController中。在updateyisheng中进行接收,接收完毕后,调用yishengMapper中的updateByPrimaryKeySelective方法进行修改。该部分代码如下:
通过yishengdao的修改方法根据id修改对应的医生yishengdao.updateByPrimaryKeySelective(yisheng);
将修改医生成功信息,保存到request的message中,在页面中给出用户提示request.setAttribute("message", "修改医生信息成功");
返回医生管理界面
return “forward:/yishengmanage.action”;
删除医生模块:
在页面中通过a标签,deleteyisheng?id=将id传入到后台中,通过deleteyisheng接收医生id。使用deleteByid的方法
删除该医生,完成删除操作。定义删除成功提示信息,删除医生成功,并保存到request中,该部分代码如下:
通过yishengdao的删除方法根据id删除对应的医生yishengdao.deleteByPrimaryKey(id);
将删除医生成功信息,保存到request的message中,在页面中给出用户提示request.setAttribute("message", "删除医生成功");
返回医生管理界面
return “forward:/yishengmanage.action”;
医生控制层:
[cc]package org.mypro.front;
import java.io.File;
import java.io.IOException;
import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Collections;
import java.util.Date;
import java.util.List;
import javax.jms.Session;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.commons.lang3.StringUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.mypro.service.YishengServiceImp;
import org.mypro.entity.Yisheng;
import org.mypro.entity.YishengExample;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.multipart.MultipartFile;
@Controller
@RequestMapping(value = “/”)
public class YishengController {
private static final Log logger = LogFactory.getLog(YishengController.class);
@Autowired
private YishengServiceImp yishengservice;
@RequestMapping(value = “addyisheng”)
public String addyisheng(HttpServletRequest request, HttpServletResponse response,HttpSession session,String backurl) {
logger.debug("YishengController.addyisheng ......");
yishengservice.addyisheng(request,session);
if(backurl != && backurl.indexOf("addyisheng.action") == -1){
return “forward:/” + backurl;}
return "addyisheng";
}
@RequestMapping(value = “addyishengact”)
public String addyishengact(HttpServletRequest request,HttpSession session, HttpServletResponse response,Yisheng yisheng,String backurl) throws IOException {
logger.debug(“YishengController.addyishengact …”);
yishengservice.addyishengact(request,session,yisheng);
if(backurl != && backurl.indexOf("addyishengact.action") == -1){
return “forward:/” + backurl;}
return “forward:/yishengmanage.action”;
}
@RequestMapping(value = “yishengmanage”)
public String yishengmanage(HttpServletRequest request,HttpSession session, HttpServletResponse response,String backurl) {
logger.debug(“YishengController.yishengmanage …”);
yishengservice.yishengmanage(request,session);
if(backurl != && backurl.indexOf("yishengmanage.action") == -1){
return “forward:/” + backurl;}
return “yishengmanage”;
}
@RequestMapping(value = “yishengview”)
public String yishengview(HttpServletRequest request,HttpSession session, HttpServletResponse response,String backurl) {
logger.debug(“YishengController.yishengview …”);
yishengservice.yishengview(request,session);
if(backurl != && backurl.indexOf("yishengview.action") == -1){
return “forward:/” + backurl;}
return “yishengview”;
}
@RequestMapping(value = “updateyisheng”)
public String updateyisheng(HttpServletRequest request, HttpServletResponse response,HttpSession session,int id,String backurl){
logger.debug(“YishengController.updateyisheng …”);
yishengservice.updateyisheng(request,session,id);
if(backurl != && backurl.indexOf("updateyisheng.action") == -1){
return “forward:/” + backurl;}
return “updateyisheng”;
}
@RequestMapping(value = “updateyishengact”)
public String updateyishengact(HttpServletRequest request, HttpServletResponse response,Yisheng yisheng,HttpSession session,String backurl) throws IOException {
logger.debug(“YishengController.updateyishengact …”);
![img](https://img-blog.csdnimg.cn/img_convert/267d52239166808549efafa6cb4a9489.png)
![img](https://img-blog.csdnimg.cn/img_convert/bd1a549eac4c08c19f890508b81b67ee.png)
**网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。**
**[需要这份系统化资料的朋友,可以戳这里获取](https://bbs.csdn.net/topics/618545628)**
**一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!**
hrows IOException {
logger.debug(“YishengController.updateyishengact …”);
[外链图片转存中…(img-z8tn0izc-1714740852787)]
[外链图片转存中…(img-yGFmjkOb-1714740852787)]
网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。
一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!