通过XMLConfiguration解析XML获取更新数据库sql

最新推荐文章于 2022-09-26 10:36:37 发布
最新推荐文章于 2022-09-26 10:36:37 发布
阅读量258 收藏
点赞数
文章标签： 数据库 java runtime
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/iteye_735/article/details/82524251
版权

需求：将用户从数据库导出，并且导入另一个用户后更新其中一些表的数据值。

1、XML原始文件

 

<?xml version="1.0" encoding="UTF-8" ?>
<database>
	<tables>
		<!-- 修改BUSINESS_SYSTEM表 -->
		<table name = "BUSINESS_SYSTEM">
			<!-- 终端管理 -->
			<fields id="2">
				<field IP = "xxxx.xxxx.xxxx.xxxx" />
				<field PORT = "40009"/>
			</fields>
            <!-- 权限管理 -->
			<fields id="3">
				<field IP = "xxxx.xxxx.xxxx.xxxx"/>
				<field PORT = "40001"/>
			</fields>
            <!-- 短彩信管理平台 -->
			<fields id="101">
				<field IP = "xxxx.xxxx.xxxx.xxxx"/>
				<field PORT = "40004"/>
			</fields>
			<!-- 商户管理系统 -->
			<fields id="121">
				<field IP = "xxxx.xxxx.xxxx.xxxx"/>
				<field PORT = "8080"/>
			</fields>
			<!-- 基础用户管理系统 -->
			<fields id="141">
				<field IP = "xxxx.xxxx.xxxx.xxxx"/>
				<field PORT = "40001"/>
			</fields>
			<!-- 电子商务后台管理系统 -->
			<fields id="161">
				<field IP = "xxxx.xxxx.xxxx.xxxx"/>
				<field PORT = "40006"/>
			</fields>
			<!-- 万能遥控器管理系统 -->
			<fields id="201">
				<field IP = "xxxx.xxxx.xxxx.xxxx"/>
				<field PORT = "40013"/>
			</fields>
			<!-- 预付卡支付管理系统 -->
			<fields id="202">
				<field IP = "xxxx.xxxx.xxxx.xxxx"/>
				<field PORT = "40014"/>
			</fields>
			<!-- 日志管理系统 -->
			<fields id="242">
				<field IP = "xxxx.xxxx.xxxx.xxxx"/>
				<field PORT = "40023"/>
			</fields>
			<!-- 业务管理系统 -->
			<fields id="241">
				<field IP = "xxxx.xxxx.xxxx.xxxx"/>
				<field PORT = "40010"/>
			</fields>
		</table>
		<!-- 修改property_value表 -->
		<table name = "PROPERTY_VALUE">
		    <!-- 数据库URL -->
			<fields PROPERTY_VALUE_ID="12">
				<field VALUE = "jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl"/>
			</fields>
			<!-- log日志URL -->
			<fields PROPERTY_VALUE_ID="38">
				<field VALUE = "jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl"/>
			</fields>
			<!-- ftp配置 -->
			<fields PROPERTY_VALUE_ID="13">
				<field VALUE = "192.168.0.112"/>
			</fields>
			<!-- 域名 -->
			<fields PROPERTY_VALUE_ID="45">
				<field VALUE = "http://192.168.0.104/"/>
			</fields>
			<!-- jsonP -->
			<fields PROPERTY_VALUE_ID="74">
				<field VALUE = "http://xxxx.xxxx.xxxx.xxxx:40000"/>
			</fields>
			<!-- 重定向IP -->
			<fields PROPERTY_VALUE_ID="5">
				<field VALUE = "xxxx.xxxx.xxxx.xxxx"/>
			</fields>
			<!-- 重定向PORT -->
			<fields PROPERTY_VALUE_ID="6">
				<field VALUE = "40000"/>
			</fields>
		</table>
		<!-- 修改property_value表 -->
		<table name = "BG_PROPERTY_VALUE">
			<!-- 数据库URL -->
			<fields BG_PROPERTY_VALUE_ID="2">
				<field VALUE = "jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl"/>
			</fields>
			<!-- 图片服务器 -->
			<fields BG_PROPERTY_VALUE_ID="62">
				<field VALUE = "http://xxxx.xxxx.xxxx.xxxx:40018/"/>
			</fields>
			<!-- 域名 -->
			<fields BG_PROPERTY_VALUE_ID="64">
				<field VALUE = "http://192.168.0.104:8081/dfs/ws/imgSys"/>
			</fields>
			<!-- 图片服务器 -->
			<fields BG_PROPERTY_VALUE_ID="65">
				<field VALUE = "http://xxxx.xxxx.xxxx.xxxx:40018/"/>
			</fields>
			<!-- 业务自助管理自定义系统URL -->
			<fields BG_PROPERTY_VALUE_ID="69">
				<field VALUE = "jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl"/>
			</fields>
			<!-- LOG数据库url -->
			<fields BG_PROPERTY_VALUE_ID="32">
				<field VALUE = "jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl"/>
			</fields>
		</table>
	</tables>
