根据模板及表元数据生成mapper.xml配置映射

最新推荐文章于 2024-09-02 16:30:54 发布

bingliang514csdn

最新推荐文章于 2024-09-02 16:30:54 发布

阅读量663

点赞数

分类专栏： Java编程语言知识_记v1 文章标签： mybatis sql 数据库

本文链接：https://blog.csdn.net/bingliang514csdn/article/details/128206647

版权

Java编程语言知识_记v1 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一个用于自动生成MyBatis映射文件的Java程序，该程序可根据数据库表结构和表注释动态创建XML映射文件，支持增删改查等基本操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

（1），模板mapper_.ftl文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dto.<#list mapDataTableComment as listItmCom > ${listItmCom.upperColumnName} </#list>Dao">
	<!--用户实体结果映射-->
	<resultMap id="ResultMap" type="com.dto.<#list mapDataTableComment as listItmCom > ${listItmCom.upperColumnName} </#list>Dto">
	
		<result column="tid" jdbcType="VARCHAR" property="tid" />
		
	<#list mapDataList as listItm >
		<result column="${listItm.columnName}" jdbcType="VARCHAR" property="${listItm.columnName}" />
	</#list>
		
	</resultMap>

	<!--表字段列表 -->
	<sql id="Base_Column_List">
	
	<#list mapDataList as listItm >
		${listItm.columnName} ,
	</#list>
	
	</sql>

	<insert id="<#list mapDataTableComment as listItmCom > ${listItmCom.columnName} </#list>AddSave" parameterType="com.dto.<#list mapDataTableComment as listItmCom > ${listItmCom.upperColumnName} </#list>Dto">
		insert into <#list mapDataTableComment as listItmCom > ${listItmCom.columnName} </#list> values (	
			<#list mapDataList as listItm >
				井号左大括${listItm.columnName}右大括 ,
			</#list>
		)
	</insert>

	<update id="<#list mapDataTableComment as listItmCom > ${listItmCom.columnName} </#list>ModifySave" parameterType="com.dto.<#list mapDataTableComment as listItmCom > ${listItmCom.upperColumnName} </#list>Dto">
		update <#list mapDataTableComment as listItmCom > ${listItmCom.columnName} </#list> T
		<set>
			
		<#list mapDataList as listItm >
			<if test="${listItm.columnName} != null and ${listItm.columnName} != '' ">
				${listItm.columnName} = 井号左大括${listItm.columnName}, jdbcType=VARCHAR右大括,
			</if>
		</#list>
			
		</set>
	    	where 1 = 1 and tid = 井号左大括tid右大括
	</update>

	<delete id="<#list mapDataTableComment as listItmCom > ${listItmCom.columnName} </#list>Del" parameterType="com.dto.<#list mapDataTableComment as listItmCom > ${listItmCom.upperColumnName} </#list>Dto">
		delete from <#list mapDataTableComment as listItmCom > ${listItmCom.columnName} </#list> where 1 = 1 and tid = 井号左大括tid右大括
	</delete>

	<select id="get<#list mapDataTableComment as listItmCom > ${listItmCom.upperColumnName} </#list>" resultMap="ResultMap" parameterType="com.dto.<#list mapDataTableComment as listItmCom > ${listItmCom.upperColumnName} </#list>Dto">
		select
		<include refid="Base_Column_List" />
		from <#list mapDataTableComment as listItmCom > ${listItmCom.columnName} </#list> T
		where 1 = 1
		<if test="tid != null and tid != '' ">
			AND tid = 井号左大括tid, jdbcType=VARCHAR右大括
		</if>
	</select>

	<select id="query<#list mapDataTableComment as listItmCom > ${listItmCom.upperColumnName} </#list>List" resultMap="ResultMap" parameterType="com.dto.<#list mapDataTableComment as listItmCom > ${listItmCom.upperColumnName} </#list>Dto">
		select
		<include refid="Base_Column_List" />
		from <#list mapDataTableComment as listItmCom > ${listItmCom.columnName} </#list> T
		where 1 = 1
			<if test="tid != null and tid != '' ">
				AND tid = 井号左大括tid, jdbcType=VARCHAR右大括
			</if>
			
			<#list mapDataList as listItm >
			
			<if test="${listItm.columnName} != null and ${listItm.columnName} != '' ">
				AND ${listItm.columnName} like concat('%',井号左大括${listItm.columnName},jdbcType=VARCHAR右大括,'%')
			</if>
		</#list>
						
	</select>

	<select id="getMaxid" resultType="java.lang.Integer">
		select max(tid) maxTid from t00_user
	</select>

