Spring MVC+MyBatics+Spring集成小例子

缺乏、安全感 2022-04-21 14:29 214阅读 0赞

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd" >
    <mapper namespace="dao.PersonMapper">
    
    
      
      <resultMap type="Person" id="mylist" >
       <id property="id" column="id"/>
       <result property="name" column="name"/>
       <result property="age" column="age"/>
       
        <association property="country" javaType="Country" column="cid">
      <id property="id" column="cid"/>
      <result property="cname" column="cname"/>
      </association>
      </resultMap>
    
      
         <select id="getAll" resultType="Person" resultMap="mylist">
      select 
    
       p.id as id,p.`name` as name ,p.age  as age ,
       c.cname as cname   ,c.id as cid 
    
       from
    
       person p,country c 
    
       where p.cid=c.id  
       order by id
      </select>
    
     
      <insert id="save"> 
    insert into person(name,age,cid) 
    values(#{name},#{age},#{country.id}) 
    </insert>
    
    <delete id="delete">
    delete from person where id=#{id}
    </delete>
    
    
    
    <update id="update">
    
    update person set name=#{name},age=#{age},cid=#{country.id} where id=#{id} 
    </update>
    
    <select id="get" resultType="Person" resultMap="mylist"  >
    select *from  person where id=#{id}
    </select>
    
    
    
    
      
    
       
    
    </mapper>

\[b\]\[color=green\]\[size=large\]实体类country的映射配置\[/size\]\[/color\]\[/b\]

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd" >
    <mapper namespace="dao.CountryMapper">
    
    
      
      <resultMap type="Country" id="mylist" >
       <id property="id" column="id"/>
       <result property="cname" column="cname"/>
    
      </resultMap>
    
      
         <select id="getAll" resultType="Country" resultMap="mylist">
      select 
    
       id,cname
    
       from
    
       country 
    
      </select>
    
    
    
    
    
      
    
       
    
    </mapper>

\[b\]\[color=olive\]\[size=large\]Mybatics通用DAO的写法\[/size\]\[/color\]\[/b\]

package commons;
    
    import java.io.Serializable;
    import java.util.List;
    
    import org.mybatis.spring.support.SqlSessionDaoSupport;
    
    /**
     * 操作mybatis的工具接口
     * 
     * */
    public class MyBatisDao extends SqlSessionDaoSupport {
       
    
    	   /**
    	    * @param key 命名空间+id值
    	    * @param o 需要进行保存的实体类
    	    * 保存的方法
    	    * */
    	   public void save(String key,Object o){
       
    
    		   this.getSqlSession().insert(key, o);
    	   }
    
    	   /**
    	    * 删除的方法
    	    * */
    	   public void delete(String key,Object o){
       
    		   this.getSqlSession().delete(key, o);
    	   }
    
    	   /**
    	    * 修改的方法
    	    * */
    	   public void update(String key,Object o){
       
    		   this.getSqlSession().update(key, o);
    
    	   }
    
    	   /**
    	    * 根据ID 查询单个实体类
    	    * */
    	   public <E> E get(String key,Serializable id){
       
    		   return this.getSqlSession().selectOne(key,id);
    	   }
    
    	   /***
    	    * 查询实体类集合
    	    * 
    	    * */
    	   public <E> List<E> getAll(String key){
       
    
    		   return this.getSqlSession().selectList(key);
    	   }
    
    	   /***
    	    * 查询实体类的总个数
    	    * */
    	   public int count(String key){
       
    		   return this.getSqlSession().selectOne(key);
    	   }
    	   /**
    	    * 查询总集合数
    	    * 
    	    * */
           public <E> List<E> pageList(String key,Object o){
       
        	   return this.getSqlSession().selectList(key,o);
           }
    }

\[b\]\[color=green\]\[size=large\]Spirng注解控制器类\[/size\]\[/color\]\[/b\]

package controller;
    
    import java.util.ArrayList;
    import java.util.List;
    
    import javax.annotation.Resource;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    
    import org.springframework.stereotype.Controller;
    
    import org.springframework.web.bind.annotation.RequestBody;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    
    import com.google.gson.Gson;
    import commons.MyBatisDao;
    
    
    
    import dao.CountryDao;
    import dao.PersonDao;
    import entity.Country;
    import entity.Person;
    
    /**
     * @author 秦东亮
     * 技术群:324714439
     * 
     * 
     * */
    @Controller
    public class PersonController {
       
    
    	@Resource(name="personDao")
    	  private PersonDao personDao;
    
    	 public PersonDao getPersonDao() {
       
    		return personDao;
    	}
    
    	public void setPersonDao(PersonDao personDao) {
       
    		this.personDao = personDao;
    
    	}
    	@Resource(name="countryDao")
    	private CountryDao countryDao;
    
    
    	public CountryDao getCountryDao() {
       
    		return countryDao;
    	}
    
    	@Resource(name="dao")
    	 private MyBatisDao dao;
    
    
    	public MyBatisDao getDao() {
       
    		return dao;
    	}
    
    	public void setDao(MyBatisDao dao) {
       
    		this.dao = dao;
    	}
    
    	public void setCountryDao(CountryDao countryDao) {
       
    		this.countryDao = countryDao;
    	}
    
    	/**
    	 * 输出所有的用户信息
    	 * 
    	 * **/
    	@RequestMapping( value="/showAll")
    	public String showAll(HttpServletRequest request)throws Exception{
       
    
    		//MyBatisDao dao=new MyBatisDao();
    //		/request.setAttribute("plist", personDao.find(" from Person "));
    		request.setAttribute("plist",dao.getAll("dao.PersonMapper.getAll"));
    
    		 return "showAll";
    	 }
    
    	/**
    	 * 输出所有的国家信息
    	 * 
    	 * **/
    	@RequestMapping( value="/add")
    	public String add(HttpServletRequest request)throws Exception{
       
    
    
    		//request.setAttribute("clist", countryDao.find(" from Country "));
    		 request.setAttribute("clist", dao.getAll("dao.CountryMapper.getAll"));
    
    		 return "adda";
    	 }
    
    	 /**
    	  * 删除的方法
    	  * */
    	@RequestMapping( value="/delete")
    	public String delete(HttpServletRequest request)throws Exception{
       
    
    		 int id=Integer.parseInt(request.getParameter("id"));
    		 //personDao.delete(personDao.get(id));
    		 dao.delete("dao.PersonMapper.delete", id);
    		 return "redirect:/showAll";
    	 }
    
    	 /**
    	  * 删除的方法
    	  * request域的写法
    	  * */
    	@RequestMapping( value="/update")
    	public String update(HttpServletRequest request)throws Exception{
       
    
    		 int id=Integer.parseInt(request.getParameter("id"));
    
    
    		 //request.setAttribute("p", personDao.get(id));
    		  request.setAttribute("p", dao.get("dao.PersonMapper.get", id));
    		  request.setAttribute("clist", dao.getAll("dao.CountryMapper.getAll"));
    
    		 //request.setAttribute("clist", countryDao.find(" from Country "));
    
    
    
    		 return "update";
    	 }
    
    
    	 /**
    	  * 更新的操作
    	  * 封装成实体类的写法
    	  * */
    	@RequestMapping( value="/sup",method=RequestMethod.POST)
    	public String sup(Person person,HttpServletRequest request){
       
    
    		try{
       
    
    			//personDao.update(person);
    			dao.update("dao.PersonMapper.update", person);
    //		 System.out.println("111");
    	//	System.out.println(person.getName());
    			//System.out.println(person.getCountry().getId());
    			//System.out.println(request.getParameter("name"));
    
    		}catch (Exception e) {
       
    			 e.printStackTrace();
    		}
    		 return "redirect:/showAll";
    	 }
    
    	/**
    	 * 保存一条数据
    	 * 没有使用实体类自动封装的功能
    	 * 
    	 * **/
    
    	@RequestMapping( value="/save",method=RequestMethod.POST)
    
    	public void  save(HttpServletRequest request,HttpServletResponse response)throws Exception{
       
    
    
    	//   personDao.save(person);//保存成功
    
     	 Person person=new Person();
     	 person.setAge(Integer.parseInt(request.getParameter("age")));
     	 person.setName(request.getParameter("name"));
     	 Country c=new Country();
     	 c.setId(Integer.parseInt(request.getParameter("cid")));
     	 person.setCountry(c);
     	 personDao.save(person);
    
     	//System.out.println("cid :  "+request.getParameter("cid"));
        Gson g=new Gson();
    //    List<String> list=new ArrayList<String>();
    //    list.add("A");
    //    list.add("B");
    //    list.add("C");
    //    list.add("D");
        response.setCharacterEncoding("UTF-8");
        response.setContentType("application/json;charset=utf-8");
        //response.getWriter().write(g.toJson(list)); 
        response.getWriter().write(g.toJson("添加成功!")); 
    	//	response.getWriter().write("1");
    
    
    
    	 }
    
    
    	/**
    	 * 保存一条数据
    	 * 基于ajax的json自动封装的
    	 * 实体类
    	 * 注意有嵌套类时的
    	 * 写法"county.id"
    	 * 
    	 * **/
    
    	@RequestMapping( value="/savetwo",method=RequestMethod.POST)
    
    	public void  savetwo(Person person,HttpServletRequest request,HttpServletResponse response)throws Exception{
       
    
    	   //personDao.save(person);//保存成功
    
    		//System.out.println(person.getName());
    		dao.save("dao.PersonMapper.save", person);
    
    	//	System.out.println(person);
     	//System.out.println("cid :  "+request.getParameter("cid"));
        Gson g=new Gson();
    //    List<String> list=new ArrayList<String>();
    //    list.add("A");
    //    list.add("B");
    //    list.add("C");
    //    list.add("D");
        response.setCharacterEncoding("UTF-8");
        response.setContentType("application/json;charset=utf-8");
        //response.getWriter().write(g.toJson(list)); 
        response.getWriter().write(g.toJson("添加成功!")); 
    	//	response.getWriter().write("1");
    
    
    
    	 }
    
    
    }

\[b\]\[color=olive\]\[size=large\]Spring的servlet的xml的配置:\[/size\]\[/color\]\[/b\]

<?xml version="1.0" encoding="UTF-8"?>
    <beans default-autowire="byName" 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/beans
            http://www.springframework.org/schema/beans/spring-beans.xsd
            http://www.springframework.org/schema/context  
             http://www.springframework.org/schema/context/spring-context-3.0.xsd  
           http://www.springframework.org/schema/mvc  
           http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
    
            ">
    
       
        <context:component-scan base-package="controller" />  
    
          
        <mvc:annotation-driven />  
    
    
       
    	 
    
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    
    
            <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
            <property name="prefix" value="/WEB-INF/jsp/"/>
            <property name="suffix" value=".jsp"/>
        </bean>
    
          
        
          
          <bean class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping"></bean>
          
          <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
         
    
    
          </bean>
             
           <bean id="dao" class="commons.MyBatisDao">  
         <property name="sqlSessionFactory" ref="sqlSessionFactoryBean"></property>
        </bean>
    
          
        <mvc:resources location="/jquery/" mapping="/jquery/**" />  
       
    </beans>