dbmanager.java~34~

来自「这是一个产品管理系统程序。用java 编写 希望各位踊跃分享」· JAVA~34~ 代码 · 共 42 行

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;
                                            }
}