全国省份城市地区完整数据及插入数据库程序

package dom; import java.io.File; import java.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Collection; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.parsers.ParserConfigurationException; import org.w3c.dom.DOMException; import org.w3c.dom.Document; import org.w3c.dom.Element; import org.w3c.dom.NamedNodeMap; import org.w3c.dom.Node; import org.w3c.dom.NodeList; import org.xml.sax.SAXException; import util.ConnBean; public class Dom { public static void main(String[] args) throws SQLException { try { DocumentBuilderFactory factory = DocumentBuilderFactory .newInstance(); DocumentBuilder builder = factory.newDocumentBuilder(); Document document = builder.parse(new File("src/dom/aa.xml")); // 得到所有的province节点 NodeList provinces = document.getElementsByTagName("District"); for (int i = 0; i < provinces.getLength(); i++) { System.out.println("**************************************"); Element eleNode = (Element) provinces.item(i); //String id = eleNode.getAttribute("ID"); String PARENT_ID = eleNode.getAttribute("CID"); String NAME = eleNode.getAttribute("DistrictName"); //向数据库中插入省份 String provinceSql=" insert into imbos_c_dic(PARENT_ID,NAME) values(?,?)"; ConnBean cbn=new ConnBean(); //得到数据库连接 Connection con = cbn.getCon(); PreparedStatement pst = null; pst=con.prepareStatement(provinceSql); //pst.setString(1, id); pst.setString(1, PARENT_ID); pst.setString(2, NAME); int insertRs = pst.executeUpdate(); pst.close(); con.close(); System.out.println(i); } } catch (SAXException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (ParserConfigurationException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }