NetBeans Forums

FAQ

Memberlist

Profile

Two linked apps,web app to display database table

NetBeans Forums -> Java EE Users

View previous topic :: View next topic

Author

Message

ceyezumma

Joined: 02 Feb 2009
Posts: 122

Posted: Sun Mar 15, 2009 6:38 pm Post subject: Two linked apps,web app to display database table

Name:
The name of this question is: carbon_copy

[icode]
Hello and Thank you in advance for any assistance.
[/icode]

Purpose:

The purpose of this code is create a desktop app and web app. The web app has the destop apps library. Create a web page to display the content table (please find splashbookdb.sql attached).

Question:

My question concerning this code is why the data is not displaying in page. The table is linked to the db and the headers are correct in the deployment.

Functionality:

The actual functionality of this code is: the program runs but it seems the PK is not working in the content.java.
This project is modeled after the project at
Using Java Persistence API Within a Visual Web JSF Application

: http://www.netbeans.org/kb/60/web/web-jpa.html
It is almost a carbon copy of this program except for the data (As far as I can tell).

errors:

The errors related to this code is: table displays correct but no data.

Description

Code description:Content.java (Entity class)

Code:

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package musiclibrarypersistenceapp.app;

import java.io.Serializable;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

/**
*
* @author depot
*/
@Entity
@Table(name = "content")
@NamedQueries({@NamedQuery(name = "content.findAll", query = "SELECT c FROM content c"), @NamedQuery(name = "content.findById", query = "SELECT c FROM content c WHERE c.id = :id"), @NamedQuery(name = "content.findByPublisherCode", query = "SELECT c FROM content c WHERE c.publisherCode = :publisherCode"), @NamedQuery(name = "content.findByBookIsbn", query = "SELECT c FROM content c WHERE c.bookIsbn = :bookIsbn"), @NamedQuery(name = "content.findByBookTitle", query = "SELECT c FROM content c WHERE c.bookTitle = :bookTitle"), @NamedQuery(name = "content.findByArtist", query = "SELECT c FROM content c WHERE c.artist = :artist"), @NamedQuery(name = "content.findBySong", query = "SELECT c FROM content c WHERE c.song = :song"), @NamedQuery(name = "content.findByPageNum", query = "SELECT c FROM content c WHERE c.pageNum = :pageNum")})
public class Content implements Serializable {
private static final long serialVersionUID = 1L;

@Column(name = "publisher_code")
private String publisherCode;
@Column(name = "book_isbn")
private String bookIsbn;
@Column(name = "book_title")
private String bookTitle;
@Column(name = "artist")
private String artist;
@Column(name = "song")
private String song;
@Column(name = "page_num")
private Integer pageNum;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "id")
private Integer id;

public Content() {
}

public Content(Integer id) {
this.id = id;
}

public Integer getId() {
return id;
}

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

public String getPublisherCode() {
return publisherCode;
}

public void setPublisherCode(String publisherCode) {
this.publisherCode = publisherCode;
}

public String getBookIsbn() {
return bookIsbn;
}

public void setBookIsbn(String bookIsbn) {
this.bookIsbn = bookIsbn;
}

public String getBookTitle() {
return bookTitle;
}

public void setBookTitle(String bookTitle) {
this.bookTitle = bookTitle;
}

public String getArtist() {
return artist;
}

public void setArtist(String artist) {
this.artist = artist;
}

public String getSong() {
return song;
}

public void setSong(String song) {
this.song = song;
}

public Integer getPageNum() {
return pageNum;
}

public void setPageNum(Integer pageNum) {
this.pageNum = pageNum;
}

@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 Content)) {
return false;
}
Content other = (Content) 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 "musiclibrarypersistenceapp.app.Content[id=" + id + "]";
}

}

Description

Code description:MPLController.java (controller for the entity content)

Code:

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package musiclibrarypersistenceapp.app;

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

/**
*
* @author depot
*/
public class MLPController {

private EntityManagerFactory emf;

private EntityManager getEntityManager() {
if (emf == null) {
emf = Persistence.createEntityManagerFactory("MLPPU");
}
return emf.createEntityManager();
}

public Content[] getContent() {
EntityManager em = getEntityManager();
try {
javax.persistence.Query q = em.createQuery("select c from content as c");
return (Content[]) q.getResultList().toArray(new Content[0]);
} finally {
em.close();
}

}
}

Description

Code description: persistence.xml

Code:

