Entityクラスを使用してpre_userテーブルからpre_customer_idカラムの値をすべて取得して
String型のListに格納したいのですが、良い方法が見つかりませんでした。そもそもEntityクラスから特定カラムの値を取得してListを作成するのは難しいのでしょうか?
Java
1package registration.dao; 2 3import java.io.Closeable; 4import java.io.IOException; 5import java.util.Date; 6import java.util.List; 7 8import javax.persistence.EntityManager; 9import javax.persistence.EntityTransaction; 10import javax.persistence.Persistence; 11import javax.persistence.PersistenceException; 12import javax.persistence.TypedQuery; 13 14import registration.entity.PreUserEntity; 15import util.dao.ResourceDAO; 16 17/** 18 * 仮ユーザーテーブルにアクセスする 19 * 20 * @author user 21 * 22 */ 23public class PreUserDAO implements Closeable, ResourceDAO { 24 25 private EntityManager em = null; 26 private EntityTransaction et = null; 27 28 public PreUserDAO() { 29 em = Persistence.createEntityManagerFactory("restaurant").createEntityManager(); 30 } 31 32 public List<String> findAllPreUserId(){ 33 List<String> preUserIdList = null; 34 //pre_userテーブルのpre_user_idカラムの値をすべて取得する 35 TypedQuery<PreUserEntity> query = em.createNamedQuery("PreUser.findAllPreCostomerId", PreUserEntity.class); 36 List<PreUserEntity> entity = query.getResultList(); 37 38 //TODO Entityクラス型のListからString型のListにしたい 39 return preUserIdList; 40 41 } 42 43 @Override 44 public void close() throws IOException { 45 if (em != null) { 46 em.close(); 47 } 48 } 49}
java
1package registration.entity; 2 3import java.io.Serializable; 4import java.util.Date; 5 6import javax.persistence.Column; 7import javax.persistence.Entity; 8import javax.persistence.Id; 9import javax.persistence.NamedNativeQueries; 10import javax.persistence.NamedNativeQuery; 11import javax.persistence.NamedQuery; 12import javax.persistence.Table; 13import javax.persistence.Temporal; 14import javax.persistence.TemporalType; 15 16/** 17 * The persistent class for the pre_user database table. 18 * 19 */ 20@Entity 21@Table(name = "pre_user") 22@NamedQuery(name = "PreUser.findAll", query = "SELECT p FROM pre_user p") 23@NamedNativeQueries({ 24 @NamedNativeQuery(name = "PreUser.findAllPreCostomerId"", query = "SELECT pre_customer_id FROM pre_user", resultClass = PreUserEntity.class) }) 25 26public class PreUserEntity implements Serializable { 27 28 private static final long serialVersionUID = 1L; 29 30 @Id 31 @Column(name = "pre_customer_id") 32 private String preCustomerId; 33 34 @Column(name = "process_name") 35 private String processName; 36 37 @Column(name = "process_status") 38 private String processStatus; 39 40 @Temporal(TemporalType.TIMESTAMP) 41 @Column(name = "register_time") 42 private Date registerTime; 43 44 @Column(name = "register_user") 45 private String registerUser; 46 47 @Temporal(TemporalType.TIMESTAMP) 48 @Column(name = "update_time") 49 private Date updateTime; 50 51 @Column(name = "update_user") 52 private String updateUser; 53 54 public PreUserEntity() { 55 } 56 57 public String getPreCustomerId() { 58 return this.preCustomerId; 59 } 60 61 public void setPreCustomerId(String preCustomerId) { 62 this.preCustomerId = preCustomerId; 63 } 64 65 public String getProcessName() { 66 return this.processName; 67 } 68 69 public void setProcessName(String processName) { 70 this.processName = processName; 71 } 72 73 public String getProcessStatus() { 74 return this.processStatus; 75 } 76 77 public void setProcessStatus(String processStatus) { 78 this.processStatus = processStatus; 79 } 80 81 public Date getRegisterTime() { 82 return this.registerTime; 83 } 84 85 public void setRegisterTime(Date registerTime) { 86 this.registerTime = registerTime; 87 } 88 89 public String getRegisterUser() { 90 return this.registerUser; 91 } 92 93 public void setRegisterUser(String registerUser) { 94 this.registerUser = registerUser; 95 } 96 97 public Date getUpdateTime() { 98 return this.updateTime; 99 } 100 101 public void setUpdateTime(Date updateTime) { 102 this.updateTime = updateTime; 103 } 104 105 public String getUpdateUser() { 106 return this.updateUser; 107 } 108 109 public void setUpdateUser(String updateUser) { 110 this.updateUser = updateUser; 111 } 112}
xml
1persistence.xml 2<?xml version="1.0" encoding="UTF-8"?> 3<persistence xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" 5 version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"> 6 7 <!-- MySQL + TOMCAT--> 8 <!--<persistence-unit name="restaurant" transaction-type="RESOURCE_LOCAL">--> 9 <persistence-unit name="restaurant"> 10 <provider>org.hibernate.jpa.HibernatePersistence</provider> 11 <exclude-unlisted-classes>false</exclude-unlisted-classes> 12 <properties> 13 <!-- DAOS --> 14 <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" /> 15 <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/restaurant?useSSL=false" /> 16 <property name="javax.persistence.jdbc.user" value="administrator" /> 17 <property name="javax.persistence.jdbc.password" value="password" /> 18 <!-- Configuration--> 19 <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/> 20 <property name="hibernate.hbm2ddl.auto" value="update"/> 21 <property name="hibernate.show_sql" value="true"/> 22 <property name="hibernate.format_sql" value="true"/> 23 <property name="hibernate.archive.autodetection" value="class"/> 24 <!-- POOL 25 <property name="hibernate.c3p0.min_size" value="5"/> 26 <property name="hibernate.c3p0.max_size" value="20"/> 27 <property name="hibernate.c3p0.timeout" value="300"/> 28 <property name="hibernate.c3p0.max_statements" value="50"/> 29 <property name="hibernate.c3p0.idle_test_period" value="3000"/> 30 --> 31 </properties> 32 </persistence-unit> 33 34 <!-- JUnit MYSQL --> 35 <persistence-unit name="restaurant"> 36 <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider> 37 <properties> 38 <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/> 39 <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/> 40 <property name="hibernate.connection.release_mode" value="after_transaction"/> 41 <property name="hibernate.connection.username" value="administrator"/> 42 <property name="hibernate.connection.password" value="password"/> 43 <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/restaurant?useSSL=false"/> 44 </properties> 45 </persistence-unit> 46</persistence>
回答2件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。