Through the comprehensive application of JSP and JDBC, master the basic principles and common techniques of server-side database programming for small and medium-sized Java Web application systems, and have the basic hands-on ability to design server-side database tables and JSP page JDBC programming. Specifically, it includes:
Write Java code, be familiar with and master the use of JDBC, including the principles and common methods of Connection, Statement, PreparedStatement, and ResultSet objects; 2) Write JSP pages, be familiar with and master the application syntax and control structure of JDBC in JSP pages, master the use of JSP built-in objects and server-side debugging techniques; 3) Realize the integration and integration of server-side programming technologies such as JSP and JDBC, master routine data operations such as CRUD on single tables and associated tables, and achieve reasonable code layout, dynamic webpage presentation, and real-time interaction on server-side pages.
- Master the entire process of Java web website design;
- Further proficiency in Servlet technology, databases, tags, and other general Java web application technologies;
- Master the entire Java web application architecture, directory structure, and server usage.
On the basis of comprehensive programming experiments on the client side, combined with technologies such as JSP&JDBC, the main modules of the mall backend management system (login, product, product information, etc.) are completed to achieve dynamic data display and backend operation functions of corresponding information. This mainly includes related database design and user login functions, product list dynamic database table content list display function, shopping cart addition and backend interaction function with the database, and can be debugged using development tools for server-side code.
- Design a comprehensive online store;
- Account module: Provides user registration and login, considering the increase or decrease in the number of users, requiring the use of database technology;
- Product display module: In order to increase sales volume, it is necessary to have a simple advertising function and provide detailed product parameters; To promote products, the website needs to display hot selling products, classify and search for products
- Order Management Module and Order Details Module: Display detailed information of saved orders;
- Shopping cart module: Add/delete products, checkout, display order information.
- Implement a series of operations by logging in as an administrator to the backend.
This mall mainly utilizes JavaServlet technology for development, which has strong logic, scalability, and is easy to maintain. The interface design of the mall mainly utilizes CSS to beautify the storefront. Secondly, the design of this mall also utilizes JSP technology, JDBC technology, and JavaBean technology.
On the basis of the basic implementation of front-end business, the main development includes: registration, login, payment and order placement (outbound shipping), order management, product management, customer management, and other back-end businesses. 1、 Registration 2、 Login 3、 Pay to place an order
(1、If the customer is not logged in, please log in; (Successfully logged in and generated customer object coexisting in Session) (2. No specific payment function is required, just highlight the total amount; (3. Shipping information: recipient, contact phone number, shipping address; (4. Generate an order, including: order number, customer, order date, total amount, recipient, contact phone number, and delivery address; (5. Add detailed records, including: order, purchased goods, quantity, unit price, and reduce the inventory of goods accordingly.
Order inquiry and deletion
- Purchase and warehousing
- Product inquiry and delisting