当前位置：网站首页>【SSM整合】1. 基本环境搭建
【SSM整合】1. 基本环境搭建
2022-04-21 06:14:00 【Leo＆＆Eva】
我们首先实现一个对数据库表account的一些操作，有添加和查询所有并展示在页面中的功能
话不多说。先导依赖
<dependencies>
<!--spring相关-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.1.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.1.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.1.2.RELEASE</version>
</dependency>
<!-- JDBC-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.1.2.RELEASE</version>
</dependency>
<!-- aop-->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.4</version>
</dependency>
<!-- SpringMVC-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>4.1.2.RELEASE</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.1.2.RELEASE</version>
</dependency>
<!-- Servlet-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
</dependency>
<!-- jsp-->
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.1</version>
</dependency>
<!-- mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.7</version>
</dependency>
<!-- mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.26</version>
</dependency>
<!-- c3p0-->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
<!-- jstl-->
<dependency>
<groupId>javax.servlet.jsp.jstl</groupId>
<artifactId>jstl-api</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<!-- junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test.test</scope>
</dependency>
</dependencies>1. 创建数据库ssm并创建account表
2. 创建domain包用来存放对象类Account
package com.lh.domain;
public class Account {
private int id;
private String name;
private double money;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public double getMoney() {
return money;
}
public void setMoney(double money) {
this.money = money;
}
@Override
public String toString() {
return "account{" +
"id=" + id +
", name='" + name + '\'' +
", money=" + money +
'}';
}
}
3. 创建mapper包存放持久层操作接口AccountMapper
package com.lh.mapper;
import com.lh.domain.Account;
import java.util.List;
public interface AccountMapper {
public void save(Account account);
public List<Account> findAll();
}
4. 创建service包存放业务层接口AccountService和类AccountServiceImpl（impl包下）
package com.lh.service;
import com.lh.domain.Account;
import java.util.List;
public interface AccountService {
public void save(Account account);
public List<Account> findAll();
}
package com.lh.service.impl;
import com.lh.domain.Account;
import com.lh.service.AccountService;
import java.util.List;
public class AccountServiceImpl implements AccountService {
@Override
public void save(Account account) {
}
@Override
public List<Account> findAll() {
return null;
}
}
5. 然后就是创建控制层的包controller用来存放控制器类AccountController
package com.lh.controller;
import com.lh.domain.Account;
import org.springframework.web.servlet.ModelAndView;
public class AccountController {
//保存
public String save(Account account){
return null;
}
//查询
public ModelAndView findAll(){
return null;
}
}
6. 再就是配置文件的添加了
6.1. jdbc.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm
jdbc.username=root
jdbc.password=root6.2. log4j.properties
### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:/mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### set log levels - for more verbose logging change 'info' to 'debug' ###
log4j.rootLogger=all, stdout
6.3. applicationContext.xml, 内容先不添加
<?xml version="1.0" encoding="UTF-8" ?>
<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"
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">
</beans>6.4. Spring-mvc.xml
<?xml version="1.0" encoding="UTF-8" ?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
</beans>
6.5. AccountMapper.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">
<mapper>
</mapper>6.6. sqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
</configuration>7. 最后就是创建前台的页面save.jsp, accountList.jsp
save.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>save</title>
</head>
<body>
<h1>添加账户信息表单</h1>
<form name = "accountForm" action="${pageContext.request.contextPath}/account/save", method="post">
账户名称:<input type="text" name="name"><br>
账户金额:<input type="text" name="money"><br>
<input type="submit" value="保存"><br>
</form>
</body>
</html>
accountList.jsp（在WEB-INF/pages下）
<%@ 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>
<h1>展示账户数据列表</h1>
<table border="1px">
<tr>
<th>账户id</th>
<th>账户名称</th>
<th>账户金额</th>
</tr>
<c:forEach items="${accountList}" var="account">
<tr>
<td>${account.id}</td>
<td>${account.name}</td>
<td>${account.money}</td>
</tr>
</c:forEach>
</table>
</body>
</html>
版权声明
本文为[Leo＆＆Eva]所创，转载请带上原文链接，感谢
https://blog.csdn.net/m0_55336071/article/details/124220976
边栏推荐
猜你喜欢
notepad ++ 将制表符（tab）替换为空格
原形网络（Prototypical Networks）基于PyTorch的实现
Vivado HLS software click desktop icon failure solution
ESP32 LVGL8.1 ——textarea 文本区域 (textarea 26)
![3、 2 [Verilog HDL] hierarchical modeling of basic knowledge](/img/e1/86e9e0e150ad894933a08b8bc91738.png)
3、 2 [Verilog HDL] hierarchical modeling of basic knowledge
First meet tensorflow 2 0 -- fashion MNIST identification
Tensorflow案例4：Mnist手写数字识别(线性神经网络)及其局限性
reg文件导入注册表后出现中文乱码的解决方法
Qt中正则表达式的使用
ROS入门学习笔记（二）
随机推荐
Summary of 28 R language document communication tweets
MATLAB data normalization function
Draw biaxial separation diagram with ggplot2
ESP32 LVGL8.1 ——Input devices 输入设备 (Input devices 18)
Étapes détaillées et explication de la conversion des données MNIST au format de tableau numérique
Qt中正则表达式的使用
Vivado HLS software click desktop icon failure solution
CISSP认证每日知识点（2022年4月14日）
2、 Signal filtering ＞ mean filtering and median filtering
每日CISSP认证常错题（2022年4月11日）
canvas 绘制路飞
Excel截取文本
Document No. 0 - FPGA learning ideas
搭建自己的blog
const关键字、变量、函数用const修饰
Learn SCI paper drawing skills (b)
shell编程时，引用相对路径的shell文件
QT error: no matching member function for call to ‘connect‘
Official account version update and introduction
MNIST数据集的神经网络推理处理