SpringMVC入门 -ORM及mybatis学习

1、pom.xml配置
这里ORM利用的是mybatis库，因此添加依赖。

<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis</artifactId>
	<version>3.4.6</version>
</dependency>

2、待实现的数据接口
添加了searchNewsData来对newsData的name和content进行模糊匹配，返回列表。

package gensoku.data;

import java.util.List;

public interface newsDataHub 
{
    public void addNewsData(newsData n);
    public newsData getNewsDataByID(int id);
    public List<newsData> searchNewsData(String str);
    public int retMaxID();
}

3、webConfig配置
无需进行数据源、连接池的显式初始化，因为mybatis会读取配置文件并完成该工作；数据仓库初始化需要传入配置文件的地址。

package gensoku;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.ViewResolver;
import org.springframework.web.servlet.config.annotation.DefaultServletHandlerConfigurer;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter;
import org.springframework.web.servlet.view.InternalResourceViewResolver;

import gensoku.respository.myRespository;

@Configuration
@EnableWebMvc
//@ComponentScan("gensoku")
public class webConfig extends WebMvcConfigurerAdapter
{

    //数据仓库
    @Bean
    public myRespository retMyRespository()
    {
        return new myRespository("/gensoku/config/myBatisConfig.xml");
    }

    @Bean
    public myController retController()
    {
        myRespository mr = retMyRespository();
        if(mr != null)
            return new myController(mr, "F:/java_demo/rumia_spring_ORM/res/");
        else
            return null;
    }

    @Bean
    public ViewResolver viewResolver()
    {
        InternalResourceViewResolver rs = new InternalResourceViewResolver();
        rs.setPrefix("/WEB-INF/classes/pages/");
        rs.setExposeContextBeansAsAttributes(true);
        return rs;
    }

    @Override
    public void configureDefaultServletHandling(DefaultServletHandlerConfigurer con)
    {
        con.enable();
    }
}

4、myBatisConfig.xml配置文件
被mybatis库用于初始化配置数据源、连接池，同时指定ORM映射的配置文件。

<?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>
    <environments default="development">
        <environment id="development">
        <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/webapp"/>
                <property name="username" value="webber"/>
                <property name="password" value="rumia"/>
            </dataSource>
        </environment>
    </environments>
    
    <mappers>
        <mapper resource="/gensoku/config/newsMapping.xml"/>
    </mappers>
</configuration>

5、newsMapping.xml配置文件
配置ORM映射。mybatis利用JDBC和动态代理技术来实例化自定义的库操作接口，然后开发者可以直接调用该实例对象（ORM对象）的接口来完成数据持久化操作，从而完成数据持久化层和数据库层的解耦；这里的配置文件就是用来指明库操作接口与sql语句间的操作映射。
主要配置项为待实例化的接口类，接口函数，sql传入参数，返回类型等，传入参数内嵌在sql语句中；还可以定义返回对象的值映射、动态sql、cache等。

<?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="gensoku.respository.newsMapper">
    
    <resultMap id="ansMap" type="gensoku.data.newsData">
        <id property="id" column="id" />
        <result property="name" column="name"/>
        <result property="content" column="content"/>
    </resultMap>

    <select id="selectNewsByID" resultMap="ansMap">
        select id,name,content from newsHub 
        <where>
            <if test="id != null">
                id=#{id}
            </if>
        </where>
    </select>

    <select id="searchNews" resultMap="ansMap">
        select id,name,content from newsHub where ${column} like #{name}
    </select>

    <insert id="insertNews">
        insert into newsHub (id,name,content) values (#{id},#{name},#{content})
    </insert>

    <select id="retNewsMaxID" resultType="int">
        select max(id) from newsHub
    </select>
</mapper>

6、newsMapper 自定义的库操作接口
该定义需和newsMapping.xml相对应，包括函数名，参数和返回类型；传入的sql参数是利用标注来指定的。

package gensoku.respository;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import gensoku.data.newsData;

public interface newsMapper
{
    public newsData selectNewsByID(@Param("id") int id);
    public List<newsData> searchNews(@Param("column") String column, @Param("name") String id);
    public void insertNews(@Param("id") int id, @Param("name") String name, @Param("content") String content);
    public int retNewsMaxID();
}

7、myRespository 数据仓库（即DOA）
直接利用实例化得到的ORM对象执行数据库操作。

package gensoku.respository;

import java.io.InputStream;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.springframework.stereotype.Component;

import gensoku.data.newsData;
import gensoku.data.newsDataHub;

@Component
public class myRespository implements newsDataHub
{
    SqlSessionFactory sqlSessionFactory;

    public myRespository() {}

    public myRespository(String resConfigPath)
    {
        try
        {
        	//利用传入配置地址初始化sqlSessionFactory
            InputStream is = Resources.getResourceAsStream(resConfigPath);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }

    @Override
    public void addNewsData(newsData n)
    {
        try
        {
        	//利用sqlSessionFactory获得新的session
            SqlSession session = sqlSessionFactory.openSession();
            //利用session返回实例化的ORM对象
            newsMapper mapper = session.getMapper(newsMapper.class);
            //调用ORM对象的接口执行数据库插入操作
            mapper.insertNews(n.getId(), n.getName(), n.getContent());
            //提交事务并关闭session
            session.commit(); 
            session.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }

    }

    @Override
    public newsData getNewsDataByID(int id) 
    {
        try
        {
            SqlSession session = sqlSessionFactory.openSession();
            newsMapper mapper = session.getMapper(newsMapper.class);
            newsData ans = mapper.selectNewsByID(id);
            session.close();
            return ans;
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return null;
        }
    }

    @Override
    public List<newsData> searchNewsData(String str)
    {
        try
        {
            String ss = "%"+str+"%";
            SqlSession session = sqlSessionFactory.openSession();
            newsMapper mapper = session.getMapper(newsMapper.class);
            //分别对name和content进行模糊匹配，将结果合并
            List<newsData> ans = mapper.searchNews("name", ss);
            ans.addAll(mapper.searchNews("content", ss));
            session.close();
            return ans;
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return null;
        }
	}

    @Override
    public int retMaxID() 
    {
        try
        {
            SqlSession session = sqlSessionFactory.openSession();
            newsMapper mapper = session.getMapper(newsMapper.class);
            int ans = mapper.retNewsMaxID();
            session.close();
            return ans;
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return -1;
        }
    }
}