Atitit mybatisutil 模块测试功能列表
1.1. mybatis读取mapper配置的sql语句 使用xml类库 1
Itfs pna
Java sql yash ...get conn ,,exe sql
1.1. mybatis读取mapper配置的sql语句 使用xml类库
C:\0wkspc\oploggerPrj\src\com\attilax\util\MybatisUtil.java
package com.attilax.util;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.SqlSession;
import org.apache.zookeeper.common.PathUtils;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.input.SAXBuilder;
import com.cnhis.cloudhealth.clidoctorweb.gzip.PathUtil;
import com.google.common.collect.Maps;
import cn.freeteam.util.MybatisSessionFactory;
public class MybatisUtil {
protected static Statement getStt() {
SqlSession session = getSqlSession();
Connection conn = session.getConnection();
Statement st = null;
try {
conn.setAutoCommit(true);
st = conn.createStatement();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
return st;
}
private static SqlSession getSqlSession() {
MybatisSessionFactory.CONFIG_FILE_LOCATION = "/com/attilax/db/mybatisutil/mybatis_postgresql.xml";
SqlSession session = MybatisSessionFactory.getSession();
return session;
}
public static void main(String[] args) {
String sqlid="adviceSousuo_kucui";
String s=getMybaticsCfgedSqlBysqlid("C:\\0wkspc\\clinical\\src\\main\\java\\com\\cnhis\\cloudhealth\\clinical\\clidoctor\\clischemedefine\\mapper\\CliSchemeDefineMapper.xml","adviceSousuo_kucui");
System.out.println(s);
// String f="D:\\0workspace\\atiplat_restapi\\src\\aaaPKg\\flow_design_cs.xml";
//
// Map m=(Map) serilizeUtil.serizGetObjFromFile("c:\\logs\\adviceSousuo_kucui_map_8080f6ab-35b1-440f-b1b5-8c1b0ea2de32");
//
// Statement st = getStt(); // ini envi
//
// List li= getSqlSession().selectList(sqlid, m);
// System.out.println(li.size());
}
private static String getMybaticsCfgedSqlBysqlid(String f,String sqlid) {
// TODO Auto-generated method stub
SAXBuilder builder=new SAXBuilder(false);
Document doc;
try {
doc = builder.build(f);
} catch (JDOMException | IOException e) {
throw new RuntimeException(e);
}
Element books=doc.getRootElement();
List< Element> definitions_eles=books.getChildren("select");
for (Element e : definitions_eles) {
System.out.println(e.getAttribute("id"));
if(e.getAttribute("id").getValue().equals(sqlid))
return e.getText();
}
// Element process_ele=books.getChild("process");
// System.out.println(process_ele.getAttributeValue("deadlineLimit"));
System.out.println("--f");
return sqlid;
}
}