com.recber.dao.UserDaoImpl.java Source code

Introduction

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

import java.util.ArrayList;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import com.recber.domain.User;
import com.recber.jdbc.UserRowMapper;

/**
 *
 * @author recber
 */
public class UserDaoImpl implements UserDao {

    @Autowired
    DataSource dataSource;

    @Override
    public void insertData(User user) {

        String sql = "INSERT INTO user " + "(first_name,last_name, face, city) VALUES (?, ?, ?,?)";

        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

        jdbcTemplate.update(sql,
                new Object[] { user.getFirstName(), user.getLastName(), user.getFace(), user.getCity() });

    }

    @Override
    public List<User> getUserList() {
        List userList = new ArrayList();

        String sql = "select * from user";

        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        userList = jdbcTemplate.query(sql, new UserRowMapper());
        return userList;
    }

    @Override
    public void deleteData(String id) {
        String sql = "delete from user where user_id=" + id;
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        jdbcTemplate.update(sql);

    }

    @Override
    public void updateData(User user) {

        String sql = "UPDATE user set first_name = ?,last_name = ?, face = ?, city = ? where user_id = ?";
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

        jdbcTemplate.update(sql, new Object[] { user.getFirstName(), user.getLastName(), user.getFace(),
                user.getCity(), user.getUserId() });

    }

    @Override
    public User getUser(String id) {
        List<User> userList = new ArrayList<User>();
        String sql = "select * from user where user_id= " + id;
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        userList = jdbcTemplate.query(sql, new UserRowMapper());
        return userList.get(0);
    }

}