<?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="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="MLPPU" transaction-type="RESOURCE_LOCAL">
<provider>oracle.toplink.essentials.PersistenceProvider</provider>
<class>musiclibrarypersistenceapp.app.Content</class>
<properties>
<property name="toplink.jdbc.user" value="root"/>
<property name="toplink.jdbc.password" value="ceyesuma"/>
<property name="toplink.jdbc.url" value="jdbc:mysql://localhost:3306/splashbookdb"/>
<property name="toplink.jdbc.driver" value="com.mysql.jdbc.Driver"/>
</properties>
</persistence-unit>
</persistence>

Description

Code description:sessionBean1.java

Code:

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package musiclibrarypersistenceweb.web;

import com.sun.rave.web.ui.appbase.AbstractSessionBean;
import javax.faces.FacesException;
import musiclibrarypersistenceapp.app.Content;
import musiclibrarypersistenceapp.app.MLPController;

/**
* Session scope data bean for your application. Create properties
* here to represent cached data that should be made available across
* multiple HTTP requests for an individual user.
*
* An instance of this class will be created for you automatically,
* the first time your application evaluates a value binding expression
* or method binding expression that references a managed bean using
* this class.
*
* @version SessionBean1.java
* @version Created on Mar 15, 2009, 9:37:06 AM
* @author depot
*/
public class SessionBean1 extends AbstractSessionBean {
// <editor-fold defaultstate="collapsed" desc="Managed Component Definition">

/**
* Automatically managed component initialization. WARNING:
* This method is automatically generated, so any user-specified code inserted
* here is subject to being replaced.
*/
private Content[] content;
private void _init() throws Exception {
}
// </editor-fold>
/**
* Construct a new session data bean instance.
*/

public SessionBean1() {
}

/**
* This method is called when this bean is initially added to
* session scope. Typically, this occurs as a result of evaluating
* a value binding or method binding expression, which utilizes the
* managed bean facility to instantiate this bean and store it into
* session scope.
*
* You may customize this method to initialize and cache data values
* or resources that are required for the lifetime of a particular
* user session.
*/
@Override
public void init() {
// Perform initializations inherited from our superclass
super.init();
// Perform application initialization that must complete
// *before* managed components are initialized
// TODO - add your own initialiation code here
try {
_init();
} catch (Exception e) {
log("SessionBean1 Initialization Failure", e);
throw e instanceof FacesException ? (FacesException) e : new FacesException(e);
}
updateContent();
// <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
// Initialize automatically managed components
// *Note* - this logic should NOT be modified
try {
_init();
} catch (Exception e) {
log("SessionBean1 Initialization Failure", e);
throw e instanceof FacesException ? (FacesException) e : new FacesException(e);
}

// </editor-fold>
// Perform application initialization that must complete
// *after* managed components are initialized
// TODO - add your own initialization code here
}

/**
* This method is called when the session containing it is about to be
* passivated. Typically, this occurs in a distributed servlet container
* when the session is about to be transferred to a different
* container instance, after which the <code>activate()</code> method
* will be called to indicate that the transfer is complete.
*
* You may customize this method to release references to session data
* or resources that can not be serialized with the session itself.
*/
@Override
public void passivate() {
}

/**
* This method is called when the session containing it was
* reactivated.
*
* You may customize this method to reacquire references to session
* data or resources that could not be serialized with the
* session itself.
*/
@Override
public void activate() {
}

/**
* This method is called when this bean is removed from
* session scope. Typically, this occurs as a result of
* the session timing out or being terminated by the application.
*
* You may customize this method to clean up resources allocated
* during the execution of the <code>init()</code> method, or
* at any later time during the lifetime of the application.
*/
@Override
public void destroy() {
}

/**
* Return a reference to the scoped data bean.
*
* @return reference to the scoped data bean
*/
protected ApplicationBean1 getApplicationBean1() {
return (ApplicationBean1) getBean("ApplicationBean1");
}

public Content[] getContent() {
return content;
}

public void setContent(Content[] content) {
this.content = content;
}

public Content[] updateContent() {
MLPController mLPController = new MLPController();
content = mLPController.getContent();
return content;
}
}

Thanks again.
-ceyesuma

Solution:

The solutions related to this code are

Note:

Note:

splashbookdb.zip

Description:

Download

Filename:

splashbookdb.zip

Filesize:

13.95 KB

Downloaded:

51 Time(s)

Display posts from previous:

	NetBeans Forums -> Java EE Users	All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum