DAT -- RegisterDao

package register;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCallback;
import org.springframework.jdbc.core.ResultSetExtractor;

public class RegisterDao implements IRegister{
private JdbcTemplate jdbcTemplate;

public void setJdbcTemplate(JdbcTemplate jdbcTemplate){
this.jdbcTemplate=jdbcTemplate;
}
public boolean saveUser(final RegisterPojo r)
{
String query = "insert into userdetails values(?,?,?,?,?,?)";
return jdbcTemplate.execute(query,new PreparedStatementCallback<Boolean>(){
@Override
public Boolean doInPreparedStatement(PreparedStatement ps)
throws SQLException, DataAccessException {
ps.setString(1, r.getFirstName());
ps.setString(2,r.getLastName());
ps.setString(3, r.getEid());
ps.setString(4,r.getPwd());
ps.setString(5, r.getDob());
ps.setString(6, r.getGender());
return ps.execute();
}
});
}
public int updateUser(RegisterPojo r)
{
String query = "update userdetails set firstName='"+r.getFirstName()+"',lastName='"+r.getLastName()+"',eid='"+r.getEid()+"',pwd='"+r.getPwd()+"',dob='"+r.getDob()+"',gender='"+r.getGender()+"' where eid='"+r.getEid()+"' ";

return jdbcTemplate.update(query);
}
public int deleteUser(RegisterPojo r )
{
String query="delete from userdetails where eid='"+r.getEid()+"'";
return jdbcTemplate.update(query);
}
public List<RegisterPojo> getDetails(){
return jdbcTemplate.query("select firstName,lastName,dob,gender from userdetails", new ResultSetExtractor<List<RegisterPojo>>(){

@Override
public List<RegisterPojo> extractData(ResultSet rs)
throws SQLException, DataAccessException {
List<RegisterPojo> list = new ArrayList<RegisterPojo>();
while(rs.next()){
RegisterPojo rp = new RegisterPojo();
rp.setFirstName(rs.getString(1));
rp.setLastName(rs.getString(2));
rp.setDob(rs.getString(3));
rp.setGender(rs.getString(4));
list.add(rp);
return list;

}

return null;
}



});


};

}