ssm框架的整合及增删改查

最新推荐文章于 2024-06-12 22:45:12 发布

小小舍

最新推荐文章于 2024-06-12 22:45:12 发布

阅读量2.1k

点赞数 4

分类专栏： mybatis spring spring mvc

本文链接：https://blog.csdn.net/qq_43560721/article/details/89491570

版权

spring 同时被 3 个专栏收录

11 篇文章 1 订阅

订阅专栏

mybatis

10 篇文章 1 订阅

订阅专栏

spring mvc

2 篇文章 0 订阅

订阅专栏

项目结构：

数据库表：

给项目添加依赖：

<?xml version="1.0" encoding="UTF-8"?>
<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">
	<modelVersion>4.0.0</modelVersion>
	<groupId>cn.xxs</groupId>
	<artifactId>ssm_select</artifactId>
	<name>test</name>
	<packaging>war</packaging>
	<version>1.0.0-BUILD-SNAPSHOT</version>
	<properties>
		<!-- jdk版本 -->
		<java-version>1.8</java-version>
		<!-- spring版本 -->
		<org.springframework-version>4.3.7.RELEASE</org.springframework-version>
		<!-- 切点版本 -->
		<org.aspectj-version>1.8.1</org.aspectj-version>
		<!-- 日志版本 -->
		<org.slf4j-version>1.6.6</org.slf4j-version>
		<!-- mybatis版本 -->
		<org.mybatis-version>3.2.8</org.mybatis-version>
		<!-- mysql连接版本 -->
		<mysql-version>5.1.45</mysql-version>
		<!-- jackson版本 -->
		<jackson-version>2.9.4</jackson-version>
	</properties>
	<dependencies>
		<!-- Spring -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${org.springframework-version}</version>
			<exclusions>
				<!-- Exclude Commons Logging in favor of SLF4j -->
				<exclusion>
					<groupId>commons-logging</groupId>
					<artifactId>commons-logging</artifactId>
				 </exclusion>
			</exclusions>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aspects</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-beans</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
				<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context-support</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-expression</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>	
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-instrument</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-instrument-tomcat</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
				<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jms</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>	
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-messaging</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
				<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-oxm</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
				<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
				<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc-portlet</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-websocket</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
												
		<!-- AspectJ -->
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjrt</artifactId>
			<version>1.8.9</version>
		</dependency>	
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjweaver</artifactId>
			<version>1.8.1</version>
		</dependency>
		
		<!-- commons -->
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.4</version>
		</dependency>
		<dependency>
			<groupId>commons-fileupload</groupId>
			<artifactId>commons-fileupload</artifactId>
			<version>1.3.1</version>
		</dependency>	
		<dependency>
			<groupId>commons-io</groupId>
			<artifactId>commons-io</artifactId>
			<version>2.5</version>
		</dependency>					
		<dependency>
			<groupId>commons-logging</groupId>
			<artifactId>commons-logging</artifactId>
			<version>1.2</version>
		</dependency>	
		<dependency>
			<groupId>commons-net</groupId>
			<artifactId>commons-net</artifactId>
			<version>3.0</version>
		</dependency>
		<dependency>
			<groupId>commons-pool</groupId>
			<artifactId>commons-pool</artifactId>
			<version>1.5.5</version>
		</dependency>
		
		<!-- json -->
 		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-annotations</artifactId>
			<version>${jackson-version}</version>
		</dependency>
 		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-core</artifactId>
			<version>${jackson-version}</version>
		</dependency>
 		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-databind</artifactId>
			<version>${jackson-version}</version>
		</dependency>
		
		<!-- jstl标签库 -->
 		<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
		
		<!-- mybatis -->
 		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.2.8</version>
		</dependency>
 		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.2</version>
		</dependency>
						
		<!-- mysql -->
 		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>${mysql-version}</version>
		</dependency>
																
		<!-- Logging -->
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>${org.slf4j-version}</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>jcl-over-slf4j</artifactId>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.17</version>
			<exclusions>
				<exclusion>
					<groupId>javax.mail</groupId>
					<artifactId>mail</artifactId>
				</exclusion>
				<exclusion>
					<groupId>javax.jms</groupId>
					<artifactId>jms</artifactId>
				</exclusion>
				<exclusion>
					<groupId>com.sun.jdmk</groupId>
					<artifactId>jmxtools</artifactId>
				</exclusion>
				<exclusion>
					<groupId>com.sun.jmx</groupId>
					<artifactId>jmxri</artifactId>
				</exclusion>
			</exclusions>
			<scope>runtime</scope>
		</dependency>

		<!-- @Inject -->
		<dependency>
			<groupId>javax.inject</groupId>
			<artifactId>javax.inject</artifactId>
			<version>1</version>
		</dependency>
				
		<!-- Servlet -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>servlet-api</artifactId>
			<version>2.5</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet.jsp</groupId>
			<artifactId>jsp-api</artifactId>
			<version>2.1</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
	
		<!-- Test -->
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.7</version>
			<scope>test</scope>
		</dependency>        
	</dependencies>
    <build>
        <plugins>
            <plugin>
                <artifactId>maven-eclipse-plugin</artifactId>
                <version>2.9</version>
                <configuration>
                    <additionalProjectnatures>
                        <projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>
                    </additionalProjectnatures>
                    <additionalBuildcommands>
                        <buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>
                    </additionalBuildcommands>
                    <downloadSources>true</downloadSources>
                    <downloadJavadocs>true</downloadJavadocs>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>2.5.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <compilerArgument>-Xlint:all</compilerArgument>
                    <showWarnings>true</showWarnings>
                    <showDeprecation>true</showDeprecation>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.codehaus.mojo</groupId>
                <artifactId>exec-maven-plugin</artifactId>
                <version>1.2.1</version>
                <configuration>
                    <mainClass>org.test.int1.Main</mainClass>
                </configuration>
            </plugin>
        </plugins>
    </build>
	<repositories>
		<repository>
			<id>alimaven</id>
			<name>aliyun maven</name>
			<url>http://maven.aliyun.com/nexus/content/groups/public/</url>
			<releases>
				<enabled>true</enabled>
			</releases>
			<snapshots>
				<enabled>false</enabled>
			</snapshots>
		</repository>
	</repositories>
