ssm的增删改查实现

1.controller实现

package com.controller;
import java.util.List;

import javax.annotation.Resource;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.model.User;
import com.service.UserService;

@Controller
public class UserController {
	@Resource
     private UserService userService;
    //增
    @RequestMapping("/add")
    public String add(User user){
    	int a = userService.adduser(user);
		return "add";
    }
    //查
    @RequestMapping("/find")
    public String find(Model model){
    	List<User> list = userService.find();
    	model.addAttribute("list", list);
		return "find";
    } 
    //改
    @RequestMapping("/update")
    public String update(User user){
    	int u = userService.update(user);
		return "redirect:find.go";
    }
    //删
    @RequestMapping("/delete")
    public String delete(User user){
    	int d = userService.delete(user.getId());
		return "redirect:find.go";
    }    
}

2.daoimpl实现：

package com.dao;

import java.util.List;

import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.springframework.stereotype.Repository;

import com.model.User;
@Repository
public class UserDaoImpl extends SqlSessionDaoSupport{
    
	public int adduser(User user) {
		int a = this.getSqlSession().insert("user.add", user);
		return a;
	}

	public List<User> find() {
	    List<User> list = this.getSqlSession().selectList("user.find");
		return list;
	}

	public int update(User user) {
		int u = this.getSqlSession().update("user.update",user);
		return u;
	}

	public int delete(int id) {
	    int d = this.getSqlSession().delete("user.delete", id);
		return d;
	}


}

3.mapper.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 namespace="user">

    <select id="find"  resultType="com.model.User">
        select * from user
    </select>
    
    <delete id="delete">
       delete  from user where id=#{id}
    </delete>
    
    <insert id="add">
      insert into user(username,password) values(#{username},#{password})
    </insert>
    
    <update id="update">
      update user
      <set>
        <if test="username!=null and username!=''">
           username=#{username},
        </if>
        <if test="password!=null and password!=''">
           password=#{password},
        </if>         
      </set>
      <where>
          id=#{id}
      </where>
    </update>
    
</mapper>

4.spring注入

<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:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans 
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.1.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
        http://www.springframework.org/schema/aop 
        http://www.springframework.org/schema/aop/spring-aop-3.1.xsd">
  
        <context:property-placeholder location="classpath:jdbc.properties"/>
  
        <!-- 注入数据源，整合c3p0 -->
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
           <property name="driverClass" value="${jdbc.driverClass}"/>
           <property name="jdbcUrl" value="${jdbc.url}"/>
           <property name="user" value="${jdbc.username}"/>
           <property name="password" value="${jdbc.password}"/>
           <!--配置数据库连接池的初始连接数、最小链接数、获取连接数、最大连接数、最大空闲时间-->
           <property name="initialPoolSize" value="10"/>
           <property name="minPoolSize" value="10"/>
           <property name="acquireIncrement" value="5"/>
           <property name="maxPoolSize" value="100"/>
           <property name="maxIdleTime" value="30"/>
           <property name="idleConnectionTestPeriod" value="18000"/>
        </bean>
        

        <!-- 获取sqlSessionFactory -->
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <!-- 1.注入数据源 -->
            <property name="dataSource" ref="dataSource"/>
            <property name="configLocation" value="classpath:mybatis-config.xml"/>
            <!-- 2.匹配mapper文件，自动装配 -->
            <property name="mapperLocations" value="classpath:com/mybatis/mapping/*.xml"/>
        </bean>
          
        <!-- 获取sqlSession，在spring里为SqlSessionTemplate -->  
        <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <!-- 给 SqlSessionTemplate 的构造函数赋值-->
        <constructor-arg index="0" ref="sqlSessionFactory" />
        </bean>
     
        <!-- 将sqlsession注入daoimpl数据实现层 -->
        <bean id="userDaoImpl" class="com.dao.UserDaoImpl">
        <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean> 
                
        <!-- 扫描注解 -->
        <context:component-scan base-package="com.service"/>
        
        
</beans>