Save list in database

[John Sullivan]

Hi,

I have problems with one project. I have two tables Publisher and SubPublisher(id, publisher_id, name), when i add publisher in that form i have dynamic input fields for subPublishers. I get list of subPublishers and then i need to save them in table subPublisher with id of publisher.

Here is my code:

Publisher

@Entity
@Table(name = "publisher")
public class Publisher {
	
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	@Column(name = "id")
	private int id;
	
	@Column(name = "name")
	private String publisherName;
	
	@Column(name = "description")
	private String description;
	
	@Column(name = "status")
	private boolean status;
	
	@Column(name = "website_url")
	private String websiteURL;
	
	@Column(name = "time_added") 
	private Date timeAdded;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getPublisherName() {
		return publisherName;
	}

	public void setPublisherName(String publisherName) {
		this.publisherName = publisherName;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public boolean isStatus() {
		return status;
	}

	public void setStatus(boolean status) {
		this.status = status;
	}

	public String getWebsiteURL() {
		return websiteURL;
	}

	public void setWebsiteURL(String websiteURL) {
		this.websiteURL = websiteURL;
	}

	public Date getTimeAdded() {
		return timeAdded;
	}

	public void setTimeAdded(Date timeAdded) {
		this.timeAdded = timeAdded;
	}
}

SubPublisher

@Entity
@Table(name = "sub_publisher")
public class SubPublisher {
	
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	@Column(name = "id")
	private int id;

	@OneToOne(fetch = FetchType.LAZY)
	@JoinColumn(name = "publisher_id")
	private Publisher publisher;

	@Column(name = "name")
	private String name;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public Publisher getPublisher() {
		return publisher;
	}

	public void setPublisher(Publisher publisher) {
		this.publisher = publisher;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}
}

PublisherRepository

public interface PublisherRepository extends JpaDataTableRepository<Publisher, Integer> {
	
	public Publisher findById(int id);
}

SubPublisherRepository

public interface SubPublisherRepository extends JpaRepository<SubPublisher, Integer> {
	
	List<SubPublisher> findByPublisher(Publisher publisher);
}

PublisherResource

public class PublisherResource {
	
	private int id;
	private String publisherName;
	private String description;
	private boolean status;
	private String websiteURL;
	private List<SubPublisherResource> subPublishers;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getPublisherName() {
		return publisherName;
	}
	public void setPublisherName(String publisherName) {
		this.publisherName = publisherName;
	}
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	public boolean isStatus() {
		return status;
	}
	public void setStatus(boolean status) {
		this.status = status;
	}
	public String getWebsiteURL() {
		return websiteURL;
	}
	public void setWebsiteURL(String websiteURL) {
		this.websiteURL = websiteURL;
	}
	public List<SubPublisherResource> getSubPublishers() {
		return subPublishers;
	}
	public void setSubPublishers(List<SubPublisherResource> subPublishers) {
		this.subPublishers = subPublishers;
	}
}

SubPublisherResource

public class SubPublisherResource {

	private String name;
	
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
}

PublisherService

@Service
public class PublisherService {
	
	private PublisherRepository publisherRepository;
	private SubPublisherRepository subPublisherRepository;

	
	public PublisherService(PublisherRepository publisherRepository, SubPublisherRepository subPublisherRepository) {
		this.publisherRepository = publisherRepository;
		this.subPublisherRepository = subPublisherRepository;
	}

	public DataTableResponse<Publisher> getPublishers(DataTableRequest request) {	
		
		return publisherRepository.findAll(request); 
	}
	
	@Transactional
	public Publisher getPublisher(int publisherId) {
		Publisher publisher = publisherRepository.findById(publisherId);		
		
		if(publisher != null){
			List<SubPublisher> subPublishers = subPublisherRepository.findByPublisher(publisher);
			//populateSubPublishers(subPublishers);
			
			subPublishers.stream().forEach(s -> {
				if(s.getId() == 0){
					s.setPublisher(publisher);
					subPublisherRepository.save(s);
				}
			});
		}
		
		if(publisher == null) {
			throw new NotFoundException("Publisher " + publisherId + " not found.");
		}
		
		return publisher;
	}
	
	private void populateSubPublishers(List<SubPublisher> subPublishers) {
		for(SubPublisher subPublisher : subPublishers){
			subPublishers.add(subPublisher);
			System.out.println(subPublisher.getName());
		}
	}

