Hibernate with Spring Boot - Revision history

Fukakai: /* Exceptions */

2019-09-23T18:06:47Z

Exceptions

← Older revision		Revision as of 20:06, 23 September 2019
Line 157:		Line 157:

	=Exceptions=		=Exceptions=
	~~'''~~@ResponseStatus(value = HttpStatus.NOT_FOUND)~~'''~~		<source lang="java">
			@ResponseStatus(value = HttpStatus.NOT_FOUND)
	public class RecordNotFoundException extends Exception {		public class RecordNotFoundException extends Exception {

	private static final long ~~'''~~serialVersionUID = 1L;~~'''~~		private static final long serialVersionUID = 1L;

	public ~~'''~~RecordNotFoundException~~'''~~(String message) {		public RecordNotFoundException(String message) {
	~~'''~~super~~'''~~(message);		super(message);
	}		}

	public ~~'''~~RecordNotFoundException~~'''~~(String message,~~'''~~ Throwable t~~'''~~) {		public RecordNotFoundException(String message, Throwable t) {
	~~'''~~super~~'''~~(message, t);		super(message, t);
	}		}
	}		}

			</source>

Fukakai: /* Controller (REST) */

2019-09-23T18:05:16Z

Controller (REST)

← Older revision		Revision as of 20:05, 23 September 2019
Line 120:		Line 120:

	==Controller (REST)==		==Controller (REST)==
	~~'''~~@RestController		<source lang="java">
	@RequestMapping("/employees")~~'''~~		@RestController
			@RequestMapping("/employees")
	public class EmployeeController{		public class EmployeeController{
	~~'''~~@Autowired~~'''~~		@Autowired
	EmployeeService service;		EmployeeService service;

	~~'''~~@GetMapping~~'''~~		@GetMapping
	public ~~'''~~ResponseEntity<List<EmployeeEntity>> getAllEmployees()~~'''~~{		public ResponseEntity<List<EmployeeEntity>> getAllEmployees(){
	List<EmployeeEntity> list = ~~'''~~service.getAllEmployees();~~'''~~		List<EmployeeEntity> list = service.getAllEmployees();

	return new ResponseEntity<List<EmployeeEntity>>(list, new HttpHeaders(), HttpStatus.OK);		return new ResponseEntity<List<EmployeeEntity>>(list, new HttpHeaders(), HttpStatus.OK);
	}		}

	~~'''~~@GetMapping("/{id}")~~'''~~		@GetMapping("/{id}")
	public ~~'''~~ResponseEntity<EmployeeEntity> getEmployeeById(@PathVariable("id") Long id)~~'''~~ throws RecordNotFoundException {		public ResponseEntity<EmployeeEntity> getEmployeeById(@PathVariable("id") Long id) throws RecordNotFoundException {
	EmployeeEntity entity = ~~'''~~service.getEmployeeById(id);~~'''~~		EmployeeEntity entity = service.getEmployeeById(id);

	return new ResponseEntity<EmployeeEntity>(entity, new HttpHeaders(), HttpStatus.OK);		return new ResponseEntity<EmployeeEntity>(entity, new HttpHeaders(), HttpStatus.OK);
	}		}

	~~'''~~@PostMapping~~'''~~		@PostMapping
	public ~~'''~~ResponseEntity<EmployeeEntity> createOrUpdateEmployee(EmployeeEntity employee)~~'''~~		public ResponseEntity<EmployeeEntity> createOrUpdateEmployee(EmployeeEntity employee)
	throws RecordNotFoundException {		throws RecordNotFoundException {
	EmployeeEntity updated = ~~'''~~service.createOrUpdateEmployee(employee);~~'''~~		EmployeeEntity updated = service.createOrUpdateEmployee(employee);
	return new ResponseEntity<EmployeeEntity>(updated, new HttpHeaders(), HttpStatus.OK);		return new ResponseEntity<EmployeeEntity>(updated, new HttpHeaders(), HttpStatus.OK);
	}		}

	~~'''~~@DeleteMapping("/{id}")~~'''~~		@DeleteMapping("/{id}")
	public ~~'''~~HttpStatus deleteEmployeeById(@PathVariable("id") Long id)~~'''~~ throws RecordNotFoundException {		public HttpStatus deleteEmployeeById(@PathVariable("id") Long id) throws RecordNotFoundException {
	~~'''~~service.deleteEmployeeById(id);~~'''~~		service.deleteEmployeeById(id);
	return HttpStatus.FORBIDDEN;		return HttpStatus.FORBIDDEN;
	}		}
	}		}
			</source>

	=Exceptions=		=Exceptions=

Fukakai: /* Service */

2019-09-23T18:04:36Z

Service

