基于java的药品管理系统_基于Java药品管理系统

介绍：

技术：java、jsp

数据库：mysql

web服务器：Tomcat

集成开发工具：myeclipse

截图：

数据库表：

CREATE TABLE admin (

id int(4) NOT NULL auto_increment,

name varchar(50) NOT NULL,

pwd varchar(50) default NULL,

quanxian int(4) default NULL,

PRIMARY KEY (name),

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

/*Data for the table admin */

insert into admin(id,name,pwd,quanxian) values (2,‘111’,‘111’,-1),(1,‘admin’,‘024admin’,-1);

/*Table structure for table dingdan */

DROP TABLE IF EXISTS dingdan;

CREATE TABLE dingdan (

id int(4) NOT NULL auto_increment,

supplierid varchar(50) default NULL,

zuangtai int(4) default ‘0’,

times varchar(50) default ‘2008-5-20’,

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;

/*Data for the table dingdan */

insert into dingdan(id,supplierid,zuangtai,times) values (1,‘3’,0,‘2008-5-20’),(2,‘3’,1,‘2008-5-20’),(3,‘2’,0,‘2008-5-20’);

/*Table structure for table leibie */

DROP TABLE IF EXISTS leibie;

CREATE TABLE leibie (

id int(4) NOT NULL auto_increment,

leibie varchar(50) NOT NULL,

PRIMARY KEY (leibie),

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;

/*Data for the table leibie */

insert into leibie(id,leibie) values (1,‘方便面类’),(2,‘服装类’),(3,‘玻璃产品类’),(4,‘qq’),(5,‘aa’),(6,‘2222’);

/*Table structure for table sandd */

DROP TABLE IF EXISTS sandd;

CREATE TABLE sandd (

id int(4) NOT NULL auto_increment,

dingdanid int(4) default NULL,

shangpinid int(4) default NULL,

sums int(4) default NULL,

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

源码下载地址：http://www.bycxy123.com/

本文地址：https://blog.csdn.net/weixin_37971904/article/details/107676128

如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！