tryencapsulatedmapping.java

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· Java 代码 · 共 46 行

import java.sql.*;

public class TryEncapsulatedMapping {
  Connection databaseConnection;
  String driverName;
  String sourceURL;

  public static void main(String[] args) {
    TryEncapsulatedMapping SQLtoJavaExample;
    try {
      SQLtoJavaExample = new TryEncapsulatedMapping();
      SQLtoJavaExample.listRecordings();
    } catch (SQLException sqle) {
      System.out.println("SQL Exception: " + sqle);
    } catch (ClassNotFoundException cnfe) {
      System.out.println(cnfe.toString());
    } 
  } 

  public TryEncapsulatedMapping() 
          throws SQLException, ClassNotFoundException {
    driverName = "COM.cloudscape.core.JDBCDriver";
    sourceURL = "jdbc:cloudscape:Wrox4370.db";

    Class.forName(driverName);
    databaseConnection = DriverManager.getConnection(sourceURL);
  }

  public void listRecordings() throws SQLException {

    Recording aRecording;
    String query = 
      "SELECT recordingid, recordingtitle, publisherid, catalognumber, recordingformatid, releasedate, languageid, listprice from recordings";

    Statement statement = databaseConnection.createStatement();
    ResultSet recordings = statement.executeQuery(query);

    while (recordings.next()) {
      aRecording = Recording.fromResults(recordings);
      System.out.println("\n" + aRecording.toString());
    } 

    recordings.close();
    databaseConnection.close();
  } 
}