</project>

配置web.xml文件：

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

	<!-- The definition of the Root Spring Container shared by all Servlets and Filters -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:web*.xml</param-value>
	</context-param>
	
	<!-- Creates the Spring Container shared by all Servlets and Filters -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>

	<!-- Processes application requests -->
	<servlet>
		<servlet-name>appServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:webmvc-config.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
		
	<servlet-mapping>
		<servlet-name>appServlet</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>

	<!-- 字符集 过滤器 -->
	<filter>
		<filter-name>CharacterEncodingFilter</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>CharacterEncodingFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>
</web-app>

在resources下创建配置文件：

创建连接数据库资源文件jdbc.properties

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

创建日志log4j.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration PUBLIC "-//APACHE//DTD LOG4J 1.2//EN" "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">

	<!-- Appenders -->
	<appender name="console" class="org.apache.log4j.ConsoleAppender">
		<param name="Target" value="System.out" />
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="%-5p: %c - %m%n" />
		</layout>
	</appender>
	
	<!-- Application Loggers -->
	<logger name="com.hp.controller">
		<level value="info" />
	</logger>
	
	<!-- 3rdparty Loggers -->
	<logger name="org.springframework.core">
		<level value="info" />
	</logger>
	
	<logger name="org.springframework.beans">
		<level value="info" />
	</logger>
	
	<logger name="org.springframework.context">
		<level value="info" />
	</logger>

	<logger name="org.springframework.web">
		<level value="info" />
	</logger>

	<!-- Root Logger -->
	<root>
		<priority value="warn" />
		<appender-ref ref="console" />
	</root>
	
</log4j:configuration>

创建webdao-config.xml文件

1.加载jdbc.properties配置

2、配置数据源

3、配置SqlSessionFactory（注入数据源，加载mybatis的配置文件，扫描pojo包，）

4、配置扫描Dao接口包，注入给spring管理

5、配置sqlSessionTemplate

