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>com.example</groupId>
<artifactId>demo</artifactId>
<version>1</version>
<packaging>jar</packaging>
<name>demo</name>
<description>Demo project for Spring Boot</description>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.3.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!--当引入jdbc依赖之后,Spring Boot会自动默认分别注入DataSourceTransactionManager或JpaTransactionManager,
所以我们不需要任何额外配置就可以用@Transactional注解进行事务的使用。-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!--jstl标签-->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--Spring Boot 对jsp页面的支持(映入这两个依赖后就不会出现访问jsp页面是jsp源码的问题了)-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-tomcat</artifactId>
<!--<scope></scope>不要写,否则会出现奇奇怪怪的问题!!!-->
</dependency>
<dependency>
<groupId>org.apache.tomcat.embed</groupId>
<artifactId>tomcat-embed-jasper</artifactId>
<!--
<scope></scope>
不要写,否则会出现奇奇怪怪的问题!!!-->
</dependency>
<!--对thymeleaf的支持-->
<!--<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>-->
<!--数据库连接池-->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.2.1</version>
</dependency>
<dependency>
<groupId>com.mchange</groupId>
<artifactId>mchange-commons-java</artifactId>
<version>0.2.3.4</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.0.4.RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.0</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<!--MyBatis 官方对Spring Boot的支持
使用方法:直接在properties文件配置MyBatis-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>org.junit.jupiter</groupId>
<artifactId>junit-jupiter-api</artifactId>
<version>5.0.0</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-test</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.0.4.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>5.0.4.RELEASE</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.0.4.RELEASE</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<!--poi操作的jar包-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.10.1</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
<resources>
<!-- 打包时将jsp文件拷贝到META-INF目录下-->
<resource>
<!-- 指定resources插件处理哪个目录下的资源文件 -->
<directory>src/main/webapp</directory>
<!--注意此次必须要放在此目录下才能被访问到-->
<targetPath>META-INF/resources</targetPath>
<includes>
<include>**/**</include>
</includes>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/**</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
</build>
</project>
配置文件
#jdbc
#别名
mybatis.type-aliases-package=com.example.bean
#直接配置MyBatis
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql:///zdyfy?characterEncoding=utf8&useSSL=true
spring.datasource.username=root
spring.datasource.password=mysql
#拦截规则
#server.servlet.context-path=/demo
#视图解析器
spring.mvc.view.prefix=/
spring.mvc.view.suffix=.jsp
使用mysql的时候注意,有时候会因为时区的问题,导致连不上数据库,此时需要设置时区为东八区
url后面追加serverTimezone=GMT%2B8
mysql中设置
set global time_zone='+8:00'
实体类
package com.example.bean;
import org.springframework.stereotype.Component;
@Component
public class Emplyee {
private Integer id;
private String name;
private String logname;
private String logpass;
private String realname;
private String address;
private String idcard;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name == null ? null : name.trim();
}
public String getLogname() {
return logname;
}
public void setLogname(String logname) {
this.logname = logname == null ? null : logname.trim();
}
public String getLogpass() {
return logpass;
}
public void setLogpass(String logpass) {
this.logpass = logpass == null ? null : logpass.trim();
}
public String getRealname() {
return realname;
}
public void setRealname(String realname) {
this.realname = realname == null ? null : realname.trim();
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address == null ? null : address.trim();
}
public String getIdcard() {
return idcard;
}
public void setIdcard(String idcard) {
this.idcard = idcard == null ? null : idcard.trim();
}
@Override
public String toString() {
return "Emplyee{" +
"id=" + id +
", name='" + name + '\'' +
", logname='" + logname + '\'' +
", logpass='" + logpass + '\'' +
", realname='" + realname + '\'' +
", address='" + address + '\'' +
", idcard='" + idcard + '\'' +
'}';
}
}
mapper 接口
package com.example.mapper;
import com.example.bean.Emplyee;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface EmplyeeMapper {
@Select("select * from emplyee\n" +
" where id = #{id}")
Emplyee selectByPrimaryKey(Integer id);
@Select(" select * from emplyee\n" +
" where logname = #{logname}\n" +
" and logpass=#{logpass}")
Emplyee seleteEmpByNamePass(Emplyee u);
@Select("select * from emplyee")
List<Emplyee> selectAll();
}
service接口
import com.example.bean.Emplyee;
import java.util.List;
public interface UserService {
/**
* 查询所有人
*
* @return
*/
List<Emplyee> selectAll();
}
实现类
@Service
public class UserServiceImpl implements UserService {
@Resource
private EmplyeeMapper emplyeeMapper;
@Override
public List<Emplyee> selectAllUser() {
return emplyeeMapper.selectAllEmp();
}
}
controller
@Controller
@RequestMapping("*.do")
public class UserController {
@Resource
private UserService userService;
@RequestMapping("/selectAll")
public String selectAll(HttpServletRequest request){
List<Emplyee> users=userService.selectAllUser();
request.getSession().setAttribute("users",users);
return "selectAll";
}
}
selectAll.jsp页面
<%--
Created by IntelliJ IDEA.
User: Administrator
Date: 2018/7/12
Time: 13:56
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>测试显示</title>
</head>
<body>
<table border="1px solid red" >
<tr>
<td>姓名</td>
<td>角色</td>
<td>登录账号</td>
</tr>
<c:forEach var="u" items="${users}">
<tr>
<td> ${u.name}</td>
<td> ${u.realname}</td>
<td> ${u.logname}</td>
</tr>
</c:forEach>
</body>
</html>
查看结果
刚开始是无法直接建立jsp文件的,需要配置之后才能建立jsp
设置JSp的模板