Author has experience of developing enterprise large scale applications built with the technologies ranging from Java and frameworks like spring,hibernate,jpa, angularjs.

How to navigate to other page Navigation tutorial-ionic2 and angular4

How to navigate to other page Navigation tutorial-ionic2 and angular4 While developing some app you most frequently have the requirement to navigate back and forth between the views. In ionic the NavController from ‘ionic-angular’ comes handy.

import { Component } from '@angular/core';
import { NavController } from 'ionic-angular';
import {ContactPage} from '../contact/contact';
@Component({
  selector: 'page-about',
  templateUrl: 'about.html'
})
export class AboutPage {

  constructor(public navCtrl: NavController) {

  }
navigate(){
  this.navCtrl.push(ContactPage);
}
}

import { Component } from '@angular/core';

import { NavController } from 'ionic-angular';

import {ContactPage} from '../contact/contact';

@Component({

selector: 'page-about',

templateUrl: 'about.html'

})

export class AboutPage {

constructor(public navCtrl: NavController) {

}

navigate(){

this.navCtrl.push(ContactPage);

}

this.navCtrl.push method accepts page Read More

How to iterate items in ionic2 with angular4 tutorial

Hi Everybody,Ever dreamed of developing mobile app on your own.So good news for you is you can develop mobile app if you know little bit of angular.So today we are going to iterate list of items using ionic2 and angular4. Read More

Map Java Collection Tutorial

Map Stores values in key and value. map does not allow duplicate key. only one null key but any number of null values To synchronize the Map use. Collections.synchronizedMap(yourMapObject) Hashmap Hashmap allows random storage sequence is not maintained. Stores values Read More

Java Collection -Set

<I>Set does not contain duplicates. randomly stores elements. does not permits null elements. How to make your list synchronised? Collections.synchronizedSet(yourSetObject) Classes <C>TreeSet Sorts element by natural order. rest of the properties are same as specified by interface Set Internally it Read More

Doubly Linked list in java

Doubly Linked List Tutorial in Java

class DoublyList
{
	DoublyList prev;
	DoublyList next;
	String data;
	
}
class DoublyAPI
{
	DoublyList head;
	
	/**
	 * Append at last
	 * @param data
	 */
	public void appendToDoublyList(String data)
	{
		if(head==null)
		{
			head=createNode(data);			
		}
		else
		{
			DoublyList traverseNode;
			traverseNode=head;
			//traverse till end
			while(traverseNode.next!=null)
			{
				traverseNode=traverseNode.next;
			}
			DoublyList newNode=createNode(data);
			
			traverseNode.next=newNode;
			newNode.prev=traverseNode;
			newNode.next=null;
		}
	}
	public void insertInMiddle(int loc,String data)
	{	
		DoublyList traverseNode = head;
		for(int i=0;i<loc;i++)
		{
			traverseNode=traverseNode.next;
		}
		DoublyList newNode=createNode(data);
	
		newNode.next=traverseNode.next;
		traverseNode.next=newNode;
		newNode.prev=traverseNode;
		newNode.next.prev=newNode;
		
		
	}
	/**
	 * Create A node
	 * @param data
	 * @return
	 */
	
	public DoublyList createNode(String data)
	{
		DoublyList doublyObj=new DoublyList();
		doublyObj.data=data;
		return doublyObj;
	}
	public void printAll()
	{
		while(head!=null)
		{
			System.out.println(head.data);
			head=head.next;
		}
		//System.out.println(head.data);
	}

}
public class DoublyLinkedList {




