springboot+jsp+mybatis+mysql

最新推荐文章于 2022-03-28 19:35:50 发布

q812979729

最新推荐文章于 2022-03-28 19:35:50 发布

阅读量265

点赞数

分类专栏：笔记文章标签： mysql java

本文链接：https://blog.youkuaiyun.com/q812979729/article/details/120032445

版权

笔记专栏收录该内容

3 篇文章

订阅专栏

本文介绍了如何使用SpringBoot、JSP和Mybatis进行整合，实现一个简单的CRUD应用。首先展示了项目的pom.xml配置，然后详细说明了Application配置、数据源设置、以及Controller、Service、Mapper接口和XML文件的实现。此外，还包含了关键的Mapper接口和XML文件的SQL操作，以及IndexController中的请求处理逻辑。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用的pom文件

<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/maven-v4_0_0.xsd">

<groupId>com.baidu</groupId>

<artifactId>springbootjsp</artifactId>

<version>1.0-SNAPSHOT</version>

<name>springbootjsp Maven Webapp</name>

<url>http://maven.apache.org</url>

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

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

<junit.version>4.12</junit.version>

<log4j.version>1.2.17</log4j.version>

<slf4j.version>1.7.5</slf4j.version>

</properties>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-parent</artifactId>

<version>1.5.2.RELEASE</version>

</parent>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-devtools</artifactId>

</dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-web</artifactId>

</dependency>

<groupId>javax.servlet</groupId>

</dependency>

<groupId>org.apache.tomcat.embed</groupId>

<artifactId>tomcat-embed-jasper</artifactId>

</dependency>

<version>${slf4j.version}</version>

</dependency>

<groupId>org.mybatis.spring.boot</groupId>

<artifactId>mybatis-spring-boot-starter</artifactId>

</dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

<!-- <dependency>

<groupId>com.alibaba</groupId>

<artifactId>druid-spring-boot-starter</artifactId>

</dependency>-->

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-thymeleaf</artifactId>

</dependency>

<groupId>com.alibaba</groupId>

<artifactId>fastjson</artifactId>

</dependency>

<groupId>junit</groupId>

<artifactId>junit</artifactId>

</dependency>

</dependencies>

<build>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-maven-plugin</artifactId>

<version>1.5.2.RELEASE</version>

</plugin>

<groupId>org.apache.maven.plugins</groupId>

<artifactId>maven-surefire-plugin</artifactId>

<useSystemClassLoader>false</useSystemClassLoader>

</configuration>

</plugin>

</plugins>

<directory>src/main/resources/mapper</directory>

</includes>

</resource>

<directory>src/main/resources</directory>

</resource>

</resources>

</build>

</project>

Application配置:

spring:

profiles:

active: dev

logging:

level: debug

server:

port: 8080 #tomcat端口

Application-dev配置

spring:

#springboot的配置

datasource: #定义数据源

driver-class-name: com.mysql.cj.jdbc.Driver

url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC

username: root

password: root

resources:

static-locations: [ "/templates/","/resources/","/static/" ]

# mvc:

# view:

# prefix: /WEB-INF/jsp/

# suffix: .jsp

thymeleaf:

prefix: classpath:/templates/

suffix: .html

mode: HTML5

encoding: UTF-8

content-type: text/html

# 关闭缓存, 即时刷新, 上线生产环境需要改为true

cache: false

# 配置静态资源文件路径

mybatis:

mapperLocations: 'classpath:/mapper/*.xml'

IndexController

import com.zygxy.po.UserInfo;

import com.zygxy.service.UserInfoService;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.RequestMapping;

import javax.annotation.Resource;

@Controller

