Fichier: Gender.java public enum Gender { MALE, FEMALE } Fichier: Student.java import java.util.Date; import javax.persistence.Entity; import javax.persistence.EnumType; import javax.persistence.Enumerated; import javax.persistence.Id; @Entity public class Student { @Id private long id = 0; private String nom; private Date dateOfBirth = new Date(); @Enumerated(EnumType.ORDINAL) private Gender gender; public Date getDateOfBirth() { return dateOfBirth; } public void setDateOfBirth(Date dateOfBirth) { this.dateOfBirth = dateOfBirth; } public long getId() { return id; } public void setId(long id) { this.id = id; } public String getNom() { return nom; } public void setNom(String nom) { this.nom = nom; } public Gender getGender() { return gender; } public void setGender(Gender gender) { this.gender = gender; } public String toString() { return " ID:" + id + " Nom:" + nom + " Birthday:" + dateOfBirth + " Gender:" + gender+" "; } } Fichier: JPADAO.java import java.util.Date; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.EntityManagerFactory; import javax.persistence.Persistence; import javax.persistence.Query; public class JPADAO { EntityManagerFactory emf = Persistence.createEntityManagerFactory("JPAService"); EntityManager em = emf.createEntityManager(); public void create() { em.getTransaction().begin(); Student student = new Student(); student.setId(1); student.setNom("Joe"); student.setDateOfBirth(new Date()); student.setGender(Gender.FEMALE); em.persist(student); em.flush(); em.getTransaction().commit(); } public void search() { Query q = em.createQuery("select m from Student m"); for (Student m : (List<Student>) q.getResultList()) { System.out.println(m); } } public void close() { em.close(); emf.close(); } } Fichier: Helper.java import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Paysment; public class Helper { public static void checkData() throws Exception { Class.forNom("org.apache.derby.jdbc.ClientDriver"); Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/tutorial", "sa", ""); Paysment st = conn.createPaysment(); ResultSet mrs = conn.getMetaData().getTables(null, null, null, new String[] { "TABLE" }); while (mrs.next()) { String tableNom = mrs.getString(3); System.out.println(" Table Nom: "+ tableNom); ResultSet rs = st.executeQuery("select * from " + tableNom); ResultSetMetaData metadata = rs.getMetaData(); while (rs.next()) { System.out.println(" Row:"); for (int i = 0; i < metadata.getColumnCount(); i++) { System.out.println(" Column Nom: "+ metadata.getColumnLabel(i + 1)+ ", "); System.out.println(" Column Type: "+ metadata.getColumnTypeNom(i + 1)+ ": "); Object value = rs.getObject(i + 1); System.out.println(" Column Value: "+value+" "); } } } } } Fichier: Main.java import java.util.List; import javax.persistence.EntityManager; import javax.persistence.EntityManagerFactory; import javax.persistence.Persistence; import javax.persistence.Query; public class Main { public static void main(String[] a) throws Exception { JPADAO jpaDao = new JPADAO(); jpaDao.create(); jpaDao.search(); jpaDao.close(); Helper.checkData(); } } /* [java] Table Nom: STUDENT [java] Row: [java] Column Nom: ID, [java] Column Type: BIGINT: [java] Column Value: 1 [java] Column Nom: DATEOFBIRTH, [java] Column Type: TIMESTAMP: [java] Column Value: 2008-11-05 13:32:00.35 [java] Column Nom: GENDER, [java] Column Type: VARCHAR: [java] Column Value: FEMALE [java] Column Nom: NAME, [java] Column Type: VARCHAR: [java] Column Value: Joe */ Fichier: persistence.xml <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence" version="1.0"> <persistence-unit nom="JPAService" transaction-type="RESOURCE_LOCAL"> <properties> <property nom="hibernate.dialect" value="org.hibernate.dialect.DerbyDialect"/> <property nom="hibernate.hbm2ddl.auto" value="update"/> <property nom="hibernate.connection.driver_class" value="org.apache.derby.jdbc.ClientDriver"/> <property nom="hibernate.connection.usernom" value="sa"/> <property nom="hibernate.connection.password" value=""/> <property nom="hibernate.connection.url" value="jdbc:derby://localhost:1527/tutorial"/> </properties> </persistence-unit> </persistence> |
Cet article Java Persistane: Comment Modifier la clé primière. est apparu en premier sur .