#项目简介 (Cloud note management system)
# #功能
Notebook management, note management, Recycle Bin management,
Sharing and collection management, event management, user management, etc.
# # Technology used
Html+ajax
Spring (IOC/AOP/MVC)
Springmvc+spring (IOC/AOP) +mybatis
MyBatis (Access MySQL database)
HTML static page for all interfaces
All requests are interactive with Ajax
Returns the JSON results for all requests, returning the following results uniformly
{
"Status": State,
"MSG": Message,
"Data":
}
# # Build a database environment
ER model diagram: Entity Relationship Model Diagram
MySQL: Library--"table--" record
Show databases;//see which libraries are available
Use test;//using the test library
CREATE TABLE EMP (
Eno int primary KEY,
ename varchar (20)
);
Show tables;//see which tables are in the current library
Desc emp;//View Table structure
INSERT into EMP (eno,ename)
VALUES (1, ' Tom ');
SELECT * from EMP;
SQL file Import
Set names utf8;//setting client-side encoding
SOURCE e:\\cloud_note.sql;//Import SQL file
Source/home/soft01/cloud_note.sql
drop table xxx;//Delete tables
Drop Database xxx;//Delete Library
# # Create Project Engineering
-Project Name: Cloudnote
-webroot placing html/scripts/css/imges ...
-Import Spring+mybatis Development Package
-Import configuration file
SPRING-MVC.XML:SPRINGMVC configuration information
Spring-mybatis.xml:mybatis configuration information
Spring-bean.xml: Other bean Component configuration information
-org.tedu.cloudnote.controller (Set Controller)
-org.tedu.cloudnote.service (Release service component)
-org.tedu.cloudnote.dao (Put DAO)
-org.tedu.cloudnote.entity (Put entity Class)
-org.tedu.cloudnote.sql (Put SQL definition XML file)
-org.tedu.cloudnote.util (Put tool Class)
1. Cloud Note Management System--Project Introduction