	public static void main(String[] args) {
		DoublyAPI apiObj=new DoublyAPI();
		apiObj.appendToDoublyList("A");
		apiObj.appendToDoublyList("B");
		apiObj.appendToDoublyList("C");
		apiObj.insertInMiddle(1, "Z");
		apiObj.printAll();
	}

}

class DoublyList

{

DoublyList prev;

DoublyList next;

String data;

}

class DoublyAPI

{

DoublyList head;

/**

* Append at last

* @param data

public void appendToDoublyList(String data)

{

if(head==null)

{

head=createNode(data);

}

else

{

DoublyList traverseNode;

traverseNode=head;

//traverse till end

while(traverseNode.next!=null)

{

traverseNode=traverseNode.next;

}

DoublyList newNode=createNode(data);

traverseNode.next=newNode;

newNode.prev=traverseNode;

newNode.next=null;

}

public void insertInMiddle(int loc,String data)

{

DoublyList traverseNode = head;

for(int i=0;i<loc;i++)

{

traverseNode=traverseNode.next;

}

DoublyList newNode=createNode(data);

newNode.next=traverseNode.next;

traverseNode.next=newNode;

newNode.prev=traverseNode;

newNode.next.prev=newNode;

}

/**

* Create A node

* @param data

* @return

public DoublyList createNode(String data)

{

DoublyList doublyObj=new DoublyList();

doublyObj.data=data;

return doublyObj;

}

public void printAll()

{

while(head!=null)

{

System.out.println(head.data);

head=head.next;

}

//System.out.println(head.data);

}

public class DoublyLinkedList {

public static void main(String[] args) {

DoublyAPI apiObj=new DoublyAPI();

apiObj.appendToDoublyList("A");

apiObj.appendToDoublyList("B");

apiObj.appendToDoublyList("C");

apiObj.insertInMiddle(1, "Z");

apiObj.printAll();

}

This is just like a tip of the iceberg.I would strongly recommend to go through

Singly Linked List using java.

Singly Linked list using java Singly Linked List is created for adding the elements one after another where each Node is linked to the other Node sequentially. The operations covered in this post are Append to the end Read More

Files Read by Multiple Thread

How to read each file on separate thread. Step 1:Get List of all files in the specified folder

String[] files=new File("D:\\test\\").list();

Now pass the file to the seperate thread.

for(String file:files)
{
new Thread(new FileList("D:\\test\\"+file)).start();
}

String[] files=new File("D:\\test\\").list();

Now pass the file to the seperate thread.

for(String file:files)

{

new Thread(new FileList("D:\\test\\"+file)).start();

}

Step 2:Create Class which will display contents of file and implements runnable. Note that I have created constructor to Read More

Binary Search Example

Binary search example in java

import java.util.ArrayList;
import java.util.List;

public class BinarySearch {

public static void main(String[] args) {
	List<Integer> items=new ArrayList<Integer>();
	items.add(1);
	items.add(12);
	items.add(78);
	items.add(79);
	items.add(80);
	items.add(81);
	items.add(82);
	items.add(83);
	items.add(85);
	items.add(150);
	items.add(500);
	int mid=0;
	int low=0;
	int high=items.size();
	int noToSearch=81;
	
	while(low<high)// it:items)
	{
		mid=(items.size()/2);
		if(noToSearch>items.get(mid))
		{
			low=mid+1;
			high=(items.size()-1);
		}
		else if(noToSearch<items.get(mid))
		{
			high=mid-1;
			
		}
		else if(noToSearch==items.get(mid))
		{
				System.out.println("FOUND");
				break;
		}
	}
	
}
}

import java.util.ArrayList;

import java.util.List;

public class BinarySearch {

public static void main(String[] args) {

List<Integer> items=new ArrayList<Integer>();

items.add(1);

items.add(12);

items.add(78);

items.add(79);

items.add(80);

items.add(81);

items.add(82);

items.add(83);

items.add(85);

items.add(150);

items.add(500);

int mid=0;

int low=0;

int high=items.size();

int noToSearch=81;

while(low<high)// it:items)

{

mid=(items.size()/2);

if(noToSearch>items.get(mid))

{

low=mid+1;

high=(items.size()-1);

}

else if(noToSearch<items.get(mid))

{

high=mid-1;

}

else if(noToSearch==items.get(mid))

{

System.out.println("FOUND");

break;

}

Hibernate Interceptor example

Hibernate Interceptor example Interceptor

package com.shivapreals.config;

import java.io.Serializable;

import org.hibernate.EmptyInterceptor;
import org.hibernate.type.Type;
public class MyInterceptor extends EmptyInterceptor{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	public boolean onSave(Object entity, Serializable id, Object[] state, String[] propertyNames, Type[] types) 
	{
		System.out.println(entity+"**");
		return false;
	}
}

package com.shivapreals.config;

import java.io.Serializable;

import org.hibernate.EmptyInterceptor;

import org.hibernate.type.Type;

public class MyInterceptor extends EmptyInterceptor{

/**

private static final long serialVersionUID = 1L;

public boolean onSave(Object entity, Serializable id, Object[] state, String[] propertyNames, Type[] types)

{

System.out.println(entity+"**");

return false;

}

AppConfig

package com.shivapreals.config;

import java.util.Properties;

import javax.sql.DataSource;


import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.ComponentScans;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.orm.hibernate5.HibernateTransactionManager;
import org.springframework.orm.hibernate5.LocalSessionFactoryBean;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import com.shivapreals.entity.Item;

/**
 * @author shivapreals
 *
 */
@Configuration
//@PropertySource("classpath:db.properties")
@EnableTransactionManagement
@ComponentScans(value = { 
      @ComponentScan("com.shivapreals.dao"),
      @ComponentScan("com.shivapreals.service") 
    })
public class AppConfig {
	//# MySQL properties
	public static final String driver="org.hsqldb.jdbcDriver";//"org.h2.Driver";
	public static final String url="jdbc:hsqldb:mem://productDb";//"jdbc:hsqldb:hsql://localhost:9137/webappdb";//"jdbc:h2:~/test";
	//server.remote_open=true
	public static final String username="sa";
	public static final String password="";

