将普通web项目改为Maven工程

1.改为maven项目(project/module）

1.1首先新建一个Maven项目

如图所示，然后一路next完成创建
2.2创建module
File–>new–>module

选择图中所示的选项
2.3导入代码，创建目录

图示为创建完成后的目录结构，当创建完之后是没有java目录和target目录的需要自行创建，之后设置java为源目录，target目录在输入名字之后会自动变成橙色，无需设置。然后将作业管理系统中的代码放入java目录中，将jsp，res网页元素放入webapp文件夹。
2.5导入依赖

<?xml version="1.0" encoding="UTF-8"?>

<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/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>Project</artifactId>
        <groupId>Project</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>ManageSystem</artifactId>
    <packaging>war</packaging>

    <name>ManageSystem Maven Webapp</name>
    <!-- FIXME change it to the project's website -->
    <url>http://www.example.com</url>

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

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>

<!--        <dependency>-->
<!--            <groupId>mysql</groupId>-->
<!--            <artifactId>mysql-connector-java</artifactId>-->
<!--            <version>8.0.19</version>-->
<!--        </dependency>-->

        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
        </dependency>

        <dependency>
            <groupId>com.zaxxer</groupId>
            <artifactId>HikariCP</artifactId>
            <version>3.4.2</version>
        </dependency>



    </dependencies>

    <build>
        <finalName>ManageSystem</finalName>
        <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
            <plugins>
                <plugin>
                    <artifactId>maven-clean-plugin</artifactId>
                    <version>3.1.0</version>
                </plugin>
                <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
                <plugin>
                    <artifactId>maven-resources-plugin</artifactId>
                    <version>3.0.2</version>
                </plugin>
                <plugin>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <version>3.8.0</version>
                </plugin>
                <plugin>
                    <artifactId>maven-surefire-plugin</artifactId>
                    <version>2.22.1</version>
                </plugin>
                <plugin>
                    <artifactId>maven-war-plugin</artifactId>
                    <version>3.2.2</version>
                </plugin>
                <plugin>
                    <artifactId>maven-install-plugin</artifactId>
                    <version>2.5.2</version>
                </plugin>
                <plugin>
                    <artifactId>maven-deploy-plugin</artifactId>
                    <version>2.8.2</version>
                </plugin>
            </plugins>
        </pluginManagement>
    </build>
</project>

导入HikariCP和javax.servlet依赖，（注意如果使用HikariCP不要导入jdbc依赖,第三部分有详细说明)

2.6配置tomcat

设置tomcat的路径

部署项目
然后就可以运行成功了

2.添加数据库连接池

2.1创建数据库连接池

package com.code.jdbc;

import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;

public class DatabasePool {
    private static HikariDataSource hikariDataSource;

    public static HikariDataSource getHikariDataSource(){
        if(hikariDataSource !=null){
            return hikariDataSource;
        }
        synchronized (DatabasePool.class){
            if (hikariDataSource == null){

                String url = "jdbc:mysql://127.0.0.1:3306/school?serverTimezone=UTC";
                HikariConfig hikariConfig = new HikariConfig();

                hikariConfig.setUsername("root");
                hikariConfig.setPassword("123456");
                hikariConfig.setJdbcUrl(url);
                hikariDataSource = new HikariDataSource(hikariConfig);

                return hikariDataSource;
            }
        }
        return null;
    }

}

2.2在控制类中使用
ConnectMysql()方法

package com.code.jdbc;

import java.sql.*;

public class JDBCControll {
    public void setStatment(Statement statment) {
        this.statment = statment;
    }

    public void setResultSet(ResultSet resultSet) {
        this.resultSet = resultSet;
    }

    private Connection connection;
    private Statement statment;
    private ResultSet resultSet;

    public Connection getConnection() {
        return connection;
    }

    public Statement getStatment() {
        return statment;
    }

    public ResultSet getResultSet() {
        return resultSet;
    }



    public  String ConnectMysql(){
        //原始连接方法
//        String url = "jdbc:mysql://127.0.0.1:3306/school?serverTimezone=UTC";
//        String driveName = "com.mysql.cj.jdbc.Driver";
//
//        try{
//            Class.forName(driveName);
//            connection = DriverManager.getConnection(url,"root","123456");
//            statment = connection.createStatement();

//        } catch (ClassNotFoundException e) {
//            e.printStackTrace();
//        } catch (SQLException e) {
//            e.printStackTrace();
//        }
//        return null;
        //改为数据库连接池后的连接方法
        try {
            connection = DatabasePool.getHikariDataSource().getConnection();
            statment = connection.createStatement();

        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    public ResultSet excuteSQL(String sqlString){
        ConnectMysql();
        try {
            resultSet = statment.executeQuery(sqlString);
            return resultSet;
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return null;

    }

    public boolean excuteUpdateSQL(String sqlString){
        ConnectMysql();
        try {
            boolean flag =  statment.execute(sqlString);

            return true;

        } catch (SQLException e) {
            e.printStackTrace();
           return false;
        }

    }


    public void closeMysql(){
        try {
            if(resultSet!=null)
                resultSet.close();
            if(statment!=null)
                statment.close();
            if(connection!=null)
                connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
}

3.常见错误

3.1未导入javax.servlet包

 <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
  </dependency>

导入javax.servlet包
3.2 HikariCP无法生成驱动实例

<dependency>
     <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
     <version>8.0.19</version>
 </dependency>

使用HikariCP一定要移除jdbc依赖，否则会报上述错误。