/*Prac8B:GuestBook Application Using JPA*/
/*MySQl Code*/
mysql> create database guestbookdb;
mysql> use guestbookdb;
mysql>create table guestbooktb(isbn int(3) PRIMARY KEY auto_increment,
bookname char(20),bookprice int(3),bookqty int(3));
/*index.jsp*/
<%@page contentType="text/html" pageEncoding="UTF-8"%>
Sign The Guest Book !!!
Sign The Guest Book !!!
/*GuestBook.java*/
package myApp;
import javax.persistence.*;
@Entity
@Table(name="guestbooktb")
public class GuestBook
{
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="visitorno",unique=true,updatable=false)
Integer visitorno;
@Column(name="visitorname")
String visitorname;
@Column(name="message")
String message;
@Column(name="messagedate")
String messagedate;
public GuestBook(){}
public GuestBook(Integer visitorno)
{
this.visitorno=visitorno;
}
public String getMessage()
{
return message;
}
public void setMessage(String message)
{
this.message=message;
}
public String getMessagedate()
{
return messagedate;
}
public void setMessagedate(String messagedate)
{
this.messagedate=messagedate;
}
public String getVisitorname()
{
return visitorname;
}
public void setVisitorname(String visitorname)
{
this.visitorname=visitorname;
}
public Integer getVisitorno()
{
return visitorno;
}
public void setVisitorno(Integer visitorno)
{
this.visitorno=visitorno;
}
}
/*GuestBookView.jsp*/
<%@page contentType="text/html" pageEncoding="UTF-8" import="java.util.List,
java.util.Iterator,myApp.GuestBook,javax.persistence.*"%>
<%!
EntityManagerFactory emf;
EntityManager em;
EntityTransaction tx;
Listguestbook;
%>
<%
emf=Persistence.createEntityManagerFactory("WebApplication8BPU");
em=emf.createEntityManager();
String submit=request.getParameter("btnsubmit");
if(submit!=null&&("Submit").equals(submit))
{
try
{
String guest=request.getParameter("guest");
String message=request.getParameter("message");
String messagedate=new java.util.Date().toString();
GuestBook gb=new GuestBook();
gb.setVisitorname(guest);
gb.setMessage(message);
gb.setMessagedate(messagedate);
tx=em.getTransaction();
tx.begin();
em.persist(gb);
tx.commit();
}
catch(Exception e)
{
if(tx!=null)
tx.rollback();
throw e;
}
response.sendRedirect("GuestBookView.jsp");
}
try
{
guestbook=em.createQuery("select g from GuestBook g").getResultList();
}
catch(Exception e)
{
throw e;
}
em.close();
%>
Guest Book
View the guest book
Click here to sign the guestbook.
<%
Iterator it=guestbook.iterator();
while(it.hasNext())
{
GuestBook obj=(GuestBook)it.next();
%>
<%=obj.getMessagedate()%>
<%=obj.getVisitorname()%>
<%=obj.getMessage()%>
<%
}
%>