You
can write any number of named native queries for an entity by placing them in “@NamedNativeQueries”
annotation.
@Entity(name="employee_details") @NamedNativeQueries({ @NamedNativeQuery(name="Employee.getById", query="select * from employee_details where id=?", resultClass=Employee.class), @NamedNativeQuery(name="Employee.getByFirstName", query="select * from employee_details where firstName=?", resultClass=Employee.class), @NamedNativeQuery(name="Employee.getByLastName", query="select * from employee_details where lastName=?", resultClass=Employee.class) }) public class Employee { }
package myFirstHibernate; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.NamedNativeQueries; import javax.persistence.NamedNativeQuery; @Entity(name="employee_details") @NamedNativeQueries({ @NamedNativeQuery(name="Employee.getById", query="select * from employee_details where id=?", resultClass=Employee.class), @NamedNativeQuery(name="Employee.getByFirstName", query="select * from employee_details where firstName=?", resultClass=Employee.class), @NamedNativeQuery(name="Employee.getByLastName", query="select * from employee_details where lastName=?", resultClass=Employee.class) }) public class Employee { @Id @GeneratedValue private int id; private String firstName; private String lastName; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getFirstName() { return firstName; } public void setFirstName(String firstName) { this.firstName = firstName; } public String getLastName() { return lastName; } public void setLastName(String lastName) { this.lastName = lastName; } }
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> <!-- Database Connection settings --> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="connection.url">jdbc:mysql://localhost/sample</property> <property name="connection.username">root</property> <property name="connection.password">tiger</property> <!-- Enable the logging of all the generated SQL statements to the console --> <property name="show_sql">true</property> <!-- Format the generated SQL statement to make it more readable, --> <property name="format_sql">false</property> <!-- Hibernate will put comments inside all generated SQL statements to hint what’s the generated SQL trying to do --> <property name="use_sql_comments">false</property> <!-- This property makes Hibernate generate the appropriate SQL for the chosen database. --> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <!-- Drop and re-create the database schema on startup --> <property name="hbm2ddl.auto">create</property> <!-- mappings for annotated classes --> <mapping class="myFirstHibernate.Employee" /> </session-factory> </hibernate-configuration>
package myFirstHibernate; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.boot.registry.StandardServiceRegistryBuilder; import org.hibernate.cfg.Configuration; public class TestEmployee { /* Step 1: Create session factory */ private static SessionFactory getSessionFactory() { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder(). applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); return factory; } public static void main(String args[])throws Exception{ Employee emp1 = new Employee(); Employee emp2 = new Employee(); Employee emp3 = new Employee(); Employee emp4 = new Employee(); Employee emp5 = new Employee(); Employee emp6 = new Employee(); Employee emp7 = new Employee(); Employee emp8 = new Employee(); emp1.setFirstName("Hari Krishna"); emp1.setLastName("Gurram"); emp2.setFirstName("Shreyas"); emp2.setLastName("Desai"); emp3.setFirstName("Piyush"); emp3.setLastName("Rai"); emp4.setFirstName("Rama Krishna"); emp4.setLastName("Gurram"); emp5.setFirstName("Sailaja"); emp5.setLastName("Navakotla"); emp6.setFirstName("Keerthi"); emp6.setLastName("Parush"); emp7.setFirstName("Gopi"); emp7.setLastName("Battu"); emp8.setFirstName("Jaideep"); emp8.setLastName("Gera"); SessionFactory sessionFactory = getSessionFactory(); Session session = sessionFactory.openSession(); session.beginTransaction(); /* Saving objects to database */ session.save(emp1); session.save(emp2); session.save(emp3); session.save(emp4); session.save(emp5); session.save(emp6); session.save(emp7); session.save(emp8); String empId = "4"; String firstName = "Shreyas"; String lastName = "Gurram"; /* Executing named query Employee.getByID */ System.out.println("---------------------------------------"); System.out.println("Executing named query Employee.getByID"); Query query = session.getNamedQuery("Employee.getById"); query.setString(0, empId); List<Employee> list = (List<Employee>)query.list(); for(Employee emp : list) System.out.println(emp.getId() + " " + emp.getFirstName() + " " + emp.getLastName()); /* Executing named query Employee.getByFirstName */ System.out.println("---------------------------------------"); System.out.println("Executing named query Employee.getByFirstName"); query = session.getNamedQuery("Employee.getByFirstName"); query.setString(0, firstName); list = (List<Employee>)query.list(); for(Employee emp : list) System.out.println(emp.getId() + " " + emp.getFirstName() + " " + emp.getLastName()); /* Executing named query Employee.getByLastName */ System.out.println("---------------------------------------"); System.out.println("Executing named query Employee.getByLastName"); query = session.getNamedQuery("Employee.getByLastName"); query.setString(0, lastName); list = (List<Employee>)query.list(); for(Employee emp : list) System.out.println(emp.getId() + " " + emp.getFirstName() + " " + emp.getLastName()); session.getTransaction().commit(); session.close(); } }
Run
TestEmployee class, you will get output like below.
Hibernate: drop table if exists employee_details Hibernate: create table employee_details (id integer not null auto_increment, firstName varchar(255), lastName varchar(255), primary key (id)) Dec 23, 2014 12:07:36 PM org.hibernate.tool.hbm2ddl.SchemaExport execute INFO: HHH000230: Schema export complete Hibernate: insert into employee_details (firstName, lastName) values (?, ?) Hibernate: insert into employee_details (firstName, lastName) values (?, ?) Hibernate: insert into employee_details (firstName, lastName) values (?, ?) Hibernate: insert into employee_details (firstName, lastName) values (?, ?) Hibernate: insert into employee_details (firstName, lastName) values (?, ?) Hibernate: insert into employee_details (firstName, lastName) values (?, ?) Hibernate: insert into employee_details (firstName, lastName) values (?, ?) Hibernate: insert into employee_details (firstName, lastName) values (?, ?) --------------------------------------- Executing named query Employee.getByID Hibernate: select * from employee_details where id=? 4 Rama Krishna Gurram --------------------------------------- Executing named query Employee.getByFirstName Hibernate: select * from employee_details where firstName=? 2 Shreyas Desai --------------------------------------- Executing named query Employee.getByLastName Hibernate: select * from employee_details where lastName=? 1 Hari Krishna Gurram 4 Rama Krishna Gurram
Prevoius Next Home
No comments:
Post a Comment