As a computer professional master of the Junior school slag, feel junior, basic core curriculum also learned a lot of Java object-oriented programming, database, data structure ..., did not hit the code to do something, very uneasy!! Recently learning Java WEB, in order to not even after the internship can not find units, the slag on the road of self-redemption!!! From the library borrowed this "JSP project development full record third edition" Want to imitate to do some examples, give oneself accumulate some knowledge experience what! So I chose an example of a library management system (Struts1.2+mysql 5.0 implementation). When I was doing this, I did not learn the struts development framework, just in the Geek College above a simple understanding of the next, here I use the blog park to record the first thing I do, I hope to have some gains.
The first is the construction of the development environment:
① Download--Install jdk1.8.0_66 version
② set the environment variable, create the variable java_home specify to the JDK installation directory, the relative path,%java_home%\bin add to the path variable, here if the path variable already exists, the direct edit at the end of the Add, note the preceding semicolon. If you do not create a path variable to add, there is no need for a semicolon. There is also the addition of the CLASSPATH variable.
③ Download Tomcat 8.0 extract, add variable
Variable name: catalina_home
Variable value: The path just installed
Test whether the installation configuration was successful
Locate the Bin folder under the installation path, locate the Startup.bat inside, run it, and then perform the following actions.
Open the browser and enter http://localhost:8080. If the following content appears, the description succeeds.
④ download Eclipse Java EE Development tool, unzip-run. Specify Tomcat as the Web server in Eclipse and select Window--preference-sever--runtime environments-add to specify the Tomcat decompression path.
⑤ download MySQL 5.6.24 installation, decomposition compression and MSI file execution install two kinds.
⑥powerdesigner16.5 modelling tools.
1.powerdesigner16.5 Version Modeling
A.physical Data Model Physical modeling abbreviation PDB
B.choose DBSM Select the database management system to use MySQL5.0
C. Creating a Table--columns column property
unsigned integer data type integer unsigned
Primary primary key foreign key foreign key mandatory must be filled in this field
Precision Accuracy
Note Char vachar nvarchar difference See Blog Park Blog
D. Created--double-click the ID column-Check the identity auto-number--mysql numerics tick unsigned
E.standard check--defult setting field default values
F.reference establish a dependency relationship between tables (the link/traceability link mentioned in the question book does not create a dependency)
G. Foreign key creation should be consistent with the data type.
H. Creating a unique key rather than a primary key
① now set the ID to primary key
② add key_2 to the Keys option in table properties
③ Double-click Key_2, enter the settings in the General option to fill in the constraint name, which is generally formatted as the Unq_ table name _ field.
④ Add the Set field ISBN in the cloumns option
⑤ check UniqueKey in MySQL, this step is important if you do not tick ISBN will be the primary key with the ID
j.database->generate Database Generate SQL file, import MySQL
Data model creation is complete.
2.MySQL
A. Start mysql->cmd->net strat MySQL
B.CD MySQL is located under the Path Bin folder
Login: Mysql-uroot-p
Enter password
Execute CREATE DATABASE Db_librarysys under C.mysql; Create a database
Use Db_librarysys; Open Database
SOURCE E:\library.sql Importing PowerDesigner-generated files
D. Database creation complete.
Library Management System--Rookie first launch (i)