</mapper>

（2），生成映射xml文件

public class TestCls {

    public static void main(String[] args) throws Exception {
        TestCls testCls = new TestCls();
        String testT00_po = "testT00_user";
        String generFileName = testT00_po + "Mapper.xml";
        testCls.outTemplate(testT00_po, "用户数据"
                , generFileName, "mapper_.ftl" );

        System.out.println("执行成功！");
    }

    // 输出到模板
    private void outTemplate(String entryInfoPoName, String tableComment
            , String templateFileName , String templFileName ) throws Exception {

        Configuration configuration = new Configuration();
        String templateDir = "F:\\xbl\\myResource\\temp_test_";
        configuration.setDirectoryForTemplateLoading(new File(templateDir));
        Template template = configuration.getTemplate(templFileName);

        Map<String, List<EntryInfoPo>> dataMap = new HashMap<String, List<EntryInfoPo>>();
        List<EntryInfoPo> listEntryInfo = new ArrayList<EntryInfoPo>();
        listEntryInfo = testMetaAddComment();
        dataMap.put("mapDataList", listEntryInfo );

        // 表注释
        dataMap.put("mapDataTableComment", testTableComment(entryInfoPoName, tableComment ));
        String generFileDir = "F:\\xbl\\myResource\\temp_test_\\gener_file_\\";
        File generFile = new File(generFileDir + templateFileName);
        if(generFile.exists()) {
            generFile.delete();
        }
        generFile.createNewFile();

        Writer outputWriter = new OutputStreamWriter(new FileOutputStream(generFile ) );
//        Writer outputWriter = new OutputStreamWriter(System.out );

        template.process(dataMap, outputWriter);
        System.out.println("输出完成！");
        outputWriter.close();
    }

    // 表注释
    private List<EntryInfoPo> testTableComment(String entryInfoPoName, String tableComment) throws Exception {

        List<EntryInfoPo> listTableComment = new ArrayList<EntryInfoPo>();
        EntryInfoPo entryInfoPo = new EntryInfoPo();
        entryInfoPo.setColumnName(entryInfoPoName);
        entryInfoPo.setColumnComment(tableComment);
        entryInfoPo.setUpperColumnName(firTextUpper( entryInfoPoName ) );
        listTableComment.add(entryInfoPo);
        return listTableComment;
    }

    // 首字母大写
    private String firTextUpper(String scontext ) {
        int textLength = scontext.length();
        String sufText = scontext.substring(1, textLength);
        String firText = scontext.substring(0, 1);
        firText = firText.toUpperCase();
        String finText = firText + sufText;
        return finText;
    }

    private List<EntryInfoPo> testMetaAddComment() throws Exception {

        List<EntryInfoPo> listEntryInfoPo = new ArrayList<EntryInfoPo>();
        Connection connection = getDataBaseConnection();
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery("show full columns from t00_user ");
        while (resultSet.next()) {

            String columnComment = resultSet.getString("Comment");
            String columnName = resultSet.getString("Field");
            columnName = columnName.toLowerCase();
            EntryInfoPo entryInfoPo = new EntryInfoPo();
            entryInfoPo.setColumnName(columnName);
            entryInfoPo.setColumnComment(columnComment);
            listEntryInfoPo.add(entryInfoPo);
        }
        return listEntryInfoPo;
    }
    private Connection getDataBaseConnection() throws Exception {
        // 连接数据库
        Class.forName("com.mysql.jdbc.Driver");
        String databaseUrl = "jdbc:mysql://127.0.0.1:3306/grcdb05?useUnicode=true&amp;characterEncoding=utf8";
        Connection connection = DriverManager.getConnection(databaseUrl, "root", "root");
        return connection;
    }
}

（3），注意替换生成的配置文件中的空格及临时替代符号