Xen Virtualization on Linux and Solaris

More Toplink Named Queries (JPA) in TomCat 5.5

This post follows up:-

Toplink Named Queries (JPA) in TomCat 5.5

Create two entity beans Emp.java and Dept.java
for tables emp and dept from scott's schema.
*
First:-


package dstu.net;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.OneToOne;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.NamedQuery;
import javax.persistence.NamedQueries;
import javax.persistence.Version;
import java.sql.Date;
import javax.persistence.Table;

@Entity
@Table(name="emp")
@NamedQueries({
@NamedQuery(
name="selectEmps",
query="SELECT i FROM Emp i"
),
@NamedQuery(
name="empForDepartment",
query="SELECT o FROM Emp o WHERE o.deptno = :deptId"
) 
})



public class Emp {

@Id
protected int empno;

protected String ename;
protected String job;
protected int mgr;
protected Date hiredate;
protected long sal;
protected long comm;
protected int deptno;

public void setEmpno(int  empno) {
this.empno=empno;
}
public int getEmpno() {
return empno;
}

public void setEname(String ename) {
this.ename=ename;
}
public String  getEname() {
return ename;
}

public void setJob(String job) {
this.job=job;
}

public String  getJob() {
return job;
}

public void setMgr(int mgr) {
this.mgr=mgr;
}
public int getMgr() {
return mgr;
}

public void setHiredate(Date hiredate) {
this.hiredate=hiredate;
}
public Date getHiredate() {
return hiredate;
}

public void setSal(long sal) {
this.sal=sal;
}

public long  getSal() {
return sal;
}

public void setComm(long comm) {
this.comm=comm;
}

public long  getComm() {
return comm;
}


public void setDeptno(int deptno) {
this.deptno=deptno;
}

public int  getDeptno() {
return deptno;
 }
}

*
Second:-
*


package dstu.net;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.OneToOne;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.NamedQuery;
import javax.persistence.NamedQueries;
import javax.persistence.Version;
import java.sql.Date;
import javax.persistence.Table;

@Entity
@Table(name="dept")

@NamedQueries({
@NamedQuery(
name="deptForEmployee",
query="SELECT i FROM Dept i WHERE i.deptno = :deptId"
),

@NamedQuery(
name="selectDepts",
query="SELECT o FROM Dept o "
) })

public class Dept {

@Id
protected int deptno;
protected String dname;
protected String loc;

public void setDeptno(int  deptno) {
this.deptno=deptno;
}
public int  getDeptno() {
return deptno;
}

public void setDname(String dname) {
this.dname=dname;
}
public String  getDname() {
return dname;
}

public void setLoc(String loc) {
this.loc=loc;
}

public String  getLoc() {
return loc;
}

}

Create two JSF pages department.jsp and employee.jsp

First:-


<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<f:view>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<BODY>
<CENTER>
<TABLE BORDER=5>
  <TR><TH CLASS="TITLE">TOPLINK NAMED QUERY</TH></TR>
</TABLE>
<H3>Displaying Dept table from scott's schema</H3>
<h:form>
<h:dataTable value="#{dataBean.depts}"
             var="rowVar"
             border="1">
  <h:column>
    <h:outputText value="#{rowVar.deptno}"/>
   <f:facet name="header">
        <h:outputText value="Depatment"/>
   </f:facet>
  </h:column>
  <h:column>
    <h:outputText value="#{rowVar.dname}"/>
   <f:facet name="header">
        <h:outputText value="Department name"/>
    </f:facet>
  </h:column>
  <h:column>
    <h:outputText value="#{rowVar.loc}"/>
  <f:facet name="header">
        <h:outputText value="Location"/>
  </f:facet>
  </h:column>
   <h:column>
      <f:facet name="header">
      <h:outputText value="Select"/>
      </f:facet>
      <h:commandButton value="employee"
                       type="submit"
                       actionListener="#{dataBean.empSelected}"
                       action="toEmp">
          <f:facet name="extraParameter">
          <f:param name="commandButtonParam"
                 value="#{rowVar.deptno}"/>
      </f:facet>
      </h:commandButton>
    </h:column>
</h:dataTable>
</h:form>
</CENTER></BODY></HTML>
</f:view>

*
Second:-
*


<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<f:view>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<BODY>
<CENTER>
<TABLE BORDER=5>
  <TR><TH CLASS="TITLE">TOPLINK NAMED QUERY</TH></TR>
</TABLE>
<H3>Displaying Emp's  table records of employees from department selected on previous page</H3>
<h:dataTable value="#{dataBean.empForDept}"
             var="rowVar"
             border="1">
  <h:column>
    <h:outputText value="#{rowVar.empno}"/>
   <f:facet name="header">
        <h:outputText value="Number"/>
  </f:facet>
  </h:column>
  <h:column>
    <h:outputText value="#{rowVar.ename}"/>
   <f:facet name="header">
        <h:outputText value="Last Name"/>
    </f:facet>
  </h:column>
  <h:column>
    <f:verbatim>$</f:verbatim>
    <h:outputText value="#{rowVar.sal}"/>
  <f:facet name="header">
        <h:outputText value="Salary"/>
  </f:facet>
  </h:column>
   <h:column>
    <h:outputText value="#{rowVar.hiredate}"/>
  <f:facet name="header">
        <h:outputText value="Date of hiring"/>
  </f:facet>
  </h:column>
  <h:column>
    <h:outputText value="#{rowVar.deptno}"/>
  <f:facet name="header">
        <h:outputText value="Department"/>
  </f:facet>
  </h:column>