<?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"  
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
	http://www.springframework.org/schema/aop 
	http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
	http://www.springframework.org/schema/context 
	http://www.springframework.org/schema/context/spring-context-4.3.xsd">
	
	<!-- 1、加载jdbc.properties配置 -->
	<context:property-placeholder location="classpath:jdbc.properties"/>
	
	<!-- 2、配置数据源 -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
	        <property name="driverClassName" value="${jdbc.driverClassName}"/>
	        <property name="url" value="${jdbc.url}"/>
	        <property name="username" value="${jdbc.username}"/>
	        <property name="password" value="${jdbc.password}"/>
	</bean>

	<!-- 3、配置SqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 注入数据源 -->
		<property name="dataSource" ref="dataSource"></property>
		<!-- 加载mybatis的配置文件 -->
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
		<!-- 扫描pojo包 -->
		<property name="typeAliasesPackage" value="cn.xxs.pojo"></property>
		<!-- 扫描mapper所需要的xml文件 ,使用xml方式-->
		<!-- <property name="mapperLocations" value="classpath:mapper/.xml"></property> -->
	</bean>

	<!-- 4、配置扫描Dao接口包，注入给spring管理 -->
	<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
		<!-- 扫描dao层接口 -->
		<property name="basePackage" value="cn.xxs.mapper"></property>
	</bean>
	
	<!-- 5、配置sqlSessionTemplate -->
	<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg index="0">
			<ref bean="sqlSessionFactory"/>
		</constructor-arg>
	</bean>
</beans>

创建webmvc-config.xml文件

1.开启springMVC注解模式

2. 扫描web相关的bean

3.静态资源默认从service配置

4.引入其它配置文件

<?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:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc 
	http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
		http://www.springframework.org/schema/beans 
		http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
		http://www.springframework.org/schema/context 
		http://www.springframework.org/schema/context/spring-context-4.3.xsd">

	<!-- 开启springMVC注解模式 -->	
	<mvc:annotation-driven conversion-service="conversionService"/>


	<!-- 扫描web相关的bean -->
	<context:component-scan base-package="cn.xxs" >
		 <!-- 了容器不去扫描service层 -->
		<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service"/>
		</context:component-scan>

	<!-- 静态资源默认从service配置-->
	<mvc:default-servlet-handler/>

	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/views/" />
		<property name="suffix" value=".jsp" />
	</bean>
	
	 <!-- 文件上传 -->
	<!--<bean id="multipartResolver"
		class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
		<property name="defaultEncoding" value="utf-8"/>默认编码ISO-8859-1
		<property name="maxInMemorySize" value="10240"/>最大内存 10M
		<property name="uploadTempDir" value="/upload/" />上传的文件名字
		<property name="maxUploadSize" value="-1" />最大文件，-1不限制
	</bean> -->
	
	<!-- 引入其它配置文件-->
	<import resource="webdao-config.xml"/>
	
</beans>

创建webservice-config.xml文件

1. 扫描包下所有的注解类型

2. 配置事务管理器

3.开启注解事务

<?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" 
	xmlns:aop="http://www.springframework.org/schema/aop" 
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
	http://www.springframework.org/schema/aop 
	http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
	http://www.springframework.org/schema/context 
	http://www.springframework.org/schema/context/spring-context-4.3.xsd">
	
	<!-- 扫描 包下所有的注解类型 -->
	<context:component-scan base-package="cn.xxs.service.impl"></context:component-scan>

	<!-- 配置事务管理器 -->
    <bean id="transactionManager"
           class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
          <!-- 注入数据库连接池 -->
           <property name="dataSource" ref="dataSource" />
    </bean>
	 
	<!-- 开启注解事务 -->
	<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>

创建mybatis-config.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>
	<!-- 配置全局属性 -->
        <settings>
                <!-- 使用jdbc的getGeneratedKeys获取数据库自增主键值 -->
                <setting name="useGeneratedKeys" value="true" />

                <!-- 使用列别名替换列名 默认:true -->
                <setting name="useColumnLabel" value="true" />

                <!-- 开启驼峰命名转换:Table{create_time} -> Entity{createTime} -->
                <setting name="mapUnderscoreToCamelCase" value="true" />
        </settings>
