关于SpringBoot+SpringMVC+Mybatis+Oracle

关于SpringBoot+SpringMVC+Mybatis+Oracle（不支持JSP需依赖）

关于各类文件的位置

applocation.properties配置文件

#编码格式
spring.http.encoding.force=true
spring.http.encoding.charset=UTF-8
spring.http.encoding.enabled=true
server.tomcat.uri-encoding=UTF-8
#热部署生效
spring.devtools.restart.enabled: true
#设置重启的目录
spring.devtools.restart.additional-paths: src/main/java
#classpath目录下的WEB-INF文件夹内容修改不重启
spring.devtools.restart.exclude: WEB-INF/**
#JSP自定义访问路径的默认配置
spring.mvc.view.prefix: /WEB-INF/jsp/
spring.mvc.view.suffix: .jsp
#映射文件路径
mybatis.mapperLocations=classpath:mapper/*.xml
#mysql/Oracle数据库连接
#spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
#spring.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl
#spring.datasource.username=scgcxx
#spring.datasource.password=scgcxx

#Druid配置 数据库连接
spring.datasource.druid.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.druid.url=jdbc:oracle:thin:@localhost:1521:orcl
spring.datasource.druid.username=scgcxx
spring.datasource.druid.password=scgcxx

# 下面为Druid连接池的补充设置，应用到上面所有数据源中
spring.datasource.druid.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.initialSize=5
spring.datasource.druid.minIdle=5
spring.datasource.druid.maxActive=20
# 配置获取连接等待超时的时间
spring.datasource.druid.maxWait=60000
# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
spring.datasource.druid.timeBetweenEvictionRunsMillis=60000
# 配置一个连接在池中最小生存的时间，单位是毫秒
spring.datasource.druid.minEvictableIdleTimeMillis=300000
spring.datasource.druid.validationQuery=SELECT 1 FROM DUAL
spring.datasource.druid.testWhileIdle=true
spring.datasource.druid.testOnBorrow=false
spring.datasource.druid.testOnReturn=false
spring.datasource.druid.poolPreparedStatements=true
spring.datasource.druid.maxPoolPreparedStatementPerConnectionSize=20
# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
spring.datasource.filters=stat,wall,log4j2
spring.datasource.logSlowSql=true
spring.datasource.useGlobalDataSourceStat=true
# pagehelper分页配置
pagehelper.helper-dialect=oracle
pagehelper.reasonable=true

logging.level.com.johe.scgcxx.dao=trace

SaftyLoginDao.mapper配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
 PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.johe.scgcxx.dao.safty.SaftyLoginDao">

	<select id="getUser" resultType="com.johe.scgcxx.model.Sys_User">
		select * from sys_user where u_name =#{u_name} and u_pwd = #{u_pwd}
	</select>

</mapper>

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>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.3.RELEASE</version>
		<relativePath /> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.example</groupId>
	<artifactId>scgcxx</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>war</packaging>
	<name>scgcxx</name>
	<description>Demo project for Spring Boot</description>

	<properties>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.0.0</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>com.oracle</groupId>
			<artifactId>ojdbc6</artifactId>
			<version>12.1.0.1-atlassian-hosted</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-devtools</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-tomcat</artifactId>
			<scope>provided</scope>
		</dependency>

		<dependency>
			<groupId>org.apache.tomcat.embed</groupId>
			<artifactId>tomcat-embed-jasper</artifactId>
		</dependency>
		<!-- https://mvnrepository.com/artifact/jstl/jstl -->
		<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>

		<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper-spring-boot-starter -->
		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper-spring-boot-starter</artifactId>
			<version>1.2.10</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/com.alibaba/druid 该依赖需求DataSource转换-->
		<!-- <dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.1.13</version>
		</dependency> -->

		<!-- https://mvnrepository.com/artifact/com.alibaba/druid-spring-boot-starter -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>1.1.14</version>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-configuration-processor</artifactId>
			<optional>true</optional>
		</dependency>
		<!-- @ConfigurationProperties注解需求 依赖   此处用于DataSource配置 -->
		<!-- <dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-configuration-processor</artifactId>
			<optional>true</optional>
		</dependency> -->
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

SaftyHome.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport"
	content="width=device-width, initial-scale=1, shrink-to-fit=no">
<title>生产过程信息系统</title>
<link rel="stylesheet" href="../../css/bootstrap.min.css" />
<style type="text/css">
html {
	height: 100%;
}

body {
	margin: 0px;
	/*外边距*/
	padding: 0px;
	/*内边距*/
	height: 100%;
}

.my-container {
	width: 100%;
	height: 100%;
	background-color: #EEEEEE;
	position: relative;
}

#top {
	box-sizing: border-box;
	position: absolute;
	left: 0px;
	top: 0px;
	width: 100%;
	height: 50px;
	background-color: #112255;
	/*字体设置*/
	color: #CCCCCC;
	font-size: 26px;
	font-weight: bold;
	line-height: 50px;
	font-family: "微软雅黑";
	padding-left: 5px;
}

#left {
	position: absolute;
	left: 0px;
	top: 50px;
	bottom: 30px;
	width: 150px;
	background-color: #C0C0C0;
}

#right {
	position: absolute;
	left: 150px;
	right: 0px;
	top: 50px;
	bottom: 30px;
	background-color: white;
}

#right iframe {
	width: 100%;
	height: 100%;
	border: none;
}

#foot {
	position: absolute;
	left: 0px;
	bottom: 0px;
	height: 30px;
	width: 100%;
	background-color: #112255;
	/*&copy;*/
	color: #CCCCCC;
	font-size: 15px;
	font-weight: bold;
	line-height: 20px;
	font-family: "微软雅黑";
	padding-left: 35%;
}

