xmltest1.java

ajax 的一个简单例子

package ajax;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import java.sql.*;

public class XMLTest1 {

	/**
	 * @param args
	 */
	public static void main(String[] args) 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++) {
			if(arg[i]==null)break;
			Element subnetElement = LanElement.addElement("geom" + i);
			// subnetElement.addText(arg[i]);
			subnetElement.setText((arg[i]));
		}

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

}