整合SSM

最新推荐文章于 2023-04-01 21:46:21 发布

揽月随风醉

最新推荐文章于 2023-04-01 21:46:21 发布

阅读量120

点赞数 1

分类专栏：笔记

本文链接：https://blog.csdn.net/qq_46100517/article/details/114277004

版权

笔记专栏收录该内容

42 篇文章 0 订阅

订阅专栏

实际上就是mybatis与spring的整合

数据库
一、建立源文件（config）
二、配置Web.xml
三、导包
- 链接：https://pan.baidu.com/s/1Qz5IC5QcwhKieFtOpeIb7A 提取码：lclc ![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/8bb9c2bd1949e3e8f93ddc2b9f8799f6.png)
四、domain层
五、mapper层
六、service接口层
七、service的实现层
八、control层
九、jsp页面
test测试类

数据库

表1：test001
在这里插入图片描述
表2：test003

——
——
——

在这里插入图片描述

一、建立源文件（config）

配置文件中的有些配置是这里没有用到的（因为我是从其它项目里面考过来的），至于那些没有用到我想你们学了那么久也清楚

1、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:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="
       http://www.springframework.org/schema/beans 
       http://www.springframework.org/schema/beans/spring-beans-4.2.xsd 
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context-4.2.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx-4.2.xsd">
       
       <!-- 配置注解扫描范围 -->
       <context:component-scan base-package="com.java.service.impl,com.java.test" />
       
       
        <!-- 读取database.properties文件 -->
       <bean id="propertyPlaceholderConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
	       	<!-- 指定properties文件所在路径 -->
	       	<property name="location" value="classpath:database.properties"></property>
       </bean>
       
       <!-- Dbcp配置数据源 -->
      <!--  <context:property-placeholder location="classpath:database.properties"/> -->
       <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
	       	<property name="driverClassName" value="${driver}"></property>
	       	<property name="url" value="${url}"></property>
	       	<property name="username" value="${username}"></property>
	       	<property name="password" value="${password}"></property>
       </bean> 
       
       <!-- 配置扫描保存sql语句的局部xml文件 -->
       <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
       		<!-- 指定数据源 -->
       		<property name="dataSource" ref="dataSource"></property>
       		<!-- 指定局部xml文件的位置 -->
       		<property name="mapperLocations" value="classpath*:com/java/mapper/*.xml"></property>
       </bean>
       
       <!-- 扫描mapper接口类，并且将接口类与xml文件关联 -->
       <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
       		<!-- 指定mapper接口类存放的位置 -->
       		<property name="basePackage" value="com.java.mapper"></property>
       </bean>
       
</beans>
**

2、database.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/db_test1?characterEncoding=utf-8
username=root
password=root

3、log4j.properties

#log4j.rootLogger=debug, stdout
#
#log4j.appender.stdout=org.apache.log4j.ConsoleAppender
#log4j.appender.stdout.Target=System.err
#log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
#log4j.appender.stdout.layout.ConversionPattern=%d %l %m %n

log4j.rootLogger=debug,logfile

log4j.appender.logfile=org.apache.log4j.FileAppender
log4j.appender.logfile.File=jbit.log
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%p %d %F %M  %m%n

4、springmvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	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-4.2.xsd
	http://www.springframework.org/schema/mvc 
	http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd 
	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd
	http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd
	http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.2.xsd">
	
	<!-- 自動扫描Spring的注解 -->
	<!-- 
		特别要注意：base-package="com.java.controller"> 一定不能配置为com.java，这个这样配置了，事务将不起作用，
		因为配置为com.java，将在SpringMvc中扫描@service，这样Spring的容器中将会有service的实例，而applicationContext.xml的扫描
		就不会产生service的实例，可以事务的AOP将无法扩展功能。同时注意：controller中注入service实例只能用接口，不然就就会报错。
	-->
	<context:component-scan base-package="com.java.control"></context:component-scan>
	
	<!-- 扫描springmvc中的注解 -->
	<!-- <mvc:annotation-driven></mvc:annotation-driven> -->
	
	<!-- 数据验证 -->
	<mvc:annotation-driven validator="validator"></mvc:annotation-driven>
	<bean id="validator" class="org.springframework.validation.beanvalidation.LocalValidatorFactoryBean">
       	<property name="providerClass" value="org.hibernate.validator.HibernateValidator" />
    </bean>
    
    <!-- 上传文件 -->
	<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
		<property name="defaultEncoding" value="utf-8"></property>
		
		<property name="maxUploadSize" value="1048576"></property>
	</bean>
	
	
	<!-- 
	<bean id="" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/pages/"></property>
		<property name="suffix" value=".jsp"></property>
	</bean>
	 -->
