Technology Stack

Backend Framework: Spring Boot

Spring Boot enables rapid development of production-ready Spring applications with minimal configuration. It follows convention-over-configuration principles, reducing setup complexity. Key features include embedded servlet containers like Tomcat or Jetty, allowing direct application execution without WAR file deployment. Automatic configuration eliminates extensive XML setup, streamlining development.

Frontend Framework: Vue.js

Vue.js is a progressive JavaScript framework for building interactive user interfaces. It utilizes a component-based architecture to create reusable UI elements, facilitating the development of single-page aplications. Vue.js offerrs reactive data binding, where UI updates automatically reflect data changes, and a virtual DOM for optimized rendering performance. Its ecosystem includes tools like Vue Router for navigation and Vuex for state management.

Database: MySQL

MySQL is a widely-used relational database management system known for its reliability and performance. It supports standard SQL for data manipulation and offers multiple storage engines, such as InnoDB and MyISAM, to cater to different application needs. MySQL is cross-platform compatible, running on operating systems like Windows, Linux, and Unix.

Core Configuration and Code Examples

Application Configuration File

This YAML configuration sets up the Spring Boot application with database connectivity and MyBatis-Plus settings.

server:
  tomcat:
    uri-encoding: UTF-8
  port: 8080
  servlet:
    context-path: /clinic-system

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/clinic_db?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
    username: admin
    password: securepass
  servlet:
    multipart:
      max-file-size: 300MB
      max-request-size: 300MB
  resources:
    static-locations: classpath:static/,file:static/

mybatis-plus:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.clinic.entity
  global-config:
    id-type: 1
    field-strategy: 1
    db-column-underline: true
    logic-delete-value: -1
    logic-not-delete-value: 0
  configuration:
    map-underscore-to-camel-case: true
    cache-enabled: false
    call-setters-on-nulls: true

Data Access Layer Mapping

This XML mapper defines SQL operasions for employee data management using MyBatis.

<?xml version="1.0" encoding="UTF-8"?>
<mapper namespace="com.clinic.dao.EmployeeDao">
    <resultMap id="employeeResultMap" type="com.clinic.entity.Employee">
        <result property="employeeId" column="employee_id"/>
        <result property="password" column="password"/>
        <result property="fullName" column="full_name"/>
        <result property="gender" column="gender"/>
        <result property="position" column="position"/>
        <result property="age" column="age"/>
        <result property="hireDate" column="hire_date"/>
        <result property="contactNumber" column="contact_number"/>
        <result property="email" column="email"/>
        <result property="idCard" column="id_card"/>
    </resultMap>

    <select id="selectEmployeeList" resultType="com.clinic.vo.EmployeeVO">
        SELECT * FROM employee
        <where>
            <if test="condition != null">
                ${condition}
            </if>
        </where>
    </select>

    <select id="selectEmployeeById" resultType="com.clinic.vo.EmployeeVO">
        SELECT * FROM employee WHERE employee_id = #{id}
    </select>

    <select id="selectEmployeeView" resultType="com.clinic.view.EmployeeView">
        SELECT * FROM employee
        <where>
            <if test="filter != null">
                ${filter}
            </if>
        </where>
    </select>
</mapper>