SSM框架搭建之传统方式(一)

最新推荐文章于 2023-06-16 23:16:23 发布

置顶扆梦楠

最新推荐文章于 2023-06-16 23:16:23 发布

阅读量391

点赞数

本文链接：https://blog.csdn.net/ymn159/article/details/101081930

版权

SSM&SSH 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

SSM框架搭建之传统方式(一)

Jdk安装配置请参照此博客
 eclipse配置jdk/tomcat参照此博客。

打开eclipse,点击File–New—Dynamic Web Project

点击Finish即可完成web项目的创建按照此目录进行文件创建

1.导入如下图所示jar包
只用导入一种数据源即可，这里有c3p0、druid、dbcp三种连接池

2.datasource.properties
mysql8的驱动名称不是~~com.mysql.jdbc.Driver~~；格外注意url的写法

datasource.driverClassName=com.mysql.cj.jdbc.Driver
datasource.userName=root
datasource.userPassword=123456
datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC

3. log4j.properties

#定义LOG输出级别
log4j.rootLogger=INFO,Console,File

#定义日志输出目的地为控制台
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.Target=System.out
#可以灵活的指定日志输出格式，下面一行是指定具体的格式
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=[%c]-%m%n

#mybatis显示SQL语句日志配置     net.cxp.blog.dao是你的dao接口所在的包名  
#log4j.logger.org.mybatis=DEBUG
log4j.logger.com.lymn.it.mapper=DEBUG

#文件大小到达指定尺寸的时候产生一个新的文件
log4j.appender.File=org.apache.log4j.RollingFileAppender
#指定输出目录
log4j.appender.File.File=d:/logs/ssm.log
#定义文件最大大小
log4j.appender.File.MaxFileSize=10MB
#输出所有日志，如果换成DEBUG表示输出DEBUG以上级别日志
log4j.appender.File.Threshold=DEBUG
log4j.appender.File.layout=org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern=[%p][%d{yyyy-MM-dd HH\:mm|\:ss}][%c]%m%n

4. spring-mvc.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: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    
                        http://www.springframework.org/schema/mvc/spring-mvc.xsd">
                        
	<!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器,此处必须排除掉@Service组件 -->
	<context:component-scan base-package="com.lymn.it.controller" />
	<!-- 会自动注册RequestMappingHandlerMapping与RequestMappingHandlerAdapter两个Bean,这是Spring MVC
	为@Controller分发请求所必需的。启动SpringMVC的注解功能，完成请求和注解POJO的映射 -->
	<mvc:annotation-driven/>
	
	<!-- 视图解析器 -->
	<!-- 定义跳转的文件的前后缀 ，视图模式配置 -->
	<bean
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 -->
		<property name="prefix" value="/WEB-INF/jsp/" />
		<property name="suffix" value=".jsp" />
	</bean>
 
	<!--对静态资源文件的访问 -->
	<!-- 针对springMVC的restful风格的url而言，配置了 -->
	<mvc:resources mapping="/images/**" location="/WEB-INF/images/" />
	<mvc:resources mapping="/css/**" location="/WEB-INF/css/" />
	
</beans>