</configuration>

在java下主要代码：

创建pojo：

package cn.xxs.pojo;

import java.util.Date;
import java.util.List;
/**
 * 学生实体类
 * @author xxs
 */
public class User {
	
	private Integer id;
	private String name;	
	private String pwd;
	private Date createDate;
	public User() {
		super();
		// TODO Auto-generated constructor stub
	}
	public User(Integer id, String name, String pwd, Date createDate) {
		super();
		this.id = id;
		this.name = name;
		this.pwd = pwd;
		this.createDate = createDate;
	}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	public Date getCreateDate() {
		return createDate;
	}
	public void setCreateDate(Date createDate) {
		this.createDate = createDate;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", pwd=" + pwd + ", createDate=" + createDate + "]";
	}
	
	
}

创建接口UserMapper：

(通过使用@MapperScan可以指定要扫描的Mapper类的包的路径)

package cn.xxs.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.mybatis.spring.annotation.MapperScan;

import cn.xxs.pojo.User;

@MapperScan
public interface UserMapper {
	/**
	 * 查询用户信息
	 */
	@Select("select * from user")
	public List<User> findUsers();
	/**
	 * 添加用户信息
	 */
	@Insert("insert into user(name,pwd,createDate)values(#{name},#{pwd},#{createDate})")
	int insertUser(User user);
	
	/**
	 * 根据userId删除用户信息
	 */
	@Delete("delete from user where id=#{id}")
	int deleteUserByUserId(Integer id);
	
	/**
	 * 更新用户信息，通过Id
	 */
	@Update("update user set name = #{name},pwd = #{pwd} where id = #{id}")
	void updateUserByUserId(User user);
	/**
	 * 根据Id 查询用户信息
	 */
	@Select("select * from user where id = #{id}")
	User selectUserById(Integer id);
}

创建service层接口：

package cn.xxs.service;

import java.util.List;

import cn.xxs.pojo.User;

public interface IUserService {
	/**
	 * 查询所有用户信息
	 * @return
	 */
	public List<User> findUsers();
	
	/**
	 * 添加用户信息
	 */
	int insertUser(User user);
	/**
	 * 根据Id删除用户信息
	 */
	int deleteUserById(Integer id);
	
	/**
	 * 更新用户信息，通过Id
	 */
	void updateUserById(User user);		
	
	/**
	 * 根据Id 查询用户信息
	 */
	User selectUserById(Integer id);
}

创建service层接口的实现类：

@Service("serviceName")注解相当于applicationContext.xml配置文件中配置的<bean id="serviceName">，表示给当前类命名一个别名，方便注入到其他需要用到的类中。@Service注解也可以不指定serviceName,如果不指定相当于<bean id="com.study.service.serviceName">，com.study.service.ServiceName就是这个类的全限定名,不加的话，默认别名就是当前类名，但是首字母小写。
@Transactional注解:
1.实质是使用了JDBC的事务来进行事务控制的
2.基于Spring的动态代理的机制
3.@Transactional实现原理
1)事务开始时，通过AOP机制，生成一个代理connection对象，并将其放入DataSource实例的某个与DataSourceTransactionManager相关的某处容器中。在接下来的整个事务中，客户代码都应该使用该connection连接数据库，执行所有数据库命令[不使用该connection连接数据库执行的数据库命令，在本事务回滚的时候得不到回滚]（物理连接connection逻辑上新建一个会话session；DataSource与TransactionManager配置相同的数据源）
2)事务结束时，回滚在第1步骤中得到的代理connection对象上执行的数据库命令，然后关闭该代理connection对象（事务结束后，回滚操作不会对已执行完毕的SQL操作命令起作用）

@Resource:

1.它在语义上被定义为通过其唯一的名称来标识特定的目标组件，其中声明的类型与匹配过程无关。

2.如果没有明确指定名称，则默认名称是从字段名称或设置方法（get、set方法）派生的。如果用在字段上，则采用字段名称; 如果用在在setter方法，它采用其属性名称（例如getProperty()方法，取property做为属性名称)。

package cn.xxs.service.impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import cn.xxs.mapper.UserMapper;
import cn.xxs.pojo.User;
import cn.xxs.service.IUserService;