</database>

 2、XMLConfiguration解析java代码

  

package com.handaer.pro.xml;

import java.util.ArrayList;
import java.util.List;

import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.XMLConfiguration;
import org.apache.commons.configuration.HierarchicalConfiguration.Node;

public class PaserXml
{
    @SuppressWarnings("unchecked")
    public List<String> initXml()
    {
        XMLConfiguration config = new XMLConfiguration();
        config.setDelimiterParsingDisabled(true);
        config.setFileName("config/data.xml");
        try
        {
            config.load();
        }
        catch (ConfigurationException e)
        {
            e.printStackTrace();
        }
        Node root = config.getRoot();
        List<String> sqlList = new ArrayList<String>();
        if (root.hasChildren())
        {
            List<Node> tablesNodeList = root.getChildren();
            for (Node tablesNode : tablesNodeList)
            {
                List<Node> tableNodeList = tablesNode.getChildren();
                for (Node tableChildNode : tableNodeList)
                {
                    StringBuilder sql = new StringBuilder("UPDATE ");
                    String tableName = (String) ((Node) tableChildNode.getAttributes().get(0)).getValue();
                    sql.append(tableName).append(" SET ");
                    List<Node> fieldsNodeList = tableChildNode.getChildren();
                    for (Node fields : fieldsNodeList)
                    {
                        StringBuilder filedSb = new StringBuilder();
                        List<Node> fieldNodeList = fields.getChildren();
                        int count = 0;
                        for (Node field : fieldNodeList)
                        {
                            count++;
                            String dbFieldName = (String) ((Node) field.getAttributes().get(0)).getName();
                            filedSb.append(dbFieldName).append("=");
                            String dbField = (String) ((Node) field.getAttributes().get(0)).getValue();
                            filedSb.append("'").append(dbField).append("'");
                            if (count < fieldNodeList.size())
                            {
                                filedSb.append(" , ");
                            }
                        }
                        String idName = (String) ((Node) fields.getAttributes().get(0)).getName();
                        filedSb.append(" WHERE ").append(idName).append("=");
                        String id = (String) ((Node) fields.getAttributes().get(0)).getValue();
                        filedSb.append(id);
                        int headLength = sql.length();
                        sql.append(filedSb);
                        System.out.println(sql.toString());
                        sqlList.add(sql.toString());
                        sql.delete(headLength, sql.length());
                        filedSb.delete(0, filedSb.length());
                    }
                    sql.delete(0, sql.length());
                }
            }
        }
        return sqlList;
    }

}

 3、ORACLE执行java源码

 

package com.handaer.pro;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;

import org.apache.log4j.Logger;

public class OracleHelper
{

    private static final Logger logger = Logger.getLogger(OracleHelper.class);

    private static int CMD_TYPE_IDX = 2;

    private static int CMD_ORACLE_IDX = 3;

    private static int CMD_FILE_PATH_IDX = 5;

    private static int CMD_OWNER_IDX = 7;

    private static int CMD_TOUSER_IDX = 9;

    private final String[] cmdExpArray = { "cmd", "/c", "", "", "file=", "", "owner=", "" };

    private final String[] cmdImpArray = { "cmd", "/c", "", "", "file=", "", "fromuser=", "", "touser=", "" };

