/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.transtracking.dao.impl;

import com.bestray.transtracking.dao.UserDao;
import com.bestray.transtracking.dao.mapper.UserResultSetExtractor;
import com.bestray.trastrack.domain.User;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;

/**
 *
 * @author Girija Sahu
 */
public class UserDaoImpl implements UserDao {
    private JdbcTemplate jdbcTemplate;
    
    public UserDaoImpl(DataSource ds) { 
          jdbcTemplate = new JdbcTemplate(ds);
    }
   
  
    public User authorizedUser(String userName, String password)throws Exception{
        
        User user = (User) jdbcTemplate.query("select * FROM account where username = ? and password =?",new Object[] { userName,password },new UserResultSetExtractor());
        return user;
        
    }
    
    public void saveUser(User user)throws Exception{
          
         String sql = "insert into account (username,password,first_name,last_name,question,answer) values (?,?,?,?,?,?)";
                 jdbcTemplate.update(sql, user.getUserName(), user.getPassword(), user.getFirstName(), user.getLastName(),user.getQuestion(),user.getAnswer() );
    }
    
}