Step 1.Database Creation
Create database Student;
Step 2.Table Creation
Create table data(sno int,name varchar(15),email varchar(15));
Step 3.Create Stored Procedure
CREATE PROCEDURE bigdata(@uid int,@uname varchar(15),@uemail varchar(15))
AS
BEGIN
SET NOCOUNT ON
insert into data values(@uid,@uname,@uemail)
SET NOCOUNT OFF
END
Step 4. Create home.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<form action="register">
S.No:<input type="text" name="sno">
Name:<input type="text" name="name">
Email:<input type="text" name="email">
<input type="submit" value="submit">
Step 5: Create hbm&cfg xml file
hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="hibernate.connection.password">Password@12345</property>
<property
name="hibernate.connection.url">jdbc:sqlserver://localhost:1433;databaseName=Student
</property>
<property name="hibernate.connection.username">sa</property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<mapping resource="regi.hbm.xml" />
</session-factory>
</hibernate-configuration>
login.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jul 19, 2016 4:39:35 PM by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
<class name="login" table="data">
<id name="sno" type="int">
<column name="sno" />
<generator class="assigned" />
</id>
<property name="name" type="java.lang.String">
<column name="name" />
</property>
<property name="email" type="java.lang.String">
<column name="email" />
</property>
</class>
</hibernate-mapping>
login.java
public class login {
private int sno;
private String name,email;
public int getSno() {
return sno;
}
public void setSno(int sno) {
this.sno = sno;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}}
register.java
import java.io.IOException;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.*;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
@WebServlet("/register")
public class register extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.getWriter().append("Served at: ").append(request.getContextPath());
String sno=request.getParameter("sno");
String name=request.getParameter("name");
String email=request.getParameter("email");
int snoo=Integer.parseInt(sno);
try
{
Configuration cfg=new Configuration();
cfg.configure("hibernate.cfg.xml");
SessionFactory ss=cfg.buildSessionFactory();
Session session=ss.openSession();
Transaction t=session.beginTransaction();
try
{
PreparedStatement st = session.connection().
prepareStatement("{callbigdata(?,?,?)}");
st.setInt(1, snoo);
st.setString(2, name);
st.setString(3, email);
st.execute();
}
catch(Exception e)
{
e.printStackTrace();
}
t.commit();
session.close();
System.out.println("Saved");
}
catch(HibernateException e)
{
System.out.println(e.getMessage());
System.out.println("ERROR");
}}}
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
<display-name>HiberDemoSP</display-name>
<servlet>
<servlet-name>register</servlet-name>
<servlet-class>register</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>register</servlet-name>
<url-pattern>/register</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>home.jsp</welcome-file>
</welcome-file-list>
</web-app>
No comments:
Post a Comment