    public void setOracleType(String type)
    {
        cmdExpArray[CMD_TYPE_IDX] = type;
        cmdImpArray[CMD_TYPE_IDX] = type;
    }

    public void setOracleInstance(String oracleInstance)
    {
        cmdExpArray[CMD_ORACLE_IDX] = oracleInstance;
        cmdImpArray[CMD_ORACLE_IDX] = oracleInstance;
    }

    public void setFilePath(String filePath)
    {
        cmdExpArray[CMD_FILE_PATH_IDX] = filePath;
        cmdImpArray[CMD_FILE_PATH_IDX] = filePath;
    }

    public void setOwner(String owner)
    {
        cmdExpArray[CMD_OWNER_IDX] = owner;
    }

    public void setUser(String fromUser, String toUser)
    {
        cmdImpArray[CMD_OWNER_IDX] = fromUser;
        cmdImpArray[CMD_TOUSER_IDX] = toUser;
    }

    public boolean preform(int type)
    {
        boolean result = false;
        try
        {
            if (logger.isDebugEnabled())
            {
                logger.debug("ORACLE command : " + this);
            }
            Process ldrTmp = null;

            if (type == 1)
            {

                ldrTmp = Runtime.getRuntime().exec(cmdExpArray);
            }
            if (type == 2)
            {

                ldrTmp = Runtime.getRuntime().exec(cmdImpArray);
            }
            final Process ldr = ldrTmp;

            new Thread()
            {
                public void run()
                {

                    BufferedReader reader = new BufferedReader(new InputStreamReader(ldr.getErrorStream()));
                    try
                    {
                        String line = reader.readLine();
                        if (logger.isDebugEnabled())
                        {
                            logger.debug("ORACLE Error Message:");
                        }
                        while (line != null)
                        {
                            line = reader.readLine();
                            if (logger.isDebugEnabled())
                            {
                                logger.debug(line);
                            }
                        }
                    }
                    catch (IOException e)
                    {
                        logger.error("ORACLE get error stream failed.", e);
                    }
                    finally
                    {
                        try
                        {
                            if (reader != null)
                            {
                                reader.close();
                                reader = null;
                            }
                        }
                        catch (IOException e)
                        {
                            logger.error(e.getMessage(), e);
                        }
                    }
                }
            }.start();

            new Thread()
            {
                public void run()
                {
                    BufferedReader reader = new BufferedReader(new InputStreamReader(ldr.getInputStream()));
                    try
                    {
                        String line = reader.readLine();
                        if (logger.isDebugEnabled())
                        {
                            logger.debug("ORACLE Output Message: ");
                        }
                        while (line != null)
                        {
                            line = reader.readLine();
                            if (logger.isDebugEnabled())
                            {
                                logger.debug(line);
                            }
                        }
                    }
                    catch (IOException e)
                    {
                        logger.error("ORACLE  get input stream failed.", e);
                    }
                    finally
                    {
                        try
                        {
                            if (reader != null)
                            {
                                reader.close();
                                reader = null;
                            }
                        }
                        catch (IOException e)
                        {
                            logger.error(e.getMessage(), e);
                        }
                    }
                }
            }.start();
            try
            {

                int exitValue = ldr.waitFor();
                if (exitValue == 2 || exitValue == 0)
                {
                    if (logger.isDebugEnabled())
                    {
                        logger.debug("ORACLE  success.");
                    }
                    result = true;
                }
                else
                {
                    logger.error("ORACLE SQLLoad failed," + this);
                }
            }
            catch (InterruptedException e)
            {
                logger.error("ORACLE SQLLoad interrupted.", e);
            }
        }
        catch (IOException e)
        {
            logger.error(e.getMessage(), e);
        }
        return result;
    }

}

 4、建立数据库连接java代码

 

