ERP information system of Changsha Rice Noodle Factory

 

1.1 business needs and objectives

1.1.1 Business Requirements 1.1.2 summary design 1.1.3 detailed design 1.2 Technical Design 1.2.1 Database Design 1.2.1.1 User table

Create Table 'mysql'. 'user _ info '(

'Userid' varchar (45 ),

'Password' varchar (45 ),

'Role' varchar (45)

)

Engine = InnoDB;

 

1.2.1.2 customer table

Create Table 'mysql'. 'kf _ info '(

'Id' varchar (20 ),

'Khbh' varchar (3 ),

'Xm 'varchar (200 ),

'Dh 'varchar (45 ),

'Sfz' varchar (45), -- ID card

'Dz' varchar (45), -- Address

'Pslx 'varchar (45), -- delivery route

'Fjlsj' varchar (45) -- customer Creation Time

)

Engine = InnoDB;

 

1.2.1.3 product table

Create Table 'mysql'. 'cp '(

'Cp _ id' varchar (45 ),

'Cp _ name' varchar (45 ),

'Cp _ class' varchar (45 ),

'Cp _ desc' varchar (200)

)

Engine = InnoDB;

 

1.2.1.4 Order Form

Create Table 'mysql'. 'dd '(

'Dd _ id' varchar (45 ),

'Khbh' varchar (45 ),

'Cp _ id' varchar (45 ),

'S1' double,

'Jg' double, -- price

'Rqsj 'varchar (45)

)

Engine = InnoDB;

Alter table 'mysql'. 'dd' add column 'qtsm 'varchar (500) after 'rqsj ';

-- Other Instructions

1.2.2 data initialization 1.2.2.1 system super Administrator

Insert into user_info (userid, password, role) values ('admin', 'admin', 'supermanager ');

 

Insert into kf_info (ID, khbh, XM, DH, sfz, DZ, pslx, kfjlsj) values ('1', '1 ',**,'*', '********', 'hn ', 'pslx', 'kfjlsj ');

 

Insert into cpvalues ('1', 'mf ');

1.2.3 coding design 1.2.3.1 front-end page design 1.2.3.2 Background Program Design

 

 

1.2.4 test design 1.2.4.1 business function test 1.2.4.2 user test 1.2.5 launch and O & M 1.2.5.1 database installation and program deployment 1.2.5.2 data backup and recovery

Show variables like '% char %'

Mysqldump-uroot-proot MySQL DD> test1. SQL

Mysqldump-uroot-proot MySQL DD> E: \ MFC

 

1.2.5.3 management and implementation plan for program version 1.3

Installation and deployment

1. MySQL executes all as the root user. SQL (change the MySQL account and password to root) 2. Change the MFC. put war in the Directory D: \ apache-Tomcat-6.0.32 \ webapps! 3. start Tomcat: D: \ apache-Tomcat-6.0.32 \ bin \ Startup. bat4 and access http: // localhost: 8080/mfc/index. jsp.

ERP information system of Changsha Rice Noodle Factory