executesqlbean.java~27~

来自「bbs系统」· JAVA~27~ 代码 · 共 52 行

package bbs.beans.dbcontact;
import java.sql.*;
import java.util.StringTokenizer; //分割字符串类

public class ExecuteSqlBean
{ private Connection con;
  private Statement stm;
  public ExecuteSqlBean()
  { String CFN="sun.jdbc.odbc.JdbcOdbcDriver";
    String DB="jdbc:odbc:dbcon";
    String USER="";
    String PWD="";

    try
    { Class.forName(CFN);
      con=DriverManager.getConnection(DB,USER,PWD) ;
      stm=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    }
    catch(Exception e)
    { e.printStackTrace();
    }
  }

public ResultSet ExecuteSql(String sql) throws Exception
  {
     String temp="";
     StringTokenizer st=new StringTokenizer(sql);
     temp=st.nextToken();

     try
     {
      if(temp.equalsIgnoreCase( "select") )
      {  ResultSet result=stm.executeQuery(sql);
        return result;
      }
      else
       { stm.executeUpdate(sql);
       return null;
       }

     }
    catch(Exception e)
     { e.printStackTrace() ;
       //throw e;
      }
     stm.close() ;
     con.close() ;
     return null;
     }
}