Spring+Mybatis整合

最新推荐文章于 2024-07-15 15:14:58 发布

laotansuocai

最新推荐文章于 2024-07-15 15:14:58 发布

阅读量213

点赞数

分类专栏：学习点滴文章标签： spring mybatis

本文链接：https://blog.csdn.net/laotansuocai/article/details/76408665

版权

学习点滴专栏收录该内容

7 篇文章 0 订阅

订阅专栏

最近在学习Spring和Mybatis的框架，自己做了一个简单的Demo，记录一下笔记，有什么错误请大家指出。后面会继续更新，整合SpringMVC
构成SSM集合框架

这里写图片描述
所需jar包

2.代码
sqlMapConfig.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>
    <!-- 批量设置别名 -->
    <typeAliases>
        <package name="com.murong.ssm.po"/>
    </typeAliases>
    <mappers>
        <mapper resource="com/murong/bean/mapper/MkmSceneMapper.xml"/>
    </mappers>
</configuration>

applicationContext.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:context="http://www.springframework.org/schema/context"
    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">
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${mysql.jdbc.driver}"/>
        <property name="url" value="${mysql.jdbc.url}"/>
        <property name="username" value="${mysql.jdbc.username}"/>
        <property name="password" value="${mysql.jdbc.password}"/>
    </bean>
    <context:property-placeholder location="classpath:mysql.properties"/>

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="configLocation" value="classpath:myBatis/sqlMapConfig.xml"/>
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <bean id="MkmSceneDao" class="com.murong.dao.impl.MkmSceneDaoIpl">
        <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
    </bean>
</beans>

MkmSceneMapper.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="com.murong.mapper.MkmSceneMapper">
    <select id="qry_mkm_scene" parameterType="String" resultType="MkmScene">
        select * from t_mkm_scene where scene_id=#{scene_id}
    </select>
    <resultMap type="com.murong.ssm.po.MkmScene" id="SceneSpotResultMap">
        <id column="scene_id" property="scene_id" />
        <result column="merc_id" property="merc_id" />
        <result column="merc_nm" property="merc_nm" />
        <result column="scene_nm" property="scene_nm" />
        <result column="scene_level" property="scene_level" />
        <result column="scene_addr" property="scene_addr" />
        <collection property="spots" ofType="com.murong.ssm.po.MkmSpot">
            <id column="spot_id" property="spot_id" />
            <result column="spot_nm" property="spot_nm" />
            <result column="spot_str_tm" property="spot_str_tm" />
            <result column="spot_end_tm" property="spot_end_tm" />
            <result column="tm_smp" property="tm_smp" />
            <result column="chk_oper" property="chk_oper" />
            <result column="chk_dt" property="chk_dt" />
            <result column="chk_tm" property="chk_tm" />
            <result column="chk_sts" property="chk_sts" />
        </collection>
    </resultMap>

    <select id="findSceneSpot" resultMap="SceneSpotResultMap">
        SELECT s.scene_id
        ,s.merc_id,s.merc_nm,s.scene_nm,s.scene_level,s.scene_addr,t.spot_id,t.spot_nm
        ,t.spot_str_tm,t.spot_end_tm,t.tm_smp,t.chk_oper,t.chk_dt,t.chk_tm,t.chk_sts
        FROM t_mkm_scene s ,t_mkm_spot t WHERE s.scene_id=t.scene_id
    </select>
    </mapper>

MkmSceneDao.java

public interface MkmSceneDao {

    public List<MkmScene> qryMkmSceneSpot(String scene_id) throws IOException;
    public MkmScene qryMkmScene(String scene_id) throws IOException;

}

MkmSceneDaoIpl.java

public class MkmSceneDaoIpl extends SqlSessionDaoSupport implements MkmSceneDao {
    @Override
    public  List<MkmScene> qryMkmSceneSpot(String scene_id) throws IOException{
         SqlSession sqlSession = this.getSqlSession();
         List<MkmScene> list = sqlSession.selectList("com.murong.mapper.MkmSceneMapper.findSceneSpot", scene_id);
         return list;

    }

    @Override
    public MkmScene qryMkmScene(String scene_id) throws IOException {
         SqlSession sqlSession = this.getSqlSession();
         MkmScene mkmScene = sqlSession.selectOne("com.murong.mapper.MkmSceneMapper.qry_mkm_scene", scene_id);
         return mkmScene;
    }

}

MkmScene.java
省略get和set方法

public class MkmScene {
    private String  scene_id;
    private String  merc_id;
    private String  merc_nm;
    private String  scene_nm;
    private String  scene_level;
    private String  scene_addr;
    private String  image_url;
    private String  scene_detail;
    private String  ticket_price;
    private String  str_tm;
    private String  end_tm;
    private String  scene_sts;
    private String  cre_dt;
    private String  tm_smp;
    private String  scene_prov;
    private String  scene_city;
    private String  chk_oper;
    private String  chk_dt;
    private String  chk_tm;
    private String  chk_sts;
    private List<MkmSpot> spots;
}

MkmSpot.java
省略get和Set方法

public class MkmSpot {
    private String scene_id;
    private String spot_id;
    private String spot_nm;
    private String spot_level;
    private String spot_addr;
    private String spot_image_url;
    private String spot_detail;
    private String spot_ticket_price;
    private String spot_str_tm;
    private String spot_end_tm;
    private String tm_smp;
    private String merc_id;
    private String merc_nm;
    private String chk_oper;
    private String chk_dt;
    private String chk_tm;
    private String chk_sts;
    private MkmScene mkmScenes;
}

mysql.propertie

mysql.jdbc.driver=com.mysql.jdbc.Driver
mysql.jdbc.url=jdbc:mysql://ip:3306/数据库实例名?useUnicode=true&amp;characterEncoding=gbk&amp;useOldAliasMetadataBehavior=true
mysql.jdbc.username=userName
mysql.jdbc.password=passWord

log4j.properties

# Global logging configuration 
log4j.rootLogger=DEBUG, stdout 
# MyBatis logging configuration... 
log4j.logger.org.mybatis.example.BlogMapper=TRACE
# Console output... 
log4j.appender.stdout=org.apache.log4j.ConsoleAppender 
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout 
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

3.测试实例
MkmSceneDaoIplTest.java

public class MkmSceneDaoIplTest {
    private ApplicationContext applicationContext;
    @Before
    public void setUp() throws Exception {
        applicationContext = new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");
    }

    @Test
    public void test() throws IOException {
        MkmSceneDao mkmSceneDao =(MkmSceneDao)applicationContext.getBean("MkmSceneDao");
        List<MkmScene> list =mkmSceneDao.qryMkmSceneSpot("000000000000000068");
        System.out.println(list.size());
    }

    @Test
    public void testMkmScene() throws IOException{
        MkmSceneDao mkmSceneDao =(MkmSceneDao)applicationContext.getBean("MkmSceneDao");
        MkmScene mkmScene =mkmSceneDao.qryMkmScene("000000000000000068");
        System.out.println(mkmScene);
    }
}