<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="ru">
		<id>http://jexp.ru/index.php?action=history&amp;feed=atom&amp;title=Java%2FJPA%2FDelete</id>
		<title>Java/JPA/Delete - История изменений</title>
		<link rel="self" type="application/atom+xml" href="http://jexp.ru/index.php?action=history&amp;feed=atom&amp;title=Java%2FJPA%2FDelete"/>
		<link rel="alternate" type="text/html" href="http://jexp.ru/index.php?title=Java/JPA/Delete&amp;action=history"/>
		<updated>2026-04-07T00:49:54Z</updated>
		<subtitle>История изменений этой страницы в вики</subtitle>
		<generator>MediaWiki 1.30.0</generator>

	<entry>
		<id>http://jexp.ru/index.php?title=Java/JPA/Delete&amp;diff=8945&amp;oldid=prev</id>
		<title>Admin: 1 версия</title>
		<link rel="alternate" type="text/html" href="http://jexp.ru/index.php?title=Java/JPA/Delete&amp;diff=8945&amp;oldid=prev"/>
				<updated>2010-06-01T07:21:58Z</updated>
		
		<summary type="html">&lt;p&gt;1 версия&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left&quot; data-mw=&quot;interface&quot;&gt;
				&lt;tr style=&quot;vertical-align: top;&quot; lang=&quot;ru&quot;&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;← Предыдущая&lt;/td&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;Версия 07:21, 1 июня 2010&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; style=&quot;text-align: center;&quot; lang=&quot;ru&quot;&gt;&lt;div class=&quot;mw-diff-empty&quot;&gt;(нет различий)&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://jexp.ru/index.php?title=Java/JPA/Delete&amp;diff=8944&amp;oldid=prev</id>
		<title> в 18:01, 31 мая 2010</title>
		<link rel="alternate" type="text/html" href="http://jexp.ru/index.php?title=Java/JPA/Delete&amp;diff=8944&amp;oldid=prev"/>
				<updated>2010-05-31T18:01:48Z</updated>
		
		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Новая страница&lt;/b&gt;&lt;/p&gt;&lt;div&gt;== Delete Entities ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
