dorunsql.java

来自「农业银行ATM对帐查询系统后台类包的源代码,实现了FTP,数据库管理等等功能」· Java 代码 · 共 55 行

package boco.DBManager.Tree;
//******************************************************************************
//:功能:实现与数据源的连接并执行传入的SQL语句,返回结果信息
//:时间:2002-07
//:作者:王建宾
//:特殊描述::test:为DEBUG时启用
//:程序描述:
//
//******************************************************************************

import java.util.*;
import java.sql.*;
import boco.shabank.dbconnection.*;
public class doRunSQL {
  //定义变量
  String errMsg;
  DBConnectionAny objDBConnection;
  Connection m_Connection;
  DBAccess db;
  //构造函数，初始化变量
  public doRunSQL() {
    errMsg = "";
    objDBConnection = null;
    m_Connection = null;
    db = null;
  }
  //执行SQL
    public void doRunSQL(String DBSourceName,String sql){
    db=new DBAccess(DBSourceName);
    errMsg="success";
    objDBConnection = objDBConnection.getInstance() ;
    System.out.println("Insert&Delete&Update&Query:"+sql);
    try{
      m_Connection = objDBConnection.getConnection(DBSourceName) ;
      db.executeUpdate(m_Connection,sql);
      //释放连接池
      objDBConnection.freeConnection(DBSourceName,m_Connection) ;
    }
    catch(Exception e){
      errMsg = e.getMessage().toString();
      System.out.print("errorMsg=" + e.getMessage()) ;
    }

  }
    public String getErrMsg()
    {
      return errMsg;
    }
    //测试主程序
    public static void main(String[] args){
      doRunSQL add = new doRunSQL();
      add.doRunSQL("dbmng","insert into ");
      System.out.println("OK!");
    }
}