databaseselect.java

J2EE独立开发制作

package db;
import java.sql.*;
import java.util.Vector;



public class DataBaseSelect {
   
   private Vector result;
     
   public DataBaseSelect() {
      result = new Vector();
   } // constructor DataBaseSelect
   
   public String connect() {
      try {
     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
     return "Driver Loaded!";
      } catch (Exception E) {
     return "Unable to load driver.";
      }
   }
   
   public String select() {
      try {
     Connection C = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=pubs", "sa", "");
     
     Statement Stmt = C.createStatement();
     
     ResultSet myResult = Stmt.executeQuery("select * from publishers");
     
     while (myResult.next()) {
        result.addElement(myResult.getString(1));
     }
     
         // Clean up
         myResult.close();
         Stmt.close();
         C.close();
     return "Connection Success!";
      } catch (SQLException E) {
     return "SQLException: " + E.getMessage();
      }
   }
      
   /**
    * Accessor for result
    **/
   public Vector getResult() {
      return result;
   }
   
   /**
    * Mutator for result
    **/
   public void setResult(Vector avector) {
     result = avector;
   }  
   
}