</h:dataTable>
</CENTER></BODY></HTML>
</f:view>

Now DataBean.java has to handle events:-


package dstu.net;


import javax.persistence.*;
import java.sql.*;
import javax.sql.*;
import java.util.*;
import javax.faces.application.FacesMessage;
import javax.faces.context.FacesContext;
import javax.faces.component.UIParameter;
import javax.faces.event.ActionEvent;
import java.util.Collection;
import javax.persistence.Query;

import dstu.net.Emp;
import dstu.net.Dept;

public class DataBean {

protected int departId;

public DataBean() {}

public dstu.net.Emp[] getEmps(){
  EntityManagerFactory emf = Persistence.createEntityManagerFactory("default");
  EntityManager  em = emf.createEntityManager();
  try {
  Collection tempCollection  = 
           em.createNamedQuery("selectEmps").getResultList();
  return(tempCollection.toArray(new dstu.net.Emp[tempCollection.size()]));
  } finally { em.close();}
}


public dstu.net.Dept[] getDepts(){
  EntityManagerFactory emf = Persistence.createEntityManagerFactory("default");
  EntityManager  em = emf.createEntityManager();
  try {
  Collection tempCollection  =
           em.createNamedQuery("selectDepts").getResultList();
  return(tempCollection.toArray(new dstu.net.Dept[tempCollection.size()]));
  } finally { em.close();}
}

public void empSelected(ActionEvent actionEvent) {
// Look for directive: actionListener="#{dataBean.empSelected}"
// in department.jsp 
this.departId =
((Integer)((UIParameter)actionEvent.getComponent().getFacet("extraParameter")).getValue()).intValue();
}

public dstu.net.Emp[] getEmpForDept(){
     Collection tempCollection = getEmpForDepartment(this.departId);
     return tempCollection.toArray(new dstu.net.Emp[tempCollection.size()]);
}

public Collection getEmpForDepartment(int deptId){
  EntityManagerFactory emf = Persistence.createEntityManagerFactory("default");
  EntityManager  em = emf.createEntityManager();
try{
       Query query = em.createNamedQuery("empForDepartment");
       query.setParameter("deptId", deptId);
       return query.getResultList();
     } finally { em.close();}
}

public void setDepartId(int departId) {
  this.departId = departId;
}

public int  getDepartId() {
        return departId;
}

}

File WEB-INF/faces-config.xml


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

<!DOCTYPE faces-config PUBLIC
  "-//Sun Microsystems, Inc.//DTD JavaServer Faces Config 1.1//EN"
  "http://java.sun.com/dtd/web-facesconfig_1_1.dtd">

<faces-config>
 <managed-bean>
    <managed-bean-name>dataBean</managed-bean-name>
    <managed-bean-class>
      dstu.net.DataBean
    </managed-bean-class>
    <managed-bean-scope>session</managed-bean-scope>
  </managed-bean>
 <navigation-rule>
      <from-view-id>/department.jsp</from-view-id>
      <navigation-case>
         <from-outcome>toEmp</from-outcome>
         <to-view-id>/employee.jsp</to-view-id>
      </navigation-case>
   </navigation-rule>
</faces-config>

File WEB-INF/classes/META-INF/persistence.xml


<persistence 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 persistence_1_0.xsd" version="1.0">
 <persistence-unit name="default" transaction-type="RESOURCE_LOCAL">
   <provider>
     oracle.toplink.essentials.PersistenceProvider
   </provider>
   <class>dstu.net.Emp</class>
   <class>dstu.net.Dept</class>
   <properties>
    <property name="toplink.logging.level" value="FINE"/>
    <property name="toplink.jdbc.driver" value="oracle.jdbc.OracleDriver"/>
    <property name="toplink.jdbc.url" value="jdbc:oracle:thin:@192.168.0.100:1522:jdevdbs"/>
    <property name="toplink.jdbc.password" value="tiger"/> 
    <property name="toplink.jdbc.user" value="scott"/> 
  </properties>
 </persistence-unit>
</persistence>

Xen Virtualization on Linux and Solaris

Friday, October 27, 2006

More Toplink Named Queries (JPA) in TomCat 5.5

This post follows up:-

Create two entity beans Emp.java and Dept.java
for tables emp and dept from scott's schema.
*
First:-

*
Second:-
*

Create two JSF pages department.jsp and employee.jsp

First:-

*
Second:-
*

Now DataBean.java has to handle events:-

File WEB-INF/faces-config.xml

File WEB-INF/classes/META-INF/persistence.xml

Web Application files layout:-

Runtime snapshots:-

About Me

Blog Archive

Friday, October 27, 2006

More Toplink Named Queries (JPA) in TomCat 5.5

This post follows up:-

****************************************************Create two entity beans Emp.java and Dept.javafor tables emp and dept from scott's schema.*****************************************************First:-

*********Second:-*********

************************************************************Create two JSF pages department.jsp and employee.jsp************************************************************First:-

*********Second:-*********

********************************************Now DataBean.java has to handle events:-********************************************

**********************************File WEB-INF/faces-config.xml**********************************

******************************************************File WEB-INF/classes/META-INF/persistence.xml******************************************************

Web Application files layout:-

Runtime snapshots:-

Create two entity beans Emp.java and Dept.java
for tables emp and dept from scott's schema.
*
First:-

*
Second:-
*

Create two JSF pages department.jsp and employee.jsp

First:-

*
Second:-
*

Now DataBean.java has to handle events:-

File WEB-INF/faces-config.xml

File WEB-INF/classes/META-INF/persistence.xml