xmltest.java

来自「ajax 的一个简单例子」· Java 代码 · 共 67 行

package ajax;
import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import java.sql.*;
import java.util.*;
import java.io.*;

public class XMLTest {


	public XMLTest() {
		
	}
	/**
	 * @param args
	 */
	public static Document Link() throws Exception {
		// TODO 自动生成方法存根
		Class.forName("org.postgresql.Driver");
		String url = "jdbc:postgresql://localhost:5432/gis";
		Connection con = DriverManager.getConnection(url, "postgres", "123456");
		Statement st = con.createStatement();
		String sql = "select *,astext(the_geom) as geom from house";

		
		System.out.println("sdflkjklafj");
		ResultSet rs = st.executeQuery(sql);
		// int i=rs.getInt(1);
		// String Lan[];
		// System.out.println(i);
		String arg[] = new String[100];
		int i = 0;
		while (rs.next()) {
			String a = rs.getString(6);
			arg[i] = a;
			i++;
			System.out.print(rs.getInt(1));

			System.out.println(rs.getString(6));

		}
		/*
		 * for(i=0;i<100;i++) { System.out.print(i);
		 * System.out.println(arg[i]); }
		 */
		rs.close();
		st.close();
		con.close();

		Document document = DocumentHelper.createDocument();
		document.setXMLEncoding("UTF-8");
		Element LanElement = document.addElement("Lan");
		for (i = 0; i < arg.length; i++) {

			Element subnetElement = LanElement.addElement("geom" + i);
			// subnetElement.addText(arg[i]);
			subnetElement.addComment(arg[i]);
		}

		// System.out.println(subnetElement.asXML());
		System.out.println(document.asXML());
		return document;
	}

}