xml连接mysql配置文件

<?xml version="1.0" encoding="UTF-8"?>
<database>
    <url>jdbc:mysql://localhost:3306/mydatabase</url>
    <username>myuser</username>
    <password>mypassword</password>
    <dbname>mydatabase</dbname>
</database>

import org.w3c.dom.*;
import javax.xml.parsers.*;
import java.sql.*;

public class DatabaseConnector {
    public static void main(String[] args) {
        try {
            // 加载XML配置文件
            DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
            DocumentBuilder builder = factory.newDocumentBuilder();
            Document document = builder.parse("config.xml");

            // 解析XML配置文件
            NodeList nodeList = document.getElementsByTagName("database");
            Element element = (Element) nodeList.item(0);
            String url = element.getElementsByTagName("url").item(0).getTextContent();
            String username = element.getElementsByTagName("username").item(0).getTextContent();
            String password = element.getElementsByTagName("password").item(0).getTextContent();
            String dbname = element.getElementsByTagName("dbname").item(0).getTextContent();

            // 建立数据库连接
            Connection conn = DriverManager.getConnection(url, username, password);
            System.out.println("Connected to database: " + dbname);

            // 关闭连接
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}