mysql读取xml文件,如何从XML文件中读取数据并将其存储到数据库(MySQL)中?

I need to get data from an XML file and store it into a MySQL Database. I am thinking of using a SAX Parser for parsing the data but I am not sure of how to store data efficiently into database, I am thinking of few technologies like JDBC and Hibernate but I wanted to ask about what would be the efficient way of doing it?

Note: Here programming language is Java.

解决方案

You could use Castor witch is an open source data binding framework for moving data from

XML to Java programming language objects and from Java to

databases.

I found also article series in IBM developerWorks that describe using Castor suited to your needs.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
在Spring Boot,可以使用Jackson XML库来读取XML配置文件的JSON数据,并使用Spring Data JDBC来连接数据库。 首先,需要在项目的pom.xml文件添加以下依赖: ```xml <dependency> <groupId>com.fasterxml.jackson.dataformat</groupId> <artifactId>jackson-dataformat-xml</artifactId> <version>2.12.1</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> ``` 接下来,在application.properties或application.yml文件配置数据库连接信息: ```yml spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai spring.datasource.username=root spring.datasource.password=root ``` 然后,在读取XML配置文件的JSON数据时,可以使用以下代码: ```java @Autowired private ResourceLoader resourceLoader; public void readJsonFromXml() throws IOException { Resource resource = resourceLoader.getResource("classpath:config.xml"); XmlMapper xmlMapper = new XmlMapper(); JsonNode jsonNode = xmlMapper.readTree(resource.getInputStream()).get("database"); String url = jsonNode.get("url").asText(); String username = jsonNode.get("username").asText(); String password = jsonNode.get("password").asText(); // 使用JDBC连接数据库 } ``` 其,config.xml文件的内容如下: ```xml <config> <database> <url>{"url":"jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai"}</url> <username>{"username":"root"}</username> <password>{"password":"root"}</password> </database> </config> ``` 通过以上步骤,就可以通过读取XML配置文件的JSON数据来连接数据库了。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值