connectionmanage.java~11~

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

package com.accp.xdj;
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 {
      DocumentBuilder doc = new DocumentBuilder();
      doc.parse(new File(""));
      DOMParser par = new DOMParser();
      par.parse("db.xml");

      conn = DriverManager.getConnection("jdbc:odbc:faq");
    }
    catch (SQLException ex1) {
    }
    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) {
      }
  }
}