新建jpa项目---
导入jar包:
EntityManager
persistence.xml:
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"
version="2.1">
<persistence-unit name="source" transaction-type="RESOURCE_LOCAL">
<properties>
<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
<property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/userdb"/>
<property name="hibernate.connection.username" value="root"/>
<property name="hibernate.connection.password" value="123456"/>
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.format_sql" value="true"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>
</properties>
</persistence-unit>
</persistence>
测试类:
package com.jpa.test;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.EntityTransaction;
import javax.persistence.Persistence;
import javax.persistence.Query;
import org.junit.Test;
import com.jpa.entity.RoleInfo;
public class TestJPA {
private static EntityManagerFactory entityManagerFactory;
static {
entityManagerFactory = Persistence.createEntityManagerFactory("source");
}
@Test
public void testAdd() {
EntityManager entityManager = entityManagerFactory.createEntityManager();
RoleInfo roleInfo = new RoleInfo();
roleInfo.setRoleName("李四");
EntityTransaction tx = entityManager.getTransaction();
tx.begin();
//entityManager.persist(roleInfo);
//entityManager.remove(object); //删除
//entityManager.merge(object) // 修改
tx.commit();
}
@Test
public void testQuery() {
EntityManager entityManager = entityManagerFactory.createEntityManager();
Query query = entityManager.createQuery("FROM RoleInfo");
System.out.println(query.getResultList());
}
}