Derby（組み込み版）をJavaでとりあえず使ってみた場合のソース例

import java.sql.ResultSet;

import java.sql.Statement;

import java.sql.Connection;

import java.sql.DriverManager;
public class DBConnectionSampleMain {

  public static void main(String[] args) {		

    String framework = "embedded";

    String driver = "org.apache.derby.jdbc.EmbeddedDriver";

    String protocol = "jdbc:derby:";

    try{

      Class.forName(driver).newInstance();

      System.out.println("Derby DB Driver is loaded");	

      Connection conn = null;

      conn = DriverManager.getConnection(protocol + "C:\\DB\\DerbyTestDB");

      Statement stmt = conn.createStatement();

      ResultSet rs = stmt.executeQuery("select count(*) from member");

      while(rs.next()){

        int count = rs.getInt(1);

        System.out.println(count);				

      }

      rs.close();

      stmt.close();

      conn.close();

      System.out.println("fin");

    }catch(Exception e){

      e.printStackTrace();

    }

  }

}