Month: October 2016

Git Clone Link: https://gitlab.com/shaileshsonare/spring_helloworld.git

Step 1. Create new Project

Step 2. Name the Project and select location

Step 3. Select Server and Settings

Step 4. Select Framework to include in Project’s library and include JSTL (Java Server Pages Tag Library)

Step 5. Project Created Successfully

Step 6. Check Welcome file. This file will display on browser if we enter only Project name in url.

e.g. http://localhost:8080/ProjectName/

Step 7. This section will decide which url pattern will be consider as Spring Requests and which url is not a part of Spring Framework.

Here all *.htm (URL ending with .htm from browser) will be consider as Spring request.

Step 8. You can run normal jsp pages also from browser which will not be part of Spring framework.

Step 9. Create new jsp file as

Right Click on WebPages >> New >> Jsp File

Step 10. Run on Browser it will run as old traditional jsp project file.

To Update Record Using Hibernate Session:

Configuration cfg = new Configuration().configure("hibernate.cfg.xml"); 

StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder().applySettings(cfg.getProperties()); 

SessionFactory factory = cfg.buildSessionFactory(ssrb.build()); Session session = factory.openSession(); 

Transaction t = session.beginTransaction(); 

Users u = (Users) session.load(Users.class, 6); // load record having id 6 into u object

u.setLastName("Nitnavre"); // set column value which needs to update

System.out.println(session.save(u)); // fire update query using save function of hibernate

t.commit(); // commit the update changes to save state in database

System.out.println("Record updated successfully...");

Ref Link:

1. https://www.journaldev.com/3481/hibernate-session-merge-vs-update-save-saveorupdate-persist-example

1. model.dao.interfaces.EmployeeDAOInterface.java

package model.dao.interfaces;

import java.util.List;
import model.Employee;

/**
 *
 * @author Shailesh Sonare
 */
public interface EmployeeDAOInterface {
    public List getAllEmplyees();
}

2. model.dao.EmployeeDAO.java

package model.dao;

import java.util.Iterator;
import java.util.List;
import model.Employee;
import model.dao.interfaces.EmployeeDAOInterface;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;

/**
 *
 * @author Shailesh Sonare
 */
public class EmployeeDAO implements EmployeeDAOInterface {

    @Override
    public List getAllEmplyees() {
        Configuration cnf = new Configuration();
        cnf.configure("hibernate.cfg.xml");
        
        StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder().applySettings(cnf.getProperties());
        
        SessionFactory sf = cnf.buildSessionFactory(ssrb.build());
        Session session = sf.openSession();
        
        String hql = "FROM Employee where id = 2";
        
        List list = session.createQuery(hql).list();
        
        for(Iterator iterator = list.iterator(); iterator.hasNext();) {
            Employee e = (Employee)iterator.next();
            
            System.out.println(e.getName());
        }
        
        return list;
    }
    
}

Link to download mysql jdbc driver
http://www.java2s.com/Code/Jar/c/Downloadcommysqljdbc515jar.htm