整个写代码的流程
1.创建一个maven
2.add Framework support
3.配置pom 添加依赖jar包
4.project Structure->Artificts->WEB-INFO下面新建一个lib文件,把依赖添加至maven项目中
5.搭建项目的整体框架并撰写代码
6.resource下新建一个xml配置文件
(1) 添加支持spring框架的依赖
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd">
(2) 开启扫描包
<context:component-scan base-package="com.bky"></context:component-scan>
(3)支持MVC的注解驱动
<mvc:annotation-driven />
(4) 拦截静态资源
mvc:default-servlet-handler/
(5)配置MVC视图解析器 配置前缀配置后缀
<bean id="nternalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 配置前缀-->
<property name="prefix" value="/jsp/"></property>
<!-- 配置后缀-->
<property name="suffix" value=".jsp"></property>
</bean>
User.java
package com.bky.beans;
public class User {
private String username;
private String passWord;
public User(String username, String passWord) {
this.username = username;
this.passWord = passWord;
}
public User() {
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassWord() {
return passWord;
}
public void setPassWord(String passWord) {
this.passWord = passWord;
}
@Override
public String toString() {
return "User{" +
"username='" + username + '\'' +
", passWord='" + passWord + '\'' +
'}';
}
}
UserController .java
package com.bky.controller;
import com.bky.beans.User;
import com.bky.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import java.util.List;
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/list")
public String getList(Model model){
//我们需要把User类型的数据返回前端,
// 那么就不是从前端接收数据,所以参数不要User 只有model
List<User> list = userService.getList();
model.addAttribute("userlist",list);
return "list";
}
}
UserDao .java
package com.bky.dao;
import com.bky.beans.User;
import java.util.List;
public interface UserDao {
public List <User> getList();
}
UserDaoImpl .java
package com.bky.dao.impl;
import com.bky.beans.User;
import com.bky.dao.UserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public class UserDaoImpl implements UserDao {
@Autowired
private JdbcTemplate jdbcTemplate;
public List<User> getList() {
List<User> query
= jdbcTemplate.query("select * from t_user", new BeanPropertyRowMapper<User>(User.class));
return query;
}
}
UserService .jaba
package com.bky.service;
import com.bky.beans.User;
import java.util.List;
public interface UserService {
public List<User> getList();
}
UserServiceImpl .java
package com.bky.service.impl;
import com.bky.beans.User;
import com.bky.dao.UserDao;
import com.bky.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
public List<User> getList() {
return userDao.getList();
}
}
UserTest_mvc.java
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!-- 开启扫描包-->
<context:component-scan base-package="com.bky"></context:component-scan>
<!-- 支持MVC的注解驱动-->
<mvc:annotation-driven />
<!-- 拦截静态资源-->
<mvc:default-servlet-handler/>
<!-- 配置MVC视图解析器-->
<bean id="nternalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 配置前缀-->
<property name="prefix" value="/jsp/"></property>
<!-- 配置后缀-->
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 配置jdbctemplate-->
<bean class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="source"></property>
</bean>
<!-- 配置连接数据库的信息-->
<bean id="source" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<!-- 注入数据源信息-->
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/test01"></property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</bean>
</beans>
list.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<table border="1px">
<tr>
<th>用户名</th>
<th>密码</th>
</tr>
<c:forEach var="user" items="${userlist}">
<tr>
<td>${user.username}</td>
<td>${user.passWord}</td>
</tr>
</c:forEach>
</table>
</body>
</html>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<!-- 配置前端总控制器-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 绑定spring核心容器-->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:UserTest_mvc.xml</param-value>
</init-param>
<!-- 设置启动级别-->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
pom.xml
<?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>org.example</groupId>
<artifactId>UserSpring</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.1.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.1.2.RELEASE</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.28</version>
</dependency>
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.1.2.RELEASE</version>
</dependency>
</dependencies>
</project>
整体框架
最后结果
遇到的问题
description The server encountered an internal error that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Servlet.init() for servlet dispatcherServlet threw exception
我重新创建一个项目并把原本的代码copy上去,就解决了
可是是包冲突的问题