beanconn.java

SAP这个系统的一个转换器

package com.idoc.util.db;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import com.idoc.util.GetProperty;
import javax.swing.JOptionPane;

/**
 * <p>Title: 资产管理系统</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: 新星公司</p>
 * @author 唐权华
 * @version 1.0
 */

public class BeanConn
    implements Serializable {

  public BeanConn() {
  }

  /**
   * 得到数据库连接
   * @return
   * @throws java.lang.Exception
   */
  public Connection getConn() throws Exception {

    GetProperty getdata = new GetProperty();

    String url = "";
    String driver = "";
    String user = "";
    String pass = "";

    try {
      url = getdata.getUrl().trim();
      driver = getdata.getDriver().trim();
      user = getdata.getUser().trim();
      pass = getdata.getPassword().trim();
      /*
              System.out.println("url = " + url);
              System.out.println("driver = " + driver);
              System.out.println("user = " + user);
              System.out.println("pass = " + pass);
       */
    }
    catch (Exception ex) {
      System.out.println("getProperty : " + ex.toString());
    }
    try {
      Class.forName(driver);
      return DriverManager.getConnection(url, user, pass);
    }
    catch (Exception ex) {
      //JOptionPane.showMessageDialog(null, "请检查你的网络是否畅通或POS中心数据库是否启动！", "读数据库错",                                   0);

      System.out.println("getConn ex : " + ex.toString());
      ex.printStackTrace();
      return null;
    }
  }
}