CREATE TABLE "public"."firma" (
  "id" INTEGER NOT NULL,
  "isim" VARCHAR(50) NOT NULL,
  "sehir" VARCHAR(50),
  CONSTRAINT "firma_pkey" PRIMARY KEY("id")
) WITH OIDS;

<?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="xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd "/>

	<persistence-unit name="OrnekUygulamaPU" transaction-type="JTA">

		<provider>oracle.toplink.essentials.PersistenceProvider</provider>

		<jta-data-source>postgresql</jta-data-source>

		<properties>
			<property name="toplink.ddl-generation" value="create-tables"/>
		</properties>

	</persistence-unit>
</persistence>

<?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="xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd "/>

<persistence-unit name="OrnekUygulamaPU" transaction-type="RESOURCE_LOCAL">
	<provider>oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider</provider>

	<class>JPA.Firma</class>

	<properties>
		<property name="toplink.jdbc.url" value="jdbc:postgresql://localhost:5432/ornek_database"/>
		<property name="toplink.jdbc.user" value="mhy">
		<property name="toplink.jdbc.driver" value="org.postgresql.Driver">
		<property name="toplink.jdbc.password" value="123456">
	</properties>

</persistence-unit>
</persistence>

	<?xml version="1.0" encoding="UTF-8"?>

	<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd "/>

		<display-name>Struts</display-name>

		<session-config>
			</session-timeout> 30 </session-timeout>
		</session-config>

		<filter>
			<filter-name>struts2</filter-name>
			<filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-class>
		</filter>
		<filter-mapping>
			<filter-name>struts2</filter-name>
			<url-pattern>/*</url-pattern>
		</filter-mapping>
		<welcome-file-list>
			<welcome-file>index.jsp</welcome-file>
		</welcome-file-list>
	</web-app>

package src;
import com.opensymphony.xwork2.ActionSupport;
import java.util.ArrayList;
import java.util.List;

public class Firma extends ActionSupport {

    private String isim = null;
    private int id = -1;
    private String sehir = null;
    private List firma_listesi = null;
    @Override
    public String execute() throws Exception{
        try{
            FirmaBD bd = new FirmaBD();
            firma_listesi = bd.bulHepsini();
            if(firma_listesi==null)
                firma_listesi = new  ArrayList();
            return SUCCESS;
        }
        catch(Exception e){
            return ERROR;
        }
    }
    public String firmaEkle () {
        try{
            FirmaBD bd = new FirmaBD();
            bd.firmaEkle(isim, sehir);
            firma_listesi = bd.bulHepsini();
            if(firma_listesi==null)
                firma_listesi = new  ArrayList();
            return SUCCESS;
        }
        catch(Exception e){
            return ERROR;
        }
    }
    public String firmaSil () {
        try{
            FirmaBD bd = new FirmaBD();
            bd.firmaSil(id);
            firma_listesi = bd.bulHepsini();
            if(firma_listesi==null)
                firma_listesi = new  ArrayList();
            return SUCCESS;
        }
        catch(Exception e){
            return ERROR;
        }
    }      

    public String getSehir() {
        return sehir;
    }
    public void setSehir(String sehir) {
        this.sehir = sehir;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getIsim() {
        return isim;
    }
    public void setIsim(String isim) {
        this.isim = isim;
    }
    public List getFirma_listesi() {
        return firma_listesi;
    }
    public void setFirma_listesi(List firma_listesi) {
        this.firma_listesi = firma_listesi;
    } 

}

package src;
import java.util.List;
public class FirmaBD {
    public void firmaEkle(String isim,String sehir) throws Exception{
        FirmaDAO dao = new FirmaDAO( -1 , isim, sehir);
        dao.kaydet();
    }
    public void firmaSil(int id) throws Exception{
        FirmaDAO dao = new FirmaDAO(  );
        dao.sil(id);
    }

    public List bulHepsini(){
        FirmaDAO dao = new FirmaDAO(  );
        return dao.bulHepsini();
    }
}

package src;

import javax.persistence.Persistence;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.EntityTransaction;
import javax.persistence.PersistenceContext;
import javax.persistence.PersistenceUnit;
import JPA.Firma;
import java.util.ArrayList;
import java.util.List;
import javax.persistence.Query;

public class FirmaDAO {

    @PersistenceUnit
    private EntityManagerFactory emf;
    @PersistenceContext
    private EntityManager em;
    private EntityTransaction transaction;
    private String isim = null;
    private Integer id = -1;
    private String sehir = null;
    private Firma jpa_firma = null;

    public FirmaDAO() {
        emf = Persistence.createEntityManagerFactory("OrnekUygulamaPU");
        em = emf.createEntityManager();
    }

    public FirmaDAO(Firma f) {
        emf = Persistence.createEntityManagerFactory("OrnekUygulamaPU");
        em = emf.createEntityManager();
        isim = f.getIsim();
        id = f.getId();
        sehir = f.getSehir();
        jpa_firma = f;
    }

    public FirmaDAO(int _id, String _isim, String _adres) throws Exception {
        emf = Persistence.createEntityManagerFactory("OrnekUygulamaPU");
        em = emf.createEntityManager();
        isim = _isim;
        id = _id;
        sehir = _adres;
        try {
            if (id == -1) {   //eklemek icin yaratılıyorsa id biricik oldugu icin cakismayi onlememiz lazim
                Query query = getEntityManager().createQuery("select max(f.id) FROM Firma f");
                if (query.getSingleResult() == null) {
                    id = -1;
                } else {
                    id = (Integer) query.getSingleResult();
                }
                jpa_firma = new Firma(id + 1, isim);
            } else {   //diger islemler icin yaratılıyorsa
                jpa_firma = new Firma(id, isim);
            }
            jpa_firma.setSehir(sehir);

        } catch (Exception ex) {
            System.out.println(ex.getMessage());
            throw new Exception();
        }
    }

    public void baslatTransaction() {
        transaction = getEntityManager().getTransaction();
        transaction.begin();
    }

    public void bitirTransaction() {
        transaction.commit();
    }

    public void kaydet() throws Exception {
        try {
            baslatTransaction();
            if (jpa_firma != null) {
                getEntityManager().persist(jpa_firma);
            }
            bitirTransaction();

        } catch (Exception ex) {
            bitirTransaction();
            System.out.println(ex.getMessage());
            throw new Exception();
        }

    }

    public void guncelle() throws Exception {
        try {
            baslatTransaction();
            if (jpa_firma != null) {
                getEntityManager().merge(jpa_firma);
            }
            bitirTransaction();
        } catch (Exception ex) {
            bitirTransaction();
            System.out.println(ex.getMessage());
            throw new Exception();
        }
    }

    public void sil(int id) throws Exception {
        try {
            baslatTransaction();
            jpa_firma = bulIDyeGore(id);
            if (jpa_firma != null) {
                getEntityManager().remove(jpa_firma);
            }
            bitirTransaction();

        } catch (Exception ex) {
            bitirTransaction();
            System.out.println(ex.getMessage());
            throw new Exception();
        }
    }

    public Firma bulIDyeGore(int id) {
        return getEntityManager().find(Firma.class, id);
    }

    public List bulIsimeGore(String isim) {
        // NamedQuery ornegi:
        try {
            Query query = getEntityManager().createNamedQuery("Firma.findByIsim");
            query.setParameter("isim", isim);
            List gecici_list = query.getResultList();
            ArrayList sonuc_listesi = new ArrayList();
            for (int i = 0; i < gecici_list.size(); i++) {
                sonuc_listesi.add(new FirmaDAO(gecici_list.get(i)));
            }
            return sonuc_listesi;
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
            return null;
        }
    }

    public List bulHepsini() {
        //JPQL ornegi
        try {
            Query query = getEntityManager().createQuery("select f FROM Firma f");
            List gecici_list = query.getResultList();
            ArrayList sonuc_listesi = new ArrayList();
            for (int i = 0; i < gecici_list.size(); i++) {
                sonuc_listesi.add(new FirmaDAO(gecici_list.get(i)));
            }
            return sonuc_listesi;
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
            return null;
        }
    }

    @PersistenceContext
    public void setEntityManager(EntityManager em) {
        this.em = em;
    }

    @PersistenceContext
    public EntityManager getEntityManager() {
        return em;
    }

    public String getSehir() {
        return sehir;
    }

    public void setSehir(String sehir) {
        this.sehir = sehir;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getIsim() {
        return isim;
    }

    public void setIsim(String isim) {
        this.isim = isim;
    }
}

package JPA;
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

@Entity
@Table(name = "firma")
@NamedQueries({
			@NamedQuery(name = "Firma.findById", query = "SELECT f FROM Firma f WHERE f.id = :id"),
			@NamedQuery(name = "Firma.findByIsim", query = "SELECT f FROM Firma f WHERE f.isim = :isim"),
			@NamedQuery(name = "Firma.findBySehir", query = "SELECT f FROM Firma f WHERE f.sehir = :sehir")
		})
public class Firma implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Column(name = "id", nullable = false)
    private Integer id;
    @Column(name = "isim", nullable = false)
    private String isim;
    @Column(name = "sehir")
    private String sehir;

    public Firma() {
    }
    public Firma(Integer id) {
        this.id = id;
    }
    public Firma(Integer id, String isim) {
        this.id = id;
        this.isim = isim;
    }
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getIsim() {
        return isim;
    }
    public void setIsim(String isim) {
        this.isim = isim;
    }
    public String getSehir() {
        return sehir;
    }
    public void setSehir(String sehir) {
        this.sehir = sehir;
    }
    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }
    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Firma)) {
            return false;
        }
        Firma other = (Firma) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }
    @Override
    public String toString() {
        return "JPA.Firma[id=" + id + "]";
    }
}

<!DOCTYPE validators PUBLIC"!DOCTYPE validators PUBLIC "-//OpenSymphony Group//XWork Validator 1.0.2//EN"
			   "http://www.opensymphony.com/xwork/xwork-validator-1.0.2.dtd">

	<validators>
		<field name="isim">
			<field-validator type="requiredstring">
				<message>İsim kısmı boş bırakılamaz</message>
			</field-validator>
		</field>
	</validators>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>

<html>

	<head>
		<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
		<title>Firma Ekle - Listele - Sil</title>
		<link href=""rel="stylesheet"type="text/css">
		<s:head theme="xhtml">
	</head>
	<body>
	<s:form action="firmaEkle" method="POST">
		<tr>
			<td colspan="2" align="center">
			<font color="#000080"/><h2>Yeni Firma Kaydı</h2></td></font>
		</tr>
		<tr>
			<s:textfield name="isim"label="Firmanın Adı"value="""">
			<s:textfield name="sehir"label="Firmanın Bulunduğu Şehir"value="""">
		</tr>
		<s:submit value="Kaydet"/>
	</s:form>
	<s:set name="d"value="%{firma_listesi}">
	<s:if test="%{#d.size()!= 0 }"/>
		<font color="#000080"/><h1>Firma Listesi:</h1></font>
		<table width="80%"border="1"align="center">
			<tr bgcolor="#99C68E"/>
				<td><b><s:text name="Firmanın Adı"/></b></td>
				<td><b><s:text name="Firmanın Bulunduğu Şehir"/></b></td>
				<td></b><s:text name="Firmayı Sil"/></b></td>
			</tr>
			<s:iterator value="id"status="status">
				<tr bgcolor="#C3FDB8"/>
					<td><s:property value="%isim"/></td>
					<td><s:property value="%sehir"/></td>
					<s:url action="firmaSil"id="url_sil">
						<s:param name="id"value="id">
					</s:url>
					<s:a href="%{url_sil}"/>Sil</s:a>
					<s:a href="%{url_sil}"/>
				</tr>
			</s:iterator>
		</table>
	</s:if>
	<s:else>
		<font color="#000080"/>
		<font color="#000080"/><h2>Şu anda sistemde kayıtlı bir firma yoktur</h2></font>
	</s:else>
	</body>
</html>

<?xml version="1.0" encoding="UTF-8">
<!DOCTYPE struts PUBLIC"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
	<constant name="struts.enable.DynamicMethodInvocation" value="false">
	<constant name="struts.devMode" value="true">
	<package name="genel" extends="struts-default">

		<action name="girisSayfaGoster" class="src.Firma">
			  <result>/WEB-INF/jsp/islemler.jsp<result>
		</action>

		<action name="firmaEkle" class="src.Firma" method="firmaEkle">
			<result name="input">/WEB-INF/islemler.jsp</result>
			<result name="error">/WEB-INF/hata.html</result>
			<result>/WEB-INF/islemler.jsp<result>
		</action>

		<action name="firmaSil" class="src.Firma" method="firmaSil">
			<result name="error">/WEB-INF/hata.html</result>
			<result>/WEB-INF/islemler.jsp<result>
		</action>

	</package>
</struts>