example02.java

java游戏核心源代码 对于喜欢java游戏的可以看看 和有帮助的

import contacts.ContactInfo;
import contacts.PhoneNumber;
import net.sf.hibernate.Hibernate;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import net.sf.hibernate.tool.hbm2ddl.SchemaUpdate;

import java.util.List;

public class Example02 {

    public static void main(String[] args) throws Exception {

        // load configuration
        Configuration config = new Configuration();
        config.configure();

        // update database schema if required
        new SchemaUpdate(config).execute(true);

        // open a session
        SessionFactory sessionFactory = config.buildSessionFactory();
        Session session = sessionFactory.openSession();

        // create a contact
        ContactInfo contact = new ContactInfo();
        contact.setFirstName("Bart");
        contact.setLastName("Simpson");

        PhoneNumber phone = new PhoneNumber();
        phone.setCountryCode("999");
        phone.setAreaCode("666");
        phone.setNumber("6969");

        contact.setPhone(phone);

        System.out.println("add contact to database...");
        try {
            session.save(contact);

            session.flush();
            session.connection().commit();
        } catch (Exception e) {
            session.connection().rollback();
        }

        System.out.println("contact:" + contact);

        System.out.println("load contact from database...");
        try {
            long id = contact.getId();
            contact = (ContactInfo)session.load(ContactInfo.class,
                                   new Long(id));

            session.flush();
            session.connection().commit();
        } catch (Exception e) {
            e.printStackTrace();
            session.connection().rollback();
        } finally {
            System.out.println("loaded contact:" + contact);
        }

        System.out.println("find all contacts...");
        try {
            List contacts = session.find("FROM contacts.ContactInfo");

            session.flush();
            session.connection().commit();

            for (int i = 0; i < contacts.size(); i++) {
                ContactInfo contactInfo = (ContactInfo) contacts.get(i);
                System.out.println("contactInfo:" + contactInfo);
            }
        } catch (Exception e) {
            e.printStackTrace();
            session.connection().rollback();
        }

        System.out.println("find all contacts with the first name of Bart...");
        try {
            String firstName = "Bart";
            List contacts = session.find(
               "select c from contacts.ContactInfo c where c.firstName=?",
               firstName, Hibernate.STRING);

            session.flush();
            session.connection().commit();

            for (int i = 0; i < contacts.size(); i++) {
                ContactInfo contactInfo = (ContactInfo) contacts.get(i);
                System.out.println("contactInfo:" + contactInfo);
            }
        } catch (Exception e) {
            e.printStackTrace();
            session.connection().rollback();
        }

        System.out.println("find all contacts with ordering...");
        try {
            List contacts = session.find("from contacts.ContactInfo c order by c.firstName asc, c.lastName desc");

            session.flush();
            session.connection().commit();

            for (int i = 0; i < contacts.size(); i++) {
                ContactInfo contactInfo = (ContactInfo) contacts.get(i);
                System.out.println("contactInfo:" + contactInfo);
            }
        } catch (Exception e) {
            e.printStackTrace();
            session.connection().rollback();
        }

        System.out.println("find how many contacts are in database...");
        try {
            List contacts = session.find("select count(c) from contacts.ContactInfo c");

            session.flush();
            session.connection().commit();

            int count = ((Integer)contacts.get(0)).intValue();
            System.out.println("count:" + count);
        } catch (Exception e) {
            e.printStackTrace();
            session.connection().rollback();
        }

        System.out.println("find all first names and last names...");
        try {
            List contacts = session.find("select c.firstName, c.lastName from contacts.ContactInfo c");

            session.flush();
            session.connection().commit();

            for (int i = 0; i < contacts.size(); i++) {
                Object[] row = (Object[]) contacts.get(i);
                String firstName = (String)row[0];
                String lastName = (String)row[1];
                System.out.println("firstName:" + firstName);
                System.out.println("lastName:" + lastName);
            }
        } catch (Exception e) {
            e.printStackTrace();
            session.connection().rollback();
        }

        System.out.println("find all last names for contacts that have a non-null lastName...");
        try {
            List contacts = session.find(
                "select c.lastName from contacts.ContactInfo c where c.lastName is not null group by c.lastName");

            session.flush();
            session.connection().commit();

            for (int i = 0; i < contacts.size(); i++) {
                String lastName = (String) contacts.get(i);
                System.out.println("lastName:" + lastName);
            }
        } catch (Exception e) {
            e.printStackTrace();
            session.connection().rollback();
        }

        // close the session
        session.close();
        sessionFactory.close();

    }
}