오늘도 행복하다.

• Database 접속 설정하기
• 테이블 생성
• SQL 실행
• 데이터 입력하고 저장하기

• Configure default JPA implementation library
• Ganymede 에서 실행했음.
• orm.xml 은 생성되지 않도록 하자

@Entity
@Table(schema="baseball", name = "players")
public class Player implements Serializable {
	@Id
	@GeneratedValue(strategy=IDENTITY)
	private int id;

	@Column(name="First_Name")
	private String firstName;

	@Column(name="Last_Name")
	private String lastName;
        
	//setter and getter
}

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" 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_1_0.xsd">
	<persistence-unit name="baseball">
		<class>org.developerworks.baseball.Player</class>
		<properties>
			<property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost:3306/baseball"/>
			<property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/>
			<property name="openjpa.ConnectionUserName" value="team"/>
		    <property name="openjpa.ConnectionPassword" value="1234"/>
		    <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
		</properties>
	</persistence-unit>
</persistence>

EntityManagerFactory factory = Persistence.createEntityManagerFactory("baseball");
EntityManager em = factory.createEntityManager();
List<Player> players = em.createQuery("SELECT p FROM Player p").getResultList();
for(Player player : players){
	System.out.println(player.getFirstName());
}

• openjpa-1.2.1.jar : User Libraries로 추가
  
• geronimo-jpa_3.0_spec-1.0.jar : JPA 구현체
  
• geronimo-jta_1.1_spec-1.1.jar
• serp-1.13.1.jar
• commons-collections-3.2.jar
• commons-lang-2.1.jar