CRUD Operation in Hibernate Example2:-
package scs;
import java.util.Iterator;
import java.util.List;
import java.util.Scanner;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
public class HiberStandard {
static Configuration cfg;
static SessionFactory sf;
static Scanner sc = new Scanner(System.in);
public static void connnection()
{
cfg = new Configuration();
cfg.configure("hibernate.cfg.xml");
sf = cfg.buildSessionFactory();
}
public static boolean checkLogin()
{
System.out.println("Admin Login Here");
System.out.println("Enter Username");
String uname = sc.next();
System.out.println("Enter Password");
String pass = sc.next();
Session ses = sf.openSession();
// Query q = ses.createQuery("from Admin obj where obj.username=:a and obj.password=:b");
//q.setString("a", uname);
//q.setString("b",pass);
Query q = ses.createQuery("from Admin obj where obj.username=? and obj.password=?");
q.setString(0, uname);
q.setString(1,pass);
List lst = q.list();
if(lst.size()>0)
{
return true;
}
else
return false;
}
public static void addEmp()
{
Session ses = sf.openSession();
Empolyee obj = new Empolyee();
Scanner sc = new Scanner(System.in);
System.out.println("Enter id for insertion ");
int id=sc.nextInt();
System.out.println("Enter name for insertion ");
String sname=sc.next();
obj.setEmpid(id);
obj.setEmpname(sname);
Object o = ses.get(Empolyee.class, id);
if(o!=null)
{
System.out.println("Already exist");
}
else
{
Transaction tx = ses.beginTransaction();
ses.save(obj);
tx.commit();
ses.close();
}
}
public static void updateEmp()
{
Session s = sf.openSession();
Empolyee obj = new Empolyee();
Transaction tx = s.beginTransaction();
System.out.println("Enter id for updation ");
int id=sc.nextInt();
System.out.println("Enter name for updation ");
String sname=sc.next();
obj.setEmpid(id);
obj.setEmpname(sname);
s.update(obj);
tx.commit();
s.close();
}
public static void deleteEmp()
{
Session ses = sf.openSession();
Empolyee obj = new Empolyee();
Transaction tx = ses.beginTransaction();
Scanner sc = new Scanner(System.in);
System.out.println("Enter id for Deletion ");
int id=sc.nextInt();
Object o = ses.get(Empolyee.class, id);
Empolyee emp = (Empolyee)o;
ses.delete(emp);
tx.commit();
ses.close();
}
public static void showEmp()
{
Session ses = sf.openSession();
Query q = ses.createQuery("from Empolyee e");
List lst = q.list();
Iterator it = lst.iterator();
while(it.hasNext())
{
Empolyee obj = (Empolyee)it.next();
System.out.println(obj.getEmpid()+" ,"+obj.getEmpname());
}
ses.close();
}
public static void main(String args[])
{
connnection();
if(checkLogin())
{
while(true)
{
System.out.println("Press 1 for Add Emp");
System.out.println("Press 2 for Update Emp");
System.out.println("Press 3 for Delete Emp");
System.out.println("Press 4 for Show Emp");
System.out.println("Press 5 for Exit Emp");
int a = sc.nextInt();
switch(a)
{
case 1:
addEmp();
break;
case 2:
updateEmp();
break;
case 3:
deleteEmp();
break;
case 4:
showEmp();
break;
case 5:
System.exit(0);
}
}
}
else
{
System.out.println("Invalid userid and password");
}
}
}
import java.util.Iterator;
import java.util.List;
import java.util.Scanner;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
public class HiberStandard {
static Configuration cfg;
static SessionFactory sf;
static Scanner sc = new Scanner(System.in);
public static void connnection()
{
cfg = new Configuration();
cfg.configure("hibernate.cfg.xml");
sf = cfg.buildSessionFactory();
}
public static boolean checkLogin()
{
System.out.println("Admin Login Here");
System.out.println("Enter Username");
String uname = sc.next();
System.out.println("Enter Password");
String pass = sc.next();
Session ses = sf.openSession();
// Query q = ses.createQuery("from Admin obj where obj.username=:a and obj.password=:b");
//q.setString("a", uname);
//q.setString("b",pass);
Query q = ses.createQuery("from Admin obj where obj.username=? and obj.password=?");
q.setString(0, uname);
q.setString(1,pass);
List lst = q.list();
if(lst.size()>0)
{
return true;
}
else
return false;
}
public static void addEmp()
{
Session ses = sf.openSession();
Empolyee obj = new Empolyee();
Scanner sc = new Scanner(System.in);
System.out.println("Enter id for insertion ");
int id=sc.nextInt();
System.out.println("Enter name for insertion ");
String sname=sc.next();
obj.setEmpid(id);
obj.setEmpname(sname);
Object o = ses.get(Empolyee.class, id);
if(o!=null)
{
System.out.println("Already exist");
}
else
{
Transaction tx = ses.beginTransaction();
ses.save(obj);
tx.commit();
ses.close();
}
}
public static void updateEmp()
{
Session s = sf.openSession();
Empolyee obj = new Empolyee();
Transaction tx = s.beginTransaction();
System.out.println("Enter id for updation ");
int id=sc.nextInt();
System.out.println("Enter name for updation ");
String sname=sc.next();
obj.setEmpid(id);
obj.setEmpname(sname);
s.update(obj);
tx.commit();
s.close();
}
public static void deleteEmp()
{
Session ses = sf.openSession();
Empolyee obj = new Empolyee();
Transaction tx = ses.beginTransaction();
Scanner sc = new Scanner(System.in);
System.out.println("Enter id for Deletion ");
int id=sc.nextInt();
Object o = ses.get(Empolyee.class, id);
Empolyee emp = (Empolyee)o;
ses.delete(emp);
tx.commit();
ses.close();
}
public static void showEmp()
{
Session ses = sf.openSession();
Query q = ses.createQuery("from Empolyee e");
List lst = q.list();
Iterator it = lst.iterator();
while(it.hasNext())
{
Empolyee obj = (Empolyee)it.next();
System.out.println(obj.getEmpid()+" ,"+obj.getEmpname());
}
ses.close();
}
public static void main(String args[])
{
connnection();
if(checkLogin())
{
while(true)
{
System.out.println("Press 1 for Add Emp");
System.out.println("Press 2 for Update Emp");
System.out.println("Press 3 for Delete Emp");
System.out.println("Press 4 for Show Emp");
System.out.println("Press 5 for Exit Emp");
int a = sc.nextInt();
switch(a)
{
case 1:
addEmp();
break;
case 2:
updateEmp();
break;
case 3:
deleteEmp();
break;
case 4:
showEmp();
break;
case 5:
System.exit(0);
}
}
}
else
{
System.out.println("Invalid userid and password");
}
}
}
Post a Comment
POST Answer of Questions and ASK to Doubt