public class IndexController {

@Resource

private UserInfoService userInfoService;

@RequestMapping("/")

public String toPageIndex(Model model) {

UserInfo userInfo = userInfoService.queryUser();

model.addAttribute("userInfo", userInfo);

System.out.println("请求登录");

return "index";

}

@RequestMapping("/login")

public String toPageLogin() {

System.out.println("请求登录");

return "page/login1";

}

UserInfoService

import com.zygxy.po.UserInfo;

public interface UserInfoService {

UserInfo queryUser();

}

UserInfoServiceImpl

import com.zygxy.mapper.UserInfoMapper;

import com.zygxy.po.UserInfo;

import com.zygxy.service.UserInfoService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

@Service

public class UserInfoServiceImpl implements UserInfoService {

@Autowired

private UserInfoMapper userInfoMapper;

@Override

public UserInfo queryUser() {

return userInfoMapper.selectByPrimaryKey(1);

}

UserInfoMapper

import com.zygxy.po.UserInfo;

import org.apache.ibatis.annotations.Mapper;

@Mapper

public interface UserInfoMapper {

int deleteByPrimaryKey(Integer id);

int insert(UserInfo record);

int insertSelective(UserInfo record);

UserInfo selectByPrimaryKey(Integer id);

int updateByPrimaryKeySelective(UserInfo record);

int updateByPrimaryKey(UserInfo record);

}

UserInfoMapper.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

</resultMap>

id, user_name, password, nick_name, age

</sql>

select

from user_info

where id = #{id,jdbcType=INTEGER}

</select>

delete from user_info

where id = #{id,jdbcType=INTEGER}

</delete>

insert into user_info (id, user_name, password,

nick_name, age)

values (#{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},

#{nickName,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER})

</insert>

insert into user_info

id,

</if>

user_name,

</if>

password,

</if>

nick_name,

</if>

age,

</if>

</trim>

#{id,jdbcType=INTEGER},

</if>

#{userName,jdbcType=VARCHAR},

</if>

#{password,jdbcType=VARCHAR},

</if>

#{nickName,jdbcType=VARCHAR},

</if>

#{age,jdbcType=INTEGER},

</if>

</trim>

</insert>

update user_info

<set>

user_name = #{userName,jdbcType=VARCHAR},

</if>

password = #{password,jdbcType=VARCHAR},

</if>

nick_name = #{nickName,jdbcType=VARCHAR},

</if>

age = #{age,jdbcType=INTEGER},

</if>

</set>

where id = #{id,jdbcType=INTEGER}

</update>

update user_info

set user_name = #{userName,jdbcType=VARCHAR},

password = #{password,jdbcType=VARCHAR},

nick_name = #{nickName,jdbcType=VARCHAR},

age = #{age,jdbcType=INTEGER}

where id = #{id,jdbcType=INTEGER}

</update>

</mapper>

UserInfo

package com.zygxy.po;

public class UserInfo {

private Integer id;

private String userName;

private String password;

private String nickName;

private Integer age;

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getUserName() {

return userName;

}

public void setUserName(String userName) {

this.userName = userName == null ? null : userName.trim();

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password == null ? null : password.trim();

}

public String getNickName() {

return nickName;

}

public void setNickName(String nickName) {

this.nickName = nickName == null ? null : nickName.trim();

}

public Integer getAge() {

return age;

}

public void setAge(Integer age) {

this.age = age;

}

各个文件的路径

Index.html

<!DOCTYPE html>

<head>

<title>layuimini-iframe版 v2 - 基于Layui的后台管理系统前端模板</title>

content="layuimini基于layui的轻量级前端后台管理框架，最简洁、易用的后台框架模板，面向所有层次的前后端程序,只需提供一个接口就直接初始化整个框架，无需复杂操作。"/>

<!--[if lt IE 9]>

<![endif]-->

</style>

</head>

<a>

</a>

</ul>

</dl>

</li>

</ul>

</li>

</li>

</li>

<a href="javascript:;">admin</a>

<dd>

<a href="javascript:;" layuimini-content-href="page/user-setting.html" data-title="基本资料"

data-icon="fa fa-gears">基本资料<span class="layui-badge-dot"></span></a>

</dd>

<dd>

<a href="javascript:;" layuimini-content-href="page/user-password.html" data-title="修改密码"

data-icon="fa fa-gears">修改密码</a>

</dd>

<dd>

</dd>

<dd>

</dd>

</dl>

</li>

</li>

</ul>

</div>

</div>

</div>

</ul>

</dl>

</li>

</ul>

</li>

</div>

</div>

layui.use(['jquery', 'layer', 'miniAdmin', 'miniTongji'], function () {

var $ = layui.jquery,

layer = layui.layer,

miniAdmin = layui.miniAdmin,

miniTongji = layui.miniTongji;

var options = {

iniUrl: "api/init.json", // 初始化接口

clearUrl: "api/clear.json", // 缓存清理接口

urlHashLocation: true, // 是否打开hash定位

bgColorDefault: false, // 主题默认配置

multiModule: true, // 是否开启多模块

menuChildOpen: false, // 是否默认展开菜单

loadingTime: 0, // 初始化加载时间

pageAnim: true, // iframe窗口动画

maxTabNum: 20, // 最大的tab打开数量

};

miniAdmin.render(options);

// 百度统计代码，只统计指定域名

miniTongji.render({

specific: true,

domains: [

'99php.cn',

'layuimini.99php.cn',

'layuimini-onepage.99php.cn',

});

$('.login-out').on("click", function () {

layer.msg('退出登录成功', function () {

window.location = 'page/login-3.html';

});

</script>

</body>

</html>

Gitee地址: https://gitee.com/lhj1024/springjspdemo.git