I have changed the console application to serverside programming using servlets.
I have written hiberservlet.html and placed it in hiber context,placed player.class,hiberservlet.class,player.hbm.xml,hibernate.cfg.xml in WEB-INF(classes folder),all the jar files in the lib folder,web.xml and tried to run the hiberservlet.html in tomcat server(
http://localhost:8080/hiber/hiberservlet.html) it's not working.
Please can anybody solve it.
hiber/hiberservlet.html
<html>
<body bgcolor="pink">
<form method=post
action="http://localhost:8080/hiber/hiberservlet">
Name :
<input type=text name="text1"> <br><br>
Place :
<input type=text name="text2"> <br><br>
Key ( for remove and find) :
<input type=text name="text3"> <br><br>
Operation :
<select name="combo1" >
<option value="add">Add
<option value="remove">Remove
<option value="find">Find
<option value="showall">Show All
</select> <br><br>
<input type=submit>
</form>
</body>
</html>
player.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate-mapping DTD 3.2//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.2 dtd">
<hibernate-mapping>
<class name="player"
table="playertable">
<id name="id" type="int" column="ID"
unsaved-value="0">
<generator class="increment"/>
</id>
<property name="name" type="string">
<column name="name"/>
</property>
<property name="place" type="string">
<column name="place"/>
</property>
</class>
</hibernate-mapping>
hibernate.cfg.xml
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate Configuration DTD 3.2//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.2 dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost/hiberdemo</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password"></property>
<property name="hibernate.connection.pool_size">10</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.MYSQLDialect</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<mapping resource="player.hbm.xml"/>
</session-factory>
</hibernate-configuration>
hiberservlet.java
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import org.hibernate.*;
import org.hibernate.cfg.*;
public class hiberservlet
extends HttpServlet
{
SessionFactory factory=null;
public void init()
{
try
{
Configuration cfg =
new Configuration();
cfg.addClass(player.class);
factory = cfg.buildSessionFactory();
System.out.println("factory ready");
}
catch(Exception e1)
{ System.out.println(""+e1);}
}
//====================================
public void doPost
(HttpServletRequest req,
HttpServletResponse res)
throws
ServletException,IOException
{
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String a = req.getParameter("text1");
String b = req.getParameter("text2");
String c = req.getParameter("text3");
String s = req.getParameter("combo1");
DataInputStream dis=new DataInputStream(System.in);
Transaction tx = null;
if(s.equals("add"))
{
try
{
Session session = factory.openSession();
tx = session.beginTransaction();
player player1 = new player(a,b);
session.save(player1);
tx.commit();
session.flush();
session.close();
out.println("added");
}
catch(Exception e1)
{System.out.println(""+e1);}
}
//---------------------------------------
if(s.equals("remove"))
{
try
{
System.out.println("What key? ");
a = dis.readLine();
Session session = factory.openSession();
tx = session.beginTransaction();
int i = Integer.parseInt(a);
player player1 = (player)
session.get(player.class,new Integer(i));
session.delete(player1);
tx.commit();
session.flush();
session.close();
System.out.println("removed");
}catch(Exception e1)
{System.out.println(""+e1);}
}
//--------------------------------------
/*if(s.equals("showall"))
{
try
{
Session session = factory.openSession();
tx = session.beginTransaction();
java.util.List list1=
session.find("from player");
Iterator i=list1.iterator();
while(i.hasNext())
{
player player1 = (player)i.next();
System.out.println(player1.getId());
System.out.println(player1.getName());
System.out.println(player1.getPlace());
System.out.println("---------------");
}
tx.commit();
session.flush();
session.close();
}catch(Exception e1)
{System.out.println(""+e1);}
} */
if(s.equals("find"))
{
try
{
System.out.println("What key ");
a = dis.readLine();
Session session = factory.openSession();
tx = session.beginTransaction();
int i=Integer.parseInt(a);
player player1 = (player)
session.get(player.class,new Integer(i));
String n=player1.getName();
String m=player1.getPlace();
System.out.println(n+"\t"+m);
tx.commit();
session.flush();
session.close();
}catch(Exception e1)
{System.out.println(""+e1);}
}
}
}
Login
FAQ
Search