** 5.spring-mybatis.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:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:task="http://www.springframework.org/schema/task"
	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  
                        http://www.springframework.org/schema/mvc/spring-mvc.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/task 
                        http://www.springframework.org/schema/task/spring-task.xsd">

	<!-- 配置包含注解的扫描路径，但是不包括controller -->
	<context:component-scan base-package="com.lymn.it.*">
		<context:exclude-filter type="annotation"
			expression="org.springframework.stereotype.Controller" />
	</context:component-scan>

	<!-- PropertyPlaceholderConfigurer 是 BeanFactory 后置处理器的实现，也是 BeanFactoryPostProcessor 
	接口的一个实现。 允许将上下文（配置文件）中的属性值放在另一个单独的标准 JavaProperties 文件中去。在 XML 文件中用类似 EL 
	表达式的 ${key} 替换指定的 properties 文件中的值 -->
	<!-- <bean id="placeHolder"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="location" value="classpath:config/datasource.properties"></property>
		多个数据源写法
		<property name="locations">
			<list>
				<value>classpath:config/datasource1.properties</value>
				<value>classpath:config/datasource2.properties</value>
			</list>
		</property>
	</bean> -->
	
	<!-- Spring2.5 以后，引入了简化的引入外部文件的方式 -->
	<context:property-placeholder location="classpath:config/datasource.properties" />
	<!-- Spring提供了的数据源,每个连接请求时都新建一个连接 -->
	 <bean id="dataSource" 
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${datasource.driverClassName}"></property>
		<property name="url" value="${datasource.url}"></property>
		<property name="username" value="${datasource.userName}"></property>
		<property name="password" value="${datasource.userPassword}"></property>
	</bean>
	<!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 扫描entity包 使用别名 -->
		<property name="typeAliasesPackage" value="com.lymn.it.model"></property>
		<!-- 配置MyBaties全局配置文件:mybatis-config.xml -->
		<!-- <property name="configLocation" value="classpath:mybatis-config.xml" /> -->
		<property name="dataSource" ref="dataSource" />
		<!-- 自动扫描mapping.xml文件 -->
		<property name="mapperLocations" value="classpath:com/lymn/it/mapper/*.xml"></property>
	</bean>
	<!-- mapper接口所在包名，Spring会自动查找其下的类 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.lymn.it.mapper" />
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
	</bean>

	<!-- (事务管理)transaction manager -->
	<bean id="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>
	<!-- 事务增强，这里用的是spring提供的特性 -->
	<tx:advice id="tx" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="select*" read-only="true" />
			<tx:method name="find*" read-only="true" />
			<tx:method name="get*" read-only="true" />
			<tx:method name="has*" read-only="true" />
			<tx:method name="count*" read-only="true" />
			<tx:method name="search*" read-only="true" />
		</tx:attributes>
	</tx:advice>
	<aop:config>
		<aop:pointcut id="pc"
			expression="execution(* com.lymn.it.service.impl..*.*(..))" />
		<!--把事务控制在Service层 -->
		<aop:advisor pointcut-ref="pc" advice-ref="tx" />
	</aop:config>
	
</beans>

6.model–User

package com.lymn.it.model;

public class User {
		private Integer userid;
		private String username;
		private String password;
		private String email;
		private String phone;
		private Integer status;
		private String code;
		public Integer getUserid() {
			return userid;
		}
		public void setUserid(Integer userid) {
			this.userid = userid;
		}
		public String getUsername() {
			return username;
		}
		public void setUsername(String username) {
			this.username = username;
		}
		public String getPassword() {
			return password;
		}
		public void setPassword(String password) {
			this.password = password;
		}
		public String getEmail() {
			return email;
		}
		public void setEmail(String email) {
			this.email = email;
		}
		public String getPhone() {
			return phone;
		}
		public void setPhone(String phone) {
			this.phone = phone;
		}
		public Integer getStatus() {
			return status;
		}
		public void setStatus(Integer status) {
			this.status = status;
		}
		public String getCode() {
			return code;
		}
		public void setCode(String code) {
			this.code = code;
		}
		@Override
		public String toString() {
			return "User [userid=" + userid + ", username=" + username + ", password=" + password + ", email=" + email
					+ ", phone=" + phone + ", status=" + status + ", code=" + code + "]";
		}

}

** 7.mapper-UserMapper.java**

package com.lymn.it.mapper;

import java.util.List;

import com.lymn.it.model.User;

public interface UserMapper {
	public List<User> getAllUsers();
	 
	public User getUserById(int userid);
 
	public boolean deleteUserById(int userid);
 
	public boolean insertUser(User user);
 
	public boolean updateUserById(User user);
}

mapper-UserMapper.java

