该博客把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>