mysql从SQL数据库中访问java中xml名称空间标记的值

Question

嗨。我编写了一个java代码，在单独的xml文件（.xml）中创建xml标记并查询数据库。我的xml标记的格式如下：

<company comp:loc=" "/> 

现在我需要从SQL数据库中获取空白字段（loc=”“）的值

如何在java中从SQL数据库中获取这些值

Answer 1

        connection = dataSource.getConnection();
        ResultSet rs;
        connection.setAutoCommit(false);
        System.out.println("Connected to server OELDBSQL!!!");
        Statement stmt=connection.createStatement();
        String querystring="select loc from location";
        rs = stmt.executeQuery(querystring );
        while(rs.next())  {
        Element child1 = doc.createElement("company");
        child1.setAttributeNS(comp,"comp:loc", rs.getString (1));