使用idea创建maven web项目

使用idea创建maven web项目

项目下载地址：解压后的 demo05

1、环境准备

开发环境：idea 2020.1.1，jdk 1.8，maven3.6.0（jdk安装教程）（idea2020.1.1安装教程）
(maven的安装配置)

数据库

create database demo;
use demo;
create table user
(
    id       int auto_increment
        primary key,
    username varchar(20) null,
    gender   varchar(1)  null,
    age      int(3)      null
);

2、创建项目

选择模板

设置项目名，位置及组织包名

选择maven版本

补充目录结构

将这两个补上

创建如下的目录结构

3、代码编写

UserServlet

package com.mystery.controller;

import com.mystery.service.IUserService;
import com.mystery.service.impl.UserServiceImpl;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebServlet("/hello")
public class UserServlet extends HttpServlet {

    IUserService iUserService = new UserServiceImpl();

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request,response);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");

        String username = iUserService.getUserName(1);

        request.setAttribute("username",username);

        //转发
        request.getRequestDispatcher("/WEB-INF/jsp/index.jsp").forward(request,response);
    }
}

IUserService

public interface IUserService {
    /*获取用户名*/
    String getUserName(Integer id);
}

UserServiceImpl

public class UserServiceImpl implements IUserService {
    private UserDao userDao = new UserDao();

    /*获取用户名*/
    @Override
    public String getUserName(Integer id) {
        return userDao.getUserName(id);
    }
}

UserDao

public class UserDao {

    /*获取用户名*/
    public String getUserName(Integer id) {

        /*获取连接数据库的五步操作*/
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;
        List<User> list = new ArrayList();
        User user = new User();
        try {
            /*1,加载驱动，在jdk1.6之后可以省略这一步*/
            Class.forName("com.mysql.jdbc.Driver");
            /*2,获取连接*/
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/demo","root","root");
            /*3,编译SQL*/
            String sql = "select username from user where id = ? ";
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setInt(id,id);
            /*4,执行SQL*/
            resultSet = preparedStatement.executeQuery();
            /*5,处理结果集*/
            while(resultSet.next()){

                user.setUsername(resultSet.getString(1));
                list.add(user);
            }


        } catch (SQLException | ClassNotFoundException throwables) {
            throwables.printStackTrace();
        } finally {
            /*释放资源,不作非空判断了*/
            try {
                if (resultSet!=null){
                    resultSet.close();
                }
                if(preparedStatement!=null){
                    preparedStatement.close();
                }
                if(connection!=null){
                    connection.close();
                }
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        return user.getUsername();
    }
}

User

public class User {
    private Integer id;
    private String username;
    private String gender;
    private Integer age;

    public User() {
    }

    public User(Integer id, String username, String gender, Integer age) {
        this.id = id;
        this.username = username;
        this.gender = gender;
        this.age = age;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", gender='" + gender + '\'' +
                ", age=" + age +
                '}';
    }
}

jsp/index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page isELIgnored="false" %>
<html>
<head>
    <title>javaweb</title>
</head>
<body>

    ${username}

</body>
</html>

pom文件配置

<?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">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.mystery</groupId>
    <artifactId>demo05</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <name>demo05 Maven Webapp</name>

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

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.0</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>
    </dependencies>

    <!--************************************************-->
    <build>
        <!--文件打包名称-->
        <finalName>demo05</finalName>
        <plugins>
            <plugin>
                <groupId>org.apache.tomcat.maven</groupId>
                <artifactId>tomcat7-maven-plugin</artifactId>
                <version>2.2</version>
                <configuration>
                    <!--maven默认的是tomcat7，在maven的配置文件中配置了tomcat8，这里可以省略删除-->
                    <version>tomcat8</version>
                    <!--项目访问的端口号-->
                    <port>80</port>
                    <!--项目访问的名称-->
                    <path>/demo05</path>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

运行


配置完点击三角形绿色按钮即可运行
地址栏输入：

http://localhost/demo05/hello