package com.cn.stephen.springbatch2.dao;

import java.sql.PreparedStatement;
import java.sql.SQLException;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementSetter;
import org.springframework.stereotype.Repository;

import com.cn.stephen.springbatch2.model.User;

@Repository
public class UserDaoImpl implements IUserDao {

	private static final String SAVE_SQL = "insert into tuser_temp(username,sex,birthday,email)" + "values(?,?,?,?)";
	@Autowired
	private JdbcTemplate jdbcTemplate;

	public void saveUser(final User user) {
		jdbcTemplate.update(SAVE_SQL, new PreparedStatementSetter() {
			public void setValues(PreparedStatement pst) throws SQLException {
				pst.setString(1, user.getName());
				pst.setString(2, user.getSex());
				pst.setDate(3, new java.sql.Date(user.getBirthday().getTime()));
				pst.setString(4, user.getEmail());
			}
		});
	}
}