	//# Hibernate properties
	public static final String show_sql="true";
	public static final String hbm2ddl="update";
	public static final String dialect="org.hibernate.dialect.HSQLDialect";//"org.hibernate.dialect.H2Dialect";
   /*@Autowired
   private Environment env;
*/
   @Bean
   public DataSource getDataSource() {
      DriverManagerDataSource dataSource = new DriverManagerDataSource();
      dataSource.setDriverClassName(driver);
      dataSource.setUrl(url);
      dataSource.setUsername(username);
      dataSource.setPassword(password);
      return dataSource;
   }
   
   @Bean
   public LocalSessionFactoryBean getSessionFactory() {
      LocalSessionFactoryBean factoryBean = new LocalSessionFactoryBean();
      factoryBean.setDataSource(getDataSource());
      
      Properties props=new Properties();
      props.setProperty("hibernate.hbm2ddl.auto", "create-drop");
      props.setProperty("hibernate.dialect", dialect);
     // props.setProperty("hibernate.show_sql", true);
      //props.put("hibernate.hbm2ddl.auto", "update");

      factoryBean.setHibernateProperties(props);
      factoryBean.setAnnotatedClasses(Item.class);
      return factoryBean;
   }

   @Bean
   public HibernateTransactionManager getTransactionManager() {
      HibernateTransactionManager transactionManager = new HibernateTransactionManager();
      transactionManager.setSessionFactory(getSessionFactory().getObject());
      return transactionManager;
   }
}

package com.shivapreals.config;

import java.util.Properties;

import javax.sql.DataSource;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.ComponentScan;

import org.springframework.context.annotation.ComponentScans;

import org.springframework.context.annotation.Configuration;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

import org.springframework.orm.hibernate5.HibernateTransactionManager;

import org.springframework.orm.hibernate5.LocalSessionFactoryBean;

import org.springframework.transaction.annotation.EnableTransactionManagement;

import com.shivapreals.entity.Item;

/**

* @author shivapreals

@Configuration

//@PropertySource("classpath:db.properties")

@EnableTransactionManagement

@ComponentScans(value = {

@ComponentScan("com.shivapreals.dao"),

@ComponentScan("com.shivapreals.service")

})

public class AppConfig {

//# MySQL properties

public static final String driver="org.hsqldb.jdbcDriver";//"org.h2.Driver";

public static final String url="jdbc:hsqldb:mem://productDb";//"jdbc:hsqldb:hsql://localhost:9137/webappdb";//"jdbc:h2:~/test";

//server.remote_open=true

public static final String username="sa";

public static final String password="";

//# Hibernate properties

public static final String show_sql="true";

public static final String hbm2ddl="update";

public static final String dialect="org.hibernate.dialect.HSQLDialect";//"org.hibernate.dialect.H2Dialect";

/*@Autowired

private Environment env;

@Bean

public DataSource getDataSource() {

DriverManagerDataSource dataSource = new DriverManagerDataSource();

dataSource.setDriverClassName(driver);

dataSource.setUrl(url);

dataSource.setUsername(username);

dataSource.setPassword(password);

return dataSource;

}

@Bean

public LocalSessionFactoryBean getSessionFactory() {

LocalSessionFactoryBean factoryBean = new LocalSessionFactoryBean();

factoryBean.setDataSource(getDataSource());

Properties props=new Properties();

props.setProperty("hibernate.hbm2ddl.auto", "create-drop");

props.setProperty("hibernate.dialect", dialect);

// props.setProperty("hibernate.show_sql", true);

//props.put("hibernate.hbm2ddl.auto", "update");

factoryBean.setHibernateProperties(props);

factoryBean.setAnnotatedClasses(Item.class);

return factoryBean;

}

@Bean

public HibernateTransactionManager getTransactionManager() {

HibernateTransactionManager transactionManager = new HibernateTransactionManager();

transactionManager.setSessionFactory(getSessionFactory().getObject());

return transactionManager;

}

ItemDaoImpl

package com.shivapreals.dao;

import java.util.List;

import org.springframework.transaction.annotation.Transactional;

import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import com.shivapreals.config.MyInterceptor;
import com.shivapreals.entity.Item;

@Repository
public class ItemDaoImpl {
@Autowired
public SessionFactory sessionFactory;
@Transactional
	public void save(Item itemObj)
	{
		sessionFactory.withOptions().interceptor(new MyInterceptor()).openSession().save(itemObj);
	}
@Transactional
	public List<Item> getItemList()
	{
		return (List<Item>)sessionFactory.getCurrentSession().createQuery("from Item").list();
		
	}
}

package com.shivapreals.dao;

import java.util.List;

import org.springframework.transaction.annotation.Transactional;

import org.hibernate.SessionFactory;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Repository;

import com.shivapreals.config.MyInterceptor;

import com.shivapreals.entity.Item;

@Repository

public class ItemDaoImpl {

@Autowired

public SessionFactory sessionFactory;

@Transactional

public void save(Item itemObj)

{

sessionFactory.withOptions().interceptor(new MyInterceptor()).openSession().save(itemObj);

}

@Transactional

public List<Item> getItemList()

{

return (List<Item>)sessionFactory.getCurrentSession().createQuery("from Item").list();

}

Item

package com.shivapreals.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "Item")
public class Item {

	@Id
	   @GeneratedValue(strategy = GenerationType.IDENTITY)
	public Long itemId;
	//public int itemId;
	
	@Column
	public String itemName;

	public Long getItemId() {
		return itemId;
	}

	public void setItemId(Long itemId) {
		this.itemId = itemId;
	}

	public String getItemName() {
		return itemName;
	}

	public void setItemName(String itemName) {
		this.itemName = itemName;
	}
	
}

package com.shivapreals.entity;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

@Entity

@Table(name = "Item")

public class Item {

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

public Long itemId;

//public int itemId;

@Column

public String itemName;

public Long getItemId() {

return itemId;

}

public void setItemId(Long itemId) {

this.itemId = itemId;

}

public String getItemName() {

return itemName;

}

public void setItemName(String itemName) {

this.itemName = itemName;

}

MainApp

package com.shivapreals;

import java.sql.SQLException;

import org.springframework.context.annotation.AnnotationConfigApplicationContext;

import com.shivapreals.config.AppConfig;
import com.shivapreals.dao.ItemDaoImpl;
import com.shivapreals.entity.Item;


/**
 * @author shivapreals
 *
 */
public class MainApp {
	public static void main(String[] args) throws SQLException {
		AnnotationConfigApplicationContext context = 
				new AnnotationConfigApplicationContext(AppConfig.class);

		ItemDaoImpl item=context.getBean(ItemDaoImpl.class);
		Item item1=new Item();
		item1.setItemId((long) 1);
		item1.setItemName("itemName");
		item.save(item1);

		System.out.println(item.getItemList().get(0).getItemName());


		context.close();
	}
}

package com.shivapreals;

import java.sql.SQLException;

import org.springframework.context.annotation.AnnotationConfigApplicationContext;

import com.shivapreals.config.AppConfig;

import com.shivapreals.dao.ItemDaoImpl;

import com.shivapreals.entity.Item;

/**

* @author shivapreals

public class MainApp {

public static void main(String[] args) throws SQLException {

AnnotationConfigApplicationContext context =

new AnnotationConfigApplicationContext(AppConfig.class);

ItemDaoImpl item=context.getBean(ItemDaoImpl.class);

Item item1=new Item();

item1.setItemId((long) 1);

item1.setItemName("itemName");

item.save(item1);

System.out.println(item.getItemList().get(0).getItemName());

context.close();

}

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
  http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<groupId>com.boraji.tutorial.hibernate</groupId>
	<artifactId>spring-hibernate-example</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>spring-hibernate-tutorial</name>
	<url>http://maven.apache.org</url>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
	</properties>

	<dependencies>
		<!-- Spring Context -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<!-- Spring ORM -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		
		<!-- https://mvnrepository.com/artifact/org.hsqldb/hsqldb -->
		<dependency>
			<groupId>org.hsqldb</groupId>
			<artifactId>hsqldb</artifactId>
			<version>2.3.5</version>

		</dependency>


		<!-- Hibernate 5.2.9 Final -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>5.2.9.Final</version>
		</dependency>
		<!-- Apache Commons DBCP -->
		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-dbcp2</artifactId>
			<version>2.1.1</version>
		</dependency>
	</dependencies>

	<build>
		<sourceDirectory>src/main/java</sourceDirectory>
		<plugins>
			<plugin>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>3.5.1</version>
				<configuration>
					<source>1.8</source>
					<target>1.8</target>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0

http://maven.apache.org/xsd/maven-4.0.0.xsd">

<groupId>com.boraji.tutorial.hibernate</groupId>

<artifactId>spring-hibernate-example</artifactId>

<version>0.0.1-SNAPSHOT</version>

<name>spring-hibernate-tutorial</name>

<url>http://maven.apache.org</url>

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

</properties>

<groupId>org.springframework</groupId>

<artifactId>spring-context</artifactId>

<version>4.3.7.RELEASE</version>

</dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-orm</artifactId>

<version>4.3.7.RELEASE</version>

</dependency>

<groupId>org.hsqldb</groupId>

<artifactId>hsqldb</artifactId>

</dependency>

<groupId>org.hibernate</groupId>

<artifactId>hibernate-core</artifactId>

<version>5.2.9.Final</version>

</dependency>

<groupId>org.apache.commons</groupId>

<artifactId>commons-dbcp2</artifactId>

</dependency>

</dependencies>

<build>

<artifactId>maven-compiler-plugin</artifactId>

</configuration>

</plugin>

</plugins>

</build>

</project>

Complete Source Code. https://github.com/shivapreals/hibernatewithinterceptor

springboot with hibernate example

Spring4 wtih hibernate example. This is pure annotation based example. Git Url: https://github.com/shivapreals/springboot-hibernate-example Project Structure pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
  http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<groupId>com.boraji.tutorial.hibernate</groupId>
	<artifactId>spring-hibernate-example</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>spring-hibernate-tutorial</name>
	<url>http://maven.apache.org</url>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
	</properties>

	<dependencies>
		<!-- Spring Context -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<!-- Spring ORM -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<!-- <dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>6.0.5</version>
		</dependency>
		-->
		<!-- https://mvnrepository.com/artifact/com.h2database/h2 -->
		<!-- https://mvnrepository.com/artifact/org.hsqldb/hsqldb -->
		<dependency>
			<groupId>org.hsqldb</groupId>
			<artifactId>hsqldb</artifactId>
			<version>2.3.5</version>

		</dependency>


		<!-- Hibernate 5.2.9 Final -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>5.2.9.Final</version>
		</dependency>
		<!-- Apache Commons DBCP -->
		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-dbcp2</artifactId>
			<version>2.1.1</version>
		</dependency>
	</dependencies>

	<build>
		<sourceDirectory>src/main/java</sourceDirectory>
		<plugins>
			<plugin>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>3.5.1</version>
				<configuration>
					<source>1.8</source>
					<target>1.8</target>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0

http://maven.apache.org/xsd/maven-4.0.0.xsd">

<groupId>com.boraji.tutorial.hibernate</groupId>

<artifactId>spring-hibernate-example</artifactId>

<version>0.0.1-SNAPSHOT</version>

<name>spring-hibernate-tutorial</name>

<url>http://maven.apache.org</url>

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

</properties>

<groupId>org.springframework</groupId>

<artifactId>spring-context</artifactId>

<version>4.3.7.RELEASE</version>

</dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-orm</artifactId>

<version>4.3.7.RELEASE</version>

</dependency>

<!-- <dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

-->

<groupId>org.hsqldb</groupId>

<artifactId>hsqldb</artifactId>

</dependency>

<groupId>org.hibernate</groupId>

<artifactId>hibernate-core</artifactId>

<version>5.2.9.Final</version>

</dependency>

<groupId>org.apache.commons</groupId>

<artifactId>commons-dbcp2</artifactId>

</dependency>

</dependencies>

<build>

<artifactId>maven-compiler-plugin</artifactId>

</configuration>

</plugin>

</plugins>

</build>

</project>

MainApp.java

package com.shivapreals;

import java.sql.SQLException;

import org.springframework.context.annotation.AnnotationConfigApplicationContext;

import com.shivapreals.config.AppConfig;
import com.shivapreals.dao.ItemDaoImpl;
import com.shivapreals.entity.Item;


/**
 * @author shivapreals
 *
 */
public class MainApp {
	public static void main(String[] args) throws SQLException {
		AnnotationConfigApplicationContext context = 
				new AnnotationConfigApplicationContext(AppConfig.class);

		ItemDaoImpl item=context.getBean(ItemDaoImpl.class);
		Item item1=new Item();
		item1.setItemId((long) 1);
		item1.setItemName("itemName");
		item.save(item1);

		System.out.println(item.getItemList().get(0).getItemName());


		context.close();
	}
}

package com.shivapreals;

import java.sql.SQLException;

import org.springframework.context.annotation.AnnotationConfigApplicationContext;

import com.shivapreals.config.AppConfig;

import com.shivapreals.dao.ItemDaoImpl;

import com.shivapreals.entity.Item;

/**

* @author shivapreals

public class MainApp {

public static void main(String[] args) throws SQLException {

AnnotationConfigApplicationContext context =

new AnnotationConfigApplicationContext(AppConfig.class);

ItemDaoImpl item=context.getBean(ItemDaoImpl.class);

Item item1=new Item();

item1.setItemId((long) 1);

item1.setItemName("itemName");

item.save(item1);

System.out.println(item.getItemList().get(0).getItemName());

context.close();

}

Item.java

package com.shivapreals.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "Item")
public class Item {

	@Id
	   @GeneratedValue(strategy = GenerationType.IDENTITY)
	public Long itemId;
	//public int itemId;
	
	@Column
	public String itemName;

	public Long getItemId() {
		return itemId;
	}

	public void setItemId(Long itemId) {
		this.itemId = itemId;
	}

	public String getItemName() {
		return itemName;
	}

	public void setItemName(String itemName) {
		this.itemName = itemName;
	}
	
}

package com.shivapreals.entity;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

@Entity

@Table(name = "Item")

public class Item {

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

public Long itemId;

//public int itemId;

@Column

public String itemName;

public Long getItemId() {

return itemId;

}

public void setItemId(Long itemId) {

this.itemId = itemId;

}

public String getItemName() {

return itemName;

}

public void setItemName(String itemName) {

this.itemName = itemName;

}

ItemDaoImpl.java

package com.shivapreals.dao;

import java.util.List;

import org.springframework.transaction.annotation.Transactional;

import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import com.shivapreals.entity.Item;

@Repository
public class ItemDaoImpl {
@Autowired
public SessionFactory sessionFactory;
@Transactional
	public void save(Item itemObj)
	{
		sessionFactory.getCurrentSession().save(itemObj);
	}
@Transactional
	public List<Item> getItemList()
	{
		return (List<Item>)sessionFactory.getCurrentSession().createQuery("from Item").list();
		
	}
}

package com.shivapreals.dao;

import java.util.List;

import org.springframework.transaction.annotation.Transactional;

import org.hibernate.SessionFactory;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Repository;

import com.shivapreals.entity.Item;

@Repository

public class ItemDaoImpl {

@Autowired

public SessionFactory sessionFactory;

@Transactional

public void save(Item itemObj)

{

sessionFactory.getCurrentSession().save(itemObj);

}

@Transactional

public List<Item> getItemList()

{

return (List<Item>)sessionFactory.getCurrentSession().createQuery("from Item").list();

}

AppConfig.java

package com.shivapreals.config;

import java.util.Properties;

import javax.sql.DataSource;


import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.ComponentScans;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.orm.hibernate5.HibernateTransactionManager;
import org.springframework.orm.hibernate5.LocalSessionFactoryBean;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import com.shivapreals.entity.Item;

/**
 * @author shivapreals
 *
 */
@Configuration
//@PropertySource("classpath:db.properties")
@EnableTransactionManagement
@ComponentScans(value = { 
      @ComponentScan("com.shivapreals.dao"),
      @ComponentScan("com.shivapreals.service") 
    })
public class AppConfig {
	//# MySQL properties
	public static final String driver="org.hsqldb.jdbcDriver";//"org.h2.Driver";
	public static final String url="jdbc:hsqldb:mem://productDb";//"jdbc:hsqldb:hsql://localhost:9137/webappdb";//"jdbc:h2:~/test";
	//server.remote_open=true
	public static final String username="sa";
	public static final String password="";

