MyBatis使用，将Class对象的所有信息添加到SQL server并导出为XML和json

对象的所有信息添加到SQL server并导出为XML和json"/>

MyBatis使用，将Class对象的所有信息添加到SQL server并导出为XML和json

mybatis配置文件 mybatis-config.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis//DTD Config 3.0//EN"
".dtd">
<configuration><environments default="development"><environment id="development"><transactionManager type="JDBC" /><dataSource type="POOLED"><property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /><property name="url"value="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=homework01" /><property name="username" value="sa" /><property name="password" value="******" /></dataSource></environment></environments><mappers><mapper resource="hhuc/mapper/HW01InfoMapper.xml" /></mappers>
</configuration>

mybatis工具类 MybatisUtils.java

package hhuc.mybatis;import java.io.IOException;
import java.io.InputStream;import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;/** author:cenhelm* mybatis工具类*/public class MybatisUtils {private static final String FILE_CONFIG = "mybatis-config.xml";private static SqlSessionFactory sqlSessionFactory ;private MybatisUtils() {}static {InputStream inputStream;try {//读取mybatis配置文件inputStream = org.apache.ibatis.io.Resources.getResourceAsStream(FILE_CONFIG);//创建会话工程（连接工厂）sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);} catch (IOException e) {e.printStackTrace();}}/*** 获取自动提交的会话* @return*/public static SqlSession getSqlSessionAutoCommit() {SqlSession session=sqlSessionFactory.openSession(true);return session;} public static SqlSession getSqlSession() {return sqlSessionFactory.openSession();}
}

mapper映射文件 HW01InfoMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis//DTD Mapper 3.0//EN"
".dtd">
<mapper namespace="hhuc.mapper.HW01InfoMapper"><insert id="insertClassInfo"parameterType="hhuc.javabean.ClassInfo" useGeneratedKeys="true"keyProperty="classId">insert into ClassInfo(className)values ( #{className} )</insert><insert id="insertMethodInfo"parameterType="hhuc.javabean.MethodInfo" useGeneratedKeys="true"keyProperty="methodId">insert into MethodInfo(classId, methodName, returnType)values ( #{classId}, #{methodName}, #{returnType} )</insert><insert id="insertParamInfo"parameterType="hhuc.javabean.ParamInfo" useGeneratedKeys="true"keyProperty="paramId">insert into ParamInfo(methodId, paramIndex, paramType)values ( #{methodId}, #{paramIndex}, #{paramType} )</insert><select id="findClassId" resultType="long">select classId from ClassInfo where className = #{className}</select><select id="findMethodId" resultType="long"><!-- 这个max()聚集函数是关键，因为我在后面要获取参数表里的methodId这个外键，而通过methodName会检索到多个id，也就是相同方法名有多个方法id，而这个id只要取最大的就一定对了 -->select max(methodId) from MethodInfo where methodName = #{methodName}</select><select id="selectClassInfo" resultType="hhuc.javabean.ClassInfo">select * from ClassInfo</select><select id="selectMethodInfo" resultType="hhuc.javabean.MethodInfo">select * from MethodInfo</select><select id="selectParamInfo" resultType="hhuc.javabean.ParamInfo">select * from ParamInfo</select></mapper>

定义映射接口 HW01InfoMapper.java

package hhuc.mapper;import org.apache.ibatis.annotations.Mapper;import hhuc.javabean.ClassInfo;
import hhuc.javabean.MethodInfo;
import hhuc.javabean.ParamInfo;/** 定义映射接口(mapper为mybatis执行数据库操作的接口类)*/@Mapper
public interface HW01InfoMapper {void insertClassInfo(ClassInfo obj);void insertMethodInfo(MethodInfo obj);void insertParamInfo(ParamInfo obj);long findClassId(String className);long findMethodId(String methodName);ClassInfo[] selectClassInfo();MethodInfo[] selectMethodInfo();ParamInfo[] selectParamInfo();
}

ClassInfo表的java对象 ClassInfo.java

package hhuc.javabean;/** author:cenhelm* homework01数据库里面的ClassInfo表,javabean规范*/public class ClassInfo {private String className;public ClassInfo() {}public String getClassName() {return className;}public void setClassName(String className) {this.className = className;}}

MethodInfo表的java对象 MethodInfo.java

package hhuc.javabean;/** author:cenhelm* homework01数据库MethodInfo数据库,javabean规范*/public class MethodInfo {private String methodName;private String returnType;private long classId;public MethodInfo() {}public String getMethodName() {return methodName;}public void setMethodName(String methodName) {this.methodName = methodName;}public String getReturnType() {return returnType;}public void setReturnType(String returnType) {this.returnType = returnType;}public long getClassId() {return classId;}public void setClassId(long classId) {this.classId = classId;}}

ParamInfo表的java对象 ParamInfo.java

package hhuc.javabean;/** author:cenhelm* homework01数据库paramInfo表，javabean规范*/public class ParamInfo {private int paramIndex;private String paramType;private long methodId;public ParamInfo() {}public int getParamIndex() {return paramIndex;}public void setParamIndex(int paramIndex) {this.paramIndex = paramIndex;}public String getParamType() {return paramType;}public void setParamType(String paramType) {this.paramType = paramType;}public long getMethodId() {return methodId;}public void setMethodId(long methodId) {this.methodId = methodId;}}

XML工具类 XMLUtils.java

package hhuc.xmlTransform;/** author:cenhelm* xml工具类，转化Java对象到xml输出*/import java.io.FileOutputStream;
import java.io.ObjectOutputStream;
import java.io.OutputStream;import com.thoughtworks.xstream.XStream;
import com.thoughtworks.xstream.io.xml.DomDriver;public class XMLUtils {private static XStream xStream = null;// 禁止实例化private XMLUtils() {}// 利用静态语句块初始化Xstream对象static {xStream = new XStream(new DomDriver("utf-8"));}//Object-->xmlpublic static void saveToFile(String filePath, Object[] objs) {try {OutputStream os = new FileOutputStream(filePath);ObjectOutputStream out = xStream.createObjectOutputStream(os);for(Object obj : objs)out.writeObject(obj);out.close();} catch (Exception e) {e.printStackTrace();}}}

json工具类 JsonUtils.java

package hhuc.jsonTransform;import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;/** author:cenhelm* json工具类，转化Java对象到json*/import com.google.gson.Gson;
import com.google.gson.GsonBuilder;public class JsonUtils {private static Gson gson = null;private JsonUtils() {}static {GsonBuilder builder = new GsonBuilder();gson = builder.create();}//obj-->json字符串public static void saveToFile(String filePath, Object[] objs) {	try {OutputStream os = new FileOutputStream(filePath);for(Object obj : objs) {String str = gson.toJson(obj, obj.getClass());	os.write(str.getBytes());}os.close();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}
}

测试类

package hhuc.test;import java.lang.reflect.Method;
import java.util.Scanner;import org.apache.ibatis.session.SqlSession;import hhuc.javabean.ClassInfo;
import hhuc.javabean.MethodInfo;
import hhuc.javabean.ParamInfo;
import hhuc.jsonTransform.JsonUtils;
import hhuc.mapper.HW01InfoMapper;
import hhuc.mybatis.MybatisUtils;
import hhuc.xmlTransform.XMLUtils;public class Test {// 插入ClassInfopublic void insertClassInfo(String className) {// 1-获取会话(连接)SqlSession session = MybatisUtils.getSqlSession();// 2-获得映射器对象HW01InfoMapper mapper = session.getMapper(HW01InfoMapper.class);// 3-创建图书对象，调用insert方法ClassInfo obj = new ClassInfo();obj.setClassName(className);mapper.insertClassInfo(obj);System.out.println("类" + obj.getClassName());// 4-提交数据修改sessionmit();// 5-关闭会话session.close();}// 找到classIdpublic long findClassId(String className) {// 1-获得一个会话SqlSession session = MybatisUtils.getSqlSession();// 2-获得映射器对象HW01InfoMapper mapper = session.getMapper(HW01InfoMapper.class);// 3-调用查询方法long id = mapper.findClassId(className);// 4-关闭会话session.close();return id;}// 插入MethodInfopublic void insertMethodInfo(long classId, String methodName, String returnType) {// 1-获取会话(连接)SqlSession session = MybatisUtils.getSqlSession();// 2-获得映射器对象HW01InfoMapper mapper = session.getMapper(HW01InfoMapper.class);// 3-创建图书对象，调用insert方法MethodInfo obj = new MethodInfo();obj.setClassId(classId);obj.setMethodName(methodName);obj.setReturnType(returnType);mapper.insertMethodInfo(obj);System.out.println("方法" + obj.getClassId() + " " + obj.getMethodName() + " " + obj.getReturnType());// 4-提交数据修改sessionmit();// 5-关闭会话session.close();}// 找到methodIdpublic long findMethodId(String methodName) {// 1-获得一个会话SqlSession session = MybatisUtils.getSqlSession();// 2-获得映射器对象HW01InfoMapper mapper = session.getMapper(HW01InfoMapper.class);// 3-调用查询方法long id = mapper.findMethodId(methodName);// 4-关闭会话session.close();return id;}// 插入ParamInfopublic void insertParamInfo(long methodId, int paramIndex, String paramType) {// 1-获取会话(连接)SqlSession session = MybatisUtils.getSqlSession();// 2-获得映射器对象HW01InfoMapper mapper = session.getMapper(HW01InfoMapper.class);// 3-创建图书对象，调用insert方法ParamInfo obj = new ParamInfo();obj.setMethodId(methodId);obj.setParamIndex(paramIndex);obj.setParamType(paramType);mapper.insertParamInfo(obj);System.out.println("参数" + obj.getMethodId() + " " + obj.getParamIndex() + " " + obj.getParamType());// 4-提交数据修改sessionmit();// 5-关闭会话session.close();}// 查询ClassInfo表中所有数据public ClassInfo[] selectClassInfo() {SqlSession session = MybatisUtils.getSqlSession();HW01InfoMapper mapper = session.getMapper(HW01InfoMapper.class);ClassInfo[] objs = mapper.selectClassInfo();return objs;}// 查询MethodInfo所有数据public MethodInfo[] selectMethodInfo() {SqlSession session = MybatisUtils.getSqlSession();HW01InfoMapper mapper = session.getMapper(HW01InfoMapper.class);MethodInfo[] objs = mapper.selectMethodInfo();return objs;}// 查询ParamInfo中所有数据public ParamInfo[] selectParamInfo() {SqlSession session = MybatisUtils.getSqlSession();HW01InfoMapper mapper = session.getMapper(HW01InfoMapper.class);ParamInfo[] objs = mapper.selectParamInfo();return objs;}// obj-->xmlpublic void saveToXml(String filePath, Object[] infos) {XMLUtils.saveToFile(filePath, infos);}//obj-->jsonpublic void saveToJson(String filePath, Object[] infos) {JsonUtils.saveToFile(filePath, infos);}public static void main(String[] args) throws Exception {System.out.println("输入完整类名");Scanner scanner = new Scanner(System.in);String className = scanner.nextLine();scanner.close();Class cls = Class.forName(className);System.out.println("装载成功");System.out.println(cls);Test test = new Test();// 插入类名信息test.insertClassInfo(cls.getName());java.lang.reflect.Method[] methods = cls.getDeclaredMethods();for (Method method : methods) {// 插入方法信息test.insertMethodInfo(test.findClassId(cls.getName()), method.getName(), method.getReturnType().getName());Class[] paramTypes = method.getParameterTypes();for (int i = 1; i <= paramTypes.length; i++) {// 插入方法参数信息test.insertParamInfo(test.findMethodId(method.getName()), i, paramTypes[i - 1].getName());}}// 存入xml和jsClassInfo[] classInfos = test.selectClassInfo();test.saveToXml("ClassInfos.xml", classInfos);test.saveToJson("ClassInfos.js", classInfos);MethodInfo[] methodInfos = test.selectMethodInfo();test.saveToXml("MethodInfos.xml", methodInfos);test.saveToJson("MethodInfos.js", methodInfos);ParamInfo[] paramInfos = test.selectParamInfo();test.saveToXml("ParamInfos.xml", paramInfos);test.saveToJson("ParamInfos.js", paramInfos);}}