Apache derby(JavaDB)

[maxogm]

Primer rada sa derby(JavaDB) embedded bazom podataka.

Primer jedne tabele u derby bazi podataka

Kod Izaberi Expand


CREATE
    TABLE TBL_USER
    (
        ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
        FIRST_NAME VARCHAR(128) NOT NULL,
        LAST_NAME VARCHAR(128) NOT NULL,
        PRIMARY KEY (ID)
    )


Za vasu aplikaciju potreban vam je samo derby jar. Mozete ga preuzeti lako koristeci maven2.

pom.xml

Kod Izaberi Expand


<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>Derby</groupId>
  <artifactId>Derby</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <dependencies>
    <dependency>
      <groupId>org.apache.derby</groupId>
      <artifactId>derby</artifactId>
      <version>10.5.3.0_1</version>
    </dependency>
  </dependencies>
</project>


Primer jedne klase za rad sa bazom:

Kod Izaberi Expand


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
*
* @author vladem
*/
public class EmbeddedDerby
{

   private String dbPath = "d:/myJavaDB";

   public EmbeddedDerby()
   {
      Connection conn = null;
      try
      {
         Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
         conn = DriverManager.getConnection("jdbc:derby:" + dbPath + ";create=false", "admin", "admin");
         Statement query = conn.createStatement();

         query.execute("INSERT INTO TBL_USER (first_name, last_name) VALUES ('Vlade', 'Maksimovic')");
         // displaying record
         ResultSet rs = query.executeQuery("SELECT * FROM TBL_USER");
         while (rs.next())
         {
            System.out.println("ID: " + rs.getInt("id") + "; First name: "
                  + rs.getString("first_name") + "; Last name: "
                  + rs.getString("last_name"));
         }
      } catch (Exception ex)
      {
         Logger.getLogger(EmbeddedDerby.class.getName()).log(Level.SEVERE, null, ex);
      } finally{
        try
      {
         conn.close();
      } catch (SQLException e)
      {
         e.printStackTrace();
      }
      }
   }

   public static void main(String... args)
   {
      new EmbeddedDerby();
   }
}