prashant4224

CREATE PROCEDURE `GetByCity`(IN cityName varchar(255))
BEGIN
	select * from user where city=cityName;
END
									 
//call test_db.GetByCity('Pune');

prashant4224

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetUser`()
BEGIN
	SELECT * FROM USER ORDER BY FIRST_NAME;
END

prashant4224

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetUser`()
BEGIN
	SELECT * FROM USER ORDER BY FIRST_NAME;
END

prashant4224

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetTotalUser`()
BEGIN
	DECLARE totalUser INT DEFAULT 0;
    SELECT COUNT(*) INTO totalUser FROM USER;
    
    SELECT totalUser;
END

prashant4224

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetUser`()
BEGIN
	SELECT * FROM USER ORDER BY FIRST_NAME;
END

prashant4224

@Component
public class RequestManager{
 @Autowired
 private RequestHandler requestHandler;
 
 public void handleRequest(){
   requestHandler.handleRequest();
 }
}

prashant4224

import org.springframework.beans.factory.annotation.Lookup;
import org.springframework.stereotype.Component;

@Component
public class RequestManager{
 private RequestHandler requestHandler;
 
 public void handleRequest(){

prashant4224

public class User {

  private int id;
  private String name;
  
  //setters & getters
  @Override
  public int hashcode() {
    final int prime = 31;
    int result = 1;

prashant4224

/* Immutable Class */
public final class Box {

	private final String key;
	private final String value;
	private final HashMap<String, String> hm;
	
	
	public Box(String key, String value, HashMap<String, String> hm) {
		this.key = key;

prashant4224

/* Singleton class double checking */
public class Technology {

	private static final Technology instance;
	
	private Technology() {}
	
	public static synchronized Technology getInstatnce() {
		if (instance == null) {
			synchronized (Technology.class) {