jsp+javabean+servlet+ajax+mysql商店管理系统

# SQL Manager 2005 Lite for MySQL 3.7.5.1 # --------------------------------------- # Host : localhost # Port : 3306 # Database : shop /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES gb2312 */; SET FOREIGN_KEY_CHECKS=0; CREATE DATABASE `shop` CHARACTER SET 'gb2312' COLLATE 'gb2312_chinese_ci'; USE `shop`; # # Structure for the `tcustomer` table : # CREATE TABLE `tcustomer` ( `NCUSTM_ID` int(11) NOT NULL auto_increment COMMENT '客户ID', `VCARID` varchar(10) NOT NULL COMMENT '会员卡ID', `VNAME` varchar(50) NOT NULL COMMENT '客户姓名', `VSEX` char(8) NOT NULL COMMENT '客户性别', `VMOBILE` varchar(20) default NULL COMMENT '手机', `VPHONE` varchar(20) default NULL COMMENT '固定电话', `NTOTAL_PRICE` double(10,2) default NULL COMMENT '总消费金额', `VADDRESS` varchar(200) default NULL COMMENT '客户联系地址', `VDESC` varchar(200) default NULL COMMENT '备注', `VCREATE` varchar(8) NOT NULL COMMENT '创建日期', `VCREATOR` varchar(10) NOT NULL COMMENT '创建人', `VUPDATE` varchar(8) default NULL COMMENT '更新日期', `VUPCREATOR` varchar(10) default NULL COMMENT '创建人', `VBIRSDAY` varchar(20) default NULL COMMENT '会员生日', PRIMARY KEY (`NCUSTM_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; # # Structure for the `tproduct` table : # CREATE TABLE `tproduct` ( `NPROD_ID` int(11) NOT NULL auto_increment COMMENT '产品编号', `VPROD_NAME` varchar(100) default NULL COMMENT '产品名', `VPROD_NO` varchar(50) NOT NULL COMMENT '产品编号', `VCOLOUR` char(2) NOT NULL COMMENT '产品颜色', `VSENSON` char(2) NOT NULL COMMENT '产品所属季节', `NUNIT_PRICE` double(10,2) default NULL COMMENT '产品单价', `NSMALL` int(11) default NULL COMMENT '小号数量', `NMIDDLE` int(11) default NULL COMMENT '中号数量', `NLARGE` int(11) default NULL COMMENT '大号数量', `NXI` int(11) default NULL COMMENT '加大号数量', `VCREATE` varchar(8) NOT NULL COMMENT '创建日期', `VCREATOR` varchar(10) NOT NULL COMMENT '创建人', `VUPDATE` varchar(8) default NULL COMMENT '更新日期', `VUPCREATOR` varchar(10) default NULL COMMENT '更新人', PRIMARY KEY (`NPROD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; # # Structure for the `tprod_sell` table : # CREATE TABLE `tprod_sell` ( `NSELL_ID` int(11) NOT NULL auto_increment COMMENT '销售ID号', `NPROD_ID` int(11) NOT NULL COMMENT '产品ID', `NCUSTM_ID` int(11) NOT NULL, `NSMALL` int(11) default NULL COMMENT '小号数量', `NMIDDLE` int(11) default NULL COMMENT '中号数量', `NLARGE` int(11) default NULL COMMENT '大号数量', `NXI` int(11) default NULL COMMENT '加大号数量', `NSELLPRICE` double(10,2) NOT NULL COMMENT '实际销售价格', `VCREDATE` varchar(8) NOT NULL COMMENT '创建日期', `VCREATOR` varchar(10) NOT NULL COMMENT '创建人', `VUPDATE` varchar(8) default NULL COMMENT '更新日期', `VUPCREATOR` varchar(10) default NULL COMMENT '更新人', PRIMARY KEY (`NSELL_ID`), KEY `FK_Reference_1` (`NCUSTM_ID`), KEY `FK_Reference_2` (`NPROD_ID`), CONSTRAINT `FK_Reference_1` FOREIGN KEY (`NCUSTM_ID`) REFERENCES `tcustomer` (`NCUSTM_ID`), CONSTRAINT `FK_Reference_2` FOREIGN KEY (`NPROD_ID`) REFERENCES `tproduct` (`NPROD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='销售ID号'; # # Structure for the `tuser` table : # CREATE TABLE `tuser` ( `NUSERID` int(11) NOT NULL auto_increment COMMENT '用户ID编号', `VNAME` varchar(50) NOT NULL COMMENT '用户姓名', `VSEX` varchar(50) NOT NULL COMMENT '用户性别', `VUSERNAME` varchar(50) NOT NULL COMMENT '登录用户名', `VPASSWORD` varchar(50) NOT NULL COMMENT '登录密码', `VROLE` char(20) NOT NULL COMMENT '登录角色', `DCREATE` datetime NOT NULL COMMENT '创建日期', `VCREATOR` varchar(10) NOT NULL COMMENT '创建人', `DUPDATE` datetime default NULL COMMENT '更新日期', `VUPCREATOR` varchar(10) default NULL COMMENT '更新人', PRIMARY KEY (`NUSERID`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; # # Definition for the `countsell_view` view : # CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `countsell_view` AS select `tprod_sell`.`NSELL_ID` AS `NSELL_ID`, `tprod_sell`.`NPROD_ID` AS `NPROD_ID`, `tprod_sell`.`NCUSTM_ID` AS `NCUSTM_ID`, `tprod_sell`.`NSMALL` AS `NSMALL`, `tprod_sell`.`NMIDDLE` AS `NMIDDLE`, `tprod_sell`.`NLARGE` AS `NLARGE`, `tprod_sell`.`NXI` AS `NXI`, `tprod_sell`.`NSELLPRICE` AS `NSELLPRICE`, `tprod_sell`.`VCREDATE` AS `VCREDATE`, `tprod_sell`.`VCREATOR` AS `VCREATOR`, `tprod_sell`.`VUPDATE` AS `VUPDATE`, `tprod_sell`.`VUPCREATOR` AS `VUPCREATOR`, `tproduct`.`VPROD_NAME` AS `VPROD_NAME`, `tproduct`.`NUNIT_PRICE` AS `NUNIT_PRICE` from (`tproduct` join `tprod_sell`) where (`tprod_sell`.`NPROD_ID` = `tproduct`.`NPROD_ID`); # # Definition for the `querysell_view` view : # CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `querysell_view` AS select `tcustomer`.`VCARID` AS `VCARID`, `tcustomer`.`VNAME` AS `VNAME`, `tproduct`.`VCOLOUR` AS `VCOLOUR`, `tproduct`.`VPROD_NO` AS `VPROD_NO`, `tproduct`.`NUNIT_PRICE` AS `NUNIT_PRICE`, `tproduct`.`VPROD_NAME` AS `VPROD_NAME`, `tproduct`.`VSENSON` AS `VSENSON`, `tprod_sell`.`NSELL_ID` AS `NSELL_ID`, `tprod_sell`.`NPROD_ID` AS `NPROD_ID`, `tprod_sell`.`NCUSTM_ID` AS `NCUSTM_ID`, `tprod_sell`.`NSMALL` AS `NSMALL`, `tprod_sell`.`NMIDDLE` AS `NMIDDLE`, `tprod_sell`.`NLARGE` AS `NLARGE`, `tprod_sell`.`NXI` AS `NXI`, `tprod_sell`.`NSELLPRICE` AS `NSELLPRICE`, `tprod_sell`.`VCREDATE` AS `VCREDATE`, `tprod_sell`.`VCREATOR` AS `VCREATOR`, `tprod_sell`.`VUPDATE` AS `VUPDATE`, `tprod_sell`.`VUPCREATOR` AS `VUPCREATOR` from ((`tcustomer` join `tproduct`) join `tprod_sell`) where ((`tprod_sell`.`NCUSTM_ID` = `tcustomer`.`NCUSTM_ID`) and (`tprod_sell`.`NPROD_ID` = `tproduct`.`NPROD_ID`)); # # Data for the `tcustomer` table (LIMIT 0,500) # INSERT INTO `tcustomer` (`NCUSTM_ID`, `VCARID`, `VNAME`, `VSEX`, `VMOBILE`, `VPHONE`, `NTOTAL_PRICE`, `VADDRESS`, `VDESC`, `VCREATE`, `VCREATOR`, `VUPDATE`, `VUPCREATOR`, `VBIRSDAY`) VALUES (1,'100001','Soho','男','13548607134','07312754426',24343,'湖南省长沙市','黄金会员','20081220','admin','20081220','admin','null'), (2,'100002','TanHuan','男','13598631245','07312589645',16754,'湖南省长沙市','白金会员','20081220','admin','20081220','admin','null'), (3,'100003','liujun','男','13586986523','07312589635',4484,'湖南省长沙市','普通会员','20081221','admin','20081221','admin','null'), (4,'100004','yaochao','男','13523697845','07312478963',1548,'湖南省株洲市','普通会员','20081221','admin','20081221','admin','null'), (5,'100005','hebing','女','13739052673','07318695324',1607,'湖南省长沙市','白金会员','20081221','admin','20081221','admin','null'), (6,'100006','huwenhua','男','13578963214','07312698532',3091,'湖南省长沙市','普通会员','20081221','admin','20081221','admin','null'), (7,'100012','东君','男','1238698565','1234567',588,'111','111','20081224','admin','20081224','admin','20081209'), (9,'100000','非会员普通消费','男','','',3679,'','','20081225','admin','20081225','admin',''); COMMIT; # # Data for the `tproduct` table (LIMIT 0,500) # INSERT INTO `tproduct` (`NPROD_ID`, `VPROD_NAME`, `VPROD_NO`, `VCOLOUR`, `VSENSON`, `NUNIT_PRICE`, `NSMALL`, `NMIDDLE`, `NLARGE`, `NXI`, `VCREATE`, `VCREATOR`, `VUPDATE`, `VUPCREATOR`) VALUES (1,'ADIDAS运动服','10001','浅�
','夏',698,2,0,1,0,'20081220','admin','20081220','admin'), (5,'NIKE外套','10002','紫�
','夏',588,2,3,0,0,'20081220','null','20081220','null'), (6,'NIKE棉袄','10003','大�
','冬',798,1,1,3,0,'2