</beans>

二、配置Web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>ssmpro1</display-name>
  

  <!-- 设置字符集编码过滤器 -->
  <filter>
  	<filter-name>char</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>char</filter-name>
  	<url-pattern>/*</url-pattern>
  </filter-mapping>
  
  
  <context-param>
  	<param-name>contextConfigLocation</param-name>
  	<param-value>classpath:applicationContext.xml</param-value>
  </context-param>
  <listener>
  	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
 

  
  <!-- springmvc的本质是servlet -->
  <servlet>
  	<servlet-name>action</servlet-name>
  	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  	<init-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:springmvc.xml</param-value>
	</init-param>
  	
  
  </servlet>
  
  <servlet-mapping>
  	<servlet-name>action</servlet-name>
  	<url-pattern>*.action</url-pattern>
  </servlet-mapping>
  
  <!-- 404/500错误跳转页面 -->
 <!--  <error-page>
  	<error-code>404</error-code>
  	<location>/pages/error/404.jsp</location>
  </error-page> -->
  
  
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
</web-app>

三、导包

链接：https://pan.baidu.com/s/1Qz5IC5QcwhKieFtOpeIb7A
提取码：lclc

四、domain层

package com.java.domain;

import javax.validation.constraints.Min;
import javax.validation.constraints.Pattern;

public class User {
	private int id;
	
	//w代表数字、下划线和大小写字母，6~18
	@Pattern(regexp="\\w{6,18}",message="用户名不合法")   //@Pattern只能够修饰String类型
	private String name;
	
	@Min(value = 18,message="不合法（未满18岁）！！！")
	private int age;
	
	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 int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	
	
}

五、mapper层

1、接口

package com.java.mapper;

import java.util.List;

import com.java.domain.User;

public interface UserMapper {
	//查找所有用户
	List<User> findAllUser();
	
	//插入用户
	void addUser(User user);
	
	//查询用户
	User findUserByName(String name);
}

2、xml

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

<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://www.mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace和mapper接口同名 -->
<mapper namespace="com.java.mapper.UserMapper">
	<!-- id用接口中定义的方法的名字 -->
	<select id="findAllUser"  resultType="com.java.domain.User">
		select * from test001
	</select>
	
	<insert id="addUser" parameterType="com.java.domain.User">
		insert into test003(name,age) values(#{name},#{age})
	</insert>
	
	<!-- 查询用户 -->
	<select id="findUserByName" parameterType="String" resultType="com.java.domain.User">
		select * from test003 where name=#{name}
	</select>
</mapper>

六、service接口层

 package com.java.service;

import java.util.List;

import com.java.domain.User;

public interface UserService {
	List<User> showUser();
	
	String register(User user);
}

七、service的实现层

package com.java.service.impl;

import java.util.List;

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

import com.java.domain.User;
import com.java.mapper.UserMapper;
import com.java.service.UserService;

@Service
public class UserServiceImpl implements UserService {
	//自动装配，这个不需要导包，或者说已经导入过了；它是Spring自带的；默认直接按照类型进行装配，如果需要按照名字装配必须使用@Qualifier
	@Autowired
	private UserMapper userMapper;
	
	public List<User> showUser() {
		List<User> list = userMapper.findAllUser();
		System.out.println(list);
		return list;
	}

	@Override
	public String register(User user) {
		User findUserByName = userMapper.findUserByName(user.getName());
		if(findUserByName != null) {
			return "该用户已存在！！！";
		}else {
			userMapper.addUser(user);
			return "注册成功！！！"	;
		}
	}

}

八、control层

name是拿到所有用户
在这里插入图片描述

registerUser是注册用户
在这里插入图片描述

package com.java.control;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.validation.Valid;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.validation.FieldError;
import org.springframework.web.bind.annotation.RequestMapping;

import com.java.domain.User;
import com.java.service.impl.UserServiceImpl;

//交给spring管理
@Controller()
public class ControlDemo {
	@Autowired
	private UserServiceImpl userServiceImpl;
	
	//映射路径
	@RequestMapping("name")
	public String show(Model model) {
		List<User> list = userServiceImpl.showUser();
		model.addAttribute("list",list);
		return "show.jsp";
	}
	
	@RequestMapping("registerUser")
	public String registerUser(@Valid User user,BindingResult errorResult,Model  model) {
		//如果有错误信息存就放到map集合里
		Map<String,String> errors = new HashMap<String,String>();
		
		if(errorResult.hasErrors()) {
			for (FieldError error : errorResult.getFieldErrors()) {
				//分别为属性名与错误信息
				errors.put(error.getField(), error.getDefaultMessage());
			}
			model.addAttribute("errors", errors);
			return "register.jsp";
		}else {
			String info = userServiceImpl.register(user);
			if(info.equals("该用户已存在！！！")) {
				errors.put("info", info);
				model.addAttribute("errors", errors);
				return "register.jsp";
			}else {
				return	"success.jsp";
			}
		}
	}
}

九、jsp页面

1、register

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
	<h1><font color="red">${errors.info }</font></h1>
	<!-- get是从服务器上获取数据，post是向服务器传送数据。 -->
	<form action="${pageContext.request.contextPath }/registerUser.action" method="post">
		用户名：<input type="text" name="name"><font color="red">${errors.name }</font>
		年龄：<input type="text" name="age"><font color="red">${errors.age }</font>
		<input type="submit"  value="确认">
	</form>
</body>
</html>

2、show

<%@ 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 charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
	<c:forEach items="${list }" var="user">
		${user.id } ${user.name } ${user.age }
	</c:forEach>
</body>
</html>

3、success

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
	<H1>注册成功!!!</H1>
</body>
</html>

——

——
——
——
——
——
——
——

test测试类

一般写完一层功能就需要写测试代买来测试一遍

测试代码把项目细分成模块来检查独立的功能,避免项目整合的时候出现BUG而很难排错,初学java在小程序里是体会不到测试的重要性,因为小程序几乎也不需要做测试,就算出错也是一目了然,很快就解决了,但是还要养成测试的习惯.在大型项目中如果没有测试用例,那将是非常可怕的（此话摘自搜狗问问）

package com.java.test;

import java.util.List;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.java.domain.User;
import com.java.service.impl.UserServiceImpl;

//让测试运行于Spring测试环境
@RunWith(SpringJUnit4ClassRunner.class) 

//@ContextConfiguration这个注解通常与@RunWith(SpringJUnit4ClassRunner.class)联合使用用来测试
@ContextConfiguration("classpath:applicationcontext.xml")

@Component
public class TestDemo1 {
	
	@Autowired
	private UserServiceImpl userServiceImpl;
	
	@Test
	public void test1() {
		List<User> list = userServiceImpl.showUser();
		System.out.println(list);
	}
}

在这里插入图片描述

揽月随风醉

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
整合SSM

实际上就是mybatis与spring的整合数据库一、建立源文件（config）1、applicationContext.xml2、database.properties3、log4j.properties4、springmvc.xml二、配置Web.xml三、导包链接：https://pan.baidu.com/s/1Qz5IC5QcwhKieFtOpeIb7A 提取码：lclc ![在这里插入图片描述](https://img-blog.csdnimg.cn/202103021005021.png?
复制链接

扫一扫