com.traveltainment.itea.bernat.contactwebapp.mvcmodel.jpa.ContactRepository.java Source code

Introduction

Here is the source code for com.traveltainment.itea.bernat.contactwebapp.mvcmodel.jpa.ContactRepository.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.traveltainment.itea.bernat.contactwebapp.mvcmodel.jpa;

import com.traveltainment.itea.bernat.contactwebapp.mvcmodel.Contact;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;

/**
 *
 * @author Bernat
 */
@Repository
public class ContactRepository {
    private final JdbcTemplate jdbc;

    @Autowired
    public ContactRepository(final JdbcTemplate jdbc) {
        this.jdbc = jdbc;
    }

    public List<Contact> findAll() {
        return jdbc.query(
                "select id, firstName, lastName, phoneNumber, emailAddress " + "from contacts order by lastName",
                (ResultSet rs, int rowNum) -> {
                    Contact contact = new Contact();
                    contact.setId(rs.getLong(1));
                    contact.setFirstName(rs.getString(2));
                    contact.setLastName(rs.getString(3));
                    contact.setPhoneNumber(rs.getString(4));
                    contact.setEmailAddress(rs.getString(5));
                    return contact;
                });
    }

    public void save(final Contact contact) {
        jdbc.update(
                "insert into contacts " + "(firstName, lastName, phoneNumber, emailAddress) " + "values (?,?,?,?)",
                contact.getFirstName(), contact.getLastName(), contact.getPhoneNumber(), contact.getEmailAddress());
    }

}