package com.tcs.ignite.dao;

import com.tcs.ignite.bean.User;
import com.tcs.ignite.connection.Connectiondetails;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author ignite234
 */
public class UserDAO {

    private Connectiondetails connectionDetails;

    public UserDAO() {
        connectionDetails = new Connectiondetails();
    }

    public boolean saveDetails(User user) {
        connectionDetails.openConnection();
        String query2 = "select * from user where Email_id like '%" + user.getEmail() + "%'";
        try {
            ResultSet resultSet = connectionDetails.statement.executeQuery(query2);
            if(resultSet.next()) {
                return false;
            }
        } catch (SQLException ex) {
            Logger.getLogger(UserDAO.class.getName()).log(Level.SEVERE, null, ex);
        }
        String query = "insert into user (Name,Email_id,Password,Gender,Hobby,City) values('" + user.getName() + "','" + user.getEmail() + "','" + user.getPassword() + "','" + user.getGender() + "','" + user.getHobby() + "','"+user.getCity()+"');";
        try {
            int result = connectionDetails.statement.executeUpdate(query);
            if (result == 0) {
                return false;
            }
        } catch (SQLException ex) {
            Logger.getLogger(UserDAO.class.getName()).log(Level.SEVERE, null, ex);
            return false;
        } finally {
            connectionDetails.closeConnection();
        }
        return true;
    }