	@Transactional
	public Publisher createPublisher(Publisher publisher, List<SubPublisher> subPublishers) {
		
		publisher = publisherRepository.save(publisher);
		createSubPublisher(publisher, subPublishers);		
		
		return publisher;
	}
	
	private void createSubPublisher(Publisher publisher, List<SubPublisher> subPublishers) {
		populateSubPublishers(subPublishers);
		
		for(SubPublisher subPublisher : subPublishers){
			subPublisher.setPublisher(publisher);
			subPublisher.setName(subPublisher.getName());
		}
		
	}

	@Transactional
	public Publisher updatePublisher(Publisher publisher) {
		
		publisher = publisherRepository.save(publisher);
		
		return publisher;
	}
	
	@Transactional
	public void updateStatus(int publisherId) {
		Publisher publisher = publisherRepository.findOne(publisherId);
		if(publisher != null && publisher.isStatus() != false){
			publisher.setStatus(false);
			publisherRepository.save(publisher);
		}
		else if(publisher != null && publisher.isStatus() != true ){
			publisher.setStatus(true);
			publisherRepository.save(publisher);
		}
	}
	
	@Transactional
	public void deletePublisher(int publisherId) {
		Publisher publisher = publisherRepository.findOne(publisherId);
		if (publisher != null) {
			publisherRepository.delete(publisher);
		}
	}
	
	public List<SubPublisher> getSubPublishers(Publisher publisher){
		return subPublisherRepository.findByPublisher(publisher);
	}
}

PublisherController

@MenuController(value = "/publisher", item = Item.Publishers)
public class PublisherController {
	
	private PublisherService publisherService;
	private PublisherConverter publisherConverter;
	private SubPublisherConverter subPublisherConverter;
	
	public PublisherController(PublisherService publisherService, PublisherConverter publisherConverter, SubPublisherConverter subPublisherConverter) {
		this.publisherService = publisherService;
		this.publisherConverter = publisherConverter;
		this.subPublisherConverter = subPublisherConverter;
	}

	@GetMapping
	public String newPublisher( Model model) {
		
		PublisherResource publisher = new PublisherResource();
		publisher.setStatus(true);
		//publisher.setSubPublishers(Arrays.stream(publisher));
		
		return showPage(publisher, model);
	}

	protected String showPage(PublisherResource publisher, Model model) {
		
		model.addAttribute("publisherForm", publisher);
		
		return "publishers/publishers-edit";
	}
	
	@PostMapping
	public String createPublisher(@ModelAttribute("publisherForm") @Validated PublisherResource resource, BindingResult result, Model model) {
		if (result.hasErrors()) {
			return showPage(resource, model);
		}
		return savePublisher(0, resource);
	}

	@GetMapping("/{publisherId}")
	public String editPublisher(@PathVariable int publisherId, Model model) {
		
		Publisher publisher = publisherService.getPublisher(publisherId);
		PublisherResource res = publisherConverter.convert(publisher);
		res.setSubPublishers(publisherService.getSubPublishers(publisher).stream()
				.map(s -> subPublisherConverter.convert(s))
				.collect(Collectors.toList())
				);
	
		return showPage(res, model);
	}


	@PostMapping("/{publisherId}")
	public String updatePublisher(@PathVariable int publisherId, @ModelAttribute("publisherForm") @Validated PublisherResource resource, BindingResult result, Model model) {
		if (result.hasErrors()) {
			return showPage(resource, model);
		}
		return savePublisher(publisherId, resource);
	}

	protected String savePublisher(int publisherId, PublisherResource resource) {
		Publisher publisher = populatePublisher(publisherId, resource);
		List<SubPublisher> subPublishers = populateSubPublishers(resource);
		
		if (publisherId == 0) {
			publisherService.createPublisher(publisher, subPublishers);
		} else {
			publisherService.updatePublisher(publisher);
		}

		return "redirect:/publishers";
	}

