This article isVideo version, please be informed that

Project introduction

Project source: gitee.com/PositiveMum…

This time share a cake market system, or very simple system. The interface is clean but not rough.

This system is based on JSP+Servlet+C3P0+Mysql+JDBC. Involve less technology, easy to understand, suitable for JavaWeb beginners to learn to use.

Difficulty level: Easy

Technology stack

The editor

IntelliJ IDEA 2019.1.1 (Ultimate Edition)

The front-end technology

Basis: HTML + CSS + JavaScript

Framework: the BootStrap + JQuery + simpleCart

The back-end technology

Jsp+Servlet

Database: mysql 5.7.27 (personal test use)

JDK version: 1.8.0_181 (for personal testing)

Tomcat Version: 8.5.34 (For personal testing)

Run locally

1. Download the zip file and decompress it or install Git and run the clone command

https://gitee.com/PositiveMumu/CakesShop.git
Copy the code

2. Use Idea to open the project and configure JDK, Tomcat, and required JAR packages. The jar packages that the project depends on are in the web/WEB-INF/lib folder.

3. Open Navicat For Mysql, create a cakeshop database, and run the cakeshop. SQL file.

4. Modify the database content in c3P0-config. XML. If not, you can paste the following content.

<?xml version="1.0" encoding="UTF-8"? >
<c3p0-config>
	<! -- Default configuration, can only appear once -->
	<default-config>
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl"><! [CDATA[jdbc:mysql://localhost:3306/cakeshop?useUnicode=true&characterEncoding=UTF-8]]></property>
		<property name="user">root</property>
		<property name="password">root</property>
	</default-config>
</c3p0-config>
Copy the code

5. Publish the information to Tomcat. For details, visit the tomcat configuration link. If the information is not modified, http://localhost:8080/ is the home page. Administrator Initial account: admin Initial password of the administrator: admin

Pay attention to

  • This project does not declare the use version of mysql, JDK and Tomcat. The above version numbers are used for personal testing.
  • Modify the contents related to the C3P0-config. XML database. **

Project screenshots

The statement

  • This project is collected from Gitee. I just explain the use of technology, attention points and start-up methods to help everyone learn and communicate.
  • If the project cannot be downloaded through gitee address or cannot run normally, please send me a private message and I will provide free assistance.

Recommended reading

  • JSP+Servlet+JDBC+DBCP2 to achieve online book buying system
  • JSP+Servlet+JDBC implementation shine online book city
  • JSP+Servlet+JDBC cloud auto repair background management system
  • JSP+Servlet+JDBC implementation of student information management system
  • JSP+Servlet+C3P0+Mysql implementation of YCU movies website
  • JSP+Servlet+C3P0+Mysql library management system