package com.handaer.pro;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class OracleConnection
{
    private static OracleConnection oracleConnection = null;

    private OracleConnection()
    {

    }

    public static final OracleConnection getOracleConnectionInstance()
    {
        if (oracleConnection == null)
        {
            oracleConnection = new OracleConnection();
        }
        return oracleConnection;
    }

    private Statement st = null;

    private Connection connection = null;

    private ResultSet rs = null;

    static
    {
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            System.out.println("加载驱动...");
        }
        catch (ClassNotFoundException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    public Connection buildConnection(String url, String userName, String password)
    {
        try
        {
            connection = DriverManager.getConnection(url, userName, password);
            System.out.println("创建连接...");
        }
        catch (SQLException e)
        {
            e.printStackTrace();
        }
        return connection;
    }

    public Statement buildStatement(Connection connection)
    {
        try
        {
            st = connection.createStatement();
        }
        catch (SQLException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return st;
    }

    public void executeSql(String sql, int type)
    {

        try
        {
            st.executeUpdate(sql);
        }
        catch (SQLException e)
        {
            if (type == 1)
            {
                System.out.println("table之间有关联");
            }
            else
            {
                e.printStackTrace();
            }

        }
    }

    public List<String> executeQuery(String sql, String field)
    {
        List<String> tableList = new ArrayList<String>();
        try
        {
            rs = st.executeQuery(sql);
            while (rs.next())
            {
                tableList.add(rs.getString(field));
            }
        }
        catch (SQLException e)
        {
            e.printStackTrace();
        }
        return tableList;
    }

    public void close()
    {
        try
        {
            if (rs != null)
            {
                rs.close();
            }
            if (st != null)
            {
                st.close();
            }
            if (connection != null)
            {
                connection.close();
            }

        }
        catch (SQLException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        System.out.println("关闭连接....");
    }

}

 5、测试程序

 

package com.handaer.pro.server;

import java.sql.Connection;
import java.util.List;

import com.handaer.pro.OracleConnection;
import com.handaer.pro.OracleHelper;
import com.handaer.pro.xml.PaserXml;

public class StartServer
{
    /**
     * ---------------------------原始库信息----------------------------------------
     * ----
     */

    public static String expuserName = "pms";

    public static String exppassword = "pmspwd";

    public static String exportip = "192.168.0.122";

    /**
     * ---------------------------目的库信息----------------------------------------
     * ----
     */

    public static String impuserName = "pms";

    public static String imppassword = "pmspwd";

    public static String url = "jdbc:oracle:thin:@192.168.0.123:1521:orcl";

    public static String impIp = "192.168.0.123";
    
    public static String impSidNum = "orcl.localdomain";

    /**
     * -----------------------------系统管理员--------------------------------------
     * -----
     */

    public static String systemName = "system";

    public static String systempassword = "handaer";

    /**
     * ------------------------------SID号--------------------------------------
     * ---
     */

    public static String sidNum = "orcl";

    public static String filePath = "D:\\exp\\pms.dmp";

    /**
     * @param args
     */
    public static void main(String[] args)
    {

        System.out.println("------------------------begin--------------------------------");
        // 导入目的表之前先删除表
        deleteTableSql();
        System.out.println("---------------------delete all table------------------------");

        // 删除目的表所有sequence
        deleteSequenceSql();
        System.out.println("--------------------delete all sequence-----------------------");

        expDbInfo();
        System.out.println("---------------------------end exp----------------------------");

        impDbInfo();
        System.out.println("----------------------------end imp-----------------------------");

        PaserXml paserXml = new PaserXml();
        List<String> sqlList = paserXml.initXml();
        System.out.println("-------------------------end init xml--------------------------");

        changeDbData(sqlList);
        System.out.println("-------------------------end modify data------------------------");
        System.out.println("-------------------------------end------------------------------");

    }

    /**
     * 导出原始库
     */
    private static void expDbInfo()
    {
        OracleHelper oracleHelper = new OracleHelper();
        oracleHelper.setOracleType("exp");
        StringBuilder sb = new StringBuilder(expuserName).append("/").append(exppassword).append("@").append(exportip).append("/").append(sidNum);
        oracleHelper.setOracleInstance(sb.toString());
        oracleHelper.setFilePath(filePath);
        oracleHelper.setOwner(expuserName);
        oracleHelper.preform(1);
    }

    /**
     * 导入目的库
     */
    private static void impDbInfo()
    {
        OracleHelper oracleHelper = new OracleHelper();
        oracleHelper.setOracleType("imp");
        StringBuilder sb = new StringBuilder(systemName).append("/").append(systempassword).append("@").append(impIp).append("/").append(impSidNum);
        oracleHelper.setOracleInstance(sb.toString());
        oracleHelper.setFilePath(filePath);
        oracleHelper.setUser(expuserName, impuserName);
        oracleHelper.preform(2);
    }

    /**
     * 修改权限数据库中的数据
     * 
     * @param sqlList
     */
    private static void changeDbData(List<String> sqlList)
    {
        Connection connection = OracleConnection.getOracleConnectionInstance().buildConnection(url, impuserName, imppassword);
        OracleConnection.getOracleConnectionInstance().buildStatement(connection);
        for (String sql : sqlList)
        {
            OracleConnection.getOracleConnectionInstance().executeSql(sql, 0);
        }
        OracleConnection.getOracleConnectionInstance().close();
    }

    /**
     * 删除目的库中所有表
     */
    private static void deleteTableSql()
    {
        Connection connection = OracleConnection.getOracleConnectionInstance().buildConnection(url, impuserName, imppassword);
        OracleConnection.getOracleConnectionInstance().buildStatement(connection);
        String sql = "select 'drop table ' || table_name ||chr(13)||chr(10) tablesql from user_tables";
        List<String> tableList = OracleConnection.getOracleConnectionInstance().executeQuery(sql, "tablesql");
        while (tableList.size() != 0)
        {
            for (String tablesql : tableList)
            {
                OracleConnection.getOracleConnectionInstance().executeSql(tablesql, 1);
            }
            tableList = OracleConnection.getOracleConnectionInstance().executeQuery(sql, "tablesql");
        }

        OracleConnection.getOracleConnectionInstance().close();
    }

    /**
     * 删除目的库中所有sequence
     */

    private static void deleteSequenceSql()
    {
        Connection connection = OracleConnection.getOracleConnectionInstance().buildConnection(url, impuserName, imppassword);
        OracleConnection.getOracleConnectionInstance().buildStatement(connection);
        String sql = "select 'drop sequence ' || sequence_name ||chr(13)||chr(10) se from user_sequences";
        List<String> tableList = OracleConnection.getOracleConnectionInstance().executeQuery(sql, "se");
        for (String tablesql : tableList)
        {
            OracleConnection.getOracleConnectionInstance().executeSql(tablesql, 0);
        }
        OracleConnection.getOracleConnectionInstance().close();
    }
}

 6、测试结果

    解析xml生成sql的结果如下：

  

UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='40009' WHERE id=2
UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='40001' WHERE id=3
UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='40004' WHERE id=101
UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='8080' WHERE id=121
UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='40001' WHERE id=141
UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='40006' WHERE id=161
UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='40013' WHERE id=201
UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='40014' WHERE id=202
UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='40023' WHERE id=242
UPDATE BUSINESS_SYSTEM SET IP='xxxx.xxxx.xxxx.xxxx' , PORT='40010' WHERE id=241
UPDATE PROPERTY_VALUE SET VALUE='jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl' WHERE PROPERTY_VALUE_ID=12
UPDATE PROPERTY_VALUE SET VALUE='jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl' WHERE PROPERTY_VALUE_ID=38
UPDATE PROPERTY_VALUE SET VALUE='192.168.0.112' WHERE PROPERTY_VALUE_ID=13
UPDATE PROPERTY_VALUE SET VALUE='http://192.168.0.104/' WHERE PROPERTY_VALUE_ID=45
UPDATE PROPERTY_VALUE SET VALUE='http://xxxx.xxxx.xxxx.xxxx:40000' WHERE PROPERTY_VALUE_ID=74
UPDATE PROPERTY_VALUE SET VALUE='xxxx.xxxx.xxxx.xxxx' WHERE PROPERTY_VALUE_ID=5
UPDATE PROPERTY_VALUE SET VALUE='40000' WHERE PROPERTY_VALUE_ID=6
UPDATE BG_PROPERTY_VALUE SET VALUE='jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl' WHERE BG_PROPERTY_VALUE_ID=2
UPDATE BG_PROPERTY_VALUE SET VALUE='http://xxxx.xxxx.xxxx.xxxx:40018/' WHERE BG_PROPERTY_VALUE_ID=62
UPDATE BG_PROPERTY_VALUE SET VALUE='http://192.168.0.104:8081/dfs/ws/imgSys' WHERE BG_PROPERTY_VALUE_ID=64
UPDATE BG_PROPERTY_VALUE SET VALUE='http://xxxx.xxxx.xxxx.xxxx:40018/' WHERE BG_PROPERTY_VALUE_ID=65
UPDATE BG_PROPERTY_VALUE SET VALUE='jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl' WHERE BG_PROPERTY_VALUE_ID=69
UPDATE BG_PROPERTY_VALUE SET VALUE='jdbc:oracle:thin:@xxxx.xxxx.xxxx.xxxx:1521:orcl' WHERE BG_PROPERTY_VALUE_ID=32
-------------------------end init xml--------------------------

 

iteye_735
关注
MyBatis内置XML元素解析器解析自定义标签——快速掌握MyBatis自定义标签开发
程序员光剑
07-28 1660
作为一个技术人员，一定要懂得把自己的知识通过有效的表达传递给他人。我认为把自己的知识通过文章的方式进行传播是非常有必要的。这也是技术博客文章的重要性。MyBatis 是 Apache 基金会的一个开源项目，它是一个优秀的持久层框架，可以用于 Java 的应用开发。MyBatis 提供了强大的映射工具，使得数据库操作变得简单而方便。MyBatis 在 MyBatis-Spring 中也提供了 Spring 和 MyBatis 之间的集成支持。
Mybatis源码解析之数据库连接与SQL执行
qq_36526036的博客
04-21 1561
文章目录1、背景介绍2、创建SqlSession3、数据库连接4、执行SQL语句5、常见面试题 这一篇文章主要MyBatis拿到配置文件之后，即获取到数据源配置信息和SQL语句之后，然后再从源码解读分析MyBatis是如何进行数据库连接和SQL语句执行。关于MyBatis是如何解析mybatis-config.xml文件，获取到数据源的请看这篇文章： Mybatis源码解析之数据源和SQL构建 1...
Configuration对properties、xml配置文件的【增删改查】及动态加载
01-13
Apache Commons Configuration对properties、xml配置文件的【增删改查】及动态加载小案例。小编也是找了网上很多资源，综合研究了一下。被怪我黑！！！
Apache Common-Configuration工具
lovemedsz的专栏
11-18 815
Apache Common-Configuration工具可以从 Properties文件，XML文件,JNDI,JDBC数据源，System Properties,Applet parameters,Servlet Parameters等读取相应信息 使用步骤 前提，引入commons-configuration-1.6.jar这个JAR包，同时还必须映入commm-logging.jar
XMLConfiguration用法
lovebosom的博客
12-16 9868
XMLConfiguration是apache工具集里的一个用于对XML文件进行读写的东东，使用起来很方便。下面我将简单的举几个使用例子。 1,读 这里是我们的XML文件:unit.xml /root/Desktop/image/4.jpg /root/Desktop/image/5.jpg root x=250:y=225
XMLConfig
llimite的专栏
08-18 1555
Imports System.Xml Public Class Config     Private xdoc As XmlDocument     Private Shared cfg As Config     Private fileName As String     REM 单例模式     Private Sub New()         cfg = Me     E
JAVA XMLConfiguration解决StringXML及多节点
weixin_30388677的博客
11-05 141
import org.apache.commons.configuration.ConfigurationException; import org.apache.commons.configuration.HierarchicalConfiguration; import org.apache.commons.configuration.HierarchicalConfiguration...
Mybatis拦截器获取xml文件最终执行的sql语句
最新发布
个人博客
09-26 1330
【代码】Mybatis拦截器获取xm文件最终执行的sql语句。
mysql查询sqlserver表_sqlserver 获取所有数据库
weixin_35355560的博客
02-02 1602
初识 MyBatis MyBatis 是第一个支持自定义 SQL、存储过程和高级映射的类持久框架。MyBatis 消除了大部分 JDBC 的样板代码、手动设置参数以及检索结果。MyBatis 能够支持简单的 XML 和注解配置规则。使 Map 接口和 POJO 类映射到数据库字段和记录。MyBatis 的特点 那么 MyBatis 具有什么特点呢？或许我们可以从如下几个方面来描述MyBatis 中...
《手写Mybatis》第4章：Mapper XML的解析和注册使用.doc
07-10
2. 解析XML文件，提取出Mapper接口名称、SQL语句、参数和结果映射等信息。 3. 创建MapperRegistry实例，将解析得到的Mapper信息注册到Registry中，建立Mapper接口与XML配置的对应关系。 4. 生成MapperProxyFactory，...
org.apache.commons.configuration.XMLConfiguration的读取范例
01-05
org.apache.commons.configuration.XMLConfiguration的读取范例
Ehcache 3.7文档—基础篇—XML Configuration
weixin_30600197的博客
03-24 511
你可以使用xml配置创建CacheManager，根据这个schema definition (http://www.ehcache.org/documentation/3.7/xsds.html#core ) 一. 配置元素 <config> 根元素 config是我们xml配置文件的根元素。它代表了CacheManager的配置。 注意：Ehcache允许创建多个Caca...
org.apache.commons.configuration.XMLConfiguration 可以用来读取和写入 xml 文件
软件哲学
05-22 2740
org.apache.commons.configuration.XMLConfiguration 可以用来读取和写入 xml 文件 这样可以把 xml 读到 PropertyPlaceholderConfigurer 里面
XMLConfiguration 的使用
欢迎来到sudyguoguo的世界
07-08 1629
XMLConfiguration xmlConfig = new XMLConfiguration("config.xml"); String STYLE = xmlConfig.getString("decorate.style"); String NUM = xmlConfig.getString("decorate.num"); String command ="AAA";
使用XMLConfiguration读取XML文件
u012230451的专栏
02-15 725
包含XMLConfiguration的TestDataReader,用来读取XML文件,并能直接或者字符串,整形数据.要读取的XML文件格式如下: [code="java"] /patient/welcome.htm Welcome to myBJC.org Unable to login An error has occurred ...
Servlet使用XMLConfiguration解析在线XML(或本地文件系统中的XML文件)
zhanglibo517的专栏
05-25 745
最近在项目中使用到了在线解析XML，特在此记录一下。 用到的jar包: commons-configuration-1.9.jar 依赖的包: commons-collections-3.1.jar commons-lang-2.6.jar commons-logging-1.1.2.jar 使用非常简单: 例子是alexa的域名查询回应包：
XMLConfiguration读取XML文件
scyxm0426的专栏
01-14 877
package com.sf.opoms.test.conf; import java.util.List; import org.apache.commons.configuration.ConfigurationException; import org.apache.commons.configuration.XMLConfiguration; import org.apache.com
深入Jetty源码之XmlConfiguration实现
weixin_34190136的博客
05-17 416
概述 XmlConfiguration是Jetty中用来实现使用XML文件配置WebAppContext实例的框架，事实上，他可以用来配置任何的Object。类似Digester可以将一个XML配置文件直接实例化成一个类实例，XmlConfiguration可以使用一个XML文件初始化一个Object实例，它支持属性设置、方法调用、新建新实例等。 Xml...
ambari自定义服务干货
CREATE_17的博客
12-13 3808
声明：博主写了一些Ambari系列文章，可以在历史文章中查看。 仔细看，肯定会对ambari的自定义服务有一个更清晰的认识。 版本：ambari 2.6.1 一、实时更改服务配置 # 以hue的配置文件hue.ini为例 File(format(&quot;/usr/hdp/2.6.4.0-91/hue/desktop/conf/hue.ini&quot;), content=T...
Mybatis XML与注解SQL解析机制详解
当MyBatis执行SQL语句时，它首先通过`id`从`configuration`中获取`mappedStatements`集合中的`MappedStatement`对象。这些对象与我们在配置文件中使用的`<select>`, `<insert>`, `<update>`, `<delete>`等标签或注解...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值