Wed Apr 21, 2010 8:10 pm
package com.codemiles.jpa;
import java.util.Date;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Query;
/**
* @author codemiles.
*
*/
public abstract class JPAService {
private EntityManager entityManager;
/**
* @param args
*/
public void insertTopic(){
EntityManagerFactory factory = Persistence
.createEntityManagerFactory("persistenceUnitName");
entityManager = factory.createEntityManager();
entityManager.getTransaction().begin();
insertTopic(1,"Ree",new Date());
entityManager.getTransaction().commit();
entityManager.close();
factory.close();
}
/**
* @param id
* id of the new topic.
* @param title
* title of the new topic.
* @param creationDate
* creation date of the topic.
*/
public void insertTopic(int id,String title,Date creationDate){
Query query = entityManager.createNativeQuery("INSERT INTO topic (ID, TITLE,CREATION_DATE) " +
" VALUES(?,?,?)");
query.setParameter(1, id);
query.setParameter(2, title);
query.setParameter(3, creationDate);
query.executeUpdate();
}
}
package com.codemiles.jpa;
import java.util.Collection;
import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;
@Entity
@Table(name="TOPIC")
public class Topic implements java.io.Serializable{
/**
*
*/
private static final long serialVersionUID = 1L;
@Id
private int Id;
private String title;
private Date creationDate;
private Date modifedDate;
private String content;
@OneToMany(mappedBy="topic")
private Collection<Comment> comments;
public int getId() {
return Id;
}
public void setId(int id) {
Id = id;
}
@Column(name="TITLE")
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
@Temporal(TemporalType.DATE)
@Column(name="CREATION_DATE")
public Date getCreationDate() {
return creationDate;
}
public void setCreationDate(Date creationDate) {
this.creationDate = creationDate;
}
@Temporal(TemporalType.DATE)
@Column(name="MODIFED_DATE")
public Date getModifedDate() {
return modifedDate;
}
public void setModifedDate(Date modifedDate) {
this.modifedDate = modifedDate;
}
@Column(name="CONTENT")
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public void setComments(Collection<Comment> comments) {
this.comments = comments;
}
public Collection<Comment> getComments() {
return comments;
}
}
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com
Powered by phpBB © phpBB Group.