Java单独集成MyBatis

快来打我* 2022-02-15 07:06 199阅读 0赞

[https://www.jianshu.com/p/d1e84642a9f2][https_www.jianshu.com_p_d1e84642a9f2]  
[https://www.jianshu.com/p/188918c8c445][https_www.jianshu.com_p_188918c8c445]

### mybatis-config.xml ###

要点：

1.  置数据库连接的账号密码
2.  指定sql语句所在的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.beyand.pgsql.domain"/>
    	</typeAliases>
    
    	
    	<environments default="development">
    	<environment id="development">
    		<transactionManager type="JDBC"/>
    		<dataSource type="POOLED">
    			<property name="driver" value="org.postgresql.Driver"/>
    			<property name="url" value="jdbc:postgresql://47.101.1x2.x8:5432/db"/>
    			<property name="username" value="###"/>
    			<property name="password" value="###"/>
    		</dataSource>
    	</environment>
    </environments>
    
    
    	
    	<mappers>
    		<mapper resource="mapper/TianWangScoreMapper.xml"/>
    	</mappers>
    
    </configuration>

### ScoreMapper.xml ###

存放具体的sql语句

### ScoreMapper ###

存放与方法对应的接口

### javabeam ###

存放输出结果的javabean

### 测试程序 ###

package com.beyand.pgsql.service;
    
    import com.beyand.pgsql.domain.SkynetSaturabilityRaw;
    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 java.io.IOException;
    import java.io.InputStream;
    
    public class QueryTianWang {
        private static SqlSessionFactory sessionFactory;
        private static String result;
        public static String queryTianWang(String openid) {
            //通过SqlSessionFactory打开一个会话
            SqlSession openSession = null;
            SkynetSaturabilityRaw skynetSaturabilityRaw=null;
            try {
                openSession = getSession();
                skynetSaturabilityRaw = openSession.selectOne("getSkeyNetBeanById",openid);
                if(null == skynetSaturabilityRaw){
                    result = "";
                }else{
                    result=skynetSaturabilityRaw.toString();
                }
    //            System.out.println(skynetSaturabilityRaw.toString());
    
            } catch (IOException e) {
                e.printStackTrace();
            }finally {
                //关闭session会话
                openSession.close();
            }
    
            return  result;
        }
    
        public static SqlSession getSession() throws IOException {
            // 加载配置文件
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            // 获取session
            SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(is);
            SqlSession sqlSession = ssf.openSession();
            return sqlSession;
        }
    }

### 结语 ###

业务代码不能随便公开，可能本文对大家没用，留作个人参考。

[https_www.jianshu.com_p_d1e84642a9f2]: https://www.jianshu.com/p/d1e84642a9f2
[https_www.jianshu.com_p_188918c8c445]: https://www.jianshu.com/p/188918c8c445