JavaWeb案例整体分析---》差旅费报销管理信息系统->>数据库操作和Mybatis配置以及pom.xml

数据库操作

CREATE TABLE ter_businessapply(
    id VARCHAR(8) PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
		position VARCHAR(50) NOT NULL,
    department VARCHAR(50) NOT NULL,
    destination VARCHAR(100) NOT NULL,
    departure_date varchar(30) NOT NULL,
    return_date varchar(30) NOT NULL,
    type varchar(30) NOT NULL,
    type_content VARCHAR(255),
    reason varchar(100) NOT NULL,
    state VARCHAR(30) NOT NULL,
    state_reason varchar(100),
		applytime varchar(30)
		
);

create TABLE ter_reimburse(
	  id VARCHAR(8) PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
		position VARCHAR(50) NOT NULL,
		yearsold int NOT NULL,
    department VARCHAR(50) NOT NULL,
    destination VARCHAR(100) NOT NULL,
    departure_date varchar(30) NOT NULL,
    return_date varchar(30) NOT NULL,
    reason varchar(100) NOT NULL,
    start_fare DOUBLE NOT NULL,
    return_fare DOUBLE NOT NULL,
    food_allowance DOUBLE NOT NULL,
    local_trans DOUBLE NOT NULL,
    accommodation DOUBLE NOT NULL,
    total_amount DOUBLE NOT NULL,
    schedule VARCHAR(30) NOT NULL,
    schedule_reason varchar(100),
		applytime varchar(30) NOT NULL
		
);

create TABLE ter_user(
    id  int primary key auto_increment,
		username varchar(30),
		password varchar(30),
		position varchar(30),
		department VARCHAR(50) 

);

create table ter_employeeinfo(
user_id VARCHAR(8) PRIMARY KEY,
    user_name VARCHAR(50) NOT NULL,
    department VARCHAR(50) NOT NULL,
    position ENUM('普通职员', '部门经理', '总经理', '财务人员') NOT NULL

);

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!--起别名-->
    <typeAliases>
        <package name="com.Moonbeams.pojo"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql:///db1?useSSL=false&amp;allowPublicKeyRetrieval=true&amp;useServerPrepStmts=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=Asia/Shanghai"/>
                <property name="username" value="用户名"/>
                <property name="password" value="密码"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--扫描mapper-->
        <package name="com.Moonbeams.mapper"/>
        <!--如果不扫描则加载映射文件-->
        <!--<mapper resource="Moonbeams/mapper/XXX.xml"/>-->

    </mappers>
</configuration>

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>org.example</groupId>
  <artifactId>travelAllowance</artifactId>
  <packaging>war</packaging>
  <version>1.0-SNAPSHOT</version>


  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    <maven.compiler.source>8</maven.compiler.source>
    <maven.compiler.target>8</maven.compiler.target>
  </properties>

  <dependencies>
    <!-- mybatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.16</version>
    </dependency>

    <!--mysql 驱动-->
    <!-- https://mvnrepository.com/artifact/com.mysql/mysql-connector-j -->
    <dependency>
      <groupId>com.mysql</groupId>
      <artifactId>mysql-connector-j</artifactId>
      <version>9.1.0</version>
    </dependency>
    <!--servlet-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>3.1.0</version>
      <scope>provided</scope>
    </dependency>

    <!--jsp-->

    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.2</version>
      <scope>provided</scope>
    </dependency>

    <!--jstl-->
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
    <!--    <dependency>-->
    <!--      <groupId>taglibs</groupId>-->
    <!--      <artifactId>standard</artifactId>-->
    <!--      <version>1.1.2</version>-->
    <!--    </dependency>-->


  </dependencies>

  <build>
    <plugins>
      <plugin>
        <groupId>org.apache.tomcat.maven</groupId>
        <artifactId>tomcat7-maven-plugin</artifactId>
        <version>2.2</version>
      </plugin>
    </plugins>
  </build>

</project>