原生JPA简单使用

最新推荐文章于 2023-06-07 11:02:18 发布

原创最新推荐文章于 2023-06-07 11:02:18 发布 · 517 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

Plugin-Development

本文介绍了如何使用JPA进行基本操作，包括设置`persistence.xml`配置文件，连接SQL Server数据库，以及在Util.java中创建EntityManager和执行持久化操作。还列出了所需的JPA依赖库。

1.JPA简单使用：

1.persistence.xml：

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.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_2_0.xsd">
<persistence-unit name="CT_JPA_SQLServer">
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<properties>
<property name="javax.persistence.jdbc.driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="javax.persistence.jdbc.url" value="jdbc:sqlserver://localhost:1433;databaseName=test" />
<property name="javax.persistence.jdbc.user" value="sa" />
<property name="javax.persistence.jdbc.password" value="Fnst.1234" />
</properties>
</persistence-unit>

</persistence>

2.Util.java：

package test;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.EntityTransaction;
import javax.persistence.Persistence;

public class Util {

private Util() {
}

private static EntityManagerFactory entityManagerFactory = null;
private static EntityManager entityManager = null;
private static EntityTransaction entityTransection = null;
static {
try {
entityManagerFactory = Persistence
.createEntityManagerFactory("CT_JPA_SQLServer");
System.out.println("Database is open? " + entityManagerFactory.isOpen());
entityManager = entityManagerFactory.createEntityManager();
entityTransection = entityManager.getTransaction();
System.out
.println("-----------Database connect success!----------");
} catch (Exception e) {
e.printStackTrace();
System.out.println("-----------Database connect fail!----------");
}
}

public static void doPersist(Object object, String tableName, long num) {
try {
entityTransection.begin();
entityManager.persist(object);
entityTransection.commit();
System.out.println("-----------" + num + ": Table " + tableName
+ " success!----------");
} catch (Exception e) {
e.printStackTrace();
System.out.println("-----------" + num + ": Table " + tableName
+ " fail!-----------");
}
}

public static void closeEnManAndFactory() {
if (null != entityManager) {
entityManager.close();
}
if (null != entityManagerFactory) {
entityManagerFactory.close();
}
}
}

2.JPA依赖jar包：

javax.persistence.jar

org.eclipse.persistence.asm.jar

org.eclipse.persistence.core.jar

org.eclipse.persistence.jpa.jar

标签

#jpa