Java单独集成MyBatis

https://www.jianshu.com/p/d1e84642a9f2
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>

	<!--&lt;!&ndash; 外部属性配置文件 &ndash;&gt;-->
	<!--<properties resource="jdbc.properties" />-->

	<!-- 为SQL映射配置文件的parameterType和resultType来设置别名。别名默认为首字母小写。 -->
	<typeAliases>
		<package name="com.beyand.pgsql.domain"/>
	</typeAliases>

	<!-- environment 元素体中包含了事务管理和连接池的配置 -->
	<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 映射器（这些 mapper 的 XML 文件包含了 SQL 代码和映射定义信息） -->
	<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;
    }
}

结语

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