	//# Hibernate properties
	public static final String show_sql="true";
	public static final String hbm2ddl="update";
	public static final String dialect="org.hibernate.dialect.HSQLDialect";//"org.hibernate.dialect.H2Dialect";
   /*@Autowired
   private Environment env;
*/
   @Bean
   public DataSource getDataSource() {
      DriverManagerDataSource dataSource = new DriverManagerDataSource();
      dataSource.setDriverClassName(driver);
      dataSource.setUrl(url);
      dataSource.setUsername(username);
      dataSource.setPassword(password);
      return dataSource;
   }
   
   @Bean
   public LocalSessionFactoryBean getSessionFactory() {
      LocalSessionFactoryBean factoryBean = new LocalSessionFactoryBean();
      factoryBean.setDataSource(getDataSource());
      
      Properties props=new Properties();
      props.setProperty("hibernate.hbm2ddl.auto", "create-drop");
      props.setProperty("hibernate.dialect", dialect);
     // props.setProperty("hibernate.show_sql", true);
      //props.put("hibernate.hbm2ddl.auto", "update");

      factoryBean.setHibernateProperties(props);
      factoryBean.setAnnotatedClasses(Item.class);
      return factoryBean;
   }

   @Bean
   public HibernateTransactionManager getTransactionManager() {
      HibernateTransactionManager transactionManager = new HibernateTransactionManager();
      transactionManager.setSessionFactory(getSessionFactory().getObject());
      return transactionManager;
   }
}

package com.shivapreals.config;

import java.util.Properties;

import javax.sql.DataSource;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.ComponentScan;

import org.springframework.context.annotation.ComponentScans;

import org.springframework.context.annotation.Configuration;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

import org.springframework.orm.hibernate5.HibernateTransactionManager;

import org.springframework.orm.hibernate5.LocalSessionFactoryBean;

import org.springframework.transaction.annotation.EnableTransactionManagement;

import com.shivapreals.entity.Item;

/**

* @author shivapreals

@Configuration

//@PropertySource("classpath:db.properties")

@EnableTransactionManagement

@ComponentScans(value = {

@ComponentScan("com.shivapreals.dao"),

@ComponentScan("com.shivapreals.service")

})

public class AppConfig {

//# MySQL properties

public static final String driver="org.hsqldb.jdbcDriver";//"org.h2.Driver";

public static final String url="jdbc:hsqldb:mem://productDb";//"jdbc:hsqldb:hsql://localhost:9137/webappdb";//"jdbc:h2:~/test";

//server.remote_open=true

public static final String username="sa";

public static final String password="";

//# Hibernate properties

public static final String show_sql="true";

public static final String hbm2ddl="update";

public static final String dialect="org.hibernate.dialect.HSQLDialect";//"org.hibernate.dialect.H2Dialect";

/*@Autowired

private Environment env;

@Bean

public DataSource getDataSource() {

DriverManagerDataSource dataSource = new DriverManagerDataSource();

dataSource.setDriverClassName(driver);

dataSource.setUrl(url);

dataSource.setUsername(username);

dataSource.setPassword(password);

return dataSource;

}

@Bean

public LocalSessionFactoryBean getSessionFactory() {

LocalSessionFactoryBean factoryBean = new LocalSessionFactoryBean();

factoryBean.setDataSource(getDataSource());

Properties props=new Properties();

props.setProperty("hibernate.hbm2ddl.auto", "create-drop");

props.setProperty("hibernate.dialect", dialect);

// props.setProperty("hibernate.show_sql", true);

//props.put("hibernate.hbm2ddl.auto", "update");

factoryBean.setHibernateProperties(props);

factoryBean.setAnnotatedClasses(Item.class);

return factoryBean;

}

@Bean

public HibernateTransactionManager getTransactionManager() {

HibernateTransactionManager transactionManager = new HibernateTransactionManager();

transactionManager.setSessionFactory(getSessionFactory().getObject());

return transactionManager;

}

db.properties

# MySQL properties
db.driver=org.h2.Driver
db.url=jdbc:h2:~/test
db.username=sa
db.password=

# Hibernate properties
hibernate.show_sql=true
hibernate.hbm2ddl.auto=update
hibernate.dialect=org.hibernate.dialect.H2Dialect

# MySQL properties

db.driver=org.h2.Driver

db.url=jdbc:h2:~/test

db.username=sa

db.password=

# Hibernate properties

hibernate.show_sql=true

hibernate.hbm2ddl.auto=update

hibernate.dialect=org.hibernate.dialect.H2Dialect

Author: admin