@Service
@Transactional
public class UserService  implements IUserService{

	@Resource
	private UserMapper userMapper;
	/**
	 * 查询用户信息
	 */
	public List<User> findUsers(){
		
		return userMapper.findUsers();
	}
	/**
	 * 添加用户信息
	 */
	public int insertUser(User user) {
		
		return userMapper.insertUser(user);
	}
	
	/**
	 * 更新用户信息，通过userId
	 */
	public void updateUserById(User user) {
		
		 userMapper.updateUserByUserId(user);
	}
	/**
	 * 根据Id 查询用户信息
	 */
	@Override
	public User selectUserById(Integer id) {
		
		return userMapper.selectUserById(id);
	}
	/**
	 * 根据userId删除用户信息
	 */
	public int deleteUserById(Integer id) {
		
		return userMapper.deleteUserByUserId(id);
	}
	
}

创建启动类：

用@Configuration加载spring

@Configuration启动容器+@Bean注册Bean

package cn.xxs.util;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.format.datetime.DateFormatter;
import org.springframework.format.datetime.DateFormatterRegistrar;
import org.springframework.format.number.NumberFormatAnnotationFormatterFactory;
import org.springframework.format.support.DefaultFormattingConversionService;
import org.springframework.format.support.FormattingConversionService;

@Configuration
public class AppConfig {

	@Bean
	public FormattingConversionService conversionService() {

		// Use the DefaultFormattingConversionService but do not register defaults
		DefaultFormattingConversionService conversionService = new DefaultFormattingConversionService(false);

		// Ensure @NumberFormat is still supported
		conversionService.addFormatterForFieldAnnotation(new NumberFormatAnnotationFormatterFactory());

		// Register date conversion with a specific global format
		DateFormatterRegistrar registrar = new DateFormatterRegistrar();
		registrar.setFormatter(new DateFormatter("yyyy-MM-dd"));
		registrar.registerFormatters(conversionService);
		
		return conversionService;
	}
}

创建控制层获取Request和Session的工具类：

package cn.xxs.controller;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;

public class BaseController {
	/**
	 * 获取Request
	 * web.xml中先设置获取request的监听
	 * @return
	 */
	public HttpServletRequest getRequest() {
		
		return ((ServletRequestAttributes)RequestContextHolder.getRequestAttributes()).getRequest();
	}

	/**
	 * 获取Session
	 */
	public HttpSession getSession() {
		
		return getRequest().getSession();
	}
	
}

创建控制类UserController，继承控制层获取Request和Session的工具类

（spring mvc中使用 @Controller 定义一个 Controller 控制器，使用 @RequestMapping 来映射 Request 请求与处理器。）

1.@Controller 用于标记在一个类上，使用它标记的类就是一个SpringMVC Controller 对象。分发处理器将会扫描使用了该注解的类的方法，并检测该方法是否使用了@RequestMapping 注解。@Controller 只是定义了一个控制器类，而使用@RequestMapping 注解的方法才是真正处理请求的处理器

2.可以使用@RequestMapping 来映射URL 到控制器类，或者是到Controller 控制器的处理方法上。当@RequestMapping 标记在Controller 类上的时候，里面使用@RequestMapping 标记的方法的请求地址都是相对于类上的@RequestMapping 而言的；当Controller 类上没有标记@RequestMapping 注解时，方法上的@RequestMapping 都是绝对路径。这种绝对路径和相对路径所组合成的最终路径都是相对于根路径“/ ”而言的。

package cn.xxs.controller;

import java.util.Date;
import java.util.List;
import java.util.Locale;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.websocket.server.PathParam;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import cn.xxs.pojo.User;
import cn.xxs.service.IUserService;


@Controller
@RequestMapping("user")
public class UserController extends BaseController{
	
	@Resource
	private IUserService userService;
	
	@RequestMapping(value = "userInfo")
	public String userInfo() {
		System.out.println("userInfo");
		List<User> userList = userService.findUsers();
		
		getRequest().setAttribute("userList", userList);
		
		return "user/userInfo";
	}	
	
