package treedoc;

/**  功能
*
* MYSQL數據庫管理類..現在只有一個方法
* 數據庫連接參數取自param.ini文件
*/

/**
 * 名稱       : WORKFLOW_DB_CONNECTION
 * 描述       : WWW.FANGFA.NET 工作流管理系統--數據庫連接層
 * 版權信息   : Copyright (c) 2004 COMSCI
 * @作者      : COMSCI Sichuan Fangfa Digital
 * @版本      : 0.9 builder 2004091910
 * @日期      : 2004/09/19
 */



import java.sql.*;
import javax.swing.*;


public class workflow_DB_connection {

  workflow_SystemConfig wsc = new workflow_SystemConfig();
  String url;
  String Driver;
  String user;
  String password;

  Connection conn;
  Statement stmt,stmt1,stmt2;
  ResultSet rs,rs1,rs2;

  public workflow_DB_connection() {

    wsc.getParameter();
    url = wsc.url;
    Driver = wsc.driver;
    user = wsc.User;
    password = wsc.Password;




    try {
      Class.forName(Driver).newInstance();
      conn = DriverManager.getConnection(url, user, password);
      stmt = conn.createStatement();
      stmt1 = conn.createStatement();
      stmt2 = conn.createStatement();
      rs = null;
      rs1 = null;
      rs2 = null;
    }
    catch (Exception e) {
      JOptionPane.showMessageDialog(null,"數據庫連接異常"+e);

    }

  }





}