dbmanager.java~33~

若已安装Jbuilder X

package Manager;
import java.sql.*;
import java.util.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */

public class DBManager {

      ResultSet rs ;

  public DBManager() {

                      }

  public  ResultSet executeQuery(String sql){

        try{
            String strurl="jdbc:odbc:myProduct";
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;

           Connection  conn=DriverManager.getConnection(strurl) ;
          Statement  stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
           //Statement  stmt=conn.createStatement();
            ResultSet  rs=stmt.executeQuery(sql);

               return rs;
            }

        catch(Exception e){

              System.out.println( "dbmanager------"+e.toString()  );
                           }

          return rs;
                                            }
}