	protected Publisher populatePublisher(int publisherId, PublisherResource resource) {
		Publisher publisher = null;
		if (publisherId == 0) {
			publisher = new Publisher();
			publisher.setTimeAdded(new Date());
		} else {
			publisher = publisherService.getPublisher(publisherId);
		}
		
		publisher.setPublisherName(resource.getPublisherName());
		publisher.setDescription(resource.getDescription());
		publisher.setStatus(resource.isStatus());
		publisher.setWebsiteURL(resource.getWebsiteURL());

		return publisher;
	}
	
	protected List<SubPublisher> populateSubPublishers(PublisherResource resource){
		if(resource.getSubPublishers() != null){
			return resource.getSubPublishers().stream()
					.map(s -> {
						SubPublisher subPublisher = new SubPublisher();
						subPublisher.setName(s.getName());
						return subPublisher;
					})
					.collect(Collectors.toList());
		}
		return Collections.emptyList();
	}
}

PublishersController

@MenuController(value = "/publishers", item = Item.Publishers)
public class PublishersController {
	
	private PublisherService publisherService;
	private PublisherConverter publisherConverter;
	
	public PublishersController(PublisherService publisherService, PublisherConverter publisherConverter) {
		this.publisherService = publisherService;
		this.publisherConverter = publisherConverter;
	}

	@GetMapping
	public String showPage() {
		return "publishers/publishers";
	}
	
	@PostMapping("/data")
	public @ResponseBody DataTableResponse<PublisherResource> getPublishers(@RequestBody DataTableRequest request) {
		return publisherConverter.convertResponse(publisherService.getPublishers(request));
	}
	
	@DeleteMapping("/{publisherIds}")
	@ResponseStatus(HttpStatus.NO_CONTENT)
	public void deletePublishers(@PathVariable Integer[] publisherIds) {
		for (Integer publisherId: publisherIds) {
			publisherService.deletePublisher(publisherId);
		}
	}
	
	@PutMapping("/{publisherIds}/disable")
	@ResponseStatus(HttpStatus.ACCEPTED)
	public void disablePublishers(@PathVariable Integer[] publisherIds) {
		changeStatus(publisherIds);
	}
	
	@PutMapping("/{publisherIds}/enable")
	@ResponseStatus(HttpStatus.ACCEPTED)
	public void enablePublishers(@PathVariable Integer[] publisherIds) {
		changeStatus(publisherIds);
	}
	
	protected void changeStatus(Integer[] publisherIds) {
		for (Integer publisherId: publisherIds) {
			publisherService.updateStatus(publisherId);
		}
	}
}

PublisherConverter

@Component
public class PublisherConverter  implements ResourceConverter<Publisher, PublisherResource> {
	
	public PublisherResource convert(Publisher publisher) {
		
		PublisherResource resource = new PublisherResource();
		
		resource.setId(publisher.getId());
		resource.setPublisherName(publisher.getPublisherName());
		resource.setDescription(publisher.getDescription());
		resource.setStatus(publisher.isStatus());
		resource.setWebsiteURL(publisher.getWebsiteURL());
		
		return resource;
	}
}

SubPublisherConverter

@Component
public class SubPublisherConverter implements ResourceConverter<SubPublisher, SubPublisherResource> {

	@Override
	public SubPublisherResource convert(SubPublisher subPublisher) {

		SubPublisherResource resource = new SubPublisherResource();
		resource.setName(subPublisher.getName());
		
		return resource;
	}
}

publishers-edit.html

<!DOCTYPE html>
<html lang="en"
	xmlns="http://www.w3.org/1999/xhtml" 
	xmlns:th="http://www.thymeleaf.org"
	xmlns:layout="http://www.ultraq.net.nz/thymeleaf/layout" 
	xmlns:c="http://java.sun.com/jsp/jstl/core"
	layout:decorator="layout">
	
	<body layout:fragment="ui-body">
		<div class="row wrapper border-bottom white-bg page-heading">
			<div class="col-lg-12">
				<h2>Publishers</h2>
				<ol class="breadcrumb">
					<li>
						<a href="/publishers">Publishers</a>
					</li>
					<li class="active">
						<strong th:unless="${publisherForm.id}" >New Publisher</strong>
						<strong th:if="${publisherForm.id}" th:text="${publisherForm.publisherName}">Edit Publisher</strong>
					</li>
				</ol>
			</div>
		</div>
		
