java系统源代码_java开发医疗信息管理系统源代码下载

该项目花了1个小时只能运行登录功能,登录成功后导航条无法点击,只能直接访问某些jsp页面,但是jsp页面的功能也没法用,所以该项目设为0牛币,以便大家下载学习。

原项目是基于sqlserver数据库的,我根据java bean生成了mysql的sql建表语句/*

Navicat MySQL Data Transfer

Source Server : localhost

Source Server Version : 50509

Source Host : localhost:3306

Source Database : hospital

Target Server Type : MYSQL

Target Server Version : 50509

File Encoding : 65001

Date: 2017-05-11 19:13:39

*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for `diagnosis`

-- ----------------------------

DROP TABLE IF EXISTS `diagnosis`;

CREATE TABLE `diagnosis` (

`type` varchar(2000) DEFAULT '',

`info` varchar(2000) DEFAULT '',

`doctorId` int(11) DEFAULT '0',

`patientId` int(11) DEFAULT '0'

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of diagnosis

-- ----------------------------

-- ----------------------------

-- Table structure for `doctor`

-- ----------------------------

DROP TABLE IF EXISTS `doctor`;

CREATE TABLE `doctor` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`staffNo` varchar(2000) DEFAULT '',

`name` varchar(2000) DEFAULT '',

`postid` int(11) DEFAULT '0',

`post` varchar(2000) DEFAULT '',

`sex` varchar(2000) DEFAULT '',

`birthday` datetime DEFAULT NULL,

`info` varchar(2000) DEFAULT '',

`mcId` int(11) DEFAULT '0',

`mcName` varchar(2000) DEFAULT '',

`loginName` varchar(2000) DEFAULT '',

`loginPassword` varchar(2000) DEFAULT '',

`isActive` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of doctor

-- ----------------------------

INSERT INTO `doctor` VALUES ('1', '1', '测试', '0', '', '男', '2017-05-11 18:25:16', '', '0', '', '测试', '111111', '0');

-- ----------------------------

-- Table structure for `medicalcourses`

-- ----------------------------

DROP TABLE IF EXISTS `medicalcourses`;

CREATE TABLE `medicalcourses` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`name` varchar(2000) DEFAULT '',

`type` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of medicalcourses

-- ----------------------------

-- ----------------------------

-- Table structure for `nurse`

-- ----------------------------

DROP TABLE IF EXISTS `nurse`;

CREATE TABLE `nurse` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`staffNo` varchar(2000) DEFAULT '',

`name` varchar(2000) DEFAULT '',

`sex` varchar(2000) DEFAULT '',

`postid` int(11) DEFAULT '0',

`post` varchar(2000) DEFAULT '',

`loginName` varchar(2000) DEFAULT '',

`loginPassword` varchar(2000) DEFAULT '',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of nurse

-- ----------------------------

INSERT INTO `nurse` VALUES ('1', '', '测试', '女', '0', '', '测试', '111111');

-- ----------------------------

-- Table structure for `operatingroom`

-- ----------------------------

DROP TABLE IF EXISTS `operatingroom`;

CREATE TABLE `operatingroom` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`orNo` varchar(2000) DEFAULT '',

`type` varchar(2000) DEFAULT '',

`address` varchar(2000) DEFAULT '',

`info` varchar(2000) DEFAULT '',

`nurseList` varchar(2000) DEFAULT '',

`isUseable` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of operatingroom

-- ----------------------------

-- ----------------------------

-- Table structure for `operation`

-- ----------------------------

DROP TABLE IF EXISTS `operation`;

CREATE TABLE `operation` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`type` varchar(2000) DEFAULT '',

`date` datetime DEFAULT NULL,

`operatingRoomId` int(11) DEFAULT '0',

`patenitId` int(11) DEFAULT '0',

`pkDoctorId` int(11) DEFAULT '0',

`extDoctorId` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of operation

-- ----------------------------

-- ----------------------------

-- Table structure for `operationschedule`

-- ----------------------------

DROP TABLE IF EXISTS `operationschedule`;

CREATE TABLE `operationschedule` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`operationRoomId` int(11) DEFAULT '0',

`operationId` int(11) DEFAULT '0',

`startTime` datetime DEFAULT NULL,

`endTime` datetime DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of operationschedule

-- ----------------------------

-- ----------------------------

-- Table structure for `pagefairy`

-- ----------------------------

DROP TABLE IF EXISTS `pagefairy`;

CREATE TABLE `pagefairy` (

`nextpage` int(11) DEFAULT '0',

`priorPage` int(11) DEFAULT '0',

`rowsCount` int(11) DEFAULT '0',

`pageCount` int(11) DEFAULT '0',

`page` int(11) DEFAULT '0',

`numberpage` int(11) DEFAULT '0'

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of pagefairy

-- ----------------------------

-- ----------------------------

-- Table structure for `pagepagination`

-- ----------------------------

DROP TABLE IF EXISTS `pagepagination`;

CREATE TABLE `pagepagination` (

`pageCount` int(11) DEFAULT '0',

`pageSize` int(11) DEFAULT '0',

`priorPage` int(11) DEFAULT '0',

`nextPage` int(11) DEFAULT '0',

`lastPage` int(11) DEFAULT '0',

`pageNum` int(11) DEFAULT '0',

`currentType` varchar(2000) DEFAULT '',

`isActive` varchar(2000) DEFAULT ''

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of pagepagination

-- ----------------------------

-- ----------------------------

-- Table structure for `patient`

-- ----------------------------

DROP TABLE IF EXISTS `patient`;

CREATE TABLE `patient` (

`oid` int(11) DEFAULT '0',

`patientNo` varchar(2000) DEFAULT '',

`name` varchar(2000) DEFAULT '',

`sex` varchar(2000) DEFAULT '',

`address` varchar(2000) DEFAULT '',

`age` int(11) DEFAULT '0',

`isfinished` int(11) DEFAULT '0',

`mcId` int(11) DEFAULT '0',

`mcName` varchar(2000) DEFAULT ''

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of patient

-- ----------------------------

-- ----------------------------

-- Table structure for `post`

-- ----------------------------

DROP TABLE IF EXISTS `post`;

CREATE TABLE `post` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`name` varchar(2000) DEFAULT '',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of post

-- ----------------------------

INSERT INTO `post` VALUES ('1', 'sdfsdf');

-- ----------------------------

-- Table structure for `receipt`

-- ----------------------------

DROP TABLE IF EXISTS `receipt`;

CREATE TABLE `receipt` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`items` varchar(2000) DEFAULT '',

`payee` varchar(2000) DEFAULT '',

`payeeId` int(11) DEFAULT '0',

`pdate` datetime DEFAULT NULL,

`isFinished` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of receipt

-- ----------------------------

-- ----------------------------

-- Table structure for `sickbed`

-- ----------------------------

DROP TABLE IF EXISTS `sickbed`;

CREATE TABLE `sickbed` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`bedNo` varchar(2000) DEFAULT '',

`type` varchar(2000) DEFAULT '',

`isUseable` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of sickbed

-- ----------------------------

-- ----------------------------

-- Table structure for `sickbedid`

-- ----------------------------

DROP TABLE IF EXISTS `sickbedid`;

CREATE TABLE `sickbedid` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`bedNo` varchar(2000) DEFAULT '',

`type` int(11) DEFAULT '0',

`nurseIds` varchar(2000) DEFAULT '',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of sickbedid

-- ----------------------------

-- ----------------------------

-- Table structure for `sinkbedschedule`

-- ----------------------------

DROP TABLE IF EXISTS `sinkbedschedule`;

CREATE TABLE `sinkbedschedule` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`sinkbedId` int(11) DEFAULT '0',

`startTime` datetime DEFAULT NULL,

`endTime` datetime DEFAULT NULL,

`operationId` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of sinkbedschedule

-- ----------------------------

-- ----------------------------

-- Table structure for `stat`

-- ----------------------------

DROP TABLE IF EXISTS `stat`;

CREATE TABLE `stat` (

`items` varchar(2000) DEFAULT '',

`payee` varchar(2000) DEFAULT '',

`name` varchar(2000) DEFAULT '',

`pdate` datetime DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of stat

-- ----------------------------

-- ----------------------------

-- Table structure for `stayinhp`

-- ----------------------------

DROP TABLE IF EXISTS `stayinhp`;

CREATE TABLE `stayinhp` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`patientId` int(11) DEFAULT '0',

`bedId` int(11) DEFAULT '0',

`startTime` datetime DEFAULT NULL,

`endTime` datetime DEFAULT NULL,

`days` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of stayinhp

-- ----------------------------

-- ----------------------------

-- Table structure for `stayinhpdto`

-- ----------------------------

DROP TABLE IF EXISTS `stayinhpdto`;

CREATE TABLE `stayinhpdto` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`patientId` int(11) DEFAULT '0',

`bedId` int(11) DEFAULT '0',

`days` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of stayinhpdto

-- ----------------------------

-- ----------------------------

-- Table structure for `viewdoctorpostmedicalcoursesdto`

-- ----------------------------

DROP TABLE IF EXISTS `viewdoctorpostmedicalcoursesdto`;

CREATE TABLE `viewdoctorpostmedicalcoursesdto` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`workNum` varchar(2000) DEFAULT '',

`name` varchar(2000) DEFAULT '',

`postName` varchar(2000) DEFAULT '',

`sex` varchar(2000) DEFAULT '',

`birthday` datetime DEFAULT NULL,

`info` varchar(2000) DEFAULT '',

`mcName` varchar(2000) DEFAULT '',

`loginName` varchar(2000) DEFAULT '',

`loginPassword` varchar(2000) DEFAULT '',

`isActive` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of viewdoctorpostmedicalcoursesdto

-- ----------------------------

-- ----------------------------

-- Table structure for `viewnursepostdto`

-- ----------------------------

DROP TABLE IF EXISTS `viewnursepostdto`;

CREATE TABLE `viewnursepostdto` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`workNum` varchar(2000) DEFAULT '',

`name` varchar(2000) DEFAULT '',

`sex` varchar(2000) DEFAULT '',

`postName` varchar(2000) DEFAULT '',

`loginName` varchar(2000) DEFAULT '',

`loginPassword` varchar(2000) DEFAULT '',

`pName` varchar(2000) DEFAULT '',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of viewnursepostdto

-- ----------------------------

项目截图

5f44669d9023f819b9cfa4031178418d.png

5f44669d9023f819b9cfa4031178418d.png

运行截图

http://localhost/login.jsp

5f44669d9023f819b9cfa4031178418d.png

http://localhost/view/doctorinsert.jsp

5f44669d9023f819b9cfa4031178418d.png

管理员后台登录

5f44669d9023f819b9cfa4031178418d.png

登录成功

5f44669d9023f819b9cfa4031178418d.png导航不可点,功能不可用,有时间有兴趣的牛牛可以改写下。

数据库截图

5f44669d9023f819b9cfa4031178418d.png

由最代码官方编辑于2017-5-11 19:17:48

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值