← Older revision		Revision as of 20:04, 23 September 2019
Line 58:		Line 58:

	== Service ==		== Service ==
	~~'''~~@Service~~'''~~		<source lang="java">
			@Service
	public class EmployeeService {		public class EmployeeService {
	~~'''~~@Autowired~~'''~~		@Autowired
	TableNameRepository repository;		TableNameRepository repository;

	~~'''###############~~ Get All~~'''~~		/******** Get All ********/
	public ~~'''~~List<EmployeeEntity> getAllEmployees()~~'''~~{		public List<EmployeeEntity> getAllEmployees(){
	List<EmployeeEntity> employeeList = ~~'''~~repository.findAll();~~'''~~		List<EmployeeEntity> employeeList = repository.findAll();

	if(employeeList.size() > 0) {		if(employeeList.size() > 0) {
	return employeeList;		return employeeList;
	} else {		} else {
	~~'''~~return new ArrayList<EmployeeEntity>();~~'''~~		return new ArrayList<EmployeeEntity>();
	}		}
	}		}

	~~'''###############~~ Get~~'''~~		/******** Get ********/
	public EmployeeEntity ~~'''~~getEmployeeById(Long id)~~'''~~ throws RecordNotFoundException{		public EmployeeEntity getEmployeeById(Long id) throws RecordNotFoundException{
	Optional<EmployeeEntity> employee = ~~'''~~repository.findById(id);~~'''~~		Optional<EmployeeEntity> employee = repository.findById(id);

	if(employee.isPresent()) {		if(employee.isPresent()) {
	return ~~'''~~employee.get();~~'''~~		return employee.get();
	} else {		} else {
	throw new RecordNotFoundException("No employee record exist for given id");		throw new RecordNotFoundException("No employee record exist for given id");
Line 85:		Line 86:
	}		}

	~~'''###############~~ Create~~'''~~ or ~~'''~~Update~~'''~~		/******** Create or Update ********/
	public EmployeeEntity ~~'''~~createOrUpdateEmployee(EmployeeEntity entity)~~'''~~ throws RecordNotFoundException{		public EmployeeEntity createOrUpdateEmployee(EmployeeEntity entity) throws RecordNotFoundException{
	Optional<EmployeeEntity> employee = ~~'''~~'repository.findById(entity.getId());~~'''~~		Optional<EmployeeEntity> employee = 'repository.findById(entity.getId());

	if(employee.isPresent()){		if(employee.isPresent()){
	EmployeeEntity newEntity = ~~'''~~employee.get();~~'''~~		EmployeeEntity newEntity = employee.get();
	newEntity.~~'''~~setEmail~~'''~~(entity.getEmail());		newEntity.setEmail(entity.getEmail());
	newEntity.~~'''~~setFirstName~~'''~~(entity.getFirstName());		newEntity.setFirstName(entity.getFirstName());
	newEntity.~~'''~~setLastName~~'''~~(entity.getLastName());		newEntity.setLastName(entity.getLastName());

	newEntity = repository.~~'''~~save~~'''~~(newEntity);		newEntity = repository.save(newEntity);

	return newEntity;		return newEntity;
	} else {		} else {
	entity = repository.~~'''~~save~~'''~~(entity);		entity = repository.save(entity);

	return entity;		return entity;
Line 105:		Line 106:
	}		}

	~~'''###############~~ Delete~~'''~~		/******** Delete ********/
	public void ~~'''~~deleteEmployeeById(Long id)~~'''~~ throws RecordNotFoundException{		public void deleteEmployeeById(Long id) throws RecordNotFoundException{
	Optional<EmployeeEntity> employee = ~~'''~~repository.findById(id);~~'''~~		Optional<EmployeeEntity> employee = repository.findById(id);

	if(employee.isPresent()){		if(employee.isPresent()){
	repository.~~'''~~deleteById(id);~~'''~~		repository.deleteById(id);
	} else {		} else {
	throw new RecordNotFoundException("No employee record exist for given id");		throw new RecordNotFoundException("No employee record exist for given id");
Line 116:		Line 117:
	}		}
	}		}
			</source>

	==Controller (REST)==		==Controller (REST)==

Fukakai: /* Repository */

2019-09-23T18:02:38Z

Repository

← Older revision		Revision as of 20:02, 23 September 2019
Line 25:		Line 25:
	See the differences of : '''JpaRepository = PagingAndSortingRepository + CrudRepository''' here ==>>		See the differences of : '''JpaRepository = PagingAndSortingRepository + CrudRepository''' here ==>>
	[[Fichier:JpaCrudRepository.png\|thumb\|100px\|JpaRepository]]		[[Fichier:JpaCrudRepository.png\|thumb\|100px\|JpaRepository]]
	~~'''~~@Repository~~'''~~		<source lang="java">
			@Repository
	public interface EmployeeRepository		public interface EmployeeRepository
	extends ~~'''~~JpaRepository<EmployeeEntity, Long>~~'''~~ {		extends JpaRepository<EmployeeEntity, Long> {
	...		...
	}		}
			</source>

	== Datasource Configuration ==		== Datasource Configuration ==

Fukakai: /* Entity */

2019-09-23T18:02:10Z

Entity

← Older revision		Revision as of 20:02, 23 September 2019
Line 10:		Line 10:
	== Entity ==		== Entity ==
	<source lang="java">		<source lang="java">
	~~'''~~@Entity~~'''~~		@Entity
	~~'''~~@Table~~'''~~(name="TABLE_EMPLOYEE")		@Table(name="TABLE_EMPLOYEE")
	public class EmployeeEntity{		public class EmployeeEntity{
	~~'''~~@Id		@Id
	@GeneratedValue~~'''~~		@GeneratedValue
	private Long id;		private Long id;
	~~'''~~@Column~~'''~~(name="column_name", ~~'''~~nullable~~'''~~=false, ~~'''~~length~~'''~~=200)		@Column(name="column_name", nullable=false, length=200)
	~~'''~~@Override~~'''~~		@Override
	public String ~~'''~~toString()~~'''~~ { ... }		public String toString() { ... }
	}		}
	</source>		</source>

Fukakai: /* Entity */

2019-09-23T18:01:37Z

Entity

← Older revision		Revision as of 20:01, 23 September 2019
Line 9:		Line 9:
	com.h2database.'''h2'''		com.h2database.'''h2'''
	== Entity ==		== Entity ==
			<source lang="java">
	'''@Entity'''		'''@Entity'''
	'''@Table'''(name="TABLE_EMPLOYEE")		'''@Table'''(name="TABLE_EMPLOYEE")
Line 19:		Line 20:
	public String '''toString()''' { ... }		public String '''toString()''' { ... }
	}		}
			</source>

	== Repository ==		== Repository ==
	See the differences of : '''JpaRepository = PagingAndSortingRepository + CrudRepository''' here ==>>		See the differences of : '''JpaRepository = PagingAndSortingRepository + CrudRepository''' here ==>>

Fukakai at 17:33, 23 September 2019

2019-09-23T17:33:38Z

← Older revision		Revision as of 19:33, 23 September 2019
Line 1:		Line 1:
	Hibernate ORM handles object-relational impedance mismatch problems by replacing direct, persistent database accesses with high-level object handling functions.		Hibernate ORM handles object-relational impedance mismatch problems by replacing direct, persistent database accesses with high-level object handling functions.
			https://howtodoinjava.com/spring-boot2/spring-boot-crud-hibernate/

	= Vulgarization =		= Vulgarization =

Fukakai: /* Exceptions */

2019-09-23T17:22:48Z

Exceptions

← Older revision		Revision as of 19:22, 23 September 2019
Line 147:		Line 147:

	=Exceptions=		=Exceptions=
	@ResponseStatus(value = HttpStatus.NOT_FOUND)		'''@ResponseStatus(value = HttpStatus.NOT_FOUND)'''
	public class RecordNotFoundException extends Exception {		public class RecordNotFoundException extends Exception {

	private static final long serialVersionUID = 1L;		private static final long '''serialVersionUID = 1L;'''

	public RecordNotFoundException(String message) {		public '''RecordNotFoundException'''(String message) {
	super(message);		'''super'''(message);
	}		}

	public RecordNotFoundException(String message, Throwable t) {		public '''RecordNotFoundException'''(String message,''' Throwable t''') {
	super(message, t);		'''super'''(message, t);
	}		}
	}		}

Fukakai: /* Controller (REST) */

2019-09-23T17:22:11Z

Controller (REST)

@@ Line 143: / Line 143: @@
          '''service.deleteEmployeeById(id);'''
          return HttpStatus.FORBIDDEN;
+     }
+  }

Fukakai: /* Repository */

2019-09-23T17:03:29Z

Repository

← Older revision		Revision as of 19:03, 23 September 2019
Line 19:		Line 19:
	}		}
	== Repository ==		== Repository ==
	See the differences of : [[Fichier:JpaCrudRepository.png\|~~left~~\|~~50px~~\|JpaRepository~~=PagingAndSortingRepository+CrudRepository~~]];		See the differences of : '''JpaRepository = PagingAndSortingRepository + CrudRepository''' here ==>>
			[[Fichier:JpaCrudRepository.png\|thumb\|100px\|JpaRepository]]
	'''@Repository'''		'''@Repository'''
	public interface EmployeeRepository		public interface EmployeeRepository