Java/Hibernate/Key

Key Generator UUID HEX

/////////////////////////////////////////////////////////////////////////
import java.io.Serializable;
import java.util.*;
import java.sql.*;
import org.hibernate.*;
import org.hibernate.cfg.*;
import org.hibernate.criterion.*;
import org.hibernate.event.*;
import org.hibernate.event.def.*;
public class Main {
   public static void main(String[] args) throws Exception {
      HibernateUtil.setup("create table account (id varchar not null,name varchar,accountnumber varchar,setup Date,balance double);");    

      Session session = HibernateUtil.currentSession();
      BasicAccount account = new BasicAccount();
      account.setName("Joe");
      account.setAccountnumber("39084");
      account.setSetupdate(new java.util.Date());
      account.setBalance(4054.00);
      session.save(account);
      session.flush();
      BasicAccount account2 = (BasicAccount)session.load
            (BasicAccount.class, account.getId());
      System.out.println(account.getId() + " : " + account.getSetupdate());
      System.out.println(account2.getId() +
             " : " + account2.getSetupdate());
      session.close();

      session.close();
      HibernateUtil.checkData("select * from account");
   }
}

/////////////////////////////////////////////////////////////////////////
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" 
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
    <class  name="BasicAccount" table="account"> 
    <id name="id" type="string" unsaved-value="null">
       <generator class="uuid.hex"/>
    </id>
    
    <property name="name"/>
    <property name="accountnumber"/>
    <property name="setupdate">
        <column name="setup" sql-type="Date"/>
    </property>
    <property name="balance" type="double"/>
    </class>
</hibernate-mapping>

/////////////////////////////////////////////////////////////////////////
import java.util.*;
public class BasicAccount {
  private String id; 
  private String name;
  private String accountnumber; 
  private Date setupdate; 
  private double balance;
  public BasicAccount() {
  }
  public void setId(String s) {
    id = s;
  }
  public String getId() {
    return id;
  }
  public void setName(String s) {
    name = s;
  }
  public String getName() {
    return name;
  }
  public void setAccountnumber(String s) {
    accountnumber = s;
  }
  public String getAccountnumber() {
    return accountnumber;
  }
  public void setSetupdate(Date d) {
    setupdate = d;
  }
  public Date getSetupdate() {
    return setupdate;
  }
  public void setBalance(double d) {
    balance = d;
  }
  public double getBalance() {
    return balance;
  }
  
}

/////////////////////////////////////////////////////////////////////////
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class HibernateUtil {
    public static final SessionFactory sessionFactory;
    static {
        try {
            // Create the SessionFactory from hibernate.cfg.xml
            sessionFactory = new Configuration().configure().buildSessionFactory();
        } catch (Throwable ex) {
            // Make sure you log the exception, as it might be swallowed
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }
    public static final ThreadLocal session = new ThreadLocal();
    public static Session currentSession() throws HibernateException {
        Session s = (Session) session.get();
        // Open a new Session, if this thread has none yet
        if (s == null) {
            s = sessionFactory.openSession();
            // Store it in the ThreadLocal variable
            session.set(s);
        }
        return s;
    }
    public static void closeSession() throws HibernateException {
        Session s = (Session) session.get();
        if (s != null)
            s.close();
        session.set(null);
    }
    
    static Connection conn; 
    static Statement st;
  public static void setup(String sql) {
    try {
      // Step 1: Load the JDBC driver.
      Class.forName("org.hsqldb.jdbcDriver");
      System.out.println("Driver Loaded.");
      // Step 2: Establish the connection to the database.
      String url = "jdbc:hsqldb:data/tutorial";
      conn = DriverManager.getConnection(url, "sa", "");
      System.out.println("Got Connection.");
      st = conn.createStatement();
      st.executeUpdate(sql);
    } catch (Exception e) {
      System.err.println("Got an exception! ");
      e.printStackTrace();
      System.exit(0);
    }
  }
  public static void checkData(String sql) {
    try {
      HibernateUtil.outputResultSet(st
          .executeQuery(sql));
//      conn.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
    public static void outputResultSet(ResultSet rs) throws Exception{
    ResultSetMetaData metadata = rs.getMetaData();
    int numcols = metadata.getColumnCount();
    String[] labels = new String[numcols]; 
    int[] colwidths = new int[numcols];
    int[] colpos = new int[numcols];
    int linewidth;
      for (int i = 0; i < numcols; i++) {
        labels[i] = metadata.getColumnLabel(i + 1); // get its label
        System.out.print(labels[i]+"  ");
    }
      System.out.println("------------------------");
    while (rs.next()) {
        for (int i = 0; i < numcols; i++) {
        Object value = rs.getObject(i + 1);
        System.out.print(value.toString().trim()+"   ");
      }
    }
    }
}

/////////////////////////////////////////////////////////////////////////
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <!-- Database connection settings -->
        <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
        <property name="connection.url">jdbc:hsqldb:data/tutorial</property>
        <property name="connection.username">sa</property>
        <property name="connection.password"></property>
        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>
        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>
        <!-- Mapping files -->
        <mapping resource="BasicAccount.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

/////////////////////////////////////////////////////////////////////////

Key Int Auto Increment

/////////////////////////////////////////////////////////////////////////
import org.hibernate.Session;
import util.ConnectionUtil;
import util.HibernateUtil;
public class Main {
  static Session session;
  public static void main(String[] args) {
    open();
    Keyword k = new Keyword();
    session.save(k);
    session.flush();
    
    close();
  }
  
  private static void open() {
    ConnectionUtil.openConnection();
    ConnectionUtil.update("CREATE TABLE KEYWORDS ( ID int, NAME VARCHAR(25) )");
    session = HibernateUtil.currentSession();
  }
  private static void close() {
    ConnectionUtil.closeConnection();
    HibernateUtil.closeSession();
    HibernateUtil.sessionFactory.close();
  }
}

/////////////////////////////////////////////////////////////////////////
public class Keyword {
    protected Integer    id_;
    protected String name_ ="aaa";
    public Keyword() {
    }
    public Integer getId() {
        return id_;
    }
    public void setId(Integer newId) {
        this.id_ = newId;
    }
    public String getName() {
        return name_;
    }
    public void setName(String newName) {
        this.name_ = newName;
    }
}

/////////////////////////////////////////////////////////////////////////
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
          "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
          "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
  <!-- table created by: CREATE TABLE KEYWORDS ( ID IDENTITY, NAME VARCHAR(25) ); -->
  <class name="Keyword" table="keywords">
        
    <id name="id" column="id" unsaved-value="null">
      <generator class="increment"/>
    </id>
        
    <property name="name" 
              column="NAME" 
              not-null="true" 
              unique="true"
              />
  </class>
</hibernate-mapping> 
<!-- $Id: Keyword.hbm.xml,v 1.3 2003/07/08 19:18:30 dwight Exp $ -->

/////////////////////////////////////////////////////////////////////////

<!DOCTYPE hibernate-configuration PUBLIC
  "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
     <!-- Database connection settings -->
        <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
        <property name="connection.url">jdbc:hsqldb:mem:testdb</property>
        <property name="connection.username">sa</property>
        <property name="connection.password"></property>
        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">2</property>
        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>
        <!-- Drop and re-create the database schema on startup 
        <property name="hbm2ddl.auto">create</property>-->
        <mapping resource="Keyword.hbm.xml"/>
  </session-factory>
</hibernate-configuration>