CRUD OPERATION in Hibernate Example2

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");
}
 }
 
}