package com.cn.lnz.dao;
import java.util.List;
import javax.annotation.Resource;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import com.cn.lnz.model.User;
@Repository("userJdbcDao")
public class UserDao implements IUserDao
{
private JdbcTemplate jdbcTemplate;
// public void setJdbcTemplate(jdbcTemplate jdbcTemplate)
// {
// this.jdbcTemplate = jdbcTemplate;
// }
@Resource
public void setDateSource(DataSource dataSource)
{
jdbcTemplate = new JdbcTemplate(dataSource);
}
@Override
public void add(User user)
{
//error1: value ---> values
//error2: params
// jdbcTemplate.update("insert into t_user(id, username, password, nickname) value(?, ?, ?, ?)", user.getUsername(), user.getPassword(), user.getNickname());
// 新增的SQL语句
String sqlInsert = "INSERT INTO t_user(id, username, password, nickname) VALUES(?, ?, ?, ?)";
// SQL中参数
int id = user != null ? user.getId() : -1;
String username = user != null ? user.getUsername() : "";
String password = user != null ? user.getPassword() : "";
String nickname = user != null ? user.getNickname() : "";
// 执行SQL
jdbcTemplate.update(sqlInsert, id, username, password, nickname);
}
@Override
public void update(User user)
{
}
@Override
public void delete(int id)
{
}
@Override
public User load(int id)
{
return null;
}
@Override
public List<User> list(String sql)
{
return null;
}
}