connectionmanage.java~14~

来自「用Ajax技术实现一个邮政编码查找的功能.」· JAVA~14~ 代码 · 共 64 行

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 {
      DOMParser par = new DOMParser();
      par.parse("db.xml");
      Document doc = par.getDocument();
      NodeList list =  doc.getElementById("name");
      String datasource =  list.item(0).getFirstChild().getNodeValue();
      System.out.println(datasource+"haha");
      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) {
      }
  }
}