SSH框架实现网上商城代码

/* SQLyog Ultimate - MySQL GUI v8.2 MySQL - 5.0.87-community-nt : Database - jxdb ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`jxdb` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `jxdb`; /*Table structure for table `access_log_p` */ DROP TABLE IF EXISTS `access_log_p`; CREATE TABLE `access_log_p` ( `ACCESS_LOG_ID` varchar(40) NOT NULL, `DEPT_NAME` varchar(100) default NULL, `USER_NAME` varchar(40) default NULL, `MODULE_NAME` varchar(200) default NULL, `CURL` varchar(400) default NULL, `CREATE_BY` varchar(40) default NULL, `CREATE_TIME` datetime default NULL, PRIMARY KEY (`ACCESS_LOG_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `access_log_p` */ /*Table structure for table `business_position_p` */ DROP TABLE IF EXISTS `business_position_p`; CREATE TABLE `business_position_p` ( `BUSINESS_POSITION_ID` varchar(40) NOT NULL, `NAME` varchar(100) default NULL, `RESPONSIBILITY` varchar(500) default NULL, `IS_USE` char(1) default NULL, `ORDER_NO` int(11) default NULL, PRIMARY KEY (`BUSINESS_POSITION_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `business_position_p` */ /*Table structure for table `dept_p` */ DROP TABLE IF EXISTS `dept_p`; CREATE TABLE `dept_p` ( `DEPT_ID` varchar(40) NOT NULL, `DEPT_NAME` varchar(100) default NULL, `DEPT_NAME_SHORT` varchar(100) default NULL, `DEPT_NAME_FULL` varchar(100) default NULL, `DEPT_DESC` varchar(100) default NULL, `PARENT_ID` varchar(40) default NULL, `PARENT_NAME` varchar(100) default NULL, `LAYER_NUM` int(11) default NULL, `IS_DUTY_LEVEL` char(1) default NULL, `IS_TEAM` char(1) default NULL, `IS_LEAF` char(1) default NULL, `IS_USE` char(1) default NULL, `ORDER_NO` int(11) default NULL, `DEPT_LEVEL` int(11) default NULL, `CREATED_BY` varchar(40) default NULL, `CREATED_TIME` datetime default NULL, `UPDATED_BY` varchar(40) default NULL, `UPDATED_TIME` datetime default NULL, `BASED_TIME` datetime default NULL, `DUTY_LEVEL` varchar(40) default NULL, PRIMARY KEY (`DEPT_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `dept_p` */ insert into `dept_p`(`DEPT_ID`,`DEPT_NAME`,`DEPT_NAME_SHORT`,`DEPT_NAME_FULL`,`DEPT_DESC`,`PARENT_ID`,`PARENT_NAME`,`LAYER_NUM`,`IS_DUTY_LEVEL`,`IS_TEAM`,`IS_LEAF`,`IS_USE`,`ORDER_NO`,`DEPT_LEVEL`,`CREATED_BY`,`CREATED_TIME`,`UPDATED_BY`,`UPDATED_TIME`,`BASED_TIME`,`DUTY_LEVEL`) values ('0','组织机构','组织机构','组织机构','root','-1',NULL,1,'1','0','0','1',1,0,NULL,'2010-09-16 16:01:37',NULL,'2010-09-16 16:01:37',NULL,'0'),('0001','杰信商贸','杰信商贸','杰信商贸','组织机构','0',NULL,1,'1','0','0','1',1,1,NULL,'2009-05-23 11:23:39',NULL,'2009-05-23 11:23:39',NULL,'0001'),('0001001','开发部','开发部','开发部','','0001','杰信商贸',2,'1','0','1','1',NULL,NULL,'001','2011-07-16 07:38:37',NULL,NULL,NULL,'0001001'),('0001002','销售部','销售部','销售部','','0001','杰信商贸',2,'1','1','1','1',NULL,NULL,'001','2011-07-16 07:39:18',NULL,NULL,NULL,'0001002'),('0001003','船务部','船务部','船务部','','0001','杰信商贸',2,'1','0','1','1',NULL,NULL,'001','2011-07-16 07:39:56',NULL,NULL,NULL,'0001003'),('0001004','财务部','财务部','财务部','','0001','杰信商贸',2,'1','0','1','1',NULL,NULL,'001','2011-07-16 07:40:18',NULL,NULL,NULL,'0001004'); /*Table structure for table `exam_paper_c` */ DROP TABLE IF EXISTS `exam_paper_c`; CREATE TABLE `exam_paper_c` ( `EXAM_PAPER_ID` varchar(40) NOT NULL, `REPORT_CARD_ID` varchar(40) default NULL, `TITLE` varchar(200) default NULL COMMENT '冗余=TEST_QUESTION_C', `CONTENT` varchar(2000) default NULL COMMENT '冗余=TEST_QUESTION_C', `ANSWER` varchar(2000) default NULL COMMENT '冗余=TEST_QUESTION_C', `INPUT_ANSWER` varchar(2000) default NULL, `CTYPE` int(11) default NULL COMMENT '冗余=TEST_QUESTION_C', `SCORE` decimal(8,2) default NULL COMMENT '冗余=TEST_QUESTION_C', `TOTAL_SCORE` decimal(8,2) default NULL, `ORDER_NO` int(11) default NULL, PRIMARY KEY (`EXAM_PAPER_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `exam_paper_c` */ insert into `exam_paper_c`(`EXAM_PAPER_ID`,`REPORT_CARD_ID`,`TITLE`,`CONTENT`,`ANSWER`,`INPUT_ANSWER`,`CTYPE`,`SCORE`,`TOTAL_SCORE`,`ORDER_NO`) values ('402880ee410310d00141031f71580003','402880ee410310d00141031f71580002','1','2','A','A',1,'5.00',NULL,NULL),('402880ee410310d00141031f71580004','402880ee410310d00141031f71580002','遵守教学纪律，无迟到，提前下课，上课拨接手机等现象','A.非常满意|B.比较满意|C.基本满意|D.不太满意|E.非常不满意','A','A',1,'10.00',NULL,NULL),('402880ee410310d00141031f71580005','402880ee410310d00141031f71580002','3','4','A','A',1,'7.00',NULL,NULL),('402880ee410310d00141032789ac0007','402880ee410310d00141032789ac0006','3','4','A','A',1,'7.00',NULL,NULL),('402880ee410310d00141032789ac0008','402880ee410310d00141032789ac0006','1','2','A','A',1,'5.00',NULL,NULL),('402880ee410310d00141032789ac0009','402880ee410310d00141032789ac0006','遵守教学纪律，无迟到，提前下课，上课拨接手机等现象','A.非常满意|B.比较满意|C.基本满意|D.不太满意|E.非常不满意','A','A',1,'10.00',NULL,NULL); /*Table structure for table `factory_c` */ DROP TABLE IF EXISTS `factory_c`; CREATE TABLE `factory_c` ( `FACTORY_ID` varchar(40) NOT NULL, `FULL_NAME` varchar(200) default NULL, `FACTORY_NAME` varchar(50) default NULL, `CONTRACTOR` varchar(30) default NULL, `PHONE` varchar(20) default NULL, `MOBILE` varchar(20) default NULL, `FAX` varchar(20) default NULL, `CTYPE` int(11) default NULL, `CNOTE` text, `STATE` int(11) default NULL, `CREATE_BY` varchar(40) default NULL, `CREATE_DEPT` varchar(40) default NULL, `CREATE_TIME` datetime default NULL, `INSPECTOR` varchar(30) default NULL, `ORDER_NO` int(11) default NULL, PRIMARY KEY (`FACTORY_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `factory_c` */ insert into `factory_c`(`FACTORY_ID`,`FULL_NAME`,`FACTORY_NAME`,`CONTRACTOR`,`PHONE`,`MOBILE`,`FAX`,`CTYPE`,`CNOTE`,`STATE`,`CREATE_BY`,`CREATE_DEPT`,`CREATE_TIME`,`INSPECTOR`,`ORDER_NO`) values ('402880e6413519870141354e97f30002','1','','','','','',1,'',NULL,NULL,NULL,NULL,'',1),('402880e64135198701413553e6980003','2','','','','','',2,'',NULL,NULL,NULL,NULL,'',2),('402880e641351987014135544a340004','3','','','','','',3,'',NULL,NULL,NULL,NULL,'',3),('402880e6413519870141355da8850005','4','','','','','',2,'',NULL,NULL,NULL,NULL,'',4),('402880e6413519870141355dbd070006','5','','','','','',2,'',NULL,NULL,NULL,NULL,'',5),('402880e6413519870141355dd12b0007','6','','','','','',3,'',NULL,NULL,NULL,NULL,'',6),('402880e6413519870141355e83930008','7','','','','','',3,'',NULL,NULL,NULL,NULL,'',7),('402880e6413519870141355e96ad0009','8','','','','','',4,'',NULL,NULL,NULL,NULL,'',8),('402880e6413519870141355eab7e000a','9','','','','','',4,'',NULL,NULL,NULL,NULL,'',9),('402880e6413519870141355ec34b000b','10','','','','','',4,'',NULL,NULL,NULL,NULL,'',10),('402880e64135198701413562dbc2000c','11','','','','','',3,'',NULL,NULL,NULL,NULL,'',11); /*Table structure for table `fast_menu_b` */ DROP TABLE IF EXISTS `fast_menu_b`; CREATE TABLE `fast_menu_b` ( `ID` varchar(40) NOT NULL, `NAME` varchar(30) default NULL, `CNNAME` varchar(30) default NULL, `CURL` varchar(150) default NULL, `CLICK_NUM` int(11) default NULL, `BELONG_USER`