ShopOnline

Overwiew

This is my first web stie. He is completed. He works, but...code is terrible, but I am too lazy for fixing and refactoring this code because project is very big, code in CONTROLLER expecially terrible, please don't see on it, but there are many different things which cost to notice.

Frameworks and tools

Java&IDE: JDK7 MyEclipse2018
Backend: SpringMVC, Spring, Hibernate, jdbc, Spring Security
Frontend: JQuery, Ajax
Database: mysql7
Web Server: Tomcat 7
Build Tool: Maven
Linux： Arch Linux
Other: Log4j, Twilio

System Features

• Ability add item to cart
• Ability send message at the phone: "We sended your order."
• Ability to restore password by gmail
• Ability to LogIn and SignUp by Spring Security
• Ability restore password
• Ability review of ordered items
• 6 different types of sorting items
• Ability create own product for Admin
• Ability edit own product for Admin
• Ability add comment
• Ability to edit comment
• Ability count sold amount of items for Admin
• Ability to revise lately viewed items
• Ability add rating

Tuning project...

1. For sending message:
   You should get trial account of twilio and then to tuning class "SendSms" in package "CloudCommunicationPlatform" in match with your trial account
2. for connecting Registration and RestorePassword:
   a)Set email company and password company in class "SendEmail" on lines:18,19
   b)Set email on line 25 in file "servlet-context.xml"
   c)Set email on line 112 in controller to your email
   d)Only gmail;
3. For work of sorting:
   You should add to your tomcat to file "server.xml" next line:

           <Connector connectionTimeout="20000" port="8080" protocol="HTTP/1.1" redirectPort="8443" URIEncoding="UTF-8">
   

How use Mysql

I'm using for start

    mysql -p -u root

Show databases

     SHOW DATABASES

Show tables

     SHOW TABLES

Use database "SawForGarden"

     USE SawForGarden

Revise database "users" , database structure

     DESCRIBE users;

Revise all content of table "users"

     SELECT * FROM users;