paip.环境设置 mybatis ibatis cfg 环境设置

paip.环境设置 mybatis ibatis cfg 环境设置


三部分
//1. 电泳。。。。
、、、、、、、、、、、、2. 猪配置文件  com/mijie/homi/search/util/ibatiascfg.xml
、、、、、、、、、、、、、、、、、3.mappers 配置文件  ibatis/index.xml


---------------------------------------------------------------------------


//1. 电泳。。。。
 public static void main(String[] args) {
       // TODO Auto-generated method stub
       try {
           String resource = "com/mijie/homi/search/util/ibatiascfg.xml";
           Reader reader;


           reader = Resources.getResourceAsReader(resource);


           SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder()
                   .build(reader);
           SqlSession sqlSession = sqlSessionFactory.openSession();
        List li=   sqlSession.selectList("getRecently100", 9999999);
//            StudentDao studentDao =sqlSession.getMapper(StudentDao.class);
//            Student st = studentDao.getstudent(1);
           System.out.println( li.size());


作者Attilax  艾龙，  EMAIL:1466519819@qq.com
来源：attilax的专栏
地址：http://blog.csdn.net/attilax

、、、、、、、、、、、、2. 猪配置文件  com/mijie/homi/search/util/ibatiascfg.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>
<!--  
<properties resource="config/config.properties"></properties>
-->
<typeAliases>
<!--  
<package name="pojo" />
-->
<typeAlias alias="Topic" type="com.mijie.homi.search.domain.topic.Topic" />
<typeAlias alias="Topic" type="com.mijie.homi.search.domain.topic.Topic"  />
<typeAlias alias="TopicOptions" type="com.mijie.homi.search.domain.topic.TopicOptions"  />
<typeAlias alias="User" type="com.mijie.homi.common.domain.user.User"  />
<typeAlias alias="UserExtInfo" type="com.mijie.homi.common.domain.user.UserExtInfo"  />
<typeAlias alias="Mood" type="com.mijie.homi.common.domain.mood.Mood"  />
<typeAlias alias="MoodUser" type="com.mijie.homi.search.domain.user.MoodUser"  />
</typeAliases>


<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://192.168.0.132:3306/homi" />
<property name="username" value="root" />
<property name="password" value="password" />
<property name="poolMaximumActiveConnections" value="15" />
<property name="poolMaximumCheckoutTime" value="5000" />
<!-- 
<property name="username" value="${username}" />
<property name="password" value="${password}" />
-->
</dataSource>
</environment>
</environments>

  <mappers>
        <mapper resource="ibatis/index.xml" />
    </mappers>
</configuration>


、、、、、、、、、、、、、、、、、3.mappers 配置文件  ibatis/index.xml




<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper  PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"  "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">




<mapper namespace="com.mijie.homi.domain.mood.Mood4full">
   
   <!-- where id  <=#{id} and timelineId=0 -->
   <select id="getRecently100" parameterType="int" resultType="java.util.HashMap">
      
         <![CDATA[ select    * from mood4full  where id  <=#{id}  
         order by id desc   limit 100  ]]>
   </select>
   
      <select id="listRecentlyLoginUserMood" parameterType="map" resultType="Mood">
    select m.* from  userExtInfo as e join mood as m
on m.id=e.moodId
where e.lastLoginAt >= #{atleastLastLoginAt}
order by e.lastLoginAt desc 
limit #{offset},#{limit}
   </select>
   
   
      <select id="moodsByIds" parameterType="string" resultType="java.util.HashMap">
    select *,u.id uid,e.lastloginat from mood m,user u,userExtInfo e  where  m.userid=u.id and u.id=e.id and m.id in ( ${_parameter} ) order by m.id desc limit 100 

   </select>
   
   </mapper>