写了两个数据获得方式----费劲周折

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;
}

}