com.beezas.dao.ContactDaoImpl.java Source code

Introduction

Here is the source code for com.beezas.dao.ContactDaoImpl.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.beezas.dao;

import java.util.List;
import com.beezas.dao.Contact;
import java.util.ArrayList;
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.jdbc.core.JdbcTemplate;
import com.beezas.dao.ContDrpDwnRowMapper;

/**
 *
 * @author HP
 */
@Repository("contactDao")
public class ContactDaoImpl implements ContactDao {

    JdbcTemplate jdbcTemplate;
    @Autowired
    DataSource dataSource;

    @Override
    public void insertData(Contact contact) {
        if (contact.getId() > 0) {
            // This is for updating data
            String sql = "UPDATE contact SET MEDIA_NAME=?, CTYPE_NAME=?, EMAIL=?, EVENT_DISPLAY=?, CONTACT_FIRST_NAME=?,"
                    + "CONTACT_LAST_NAME=?, CONTACT_EMAIL=?, CONTACT_PHNO=? WHERE ID=?";
            jdbcTemplate.update(sql, contact.getMedianame(), contact.getContacttypename(), contact.getEmail(),
                    contact.getEventDisplay(), contact.getFname(), contact.getLname(), contact.getContactemail(),
                    contact.getPhonenumber(), contact.getId());
        } else {

            //This is for inserting data
            String sql = "INSERT INTO CONTACT(ID, MEDIA_NAME, CTYPE_NAME, EMAIL, EVENT_DISPLAY, CONTACT_FIRST_NAME,"
                    + " CONTACT_LAST_NAME, CONTACT_EMAIL, CONTACT_PHNO)" + "VALUES(seq_id.nextval,?,?,?,?,?,?,?,?)";

            jdbcTemplate = new JdbcTemplate(dataSource);
            jdbcTemplate.update(sql,
                    new Object[] { contact.getMedianame(), contact.getContacttypename(), contact.getEmail(),
                            contact.getEventDisplay(), contact.getFname(), contact.getLname(),
                            contact.getContactemail(), contact.getPhonenumber() });

        }
    }

    @Override
    public List<ContDrpDwns> getMediaNam() {
        List mediaNam = new ArrayList();
        String sql = "SELECT * FROM MEDIA";
        jdbcTemplate = new JdbcTemplate(dataSource);
        mediaNam = jdbcTemplate.query(sql, new ContDrpDwnRowMapper());
        System.out.println("Present in DaoImpl mediavalues " + mediaNam);
        return mediaNam;
    }

    @Override
    public List<ContDrpDwns> getContactTyp() {
        List contactNam = new ArrayList();
        String sql = "SELECT * FROM CONTACTTYPE";
        jdbcTemplate = new JdbcTemplate(dataSource);
        contactNam = jdbcTemplate.query(sql, new ContDrpDwnRowMapper());
        System.out.println("Present in DaoImpl conttyp values " + contactNam);
        return contactNam;
    }

    public List<Contact> getContactList() {
        List entireNam = new ArrayList();
        String sql = "SELECT * FROM CONTACT";
        jdbcTemplate = new JdbcTemplate(dataSource);
        entireNam = jdbcTemplate.query(sql, new ContactRowMapper());
        System.out.println("Present in DaomImpl mottam contact" + entireNam);
        return entireNam;
    }

    @Override
    public void deleteContact(int id) {
        String sql = "DELETE FROM CONTACT WHERE ID=?"; //WE ARE USING PRIMARY-KEY(ID) FROM CONTACT TABLE
        jdbcTemplate = new JdbcTemplate(dataSource);
        jdbcTemplate.update(sql, id);
    }

}