SpringServelt

该博客把Web开发流程展现的淋漓尽致！

1.在开发Web应用一般应先配置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.ping</groupId>
    <artifactId>SpringServlet</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>
    <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>

        <!--
            servlet/ jsp/  jstl el / mysql /dbcp
            log4j, db.properties
        -->
        <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.1</version>
            <scope>provided</scope>
        </dependency>

        <!-- https://mvnrepository.com/artifact/javax.servlet.jsp/jsp-api -->
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.2</version>
            <scope>provided</scope>
        </dependency>

        <!-- https://mvnrepository.com/artifact/javax.el/javax.el-api -->
        <dependency>
            <groupId>javax.el</groupId>
            <artifactId>javax.el-api</artifactId>
            <version>3.0.0</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/javax.servlet/jstl -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>

    </dependencies>

    <build>
        <finalName>jsjprojects</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>

2.应配置Tomcat

3.连接数据库（tools）：

package com.ping.tools;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class getConnection {
    private Connection connection;
    private PreparedStatement preparedStatement;
    private ResultSet resultSet;
    private String username = "root";
    private String password = "wzp961208";
    private String url = "jdbc:mysql://localhost:3306/user";
    private String driver = "com.mysql.jdbc.Driver";

    public Connection getConnection() {
        try {
            Class.forName(driver);
            connection = DriverManager.getConnection(url, username, password);

        } catch (Exception e) {
            e.printStackTrace();
        }
        return connection;
    }

    public int updataMethod(String sql) {
        int flag = 0;
        try {
            connection = this.getConnection();
            preparedStatement = connection.prepareStatement(sql);
            flag = preparedStatement.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return flag;
    }

    public ResultSet queryMethod(String sql) {
        try {
            connection = this.getConnection();
            preparedStatement = connection.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery();

        } catch (Exception e) {
            e.printStackTrace();
        }
        return resultSet;
    }

    public void closeDB() {
        try {
            if (resultSet != null) {
                resultSet.close();
            }
            if (preparedStatement != null) {
                preparedStatement.close();
            }
            if (connection != null) {
                connection.close();
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

3.建立模型即（PO层）

package com.ping.po;
public class users {
private  Integer   userId;
private  String  userName;
private  String  userAddr;
 public users(){

 }
    public Integer getUserId() {
        return userId;
    }

    public void setUserId(Integer userId) {
        this.userId = userId;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getUserAddr() {
        return userAddr;
    }

    public void setUserAddr(String userAddr) {
        this.userAddr = userAddr;
    }

    @Override
    public String toString() {
        return "users{" +
                "userId=" + userId +
                ", userName='" + userName + '\'' +
                ", userAddr='" + userAddr + '\'' +
                '}';
    }
}

4.建立持久层（dao)

package com.ping.dao;
import com.ping.po.users;
import com.ping.tools.getConnection;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class usersDao {
    public List<users> queryListUser() {
        String sql = " select * from users";
        try {
            ResultSet resultSet = new getConnection().queryMethod(sql);
            List<users> list = new ArrayList<>();
            while (resultSet.next()) {
                users user = new users();
                user.setUserId(resultSet.getInt("userId"));
                user.setUserName(resultSet.getString("userName"));
                user.setUserAddr(resultSet.getString("userAddr"));
                list.add(user);
            }
            return list;

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

    }
}

5.建立service层

package com.ping.service;
import com.ping.po.users;
import java.util.List;
public interface usersService {
    public List<users> queryListUser();
}
package com.ping.service;
import com.ping.dao.usersDao;
import com.ping.po.users;
import java.util.List;
public class usersServiceImp implements  usersService {
     private usersDao usersdao;
    @Override
    public List<users> queryListUser() {
       return usersdao.queryListUser();
    }
}

6.建立控制层（controller）

package com.ping.controler;
import com.ping.po.users;
import com.ping.service.usersService;
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;
import java.util.List;
public class UserListController extends HttpServlet {
    private usersService usersservice;
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       //1.获取表单参数
        //2. 调用业务逻辑
        List<users> userlist=null;
        try{
            userlist=usersservice.queryListUser();

        }catch(Exception e){
            e.printStackTrace();
        }
        //3.转向
        request.setAttribute("userListKey",userlist);
       request.getRequestDispatcher("show.jsp").forward(request,response);
    }
}

7.建立视图层（view)

<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<table border="1" width="100%">
    <tr>
        <td>userId</td>
        <td>userName</td>
        <td>userAddr</td>
    </tr>
    <c:forEach items="${userListKey}" var="user">
        <td>${user.userId}</td>
        <td>${user.userName}</td>
        <td>${user.userAddr}</td>
    </c:forEach>

</table>
</body>
</html>