- pom.xml
<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.jxut</groupId>
<artifactId>springmvc-getdata-json</artifactId>
<version>1.0-SNAPSHOT</version>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>8</source>
<target>8</target>
</configuration>
</plugin>
</plugins>
</build>
<packaging>war</packaging>
<dependencies>
<!-- Spring核心类-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<!-- Spring MVC -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<!-- servlet -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!-- jsp -->
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.1</version>
<scope>provided</scope>
</dependency>
<!-- Jackson转换核心包依赖 -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.9.2</version>
</dependency>
<!-- Jackson转换的数据绑定包依赖 -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.2</version>
</dependency>
<!-- Jackson JSON转换注解包 -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.9.0</version>
</dependency>
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version> <!-- 使用你需要的版本 -->
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.9</version> <!-- 使用你需要的版本 -->
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<!-- Spring Framework 的核心依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
<!-- Spring Framework 的事务管理依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.6.RELEASE</version>
</dependency>
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.5</version> <!-- 请检查并使用最新版本 -->
</dependency>
</dependencies>
</project>
- 2.rouse-spring-mvc
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
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/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">
<!-- 配置 Spring MVC 要扫描的包 -->
<context:component-scan base-package="com.jxut.rj215lt.controller"/>
<!-- 配置视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/pages/"/>
<property name="suffix" value=".jsp"/>
</bean>
<mvc:annotation-driven/>
<!-- 配置静态资源的访问映射，即此配置中的文件，不会被DispatcherServlet拦截 -->
<mvc:resources mapping="/js/**" location="/js/"/>
</beans>
- 3.spring-mybatis
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
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/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">
<!-- 配置 Spring MVC 要扫描的包 -->
<context:component-scan base-package="com.jxut.rj215lt.controller"/>
<!-- 配置视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/pages/"/>
<property name="suffix" value=".jsp"/>
</bean>
<mvc:annotation-driven/>
<!-- 配置静态资源的访问映射，即此配置中的文件，不会被DispatcherServlet拦截 -->
<mvc:resources mapping="/js/**" location="/js/"/>
</beans>
- 4.Mapper
- Book
- @Mapper
-
public interface BookMapper {
List<Book> selectAllBooks();
int insertBook(Book book);
} - UserMApper
-
@Mapper
public interface UserMapper {
public User login(@Param("username") String username,
@Param("password") String password) ;
}
- 5.Mapper.xml
- Book
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jxut.rj215lt.mapper.BookMapper">
<select id="selectAllBooks" resultType="com.jxut.rj215lt.pojo.Book">
SELECT * FROM books
</select>
<insert id="insertBook" parameterType="com.jxut.rj215lt.pojo.Book">
INSERT INTO books (name, author, publication_date)
VALUES (#{name}, #{author}, #{publicationDate})
</insert>
</mapper> - User
-
<?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">
<mapper namespace="com.jxut.rj215lt.mapper.UserMapper">
<select id="login" resultType="com.jxut.rj215lt.pojo.User">
select username,password from `user`
where username=#{username}
and password=#{password}
</select>
</mapper>
- Book
- 6.Service
-
public interface BookService {
List<Book> selectAllBooks();
int insertBook(Book book);
} -
@Service
public class BookServiceImpl implements BookService {
@Autowired
private BookMapper bookMapper;
@Override
public List<Book> selectAllBooks() {
return bookMapper.selectAllBooks();
}
@Override
public int insertBook(Book book) {
return bookMapper.insertBook(book);
}
}
-
-
-
public interface UserService {
public User login(String username,
String password) ;
} -
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public User login(String username, String password) {
return userMapper.login(username, password);
}
}
-
- 7.controller
- Book
@Controller
public class BookController {
@Autowired
private BookService bookService;
@GetMapping("/books")
@ResponseBody
public List<Book> getAllBooks() {
return bookService.selectAllBooks();
}
@PostMapping("/addbook")
@ResponseBody
public String addBook(@RequestBody Book book) {
int result = bookService.insertBook(book);
if (result > 0) {
return "Book added successfully!";
} else {
return "Failed to add book.";
}
}
} - USer
-
@RestController
@CrossOrigin
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@RequestMapping(value="/MyLogin.html",method = RequestMethod.GET)
public String login(){
return "login";
}
@ResponseBody
@RequestMapping(value="/MyLogin.html",method = RequestMethod.POST)
public String login(@RequestParam String username,
@RequestParam String password,
HttpServletRequest request,
HttpSession session) {
User u = userService.login(username, password);
if (u != null) {
session.setAttribute("user",u);
return "redirect:index.html";
} else {
request.setAttribute("error","用户名和密码不正确");
return "login";
}
} - Index
-
@Controller
public class IndexController {
@RequestMapping("/index.html")
public String index(){
return "index";
}
}}
- Book
- login.jsp
-
<%--
Created by IntelliJ IDEA.
User: liuting
Date: 2024/5/29
Time: 20:15
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
String path=request.getContextPath();
String basePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path;
%>
<html lang="en">
<head>
<base href="<%=basePath%>"/>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>登录页面</title>
<style>
/* 简单的样式，用于美化页面 */
body {
font-family: Arial, sans-serif;
margin: 0;
padding: 20px;
}
.container {
max-width: 300px;
margin: 0 auto;
padding: 20px;
border: 1px solid #ccc;
border-radius: 5px;
}
h2 {
text-align: center;
}
label, input {
display: block;
width: 100%;
margin-bottom: 10px;
}
input[type="submit"] {
width: auto;
margin-top: 15px;
}
</style>
<script src="../../js/jquery.js"></script>
<script>
$(function() {
$("#login").on("click",function(){
var username=$("#username").val();
var mima = $('#password').val();
alert('yeah')
$.post("http://localhost:8080/user/selectUserAll", {
username: username,
password: mima,
}, function(res) {
if(res.code === 200) {
alert('登录成功，欢迎您')
}
})
});
})
</script>
</head>
<body>
<div class="container">
<h2>登录</h2>
<form id="login-form" method="post" name="login" action="MyLogin.html"> <!-- 这里需要替换为你的服务器端处理脚本 -->
<label for="username">用户名:</label>
<input type="text" id="username" name="username" required>
<label for="password">密码:</label>
<input type="password" id="password" name="password" required>
<input id='login' type="submit" value="登录">
<div style="color: red">
${error}
</div>
</form>
</div>
</body>
</html>
-
- bookList.jsp
-
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
String path=request.getContextPath();
String basePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path;
%>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>图书列表</title>
<style>
/* 简单的样式 */
table {
border-collapse: collapse;
width: 100%;
}
th, td {
text-align: left;
padding: 8px;
}
tr:nth-child(even) {background-color: #f2f2f2;}
</style>
</head>
<body>
<h2>图书列表</h2>
<table id="booksTable">
<tr>
<th>ID</th>
<th>书名</th>
<th>作者</th>
<th>出版日期</th>
</tr>
</table>
<script>
function fetchBooks() {
const xhr = new XMLHttpRequest();
xhr.open('GET', '/books', true);
xhr.onreadystatechange = function () {
if (xhr.readyState === 4 && xhr.status === 200) {
const books = JSON.parse(xhr.responseText);
const table = document.getElementById('booksTable');
// 清除旧的图书数据（如果有的话）
table.innerHTML = '<tr><th>ID</th><th>书名</th><th>作者</th><th>出版日期</th></tr>';
// 遍历图书列表并添加到表格中
books.forEach(book => {
const row = table.insertRow(-1); // 在表格末尾插入新行
row.insertCell().textContent = book.id;
row.insertCell().textContent = book.name;
row.insertCell().textContent = book.author;
row.insertCell().textContent = book.publicationDate; // 假设后端返回的是可读的日期字符串
});
}
};
xhr.send();
}
// 页面加载完成后调用fetchBooks函数
window.onload = fetchBooks;
</script>
</body>
</html>
-
- index.jsp
-
<html lang="en">
<head>
<base href="<%=basePath%>"/>
<title>登录提示</title>
</head>
<body>
<h1>您登录${user.username}</h1>
</body>
</html>
-
- addBook
-
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Add Book</title>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
</head>
<body>
<h2>Add Book</h2>
<form id="bookForm">
<div>
<label for="name">Name:</label>
<input type="text" id="name" name="name" required>
</div>
<div>
<label for="author">Author:</label>
<input type="text" id="author" name="author" required>
</div>
<div>
<label for="publicationDate">Publication Date:</label>
<input type="date" id="publicationDate" name="publicationDate">
</div>
<button type="submit">Add Book</button>
</form>
<script>
$(document).ready(function() {
$('#bookForm').on('submit', function(e) {
e.preventDefault(); // 阻止表单默认提交行为
var book = {
name: $('#name').val(),
author: $('#author').val(),
publicationDate: $('#publicationDate').val()
};
$.ajax({
url: '/books', // 后端添加图书的API地址
type: 'POST',
contentType: 'application/json', // 发送JSON数据
data: JSON.stringify(book), // 将对象转换为JSON字符串
success: function(response) {
alert(response); // 显示服务器返回的消息
// 你可以在这里添加其他逻辑，如清空表单、重定向等
},
error: function(xhr, status, error) {
alert('Error adding book: ' + error);
}
});
});
});
</script>
</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">
<!--Spring的配置文件-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</context-param>
<!--Spring的监听器-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--SpringMVC的前端控制器-->
<servlet>
<servlet-name>springMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mybatis.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<!--访问DispatcherServlet对应的路径-->
<servlet-mapping>
<servlet-name>springMVC</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!--编码格式过滤器-->
<filter>
<filter-name>encoding</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--引导页-->
<welcome-file-list>
<welcome-file>\index.jsp</welcome-file>
</welcome-file-list>
</web-app>
-
本文来自博客园，作者：{舛}，转载请注明原文链接：https://www.cnblogs.com/Ting-liu/p/18221412
浙公网安备 33010602011771号