File: Main.java&lt;br /&gt;
import javax.persistence.EntityManager;&lt;br /&gt;
import javax.persistence.EntityManagerFactory;&lt;br /&gt;
import javax.persistence.Persistence;&lt;br /&gt;
public class Main {&lt;br /&gt;
  public static void main(String[] a) throws Exception {&lt;br /&gt;
    JPAUtil util = new JPAUtil();&lt;br /&gt;
    EntityManagerFactory emf = Persistence.createEntityManagerFactory(&amp;quot;ProfessorService&amp;quot;);&lt;br /&gt;
    EntityManager em = emf.createEntityManager();&lt;br /&gt;
    ProfessorService service = new ProfessorService(em);&lt;br /&gt;
    em.getTransaction().begin();&lt;br /&gt;
    service.removeDepartment();&lt;br /&gt;
    //service.removeDepartment2();&lt;br /&gt;
    &lt;br /&gt;
    util.checkData(&amp;quot;select * from Professor&amp;quot;);&lt;br /&gt;
    util.checkData(&amp;quot;select * from Department&amp;quot;);&lt;br /&gt;
    em.getTransaction().rumit();&lt;br /&gt;
    em.close();&lt;br /&gt;
    emf.close();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Department.java&lt;br /&gt;
&lt;br /&gt;
import java.util.ArrayList;&lt;br /&gt;
import java.util.Collection;&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.OneToMany;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Department {&lt;br /&gt;
    @Id&lt;br /&gt;
    private int id;&lt;br /&gt;
    private String name;&lt;br /&gt;
    @OneToMany(mappedBy=&amp;quot;department&amp;quot;)&lt;br /&gt;
    private Collection&amp;lt;Professor&amp;gt; employees;&lt;br /&gt;
    public Department() {&lt;br /&gt;
        employees = new ArrayList&amp;lt;Professor&amp;gt;();&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public int getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getName() {&lt;br /&gt;
        return name;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Collection&amp;lt;Professor&amp;gt; getProfessors() {&lt;br /&gt;
        return employees;&lt;br /&gt;
    }&lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return &amp;quot;Department no: &amp;quot; + getId() + &lt;br /&gt;
               &amp;quot;, name: &amp;quot; + getName();&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: JPAUtil.java&lt;br /&gt;
import java.io.Reader;&lt;br /&gt;
import java.sql.Connection;&lt;br /&gt;
import java.sql.DriverManager;&lt;br /&gt;
import java.sql.ResultSet;&lt;br /&gt;
import java.sql.ResultSetMetaData;&lt;br /&gt;
import java.sql.Statement;&lt;br /&gt;
public class JPAUtil {&lt;br /&gt;
  Statement st;&lt;br /&gt;
  &lt;br /&gt;
  public JPAUtil() throws Exception{&lt;br /&gt;
    Class.forName(&amp;quot;org.hsqldb.jdbcDriver&amp;quot;);&lt;br /&gt;
    System.out.println(&amp;quot;Driver Loaded.&amp;quot;);&lt;br /&gt;
    String url = &amp;quot;jdbc:hsqldb:data/tutorial&amp;quot;;&lt;br /&gt;
    Connection conn = DriverManager.getConnection(url, &amp;quot;sa&amp;quot;, &amp;quot;&amp;quot;);&lt;br /&gt;
    System.out.println(&amp;quot;Got Connection.&amp;quot;);&lt;br /&gt;
    st = conn.createStatement();&lt;br /&gt;
  }&lt;br /&gt;
  public void executeSQLCommand(String sql) throws Exception {&lt;br /&gt;
    st.executeUpdate(sql);&lt;br /&gt;
  }&lt;br /&gt;
  public void checkData(String sql) throws Exception {&lt;br /&gt;
    ResultSet rs = st.executeQuery(sql);&lt;br /&gt;
    ResultSetMetaData metadata = rs.getMetaData();&lt;br /&gt;
    for (int i = 0; i &amp;lt; metadata.getColumnCount(); i++) {&lt;br /&gt;
      System.out.print(&amp;quot;\t&amp;quot;+ metadata.getColumnLabel(i + 1)); &lt;br /&gt;
    }&lt;br /&gt;
    System.out.println(&amp;quot;\n----------------------------------&amp;quot;);&lt;br /&gt;
    while (rs.next()) {&lt;br /&gt;
      for (int i = 0; i &amp;lt; metadata.getColumnCount(); i++) {&lt;br /&gt;
        Object value = rs.getObject(i + 1);&lt;br /&gt;
        if (value == null) {&lt;br /&gt;
          System.out.print(&amp;quot;\t       &amp;quot;);&lt;br /&gt;
        } else {&lt;br /&gt;
          System.out.print(&amp;quot;\t&amp;quot;+value.toString().trim());&lt;br /&gt;
        }&lt;br /&gt;
      }&lt;br /&gt;
      System.out.println(&amp;quot;&amp;quot;);&lt;br /&gt;
    }&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Professor.java&lt;br /&gt;
&lt;br /&gt;
import java.util.ArrayList;&lt;br /&gt;
import java.util.Collection;&lt;br /&gt;
import java.util.Date;&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.ManyToMany;&lt;br /&gt;
import javax.persistence.ManyToOne;&lt;br /&gt;
import javax.persistence.NamedQueries;&lt;br /&gt;
import javax.persistence.NamedQuery;&lt;br /&gt;
import javax.persistence.OneToMany;&lt;br /&gt;
import javax.persistence.Temporal;&lt;br /&gt;
import javax.persistence.TemporalType;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Professor {&lt;br /&gt;
    @Id&lt;br /&gt;
    private int id;&lt;br /&gt;
    private String name;&lt;br /&gt;
    private long salary;&lt;br /&gt;
    @Temporal(TemporalType.DATE)&lt;br /&gt;
    private Date startDate;&lt;br /&gt;
    &lt;br /&gt;
    @ManyToOne&lt;br /&gt;
    private Professor manager;&lt;br /&gt;
    &lt;br /&gt;
    @OneToMany(mappedBy=&amp;quot;manager&amp;quot;)&lt;br /&gt;
    private Collection&amp;lt;Professor&amp;gt; directs;&lt;br /&gt;
    @ManyToOne&lt;br /&gt;
    private Department department;&lt;br /&gt;
    &lt;br /&gt;
    @ManyToMany &lt;br /&gt;
    private Collection&amp;lt;Project&amp;gt; projects;&lt;br /&gt;
    public Professor() {&lt;br /&gt;
        projects = new ArrayList&amp;lt;Project&amp;gt;();&lt;br /&gt;
        directs = new ArrayList&amp;lt;Professor&amp;gt;();&lt;br /&gt;
    }&lt;br /&gt;
    public int getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getName() {&lt;br /&gt;
        return name;&lt;br /&gt;
    }&lt;br /&gt;
    public long getSalary() {&lt;br /&gt;
        return salary;&lt;br /&gt;
    }&lt;br /&gt;
    public Date getStartDate() {&lt;br /&gt;
        return startDate;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Department getDepartment() {&lt;br /&gt;
        return department;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Collection&amp;lt;Professor&amp;gt; getDirects() {&lt;br /&gt;
        return directs;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Professor getManager() {&lt;br /&gt;
        return manager;&lt;br /&gt;
    }&lt;br /&gt;
    public Collection&amp;lt;Project&amp;gt; getProjects() {&lt;br /&gt;
        return projects;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return &amp;quot;Professor &amp;quot; + getId() + &lt;br /&gt;
               &amp;quot;: name: &amp;quot; + getName() +&lt;br /&gt;
               &amp;quot;, salary: &amp;quot; + getSalary() +&lt;br /&gt;
               &amp;quot;, dept: &amp;quot; + ((getDepartment() == null) ? null : getDepartment().getName());&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: ProfessorService.java&lt;br /&gt;
import java.util.List;&lt;br /&gt;
import javax.persistence.EntityManager;&lt;br /&gt;
import javax.persistence.Query;&lt;br /&gt;
public class ProfessorService {&lt;br /&gt;
  protected EntityManager em;&lt;br /&gt;
  public ProfessorService(EntityManager em) {&lt;br /&gt;
    this.em = em;&lt;br /&gt;
  }&lt;br /&gt;
  public void removeDepartment() {&lt;br /&gt;
    em.createQuery(&lt;br /&gt;
        &amp;quot;DELETE FROM Department d &amp;quot;&lt;br /&gt;
            + &amp;quot;WHERE d.name IN (&amp;quot;CA&amp;quot;, &amp;quot;NY30&amp;quot;)&amp;quot;).executeUpdate();&lt;br /&gt;
  }&lt;br /&gt;
  public void removeDepartment2() {&lt;br /&gt;
    em.createQuery(&lt;br /&gt;
        &amp;quot;UPDATE Professor e &amp;quot; +&lt;br /&gt;
        &amp;quot;SET e.department = null &amp;quot; +&lt;br /&gt;
        &amp;quot;WHERE e.department.name IN (&amp;quot;CA13&amp;quot;, &amp;quot;CA19&amp;quot;, &amp;quot;NY30&amp;quot;)&amp;quot;&lt;br /&gt;
).executeUpdate();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Project.java&lt;br /&gt;
&lt;br /&gt;
import java.util.ArrayList;&lt;br /&gt;
import java.util.Collection;&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.ManyToMany;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Project {&lt;br /&gt;
    @Id&lt;br /&gt;
    protected int id;&lt;br /&gt;
    protected String name;&lt;br /&gt;
    @ManyToMany(mappedBy=&amp;quot;projects&amp;quot;)&lt;br /&gt;
    private Collection&amp;lt;Professor&amp;gt; employees;&lt;br /&gt;
    public Project() {&lt;br /&gt;
        employees = new ArrayList&amp;lt;Professor&amp;gt;();&lt;br /&gt;
    }&lt;br /&gt;
    public int getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getName() {&lt;br /&gt;
        return name;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Collection&amp;lt;Professor&amp;gt; getProfessors() {&lt;br /&gt;
        return employees;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return &amp;quot;Project id: &amp;quot; + getId() + &amp;quot;, name: &amp;quot; + getName();&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
File: persistence.xml&lt;br /&gt;
&amp;lt;persistence xmlns=&amp;quot;http://java.sun.ru/xml/ns/persistence&amp;quot;&lt;br /&gt;
             xmlns:xsi=&amp;quot;http://www.w3.org/2001/XMLSchema-instance&amp;quot;&lt;br /&gt;
             xsi:schemaLocation=&amp;quot;http://java.sun.ru/xml/ns/persistence http://java.sun.ru/xml/ns/persistence/persistence&amp;quot; version=&amp;quot;1.0&amp;quot;&amp;gt;&lt;br /&gt;
  &amp;lt;persistence-unit name=&amp;quot;JPAService&amp;quot; transaction-type=&amp;quot;RESOURCE_LOCAL&amp;quot;&amp;gt;&lt;br /&gt;
    &amp;lt;properties&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.dialect&amp;quot; value=&amp;quot;org.hibernate.dialect.HSQLDialect&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.hbm2ddl.auto&amp;quot; value=&amp;quot;update&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.driver_class&amp;quot; value=&amp;quot;org.hsqldb.jdbcDriver&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.username&amp;quot; value=&amp;quot;sa&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.password&amp;quot; value=&amp;quot;&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.url&amp;quot; value=&amp;quot;jdbc:hsqldb:data/tutorial&amp;quot;/&amp;gt;&lt;br /&gt;
    &amp;lt;/properties&amp;gt;&lt;br /&gt;
  &amp;lt;/persistence-unit&amp;gt;&lt;br /&gt;
&amp;lt;/persistence&amp;gt;&lt;br /&gt;
&lt;br /&gt;
           &lt;br /&gt;
       &amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Delete With Condition ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
&lt;br /&gt;
File: Main.java&lt;br /&gt;
import javax.persistence.EntityManager;&lt;br /&gt;
import javax.persistence.EntityManagerFactory;&lt;br /&gt;
import javax.persistence.Persistence;&lt;br /&gt;
public class Main {&lt;br /&gt;
  public static void main(String[] a) throws Exception {&lt;br /&gt;
    JPAUtil util = new JPAUtil();&lt;br /&gt;
    EntityManagerFactory emf = Persistence.createEntityManagerFactory(&amp;quot;ProfessorService&amp;quot;);&lt;br /&gt;
    EntityManager em = emf.createEntityManager();&lt;br /&gt;
    ProfessorService service = new ProfessorService(em);&lt;br /&gt;
    em.getTransaction().begin();&lt;br /&gt;
    service.executeUpdate(&amp;quot;DELETE FROM Professor e WHERE e.department IS NULL&amp;quot;);&lt;br /&gt;
    em.getTransaction().rumit();&lt;br /&gt;
    em.close();&lt;br /&gt;
    emf.close();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Address.java&lt;br /&gt;
&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Address {&lt;br /&gt;
    @Id&lt;br /&gt;
    private int id;&lt;br /&gt;
    private String street;&lt;br /&gt;
    private String city;&lt;br /&gt;
    private String state;&lt;br /&gt;
    private String zip;&lt;br /&gt;
    &lt;br /&gt;
    public int getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setId(int id) {&lt;br /&gt;
        this.id = id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getStreet() {&lt;br /&gt;
        return street;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setStreet(String address) {&lt;br /&gt;
        this.street = address;&lt;br /&gt;
    }&lt;br /&gt;
    public String getCity() {&lt;br /&gt;
        return city;&lt;br /&gt;
    }&lt;br /&gt;
    public void setCity(String city) {&lt;br /&gt;
        this.city = city;&lt;br /&gt;
    }&lt;br /&gt;
    public String getState() {&lt;br /&gt;
        return state;&lt;br /&gt;
    }&lt;br /&gt;
    public void setState(String state) {&lt;br /&gt;
        this.state = state;&lt;br /&gt;
    }&lt;br /&gt;
    public String getZip() {&lt;br /&gt;
        return zip;&lt;br /&gt;
    }&lt;br /&gt;
    public void setZip(String zip) {&lt;br /&gt;
        this.zip = zip;&lt;br /&gt;
    }&lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return &amp;quot;Address id: &amp;quot; + getId() + &lt;br /&gt;
               &amp;quot;, street: &amp;quot; + getStreet() +&lt;br /&gt;
               &amp;quot;, city: &amp;quot; + getCity() +&lt;br /&gt;
               &amp;quot;, state: &amp;quot; + getState() +&lt;br /&gt;
               &amp;quot;, zip: &amp;quot; + getZip();&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Department.java&lt;br /&gt;
&lt;br /&gt;
import java.util.HashSet;&lt;br /&gt;
import java.util.Set;&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.OneToMany;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Department {&lt;br /&gt;
    @Id&lt;br /&gt;
    private int id;&lt;br /&gt;
    private String name;&lt;br /&gt;
    @OneToMany(mappedBy=&amp;quot;department&amp;quot;)&lt;br /&gt;
    private Set&amp;lt;Professor&amp;gt; employees = new HashSet&amp;lt;Professor&amp;gt;();&lt;br /&gt;
    public int getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setId(int deptNo) {&lt;br /&gt;
        this.id = deptNo;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getName() {&lt;br /&gt;
        return name;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setName(String deptName) {&lt;br /&gt;
        this.name = deptName;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Set&amp;lt;Professor&amp;gt; getProfessors() {&lt;br /&gt;
        return employees;&lt;br /&gt;
    }&lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return &amp;quot;Department no: &amp;quot; + getId() + &lt;br /&gt;
               &amp;quot;, name: &amp;quot; + getName();&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: JPAUtil.java&lt;br /&gt;
import java.io.Reader;&lt;br /&gt;
import java.sql.Connection;&lt;br /&gt;
import java.sql.DriverManager;&lt;br /&gt;
import java.sql.ResultSet;&lt;br /&gt;
import java.sql.ResultSetMetaData;&lt;br /&gt;
import java.sql.Statement;&lt;br /&gt;
public class JPAUtil {&lt;br /&gt;
  Statement st;&lt;br /&gt;
  &lt;br /&gt;
  public JPAUtil() throws Exception{&lt;br /&gt;
    Class.forName(&amp;quot;org.hsqldb.jdbcDriver&amp;quot;);&lt;br /&gt;
    System.out.println(&amp;quot;Driver Loaded.&amp;quot;);&lt;br /&gt;
    String url = &amp;quot;jdbc:hsqldb:data/tutorial&amp;quot;;&lt;br /&gt;
    Connection conn = DriverManager.getConnection(url, &amp;quot;sa&amp;quot;, &amp;quot;&amp;quot;);&lt;br /&gt;
    System.out.println(&amp;quot;Got Connection.&amp;quot;);&lt;br /&gt;
    st = conn.createStatement();&lt;br /&gt;
  }&lt;br /&gt;
  public void executeSQLCommand(String sql) throws Exception {&lt;br /&gt;
    st.executeUpdate(sql);&lt;br /&gt;
  }&lt;br /&gt;
  public void checkData(String sql) throws Exception {&lt;br /&gt;
    ResultSet rs = st.executeQuery(sql);&lt;br /&gt;
    ResultSetMetaData metadata = rs.getMetaData();&lt;br /&gt;
    for (int i = 0; i &amp;lt; metadata.getColumnCount(); i++) {&lt;br /&gt;
      System.out.print(&amp;quot;\t&amp;quot;+ metadata.getColumnLabel(i + 1)); &lt;br /&gt;
    }&lt;br /&gt;
    System.out.println(&amp;quot;\n----------------------------------&amp;quot;);&lt;br /&gt;
    while (rs.next()) {&lt;br /&gt;
      for (int i = 0; i &amp;lt; metadata.getColumnCount(); i++) {&lt;br /&gt;
        Object value = rs.getObject(i + 1);&lt;br /&gt;
        if (value == null) {&lt;br /&gt;
          System.out.print(&amp;quot;\t       &amp;quot;);&lt;br /&gt;
        } else {&lt;br /&gt;
          System.out.print(&amp;quot;\t&amp;quot;+value.toString().trim());&lt;br /&gt;
        }&lt;br /&gt;
      }&lt;br /&gt;
      System.out.println(&amp;quot;&amp;quot;);&lt;br /&gt;
    }&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Phone.java&lt;br /&gt;
&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.OneToOne;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Phone {&lt;br /&gt;
    @Id&lt;br /&gt;
    private long id;&lt;br /&gt;
    private String number;&lt;br /&gt;
    private String type;&lt;br /&gt;
    @OneToOne Professor employee;&lt;br /&gt;
    &lt;br /&gt;
    public long getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setId(long id) {&lt;br /&gt;
        this.id = id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getNumber() {&lt;br /&gt;
        return number;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setNumber(String phoneNo) {&lt;br /&gt;
        this.number = phoneNo;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getType() {&lt;br /&gt;
        return type;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setType(String phoneType) {&lt;br /&gt;
        this.type = phoneType;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Professor getProfessor() {&lt;br /&gt;
        return employee;&lt;br /&gt;
    }&lt;br /&gt;
    public void setProfessor(Professor employee) {&lt;br /&gt;
        this.employee = employee;&lt;br /&gt;
    }&lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return &amp;quot;Phone id: &amp;quot; + getId() + &lt;br /&gt;
               &amp;quot;, no: &amp;quot; + getNumber() +&lt;br /&gt;
               &amp;quot;, type: &amp;quot; + getType();&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Professor.java&lt;br /&gt;
import java.util.ArrayList;&lt;br /&gt;
import java.util.Collection;&lt;br /&gt;
import java.util.Date;&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.ManyToMany;&lt;br /&gt;
import javax.persistence.ManyToOne;&lt;br /&gt;
import javax.persistence.OneToMany;&lt;br /&gt;
import javax.persistence.OneToOne;&lt;br /&gt;
import javax.persistence.Temporal;&lt;br /&gt;
import javax.persistence.TemporalType;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Professor {&lt;br /&gt;
    @Id&lt;br /&gt;
    private int id;&lt;br /&gt;
    private String name;&lt;br /&gt;
    private long salary;&lt;br /&gt;
    @Temporal(TemporalType.DATE)&lt;br /&gt;
    private Date startDate;&lt;br /&gt;
    &lt;br /&gt;
    @OneToOne&lt;br /&gt;
    private Address address;&lt;br /&gt;
    &lt;br /&gt;
    @OneToMany(mappedBy=&amp;quot;employee&amp;quot;)&lt;br /&gt;
    private Collection&amp;lt;Phone&amp;gt; phones = new ArrayList&amp;lt;Phone&amp;gt;();&lt;br /&gt;
    &lt;br /&gt;
    @ManyToOne&lt;br /&gt;
    private Department department;&lt;br /&gt;
    &lt;br /&gt;
    @ManyToOne&lt;br /&gt;
    private Professor manager;&lt;br /&gt;
    &lt;br /&gt;
    @OneToMany(mappedBy=&amp;quot;manager&amp;quot;)&lt;br /&gt;
    private Collection&amp;lt;Professor&amp;gt; directs = new ArrayList&amp;lt;Professor&amp;gt;();&lt;br /&gt;
    &lt;br /&gt;
    @ManyToMany(mappedBy=&amp;quot;employees&amp;quot;)&lt;br /&gt;
    private Collection&amp;lt;Project&amp;gt; projects = new ArrayList&amp;lt;Project&amp;gt;();&lt;br /&gt;
    public int getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setId(int empNo) {&lt;br /&gt;
        this.id = empNo;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getName() {&lt;br /&gt;
        return name;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setName(String name) {&lt;br /&gt;
        this.name = name;&lt;br /&gt;
    }&lt;br /&gt;
    public long getSalary() {&lt;br /&gt;
        return salary;&lt;br /&gt;
    }&lt;br /&gt;
    public void setSalary(long salary) {&lt;br /&gt;
        this.salary = salary;&lt;br /&gt;
    }&lt;br /&gt;
    public Date getStartDate() {&lt;br /&gt;
        return startDate;&lt;br /&gt;
    }&lt;br /&gt;
    public void setStartDate(Date startDate) {&lt;br /&gt;
        this.startDate = startDate;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Collection&amp;lt;Phone&amp;gt; getPhones() {&lt;br /&gt;
        return phones;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void addPhone(Phone phone) {&lt;br /&gt;
        if (!getPhones().contains(phone)) {&lt;br /&gt;
            getPhones().add(phone);&lt;br /&gt;
            if (phone.getProfessor() != null) {&lt;br /&gt;
                phone.getProfessor().getPhones().remove(phone);&lt;br /&gt;
            }&lt;br /&gt;
            phone.setProfessor(this);&lt;br /&gt;
        }&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Department getDepartment() {&lt;br /&gt;
        return department;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setDepartment(Department department) {&lt;br /&gt;
        if (this.department != null) {&lt;br /&gt;
            this.department.getProfessors().remove(this);&lt;br /&gt;
        }&lt;br /&gt;
        this.department = department;&lt;br /&gt;
        this.department.getProfessors().add(this);&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Collection&amp;lt;Professor&amp;gt; getDirects() {&lt;br /&gt;
        return directs;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void addDirect(Professor employee) {&lt;br /&gt;
        if (!getDirects().contains(employee)) {&lt;br /&gt;
            getDirects().add(employee);&lt;br /&gt;
            if (employee.getManager() != null) {&lt;br /&gt;
                employee.getManager().getDirects().remove(employee);&lt;br /&gt;
            }&lt;br /&gt;
            employee.setManager(this);&lt;br /&gt;
        }&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Professor getManager() {&lt;br /&gt;
        return manager;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setManager(Professor manager) {&lt;br /&gt;
        this.manager = manager;&lt;br /&gt;
    }&lt;br /&gt;
    public Collection&amp;lt;Project&amp;gt; getProjects() {&lt;br /&gt;
        return projects;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void addProject(Project project) {&lt;br /&gt;
        if (!getProjects().contains(project)) {&lt;br /&gt;
            getProjects().add(project);&lt;br /&gt;
        }&lt;br /&gt;
        if (!project.getProfessors().contains(this)) {&lt;br /&gt;
            project.getProfessors().add(this);&lt;br /&gt;
        }&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Address getAddress() {&lt;br /&gt;
        return address;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setAddress(Address address) {&lt;br /&gt;
        this.address = address; &lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return &amp;quot;Professor &amp;quot; + getId() + &lt;br /&gt;
               &amp;quot;: name: &amp;quot; + getName() +&lt;br /&gt;
               &amp;quot;, salary: &amp;quot; + getSalary() +&lt;br /&gt;
               &amp;quot;, phones: &amp;quot; + getPhones() +&lt;br /&gt;
               &amp;quot;, managerNo: &amp;quot; + ((getManager() == null) ? null : getManager().getId()) +&lt;br /&gt;
               &amp;quot;, deptNo: &amp;quot; + ((getDepartment() == null) ? null : getDepartment().getId());&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: ProfessorService.java&lt;br /&gt;
import java.util.List;&lt;br /&gt;
import javax.persistence.EntityManager;&lt;br /&gt;
import javax.persistence.Query;&lt;br /&gt;
public class ProfessorService {&lt;br /&gt;
  protected EntityManager em;&lt;br /&gt;
  public ProfessorService(EntityManager em) {&lt;br /&gt;
    this.em = em;&lt;br /&gt;
  }&lt;br /&gt;
  public List executetQuery(String queryString) {&lt;br /&gt;
    Query query = em.createQuery(queryString);&lt;br /&gt;
    return query.getResultList();&lt;br /&gt;
  }&lt;br /&gt;
  public void executeUpdate(String updateString) {&lt;br /&gt;
    em.createQuery(updateString).executeUpdate();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Project.java&lt;br /&gt;
&lt;br /&gt;
import java.util.ArrayList;&lt;br /&gt;
import java.util.Collection;&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.Inheritance;&lt;br /&gt;
import javax.persistence.ManyToMany;&lt;br /&gt;
@Entity&lt;br /&gt;
@Inheritance&lt;br /&gt;
public class Project {&lt;br /&gt;
    @Id&lt;br /&gt;
    protected int id;&lt;br /&gt;
    protected String name;&lt;br /&gt;
    @ManyToMany&lt;br /&gt;
    protected Collection&amp;lt;Professor&amp;gt; employees = new ArrayList&amp;lt;Professor&amp;gt;();&lt;br /&gt;
    &lt;br /&gt;
    public int getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setId(int projectNo) {&lt;br /&gt;
        this.id = projectNo;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getName() {&lt;br /&gt;
        return name;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setName(String projectName) {&lt;br /&gt;
        this.name = projectName;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public Collection&amp;lt;Professor&amp;gt; getProfessors() {&lt;br /&gt;
        return employees;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void addProfessor(Professor employee) {&lt;br /&gt;
        if (!getProfessors().contains(employee)) {&lt;br /&gt;
            getProfessors().add(employee);&lt;br /&gt;
        }&lt;br /&gt;
        if (!employee.getProjects().contains(this)) {&lt;br /&gt;
            employee.getProjects().add(this);&lt;br /&gt;
        }&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return getClass().getName().substring(getClass().getName().lastIndexOf(&amp;quot;.&amp;quot;)+1) + &lt;br /&gt;
                &amp;quot; no: &amp;quot; + getId() + &lt;br /&gt;
                &amp;quot;, name: &amp;quot; + getName();&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
File: persistence.xml&lt;br /&gt;
&amp;lt;persistence xmlns=&amp;quot;http://java.sun.ru/xml/ns/persistence&amp;quot;&lt;br /&gt;
             xmlns:xsi=&amp;quot;http://www.w3.org/2001/XMLSchema-instance&amp;quot;&lt;br /&gt;
             xsi:schemaLocation=&amp;quot;http://java.sun.ru/xml/ns/persistence http://java.sun.ru/xml/ns/persistence/persistence&amp;quot; version=&amp;quot;1.0&amp;quot;&amp;gt;&lt;br /&gt;
  &amp;lt;persistence-unit name=&amp;quot;JPAService&amp;quot; transaction-type=&amp;quot;RESOURCE_LOCAL&amp;quot;&amp;gt;&lt;br /&gt;
    &amp;lt;properties&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.dialect&amp;quot; value=&amp;quot;org.hibernate.dialect.HSQLDialect&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.hbm2ddl.auto&amp;quot; value=&amp;quot;update&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.driver_class&amp;quot; value=&amp;quot;org.hsqldb.jdbcDriver&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.username&amp;quot; value=&amp;quot;sa&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.password&amp;quot; value=&amp;quot;&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.url&amp;quot; value=&amp;quot;jdbc:hsqldb:data/tutorial&amp;quot;/&amp;gt;&lt;br /&gt;
    &amp;lt;/properties&amp;gt;&lt;br /&gt;
  &amp;lt;/persistence-unit&amp;gt;&lt;br /&gt;
&amp;lt;/persistence&amp;gt;&lt;br /&gt;
&lt;br /&gt;
           &lt;br /&gt;
       &amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Remove An Entity ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
&lt;br /&gt;
File: Professor.java&lt;br /&gt;
&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Professor {&lt;br /&gt;
  @Id&lt;br /&gt;
  private int id;&lt;br /&gt;
  private String name;&lt;br /&gt;
  private long salary;&lt;br /&gt;
  public Professor() {&lt;br /&gt;
  }&lt;br /&gt;
  public Professor(int id) {&lt;br /&gt;
    this.id = id;&lt;br /&gt;
  }&lt;br /&gt;
  public int getId() {&lt;br /&gt;
    return id;&lt;br /&gt;
  }&lt;br /&gt;
  public void setId(int id) {&lt;br /&gt;
    this.id = id;&lt;br /&gt;
  }&lt;br /&gt;
  public String getName() {&lt;br /&gt;
    return name;&lt;br /&gt;
  }&lt;br /&gt;
  public void setName(String name) {&lt;br /&gt;
    this.name = name;&lt;br /&gt;
  }&lt;br /&gt;
  public long getSalary() {&lt;br /&gt;
    return salary;&lt;br /&gt;
  }&lt;br /&gt;
  public void setSalary(long salary) {&lt;br /&gt;
    this.salary = salary;&lt;br /&gt;
  }&lt;br /&gt;
  public String toString() {&lt;br /&gt;
    return &amp;quot;Professor id: &amp;quot; + getId() + &amp;quot; name: &amp;quot; + getName() + &amp;quot; salary: &amp;quot; + getSalary();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: ProfessorService.java&lt;br /&gt;
import java.util.Collection;&lt;br /&gt;
import javax.persistence.EntityManager;&lt;br /&gt;
import javax.persistence.Query;&lt;br /&gt;
public class ProfessorService {&lt;br /&gt;
  protected EntityManager em;&lt;br /&gt;
  public ProfessorService(EntityManager em) {&lt;br /&gt;
    this.em = em;&lt;br /&gt;
  }&lt;br /&gt;
  public Professor createProfessor(int id, String name, long salary) {&lt;br /&gt;
    Professor emp = new Professor(id);&lt;br /&gt;
    emp.setName(name);&lt;br /&gt;
    emp.setSalary(salary);&lt;br /&gt;
    em.persist(emp);&lt;br /&gt;
    return emp;&lt;br /&gt;
  }&lt;br /&gt;
  public void removeProfessor(int id) {&lt;br /&gt;
    Professor emp = findProfessor(id);&lt;br /&gt;
    if (emp != null) {&lt;br /&gt;
      em.remove(emp);&lt;br /&gt;
    }&lt;br /&gt;
  }&lt;br /&gt;
  public Professor raiseProfessorSalary(int id, long raise) {&lt;br /&gt;
    Professor emp = em.find(Professor.class, id);&lt;br /&gt;
    if (emp != null) {&lt;br /&gt;
      emp.setSalary(emp.getSalary() + raise);&lt;br /&gt;
    }&lt;br /&gt;
    return emp;&lt;br /&gt;
  }&lt;br /&gt;
  public Professor findProfessor(int id) {&lt;br /&gt;
    return em.find(Professor.class, id);&lt;br /&gt;
  }&lt;br /&gt;
  public Collection&amp;lt;Professor&amp;gt; findAllProfessors() {&lt;br /&gt;
    Query query = em.createQuery(&amp;quot;SELECT e FROM Professor e&amp;quot;);&lt;br /&gt;
    return (Collection&amp;lt;Professor&amp;gt;) query.getResultList();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: JPAUtil.java&lt;br /&gt;
import java.io.Reader;&lt;br /&gt;
import java.sql.Connection;&lt;br /&gt;
import java.sql.DriverManager;&lt;br /&gt;
import java.sql.ResultSet;&lt;br /&gt;
import java.sql.ResultSetMetaData;&lt;br /&gt;
import java.sql.Statement;&lt;br /&gt;
public class JPAUtil {&lt;br /&gt;
  Statement st;&lt;br /&gt;
  &lt;br /&gt;
  public JPAUtil() throws Exception{&lt;br /&gt;
    Class.forName(&amp;quot;org.hsqldb.jdbcDriver&amp;quot;);&lt;br /&gt;
    System.out.println(&amp;quot;Driver Loaded.&amp;quot;);&lt;br /&gt;
    String url = &amp;quot;jdbc:hsqldb:data/tutorial&amp;quot;;&lt;br /&gt;
    Connection conn = DriverManager.getConnection(url, &amp;quot;sa&amp;quot;, &amp;quot;&amp;quot;);&lt;br /&gt;
    System.out.println(&amp;quot;Got Connection.&amp;quot;);&lt;br /&gt;
    st = conn.createStatement();&lt;br /&gt;
  }&lt;br /&gt;
  public void executeSQLCommand(String sql) throws Exception {&lt;br /&gt;
    st.executeUpdate(sql);&lt;br /&gt;
  }&lt;br /&gt;
  public void checkData(String sql) throws Exception {&lt;br /&gt;
    ResultSet rs = st.executeQuery(sql);&lt;br /&gt;
    ResultSetMetaData metadata = rs.getMetaData();&lt;br /&gt;
    for (int i = 0; i &amp;lt; metadata.getColumnCount(); i++) {&lt;br /&gt;
      System.out.print(&amp;quot;\t&amp;quot;+ metadata.getColumnLabel(i + 1)); &lt;br /&gt;
    }&lt;br /&gt;
    System.out.println(&amp;quot;\n----------------------------------&amp;quot;);&lt;br /&gt;
    while (rs.next()) {&lt;br /&gt;
      for (int i = 0; i &amp;lt; metadata.getColumnCount(); i++) {&lt;br /&gt;
        Object value = rs.getObject(i + 1);&lt;br /&gt;
        if (value == null) {&lt;br /&gt;
          System.out.print(&amp;quot;\t       &amp;quot;);&lt;br /&gt;
        } else {&lt;br /&gt;
          System.out.print(&amp;quot;\t&amp;quot;+value.toString().trim());&lt;br /&gt;
        }&lt;br /&gt;
      }&lt;br /&gt;
      System.out.println(&amp;quot;&amp;quot;);&lt;br /&gt;
    }&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Main.java&lt;br /&gt;
import javax.persistence.EntityManager;&lt;br /&gt;
import javax.persistence.EntityManagerFactory;&lt;br /&gt;
import javax.persistence.Persistence;&lt;br /&gt;
public class Main {&lt;br /&gt;
  public static void main(String[] a) throws Exception {&lt;br /&gt;
    JPAUtil util = new JPAUtil();&lt;br /&gt;
    EntityManagerFactory emf = Persistence.createEntityManagerFactory(&amp;quot;ProfessorService&amp;quot;);&lt;br /&gt;
    EntityManager em = emf.createEntityManager();&lt;br /&gt;
    ProfessorService service = new ProfessorService(em);&lt;br /&gt;
    em.getTransaction().begin();&lt;br /&gt;
    Professor emp = service.createProfessor(158, &amp;quot;AAA&amp;quot;, 45000);&lt;br /&gt;
    em.getTransaction().rumit();&lt;br /&gt;
    System.out.println(&amp;quot;Persisted &amp;quot; + emp);&lt;br /&gt;
    util.checkData(&amp;quot;select * from Professor&amp;quot;);&lt;br /&gt;
    // remove an employee&lt;br /&gt;
    em.getTransaction().begin();&lt;br /&gt;
    service.removeProfessor(158);&lt;br /&gt;
    em.getTransaction().rumit();&lt;br /&gt;
    System.out.println(&amp;quot;Removed Professor 158&amp;quot;);&lt;br /&gt;
    util.checkData(&amp;quot;select * from Professor&amp;quot;);&lt;br /&gt;
    &lt;br /&gt;
    em.close();&lt;br /&gt;
    emf.close();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
File: persistence.xml&lt;br /&gt;
&amp;lt;persistence xmlns=&amp;quot;http://java.sun.ru/xml/ns/persistence&amp;quot;&lt;br /&gt;
             xmlns:xsi=&amp;quot;http://www.w3.org/2001/XMLSchema-instance&amp;quot;&lt;br /&gt;
             xsi:schemaLocation=&amp;quot;http://java.sun.ru/xml/ns/persistence http://java.sun.ru/xml/ns/persistence/persistence&amp;quot; version=&amp;quot;1.0&amp;quot;&amp;gt;&lt;br /&gt;
  &amp;lt;persistence-unit name=&amp;quot;JPAService&amp;quot; transaction-type=&amp;quot;RESOURCE_LOCAL&amp;quot;&amp;gt;&lt;br /&gt;
    &amp;lt;properties&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.dialect&amp;quot; value=&amp;quot;org.hibernate.dialect.HSQLDialect&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.hbm2ddl.auto&amp;quot; value=&amp;quot;update&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.driver_class&amp;quot; value=&amp;quot;org.hsqldb.jdbcDriver&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.username&amp;quot; value=&amp;quot;sa&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.password&amp;quot; value=&amp;quot;&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.url&amp;quot; value=&amp;quot;jdbc:hsqldb:data/tutorial&amp;quot;/&amp;gt;&lt;br /&gt;
    &amp;lt;/properties&amp;gt;&lt;br /&gt;
  &amp;lt;/persistence-unit&amp;gt;&lt;br /&gt;
&amp;lt;/persistence&amp;gt;&lt;br /&gt;
           &lt;br /&gt;
       &amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Removing With Relationships ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
&lt;br /&gt;
File: ParkingSpace.java&lt;br /&gt;
&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.OneToOne;&lt;br /&gt;
import javax.persistence.Table;&lt;br /&gt;
@Entity&lt;br /&gt;
@Table(name=&amp;quot;PARKING_SPACE&amp;quot;)&lt;br /&gt;
public class ParkingSpace {&lt;br /&gt;
    @Id&lt;br /&gt;
    private int id;&lt;br /&gt;
    private int lot;&lt;br /&gt;
    private String location;&lt;br /&gt;
    @OneToOne(mappedBy=&amp;quot;parkingSpace&amp;quot;)&lt;br /&gt;
    private Professor employee;&lt;br /&gt;
    public int getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setId(int id) {&lt;br /&gt;
        this.id = id;&lt;br /&gt;
    }&lt;br /&gt;
    public int getLot() {&lt;br /&gt;
        return lot;&lt;br /&gt;
    }&lt;br /&gt;
    public void setLot(int lot) {&lt;br /&gt;
        this.lot = lot;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getLocation() {&lt;br /&gt;
        return location;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setLocation(String deptName) {&lt;br /&gt;
        this.location = deptName;&lt;br /&gt;
    }&lt;br /&gt;
    public Professor getProfessor() {&lt;br /&gt;
        return employee;&lt;br /&gt;
    }&lt;br /&gt;
    public void setProfessor(Professor employee) {&lt;br /&gt;
        this.employee = employee;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return &amp;quot;ParkingSpace id: &amp;quot; + getId() + &amp;quot; lot: &amp;quot; + getLot() +&lt;br /&gt;
               &amp;quot;, location: &amp;quot; + getLocation();&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Professor.java&lt;br /&gt;
&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.JoinColumn;&lt;br /&gt;
import javax.persistence.OneToOne;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Professor {&lt;br /&gt;
    @Id&lt;br /&gt;
    private int id;&lt;br /&gt;
    private String name;&lt;br /&gt;
    &lt;br /&gt;
    @OneToOne &lt;br /&gt;
    @JoinColumn(name=&amp;quot;PSPACE_ID&amp;quot;) &lt;br /&gt;
    private ParkingSpace parkingSpace;&lt;br /&gt;
    public int getId() {&lt;br /&gt;
        return id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setId(int id) {&lt;br /&gt;
        this.id = id;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public String getName() {&lt;br /&gt;
        return name;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setName(String name) {&lt;br /&gt;
        this.name = name;&lt;br /&gt;
    }&lt;br /&gt;
    public ParkingSpace getParkingSpace() {&lt;br /&gt;
        return parkingSpace;&lt;br /&gt;
    }&lt;br /&gt;
    &lt;br /&gt;
    public void setParkingSpace(ParkingSpace parkingSpace) {&lt;br /&gt;
        this.parkingSpace = parkingSpace;&lt;br /&gt;
    }&lt;br /&gt;
    public String toString() {&lt;br /&gt;
        return &amp;quot;Professor id: &amp;quot; + getId() + &amp;quot; name: &amp;quot; + getName() + &lt;br /&gt;
               &amp;quot; with &amp;quot; + getParkingSpace();&lt;br /&gt;
    }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: ProfessorService.java&lt;br /&gt;
import java.util.Collection;&lt;br /&gt;
import javax.persistence.EntityManager;&lt;br /&gt;
public class ProfessorService {&lt;br /&gt;
  protected EntityManager em;&lt;br /&gt;
  public ProfessorService(EntityManager em) {&lt;br /&gt;
    this.em = em;&lt;br /&gt;
  }&lt;br /&gt;
  public void removeParkingSpace(int empId) {&lt;br /&gt;
    Professor emp = em.find(Professor.class, empId);&lt;br /&gt;
    emp.setParkingSpace(null);&lt;br /&gt;
    em.remove(emp.getParkingSpace());&lt;br /&gt;
  }&lt;br /&gt;
  public void removeParkingSpaceWithFailure(int empId) {&lt;br /&gt;
    Professor emp = em.find(Professor.class, empId);&lt;br /&gt;
    em.remove(emp.getParkingSpace());&lt;br /&gt;
  }&lt;br /&gt;
  public Collection&amp;lt;Professor&amp;gt; findAllProfessors() {&lt;br /&gt;
    return (Collection&amp;lt;Professor&amp;gt;) em.createQuery(&amp;quot;SELECT e FROM Professor e&amp;quot;).getResultList();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: JPAUtil.java&lt;br /&gt;
import java.io.Reader;&lt;br /&gt;
import java.sql.Connection;&lt;br /&gt;
import java.sql.DriverManager;&lt;br /&gt;
import java.sql.ResultSet;&lt;br /&gt;
import java.sql.ResultSetMetaData;&lt;br /&gt;
import java.sql.Statement;&lt;br /&gt;
public class JPAUtil {&lt;br /&gt;
  Statement st;&lt;br /&gt;
  &lt;br /&gt;
  public JPAUtil() throws Exception{&lt;br /&gt;
    Class.forName(&amp;quot;org.hsqldb.jdbcDriver&amp;quot;);&lt;br /&gt;
    System.out.println(&amp;quot;Driver Loaded.&amp;quot;);&lt;br /&gt;
    String url = &amp;quot;jdbc:hsqldb:data/tutorial&amp;quot;;&lt;br /&gt;
    Connection conn = DriverManager.getConnection(url, &amp;quot;sa&amp;quot;, &amp;quot;&amp;quot;);&lt;br /&gt;
    System.out.println(&amp;quot;Got Connection.&amp;quot;);&lt;br /&gt;
    st = conn.createStatement();&lt;br /&gt;
  }&lt;br /&gt;
  public void executeSQLCommand(String sql) throws Exception {&lt;br /&gt;
    st.executeUpdate(sql);&lt;br /&gt;
  }&lt;br /&gt;
  public void checkData(String sql) throws Exception {&lt;br /&gt;
    ResultSet rs = st.executeQuery(sql);&lt;br /&gt;
    ResultSetMetaData metadata = rs.getMetaData();&lt;br /&gt;
    for (int i = 0; i &amp;lt; metadata.getColumnCount(); i++) {&lt;br /&gt;
      System.out.print(&amp;quot;\t&amp;quot;+ metadata.getColumnLabel(i + 1)); &lt;br /&gt;
    }&lt;br /&gt;
    System.out.println(&amp;quot;\n----------------------------------&amp;quot;);&lt;br /&gt;
    while (rs.next()) {&lt;br /&gt;
      for (int i = 0; i &amp;lt; metadata.getColumnCount(); i++) {&lt;br /&gt;
        Object value = rs.getObject(i + 1);&lt;br /&gt;
        if (value == null) {&lt;br /&gt;
          System.out.print(&amp;quot;\t       &amp;quot;);&lt;br /&gt;
        } else {&lt;br /&gt;
          System.out.print(&amp;quot;\t&amp;quot;+value.toString().trim());&lt;br /&gt;
        }&lt;br /&gt;
      }&lt;br /&gt;
      System.out.println(&amp;quot;&amp;quot;);&lt;br /&gt;
    }&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
File: Main.java&lt;br /&gt;
import java.util.Collection;&lt;br /&gt;
import java.util.Iterator;&lt;br /&gt;
import javax.persistence.EntityManager;&lt;br /&gt;
import javax.persistence.EntityManagerFactory;&lt;br /&gt;
import javax.persistence.Persistence;&lt;br /&gt;
public class Main {&lt;br /&gt;
  public static void main(String[] a) throws Exception {&lt;br /&gt;
    JPAUtil util = new JPAUtil();&lt;br /&gt;
    EntityManagerFactory emf = Persistence.createEntityManagerFactory(&amp;quot;ProfessorService&amp;quot;);&lt;br /&gt;
    EntityManager em = emf.createEntityManager();&lt;br /&gt;
    ProfessorService service = new ProfessorService(em);&lt;br /&gt;
    em.getTransaction().begin();&lt;br /&gt;
    service.removeParkingSpace(1);&lt;br /&gt;
    service.removeParkingSpaceWithFailure(1);&lt;br /&gt;
    &lt;br /&gt;
    util.checkData(&amp;quot;select * from Professor&amp;quot;);&lt;br /&gt;
    em.getTransaction().rumit();&lt;br /&gt;
    em.close();&lt;br /&gt;
    emf.close();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
File: persistence.xml&lt;br /&gt;
&amp;lt;persistence xmlns=&amp;quot;http://java.sun.ru/xml/ns/persistence&amp;quot;&lt;br /&gt;
             xmlns:xsi=&amp;quot;http://www.w3.org/2001/XMLSchema-instance&amp;quot;&lt;br /&gt;
             xsi:schemaLocation=&amp;quot;http://java.sun.ru/xml/ns/persistence http://java.sun.ru/xml/ns/persistence/persistence&amp;quot; version=&amp;quot;1.0&amp;quot;&amp;gt;&lt;br /&gt;
  &amp;lt;persistence-unit name=&amp;quot;JPAService&amp;quot; transaction-type=&amp;quot;RESOURCE_LOCAL&amp;quot;&amp;gt;&lt;br /&gt;
    &amp;lt;properties&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.dialect&amp;quot; value=&amp;quot;org.hibernate.dialect.HSQLDialect&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.hbm2ddl.auto&amp;quot; value=&amp;quot;update&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.driver_class&amp;quot; value=&amp;quot;org.hsqldb.jdbcDriver&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.username&amp;quot; value=&amp;quot;sa&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.password&amp;quot; value=&amp;quot;&amp;quot;/&amp;gt;&lt;br /&gt;
      &amp;lt;property name=&amp;quot;hibernate.connection.url&amp;quot; value=&amp;quot;jdbc:hsqldb:data/tutorial&amp;quot;/&amp;gt;&lt;br /&gt;
    &amp;lt;/properties&amp;gt;&lt;br /&gt;
  &amp;lt;/persistence-unit&amp;gt;&lt;br /&gt;
&amp;lt;/persistence&amp;gt;&lt;br /&gt;
           &lt;br /&gt;
       &amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;/div&gt;</summary>
			</entry>

	</feed>