package cn.lijun.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import cn.lijun.domain.User;
public class UserDaoIml extends JdbcDaoSupport implements UserDao {
@Override
public void save(User u) {
String sql="insert into user values(null,?)";
super.getJdbcTemplate().update(sql, u.getName());
}
@Override
public void delete(Integer id) {
// TODO Auto-generated method stub
}
@Override
public void update(User u) {
// TODO Auto-generated method stub
}
@Override
public User getById(Integer id) {
String sql="select * from user where id=?";
return super.getJdbcTemplate().queryForObject(sql, new RowMapper<User>(){
public User mapRow(ResultSet rs,int ag1) throws SQLException{
User u = new User();
u.setId(rs.getInt("id"));
u.setName(rs.getString("name"));
return u;
}
},id);
}
@Override
public int getTotalCount() {
// TODO Auto-generated method stub
return 0;
}
@Override
public List<User> getAll() {
// TODO Auto-generated method stub
return null;
}
}