		<div class="wrapper wrapper-content">		
			<div class="row">
				<div class="col-lg-12">
					<div class="ibox float-e-margins">
						<div class="ibox-title">
							<h5 th:unless="${publisherForm.id}">New Publisher</h5>
							<h5 th:if="${publisherForm.id}">Edit Publisher</h5>
						</div>
						<div class="ibox-content">
							<form id="publisherForm" th:object="${publisherForm}" method="post" class="form-horizontal">
								<input type="hidden" th:field="*{id}" />
								<div class="row">
									<div class="col-sm-6 b-r">
										<div class="form-group">
											<label class="col-sm-3 control-label">Publisher name: </label>
											<div class="col-sm-9">
												<input th:field="*{publisherName}" type="text" class="form-control" th:maxlength="45"/>
											</div>
										</div>
										<div class="form-group">
											<label class="col-sm-3 control-label">Description: </label>
											<div class="col-sm-9">
												<input th:field="*{description}" type="text" class="form-control" th:maxlength="200"/>
											</div>
										</div>
										<div class="form-group">
											<label class="col-sm-3 control-label">Enabled: </label>
                                    		<div class="col-sm-9">
                                    			<input th:field="*{status}" value="ENABLED" type="checkbox"/>  
	                                    	</div>
                                		</div>
                                		<div class="form-group">
											<label class="col-sm-3 control-label">Website URL: </label>
											<div class="col-sm-9">
												<input th:field="*{websiteURL}" type="text" class="form-control" th:maxlength="50"/>
											</div>
										</div>
										
										<div class="form-group">
											<label class="col-sm-4 control-label">Sub-publishers: </label>
											<div class="col-sm-8 controls" id="profs"  th:each="subPublisher, stat : *{subPublishers}"> 
                								<form class="input-append">
                    								<div id="field">
                    									<input th:field="*{subPublishers[__${stat.index}__].name}" autocomplete="off" class="input form-control" id="field1" name="prof1" type="hidden" data-items="8"/>
                    									<button id="b1" class="btn add-more" type="button">+</button>
                    								</div>
                								</form>
                								<br/>
            								</div>
										</div>
										
										
									</div>										
								</div>
								<div class="row">
									<div class="col-sm-6">	
										<div class="form-group">
											<div class="col-sm-9 col-sm-offset-3">
												<button class="btn btn-primary" type="submit">Save</button>													
												<a class="btn btn-white" th:href="@{/publishers}">Cancel</a>                                       			 
											</div>
										</div>
									</div>
								</div>
							</form>
						</div>
					</div>
				</div>
			</div>			
		</div>	
	</body>
	
	<footer layout:fragment="ui-footer">
		<script th:inline="javascript">
		/*<![CDATA[*/
		    $(document).ready(function() {
		        if($('#allowEdit').val() == "false" &&  $('#allowView').val() == "true") {
		        	$("#publisherForm :input").prop("disabled", "disabled");
				}
		    });
			
		    $(document).ready(function(){
		        var next = 1;
		        $(".add-more").click(function(e){
		            e.preventDefault();
		            var addto = "#field" + next;
		            var addRemove = "#field" + (next);
		            next = next + 1;
		            var newIn = '<input autocomplete="off" class="input form-control" id="field' + next + '" name="field' + next + '" type="text">';
		            var newInput = $(newIn);
		            var removeBtn = '<button id="remove' + (next - 1) + '" class="btn btn-danger remove-me" >-</button></div><div id="field">';
		            var removeButton = $(removeBtn);
		            $(addto).after(newInput);
		            $(addRemove).after(removeButton);
		            $("#field" + next).attr('data-source',$(addto).attr('data-source'));
		            $("#count").val(next);  
		            
		                $('.remove-me').click(function(e){
		                    e.preventDefault();
		                    var fieldNum = this.id.charAt(this.id.length-1);
		                    var fieldID = "#field" + fieldNum;
		                    $(this).remove();
		                    $(fieldID).remove();
		                });
		        }); 
		    });
			 
		/*]]>*/ 
        </script>	
	</footer>
</html>

Problems are:
1. When i open form for adding new publisher there is no fields for adding subpublishers.
2. If i add manually publisher and subpublisher in database and when i try edit them ther is subpublisher field but they are empty, it doesn't list subpublishers that are in database.
3. In PublisherController i don't know how to setSubPublishers.

It would be great if someone can help me with these problems.
Thanks