https://www.jianshu.com/p/d1e84642a9f2
https://www.jianshu.com/p/188918c8c445
mybatis-config.xml
要点:
- 置数据库连接的账号密码
- 指定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>
<!--<!– 外部属性配置文件 –>-->
<!--<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;
}
}
结语
业务代码不能随便公开,可能本文对大家没用,留作个人参考。