query.java~1~

来自「这个是朋友作的毕业设计」· JAVA~1~ 代码 · 共 41 行

package Resource_Selection;

import java.io.*;
import java.util.*;
import java.sql.*;
import com.borland.dx.sql.dataset.*;

public class query {
  public query(String command) {
    String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
String connectionURL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\WINDOWS\\Desktop\\desktop\\毕业设计\\Grid\\computer.mdb";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String adm = null;

try {
  Class.forName(driverName).newInstance();
  con = DriverManager.getConnection(connectionURL);
  stmt = con.createStatement();
  rs = stmt.executeQuery(command);
}
  catch(Exception ex)
{
  ex.printStackTrace();
}

  finally {
    try {
      rs.close();
      stmt.close();
      con.close();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  }

}