connectionmanage.java~11~

用Ajax技术实现一个邮政编码查找的功能.

package com.accp.xdj.zipcode.server.dao;

import java.sql.*;
import javax.xml.*;
import javax.xml.parsers.*;
import java.io.*;
import org.xml.sax.*;
import org.w3c.dom.*;
import org.xml.sax.*;
import org.apache.xerces.parsers.*;

public class ConnectionManage {
  public static Connection getConnection()
  {
    Connection conn = null;
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (ClassNotFoundException ex) {
    }
    try {
      DOMParser par = new DOMParser();
      try {
        par.parse("../db.xml");
      }
      catch (IOException ex2) {
        System.out.println(ex2.toString());
      }
      catch (SAXException ex2) {
         System.out.println(ex2.toString());
      }
      //dom解悉xml
      Document doc = par.getDocument();
      NodeList list =  doc.getElementsByTagName("name");
      String datasource =  list.item(0).getFirstChild().getNodeValue();
      conn = DriverManager.getConnection("jdbc:odbc:"+datasource);
    }
    catch (SQLException ex1) {
      System.out.println(ex1.toString());
    }
    return conn;
  }

  public static void close(Connection conn) {
    try {
      if (!conn.isClosed())
        conn.close();
    }
    catch (SQLException ex) {
      System.out.println(ex.toString());
    }
  }

  public static void close(ResultSet rs)
  {
    if(rs!=null)
      try {
        rs.close();
      }
      catch (SQLException ex) {
      }
  }

  public static void close(Statement st)
  {
    if(st!=null)
      try {
        st.close();
      }
      catch (SQLException ex) {
      }
  }
}