<?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.lymn.it.mapper.UserMapper">
	<select id="getAllUsers" resultType="User">
		SELECT * FROM user
	</select>
	<select id="getUserById" parameterType="int" resultType="User">
		SELECT *
		FROM user WHERE userid = #{userid}
	</select>
	<insert id="insertUser" parameterType="User"
		useGeneratedKeys="true" keyProperty="userid">
		INSERT INTO s_user(username,password,email,phone)
		VALUES(#{username},#{password},#{email},#{phone})
	</insert>
	<update id="updateUserById" parameterType="User">
		UPDATE user SET username = #{username},
						  password = #{password},
						  email = #{email},
						  phone = #{phone}
						  WHERE 
						  userid = #{userid}
	</update>
	<delete id="deleteUserById" parameterType="int">
		DELETE  FROM user WHERE userid = #{userid}
	</delete>
</mapper>

8.service-UserService.java

package com.lymn.it.service;

import java.util.List;

import com.lymn.it.model.User;

public interface UserService {
	public List<User> getAllUsers();
	 
	public User getUserById(int userid);
 
	public boolean deleteUserById(int userid);
 
	public boolean insertUser(User user);
 
	public boolean updateUserById(User user);
}

service-UserServiceImpl.java

package com.lymn.it.service.impl;

import java.util.List;

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

import com.lymn.it.mapper.UserMapper;
import com.lymn.it.model.User;
import com.lymn.it.service.UserService;

@Service
public class UserServiceImpl implements UserService {
	@Autowired
	UserMapper userMapper;
	@Override
	public List<User> getAllUsers() {
		return userMapper.getAllUsers();

	}

	@Override
	public User getUserById(int userid) {
		return userMapper.getUserById(userid);

	}

	@Override
	public boolean deleteUserById(int userid) {
		return userMapper.deleteUserById(userid);

	}

	@Override
	public boolean insertUser(User user) {
		return userMapper.insertUser(user);
	}

	@Override
	public boolean updateUserById(User user) {
		return userMapper.updateUserById(user);
	}

}

9.controller-UserController

package com.lymn.it.controller;

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

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

import com.lymn.it.model.User;
import com.lymn.it.service.UserService;

@Controller
public class UserController {
	@Autowired
	UserService userService;
	Logger logger=Logger.getLogger(UserController.class);
	@RequestMapping(value="/user")
	public String user(Map<Object,Object> map) {
		logger.info("查询所有用户数据");
		List<User> userList =  userService.getAllUsers();
		map.put("user", userList);
		logger.info("查询完毕，返回页面");
		return "user";
	}

}

10.web.xml添加如下配置

<!-- spring容器配置 -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<!-- 注意，spring加载配置文件 -->
		<param-value>
            classpath:config/spring-mybatis.xml
        </param-value>
	</context-param>
	<!-- spring容器监听器 -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	
  	<!--springMVC的核心分发器 -->
	<servlet>
		<servlet-name>spring-mvc</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<!-- 指定Spring的配置文件 -->
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:config/spring-mvc.xml</param-value>
		</init-param>
		<!-- 启动加载一次 -->  
        <load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>spring-mvc</servlet-name>
		<!-- 此处可以可以配置成*.do 适配Struts的习惯-->
		<url-pattern>/</url-pattern>
	</servlet-mapping>

	<!-- 防止Spring内存溢出监听器 -->
    <listener>
        <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
    </listener>
    
	<!-- 解决工程编码过滤器 -->
	<filter>
		<filter-name>encodingFilter</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>
		 <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
	</filter>
	<filter-mapping>
		<filter-name>encodingFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>

11.jsp/user.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 charset="UTF-8">
<title>User</title>
</head>
<body>
	<h1>${requestScope.user}</h1>
</body>

12.建数据库test，然后在创建表

CREATE TABLE `user` (
  `userid` INT(11) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(255) DEFAULT NULL,
  `password` VARCHAR(255) DEFAULT NULL,
  `email` VARCHAR(255) DEFAULT NULL,
  `phone` VARCHAR(255) DEFAULT NULL,
  `status` VARCHAR(255) NOT NULL DEFAULT '0',
  `code` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=INNODB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

访问如下图表示配置成功

扆梦楠

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SSM框架搭建之传统方式(一)

SSM框架搭建之传统方式Jdk安装配置请参照此博客eclipse配置jdk/tomcat参照此博客。打开eclipse,点击File–New—Dynamic Web Project点击Finish即可完成web项目的创建按照此目录进行文件创建1.导入如下图所示jar包只用导入一种数据源即可，这里有c3p0、druid、dbcp三种连接池2.datasource....
复制链接

扫一扫