`

jee6 学习笔记 4 - CRUD 3 (finally): Update and Add New

阅读更多
Add new/Update/View Details can be combined altogether into one single screen. This results in the CRUD operations to only two screens. The search screen has the "delete" action as the last column of the datatable.

Here's the updated search screen(it shows primefaces database pagination attributes: paginatorPosition="bottom" rows="5" rowsPerPageTemplate="5,10,20,50"):


Here's the Add/Update/View Details screen(it shows the Primefaces <p:calendar/> widget):


Updated source "/student/studentSearch.xhtml":
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
    xmlns:f="http://java.sun.com/jsf/core"
    xmlns:h="http://java.sun.com/jsf/html"
    xmlns:p="http://primefaces.org/ui">
    
<h:head>
  <title>student search</title>
</h:head>

<h:body>
    
  <h:form id="searchForm">
    <p:panel header="Student Search Form">
      <h:panelGrid columns="3">
       <h:outputLabel value="Name: "/>
       <h:inputText value="#{ss.nameFilter}"></h:inputText>
       <h:commandButton type="submit" 
           value="Search" 
           action="#{ss.findByName}"/>
      </h:panelGrid>
    </p:panel>
  </h:form>
	    	
  <p:panel header="Students Found: #{ss.size}">
    <h:form id="dataListForm">
     <!-- search result list -->
     <p:dataTable id="idStuDataTable" 
           var="st" value="#{ss.searchResultList}" 
           paginator="true" paginatorPosition="bottom" 
           rows="5" rowsPerPageTemplate="5,10,20,50">  
		   	
	<p:column headerText="name" sortBy="#{st.name}">  
	  <h:outputText value="#{st.name}" />  
	</p:column> 
			    
	<p:column headerText="mobile" sortBy="#{st.mobile}">  
	  <h:outputText value="#{st.mobile}" />  
	</p:column>  
			     
	<p:column headerText="created date" sortBy="#{st.created_date}">  
	<h:outputText value="#{st.created_date}">
	  <f:convertDateTime pattern="yyyy-MM-dd HH:mm:ss" timeZone="#{ss.timeZone}"/>
	</h:outputText>  
	</p:column>
			    
	<p:column headerText="action" style="width:12%">
	  <h:commandLink id="idViewDetailsButton" title="View Details"
	     value="details" action="studentDetails.xhtml"> 
	    <f:setPropertyActionListener value="#{st}" target="#{stbean.student}" />
      </h:commandLink>
		            
	  <p:spacer width="4"/>
					
	  <h:commandLink id="idDeleteButton" title="Delete Student" 
           value="delete" action="#{stbean.delete}" 
           onclick="return confirm('Are you sure to delete: #{st.name}?')">
          <f:setPropertyActionListener value="#{st}" target="#{stbean.student}" />
          <f:setPropertyActionListener value="true" target="#{ss.refresh}" />
      </h:commandLink> 
        </p:column>
      </p:dataTable>
    </h:form>
  </p:panel>
    
  <h:form id="addNewFrm">
    <h:commandButton id="newButt" value="Add New Student" action="studentDetails.xhtml"/>
  </h:form>
    
</h:body>
</html>


Updated backing bean "StudentSearch.java"
package com.jxee.action.student;

import java.io.Serializable;
import java.util.List;
import java.util.TimeZone;

import javax.ejb.EJB;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;

import org.apache.log4j.Logger;

import com.jxee.ejb.student.StudentDAO;
import com.jxee.model.student.Student;

@ManagedBean(name="ss")
@SessionScoped //@ViewScoped not working with Primefaces <p:dataTable/> sorting.
public class StudentSearch implements Serializable {

  private static final Logger log = Logger.getLogger(StudentSearch.class);
  private static final String SEARCH_PAGE = "/student/studentSearch.xhtml";
  
  private List<Student> searchResultList;
  private @EJB StudentDAO dao;

  private String nameFilter;
  private int maxRows = 50;
  
  /**
   * flag if cached result list needs reloading, after add/update/delete etc.
   * set from views: <f:setPropertyActionListener value="true" target="#{ss.refresh}" />
   */
  private boolean refresh;
    

  public boolean isRefresh() {
    return refresh;
  }

  public void setRefresh(boolean refresh) {
    log.debug("-- setting refresh: " + refresh);
    this.refresh = refresh;
  }

  public String findByName() {
    log.debug("search student by nameFilter: " + nameFilter);
    searchResultList = dao.find(this.nameFilter, maxRows);
    return SEARCH_PAGE;
  }
  
  public String getNameFilter() {
    return nameFilter;
  }

  public void setNameFilter(String afilter) {
    this.nameFilter = afilter;
  }

  public int getMaxRows() {
    return maxRows;
  }

  public void setMaxRows(int maxRows) {
    this.maxRows = maxRows;
  }

  public List<Student> getSearchResultList() {
    log.debug("--- getting search result list.... isRefresh? " + this.isRefresh());
    if(this.isRefresh()) {
      this.findByName();
      this.refresh = false;
    }
    return this.searchResultList;
  }

  public void setSearchResultList(List<Student> searchResultList) {
    this.searchResultList = searchResultList;
  }
  
  public int getSize() {
    if(this.isRefresh()) {  // in order to get the correct list size
      this.findByName();
      this.refresh = false;
    }
    int size = this.searchResultList != null ? this.searchResultList.size() : 0;
    log.debug("search result size: " + size);
    return size;
  }
  
  // use default TimeZone to display time properly
  public TimeZone getTimeZone() {
    TimeZone tz = TimeZone.getDefault();
    return tz;
  } 
}


Source "/student/studentDetails.xhmtl":
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
    xmlns:f="http://java.sun.com/jsf/core"
    xmlns:h="http://java.sun.com/jsf/html"
    xmlns:p="http://primefaces.org/ui">
    
<h:head>
	<title>save student</title>
</h:head>

<h:body>
    <h:form id="formStudent">
	<p:panel header="Student Details" style="width:50%">
	<h:panelGrid columns="3">
	  Name: <h:inputText id="sname" value="#{stbean.student.name}"/>
          <p:message for="sname"/>
	  Age: <h:inputText id="sage" value="#{stbean.student.age}"/>
          <p:message for="sage"/>
	  Mobile: <h:inputText id="smobile" value="#{stbean.student.mobile}"/>
          <p:message for="smobile"/>
	  Created Date: <p:calendar id="screateddate" 
                          pattern="yyyy-MM-dd HH:mm:ss"
                          value="#{stbean.student.created_date}"/>
                    <p:message for="screateddate"/>

	  <h:inputHidden value="#{stbean.student.id}"/>

	</h:panelGrid>
	
        <p:separator/>
			
     <h:commandButton id="saveBut" value="Save" action="#{stbean.save}">
         <f:setPropertyActionListener value="true" target="#{ss.refresh}" />
     </h:commandButton>

	<p:spacer width="10"/>

     <h:commandButton id="cancelBut" value="Cancel" 
           immediate="true" action="studentSearch.xhtml"/>
   </p:panel>
 </h:form>
</h:body>
</html>


Source backing bean "StudentBean.java":
package com.jxee.action.student;

import java.io.Serializable;

import javax.ejb.EJB;
import javax.faces.bean.ManagedBean;

import org.apache.log4j.Logger;

import com.jxee.ejb.student.StudentDAO;
import com.jxee.model.student.Student;

@ManagedBean(name="stbean")
public class StudentBean implements Serializable {

  private static final Logger log = Logger.getLogger(StudentBean.class);
  private static final String SEARCH_PAGE = "/student/studentSearch.xhtml";
  private @EJB StudentDAO dao;
  
  // property set from Primefaces single row selection
  private Student student = new Student();
  
  public Student getStudent() {
    return student;
  }

  public void setStudent(Student st) {
    this.student = st;
  }

  public String save() {
    log.debug("saving student: " + this.student);
    if(student != null ) {
      if(student.getId() != null && student.getId() > 0) {
        log.debug("updating student: " + student);
        dao.update(student);
      }
      else {
        log.debug("adding new student: " + student);
        dao.add(student);
      }
    }
    return SEARCH_PAGE;
  }
  
  public String delete() {
    if(student != null) {
      log.debug("deleting student: " + student);
      dao.delete(this.student);
    }
    return SEARCH_PAGE;
  }
  
  public String cancel() {
    return SEARCH_PAGE;
  }
}


Updated dao ejb "StudnetDAOImp.java":
package com.jxee.ejb.student;

import java.util.List;

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import org.apache.log4j.Logger;

import com.jxee.ejb.UserDAOImp;
import com.jxee.model.student.Student;

@Stateless
public class StudentDAOImp implements StudentDAO {
  
  private static final Logger log = Logger.getLogger(UserDAOImp.class);

  @PersistenceContext(unitName="punit.projee6")
  private EntityManager em;
  
  @SuppressWarnings("unchecked")
  public List<Student> find(String nameFilter, int max) {
    String pattern = nameFilter != null ? "%" + nameFilter + "%" : "%";
    String sql  = "select s from Student s where s.name like :pattern";
    Query q = em.createQuery(sql);
    q.setParameter("pattern", pattern);
    q.setFirstResult(0);
    q.setMaxResults(max);
    return q.getResultList();
  }
  
  public void add(Student stu) {
    log.debug("adding new student: " + stu);
    if(stu.getId() != null) {
      // set null to avoid exception: 
      // "org.hibernate.PersistentObjectException: detached entity passed to persist"
      stu.setId(null);
    }
    em.persist(stu);
  }
  
  public void update(Student stu) {
    log.debug("updating student: " + stu);
    em.merge(stu);
  }
  
  public void delete(Student stu) {
    Student todel = em.find(Student.class, stu.getId());
    log.debug("student loaded to delete: " + todel);
    em.remove(todel);
  }
}



Now that it has a search page, a view details/add new/update page and the delete functionality as well. This completes the CRUD experiment based on the "Student" entity in the database.

What to be noted on this experiment is that:

1. Although JSF 2.0 provides a couple of ways of binding http GET parameters, it still looks odd and unnatural if you like. In this example, i used <f:setPropertyActionListener/> to bind a reload-after-add/update/delete parameter "refresh". I'll add a new blog shortly for how JSF2.0 bind http GET parameters.

2. They said that the backing bean of the primefaces "<p:dataTable/>" should be @ViewScoped to make sorting work. My experiment is that it needs to be @SessionScoped.
  • 大小: 36.7 KB
  • 大小: 31.9 KB
分享到:
评论

相关推荐

    eclipse-jee-2023-09-R-win32-x86-64.zip

    "eclipse-jee-2023-09-R-win32-x86_64.zip" 是Eclipse针对2023年9月发布的一个更新版,专为Windows 64位操作系统设计。 在Windows系统上安装和使用Eclipse-JEE,你需要了解以下关键知识点: 1. **安装步骤**: - ...

    eclipse-jee-mars-1-win32-x86_64.7z

    eclipse-jee-mars-1-win32-x86_64.7z eclipse-jee-mars-1-win32-x86_64.zip 我打的 7z 压缩包 关于有 Alt + / 不起作用解决办法: window -&gt; General -&gt; Keys -&gt; Content Assist -&gt; Binding: 改为 Alt + / When:...

    开发工具 eclipse-jee-mars-2-win32

    开发工具 eclipse-jee-mars-2-win32开发工具 eclipse-jee-mars-2-win32开发工具 eclipse-jee-mars-2-win32开发工具 eclipse-jee-mars-2-win32开发工具 eclipse-jee-mars-2-win32开发工具 eclipse-jee-mars-2-win32...

    jee6 学习笔记 6.3 - @Asynchronous

    在Java企业版(Java EE)6中,`@Asynchronous`注解是一个非常重要的特性,它使得开发者可以方便地在应用程序中实现异步处理。这个注解是Java EE并发编程的一部分,主要应用于EJB(Enterprise JavaBeans)环境,用于...

    eclipse-jee-2018-09-win32-x86_64.zip

    标题 "eclipse-jee-2018-09-win32-x86_64.zip" 提供的信息表明这是一款针对Java企业级开发的Eclipse集成开发环境(IDE)的2018年9月版本,适用于Windows 32位操作系统、x86_64架构的计算机。Eclipse是一个开源的、跨...

    eclipse-jee-oxygen-R-win32-x86_64,集成插件

    标题中的“eclipse-jee-oxygen-R-win32-x86_64”指的是Eclipse IDE for Java EE Developers的一个特定版本,Oxygen R,适用于64位的Windows操作系统。Eclipse IDE是广受欢迎的开源集成开发环境(IDE),主要用于Java...

    eclipse-jee-oxygen-3-win32.rar

    "eclipse-jee-oxygen-3-win32.rar" 是一个针对Windows 32位系统的Eclipse版本,专为Java企业级开发(JEE)设计。这个版本是Eclipse Oxygen系列的第三个发布版,它包含了众多开发者所需的工具和特性,旨在提升开发...

    eclipse-jee-2023-09-R-linux-gtk-x86-64.tar.gz

    "eclipse-jee-2023-09-R-linux-gtk-x86_64.tar.gz" 文件是Eclipse专为Java企业版(Java EE)开发者设计的2023年9月版本,适用于64位的Linux操作系统。这个版本包含了对Java EE开发所需的全部工具和功能,如Web服务器...

    eclipse-jee-2022-06-R-win32-x86_64.zip

    在解压eclipse-jee-2022-06-R-win32-x86_64.zip后,我们会得到一个名为“eclipse”的文件夹,这个文件夹包含了整个IDE的所有组件和配置。启动Eclipse IDE,用户会看到熟悉的界面,包括工作区(Workspace)、透视图...

    eclipse-jee-2021-12-R-win32-x86_64

    eclipse-jee-2021-12-R-win32-x86_64 eclipse-jee-2021-12-R-win32-x86_64 eclipse-jee-2021-12-R-win32-x86_64

    eclipse-jee-2020-09-R-win32-x86_64.zip

    标题中的“eclipse-jee-2020-09-R-win32-x86_64.zip”指的是Eclipse IDE for Java EE Developers的2020年9月版本,适用于Windows 32位和64位系统的安装包。Eclipse是一款著名的开源集成开发环境(IDE),广泛用于...

    eclipse-jee-2021-12-R-win32-x86_64.zip

    Eclipse IDE for Enterprise Java and Web Developers (eclipse-jee-2021-12-R-win32-x86_64.zip)适用于Windwos x86_64

    eclipse-jee-2020-12-R-win32-x86_64

    《Eclipse IDE for Java开发者:深入解析eclipse-jee-2020-12-R-win32-x86_64》 Eclipse IDE,全称集成开发环境(Integrated Development Environment),是全球广泛使用的开源Java开发工具。该版本"eclipse-jee-...

    eclipse-jee-indigo-SR2-win32百度云下载:

    标题中的“eclipse-jee-indigo-SR2-win32”指的是Eclipse IDE的一个特定版本,它是专为Java EE(企业级Java)开发者设计的。Eclipse是一个开源的集成开发环境(IDE),广泛用于Java编程,它提供了丰富的工具集来支持...

    eclipse-jee-2019-09-R-win32-x86_64.txt

    根据提供的文件信息,我们可以推断出这份文档与Eclipse IDE for Java有关,特别是版本为2019-09-R的Eclipse JEE(Java EE)版本,适用于win32-x86_64操作系统。下面将围绕这些信息展开相关的知识点。 ### Eclipse ...

    eclipse-jee-mars-R-win32-x86_64位官方绿色版.zip

    Eclipse-jee-mars-R-win32-x86_64位官方绿色版.zip是一个针对Windows平台的64位版本的Eclipse集成开发环境(IDE)的压缩包,特别为Java企业级(J2EE)应用程序开发设计。该版本发布于2015年6月30日,是当时Eclipse ...

    eclipse-jee-neon-3-win32-x86_64(含常用插件)

    "eclipse-jee-neon-3-win32-x86_64"这个压缩包是针对Windows 64位系统的Eclipse版本,专为Java企业版(Java EE)开发设计。"JEE"代表Java Enterprise Edition,它包含了处理Web应用程序、分布式系统和企业级服务所需...

    eclipse-jee-2022-09-R-win32-x86-64.zip

    开始使用Eclipse JEE 2022-09 R,首先需要下载"eclipse-jee-2022-09-R-win32-x86_64.zip"压缩包,解压后运行“eclipse.exe”。初次启动,用户需要配置工作空间,选择Java开发工具,以及根据项目需求添加服务器...

    eclipse-jee-neon-1a-win_64

    eclipse-jee-neon-1a-win_64

    eclipse-jee-2022-03-R-win32-x86_64.zip

    Eclipse-jee-2022-03-R-win32-x86_64.zip是一个专为Windows 64位系统设计的压缩包,其中包含了Eclipse集成开发环境(IDE)的Java和R语言版本。这个版本的Eclipse是2022年3月发布(R版本)的,针对Java开发者以及R...

Global site tag (gtag.js) - Google Analytics