dodelcurrow.java

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

package boco.shabank.dbmanager;

//******************************************************************************
//:功能:实现从数据表中删除选中的当前行
//:时间:2002-07
//:作者:王建宾
//:特殊描述::test:为DEBUG时启用
//:程序描述:
//
//******************************************************************************

import java.util.*;
import java.sql.*;
import boco.shabank.dbconnection.*;
public class doDelCurRow {
  //定义变量
  String sql;
  String errMsg;
  DBConnectionManager objDBConnection;
  Connection m_Connection;
  DBAccess db;
  //构造函数，初始化变量
  public doDelCurRow() {
    sql="";
    errMsg="success";
  }
  //返回所有数据源记录
  public void doDelCurRow(String DBSourceName,String DBTName,String KeyName,String KeyValue,String KeyType){
    db=new DBAccess();
    //根据类型返回sql语句
    if(KeyType.equalsIgnoreCase("INTeger")||KeyType.equalsIgnoreCase("INT")||KeyType.equalsIgnoreCase("BIGINT")||KeyType.equalsIgnoreCase("SMALLINT")||KeyType.equalsIgnoreCase("DOUBLE")||KeyType.equalsIgnoreCase("TINYINT")){
    sql="delete from " + DBTName + " where " + KeyName.trim() + "=" + KeyValue;
    }
    else{
      sql="delete from " + DBTName + " where " + KeyName.trim() + "='" + KeyValue + "'";
    }


    //:test:System.out.println("delete sql="+sql);
    objDBConnection = objDBConnection.getInstance() ;
    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){
      doDelCurRow del = new doDelCurRow();
      del.doDelCurRow("dbmng","dbtable","dbtid","34","int");
      System.out.println("OK!");
    }
}