.my-curr-user {
	position: absolute;
	right: 5px;
	bottom: 5px;
	font-size: 14px;
	line-height: 20px;
	padding-bottom: 10px;
	cursor: pointer;
	/*鼠标手型*/
}

.left-menu {
	margin-top: 30px;
	margin-left: 20px;
}

.left-menus {
	margin-top: 10px;
	margin-left: 20px;
	height: 30px;
	width: 110px;
	font-size: 12px;
}

.left-menus:hover {
	color: white;
	font-weight: bold;
}
</style>
</head>

<body>
	<div class="my-container">
		<div id="top">
			生产过程信息系统
			<div class="my-curr-user dropdown">
				<span class="dropdown-toggle" data-toggle="dropdown">当前用户：XXX</span>
				<div class="dropdown-menu dropdown-menu-right">
					<a class="dropdown-item" href="#">修改密码</a> <a class="dropdown-item"
						href="../../safty/login/toLogin">退出系统</a>
				</div>
			</div>
		</div>
		<div id="left">
			<div class="left-menu btn btn-secondary" data-toggle="collapse"
				href=".manage-anquan">安全管理</div>
			<a class="btn btn-primary left-menus collapse manage-anquan"
				data-parent="#left">角色管理 </a>
			<a class="btn btn-primary left-menus collapse manage-anquan"
				data-parent="#left">用户管理 </a>

			<div class="left-menu btn btn-secondary" data-toggle="collapse"
				href=".massage-jichu">基础信息管理</div>
			<a class="btn btn-primary left-menus collapse massage-jichu"
				data-parent="#left" href="../../info/customer/toList" target="right-iframe"> 客户信息维护</a>
			<a class="btn btn-primary left-menus collapse massage-jichu"
				data-parent="#left" href="../../info/color/toList" target="right-iframe"> 花色号维护 </a>
			<a class="btn btn-primary left-menus collapse massage-jichu"
				data-parent="#left" href="../../info/standard/toList" target="right-iframe"> 产品规格维护 </a>
		</div>
		<div id="right">
			<iframe name="right-iframe"></iframe>
		</div>
		<div id="foot">版权所有 &copy;西安腾瑞软件开发有限公司</div>
	</div>
</body>
	<script type="text/javascript" src="../../js/jquery-3.3.1.min.js" ></script>
	<script type="text/javascript" src="../../js/popper.min.js"></script>
	<script type="text/javascript" src="../../js/bootstrap.min.js"></script>

</html>

SaftyLogin.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<script>
	if (self != top)
		top.location = '/safty/login/toLogin';
</script>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>JSP登录首页</title>
</head>
<body>
	<form action="doLogin" method="post">
		请输入用户名：<input type="text" name="u_name">
		<br>
		请输入密　码：<input type="password" name="u_pwd">
		<br>
		<input type="submit" value="登录"> 
	</form>
</body>
</html>

ScgcxxApplication.java

package com.johe.scgcxx;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.web.servlet.config.annotation.ViewControllerRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;

@SpringBootApplication
@MapperScan("com.johe.scgcxx.dao")
public class ScgcxxApplication implements WebMvcConfigurer {
    //实现WebMvcConfigurer 即 为了设置默认访问路径 /scgcxx
	@Override
	public void addViewControllers(ViewControllerRegistry registry) {
		registry.addViewController("/scgcxx").setViewName("redirect:/safty/login/toLogin");
	}

	public static void main(String[] args) {
		SpringApplication.run(ScgcxxApplication.class, args);
	}
}

SaftyLoginController.java

package com.johe.scgcxx.controller.safty;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.johe.scgcxx.dto.Sys_User;
import com.johe.scgcxx.service.safty.SaftyLoginService;

//安全管理-用户登录
@Controller
public class SaftyLoginController {
	@Autowired
	private SaftyLoginService saftyLoginService;
	
	//   '/'表示绝对路径 不加 表示相对路径
	@RequestMapping("/safty/login/toLogin")
	public String toLoginJSP() {
		return "safty/login/SaftyLogin";
	}
	
	@RequestMapping("/safty/login/doLogin")
	public String toLogin(Sys_User user) {
		boolean flag = saftyLoginService.toLogin(user);
		if (flag) {
			System.out.println("登陆成功");
			return "redirect:/safty/home/toHome";
		}else {
			System.out.println("登录失败");
			return "redirect:/scgcxx";
		}
	}
	
	@RequestMapping("/safty/home/toHome")
	public String toHome() {
		return "safty/home/SaftyHome";
	}
}

SaftyLoginService.java

package com.johe.scgcxx.service.safty;

import com.johe.scgcxx.dto.Sys_User;

//安全管理-用户登录
public interface SaftyLoginService {

	boolean toLogin(Sys_User user);

}

SaftyLoginServiceImpl.java

package com.johe.scgcxx.service.safty.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.johe.scgcxx.dao.safty.SaftyLoginDao;
import com.johe.scgcxx.dto.Sys_User;
import com.johe.scgcxx.service.safty.SaftyLoginService;

//安全管理-用户登录
@Service
@Transactional
public class SaftyLoginServiceImpl implements SaftyLoginService {
	
	@Autowired
	private SaftyLoginDao saftyLoginDao;
	
	@Override
	public boolean toLogin(Sys_User user) {
		com.johe.scgcxx.model.Sys_User breakUser = saftyLoginDao.getUser(user);
		if (breakUser != null) {
			return true;
		}else {
			return false;
		}
	}

}

SaftyLoginDao.java

package com.johe.scgcxx.dao.safty;

import com.johe.scgcxx.dto.Sys_User;


//安全管理-用户登录
public interface SaftyLoginDao {

	com.johe.scgcxx.model.Sys_User getUser(Sys_User user);

}