	/*	@RequestMapping(value="deleteUser")
	public String delete(HttpServletRequest request) {
		
		String uId = request.getParameter("userId");
		
		int result = userService.deleteUserById(Integer.parseInt(uId));
		
		return "redirect:userInfo";
	}*/
	
	@RequestMapping(value="delUser")
	public String delete(HttpServletRequest request,@PathParam("id") Integer id) {
		
		int result = userService.deleteUserById(id);
		
		return "redirect:userInfo";
	}
	
	/**
	 * 进入新增页面
	 */
	@RequestMapping(value="editUser")
	public String edit() {
		
		return "user/editUser";
	}
	
	/**
	 * 保存用户信息
	 */
	@RequestMapping(value="addUser")
	public String add(User user) {
		
		userService.insertUser(user);
		
		return "redirect:userInfo";
	}
	
	/**
	 * 进入更新页面
	 */
	@RequestMapping(value="renewalUser")
	public String renewal(HttpServletRequest request,@PathParam("id") Integer id) {
		
		User u = userService.selectUserById(id);
		getRequest().setAttribute("u", u);
		return "user/renewalUser";
	}
	
	/**
	 *更新用户信息
	 */
	@RequestMapping(value="updateUser")
	public String update(User user) {		
		
		//User u = userService.selectUserById(user.getId());
		userService.updateUserById(user);
		
		return "redirect:userInfo";
	}
}

页面:

在webapp下创建一个index.jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<a href="/ssm_select/user/userInfo">查询用户信息</a>
</body>

在view下创建user文件夹，在uesr下创建用户列表页面userInfo.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<a href="/ssm_select/user/editUser">新增数据</a>
<table>
	<tr>
		<td>用户编号</td>
		<td>用户姓名</td>		
		<td>密码</td>
		<td>创建时间</td>
		<td>操作</td>
	</tr>
	<c:forEach items="${userList }" var="user">
		<tr>
			<td>${user.id }</td>
			<td>${user.name }</td>			
			<td>${user.pwd }</td>
			<td><fmt:formatDate value="${user.createDate }" pattern="yyyy-MM-dd"/></td>	
			<td><a href="/ssm_select/user/delUser?id=${user.id }">删除</a>
			<a href="/ssm_select/user/renewalUser?id=${user.id }">更新</a></td>		
		</tr>
	</c:forEach>
</table>
</body>
</html>

点击新增数据进入新增页面editUser.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>添加用户</title>
</head>
<body>
	<form action="/ssm_select/user/addUser" method="post">
		<table>
			<tr>
				<td>用户名：</td>
				<td><input type="text" name="name" /></td>
			</tr>
			<tr>
			    <td>密码：</td>
				<td><input type="text" name="pwd" /></td>
			</tr>			
			<tr>
				<td>创建日期：</td>
				<td><input type="date" name="createDate" /></td>
			</tr>
			<tr>
				<td colspan=2><input type="submit" value="保存" /></td>
			</tr>
		</table>
	</form>
</body>
</html>

点击保存跳转到列表页面发现新增一条数据，如下图

点击更新13条数据，进入更新页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>更新用户</title>
</head>
<body>
	<form action="/ssm_select/user/updateUser" method="post">
		<table>
			<tr>				
				<td><input type="hidden" name="id" value="${u.id }"/></td>
			</tr>
			<tr>
				<td>用户名：</td>
				<td><input type="text" name="name" value="${u.name }"/></td>
			</tr>
			<tr>
			    <td>密码：</td>
				<td><input type="text" name="pwd" value="${u.pwd }"/></td>
			</tr>						
			<tr>
				<td colspan=2><input type="submit" value="更新" /></td>
			</tr>
		</table>
	</form>
</body>
</html>

点击更新跳转到列表页面发现13条数据被更新，如下图

点击删除第10条数据，跳转到本页面，发现第10条数据被删除了，如下图

ok，这就是ssm简单的增删改查。

小小舍

关注

4
点赞
踩
26

收藏

觉得还不错? 一键收藏
0
评论
ssm框架的整合及增删改查

项目结构：数据库表：给项目添加依赖：<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocat...
复制链接

扫一扫