Software Environment and Technologies Used in System Development

Based on past development experience and project requirements, this paper has determined the software environment used for developing this system. The operating system used is Windows 11 that comes with the personal development device, the compiler selected is IntelliJ IDEA, the database management system used is MySQL, the database visualization tool is Navicat premium, the project management tool is Apache Maven, the web application server is Tomcat, and the browser used is Microsoft Edge.

MySQL is a popular relational database management system that uses the client/server model. It is highly scalable and can be programmed using various programming languages. The advantages of MySQL include its open source nature, high reliability, high performance, ease of use, and flexibility. Data in MySQL is stored in tables, each consisting of columns and rows. It has powerful querying and analysis capabilities, supports SQL language, and facilitates querying, inserting, updating, and deleting data. MySQL also provides advanced features such as stored procedures, triggers, views, indexes, etc., which allows developers to manage data more flexibly.

Apache Maven is an open-source project management and automation build tool. It is written in Java and can be used from the command line or integrated development environment (IDE). The main purpose of Maven is to manage the build and dependency relationships of Java projects. It uses an XML file (called pom.xml) to describe the configuration and dependencies of the project. Maven can automatically download the required dependencies and package them into deployable binary files. The core plugin set of Maven includes tasks such as compilation, testing, packaging, deployment, and cleaning, which can be configured through the pom.xml file.

Tomcat is a free and open-source web application server, written in Java, that can run Java Servlet and JavaServer Pages (JSP). Tomcat's architecture is very flexible and can be extended through plugins to support different functionalities. It also provides many configuration options that can be adjusted as needed. Tomcat's performance is also good and can handle large amounts of concurrent requests. Therefore, Tomcat is widely used for enterprise-level application development and deployment. Its open-source nature and free use license make it the preferred web server for many developers and organizations.

Through a lot of technical comparison and development experience guidance, this paper has decided to use six main technologies to develop this system. The programming language used is Java, the front-end framework uses Vue and Node.js, the back-end framework is the SSM framework, paired with Spring Boot and MyBatis Plus for development.

Java is a widely used computer programming language and is based on an object-oriented paradigm. Its syntax is concise and clear, and its object-oriented programming pattern is one of its characteristics. Java's cross-platform feature is another important feature, which means that Java programs can run on different platforms, making it a very popular programming language.

Java has a wide range of applications in various fields. In web development, Java also has many applications, such as web development frameworks like Java Servlet, JavaServer Pages (JSP), and JavaServer Faces (JSF), which make Java an important player in the web development field.

The SSM framework is a lightweight web application development framework based on Java technology, which consists of three open-source frameworks: Spring, SpringMVC, and MyBatis. These three frameworks have powerful functionalities, and under the integration of the SSM framework, their advantages can be fully utilized to improve development efficiency and application performance. The integration of the SSM framework is the integration of the Spring, Spring MVC, and MyBatis frameworks to form a complete web application development framework. The integration of the SSM framework can help developers more easily develop and maintain web applications while improving the performance and scalability of the application. In the SSM framework, the Spring framework can manage the lifecycle of Java objects and implement features such as dependency injection and dependency lookup; Spring MVC framework can help developers quickly develop web applications and provide useful features such as data binding, form validation, file uploading, and exception handling; MyBatis framework can help developers map Java objects to database tables and provide advanced features such as caching, batch processing, and pagination.

Spring Boot is an open-source Java framework that helps developers quickly build web applications based on the Spring framework, and has the characteristics of efficiency, simplicity, and speed. Spring Boot simplifies development through automatic configuration. Spring Boot comes with embedded web servers such as Tomcat, Jetty, and Undertow, making it easier for developers to build web applications. Spring Boot also provides some simple Maven configurations, allowing developers to build and deploy applications more quickly. In summary, Spring Boot is an extension of the Spring framework, but it is not a replacement for Spring. It is a layer of encapsulation on top of Spring, and choosing Spring Boot is more suitable for rapid development and deployment.

MyBatis Plus is an enhancement tool for MyBatis. It is a fast development framework based on MyBatis, which provides more convenient operations for MyBatis, enabling developers to perform database operations more efficiently. MyBatis Plus also provides many features, such as automatic code generation, pagination plugin, logical deletion, performance analysis plugin, etc., with automatic code generation being the most commonly used feature.