userdao.java

package dao;
import java.sql.ResultSet;
import java.sql.SQLException;

import entity.User;
import util.RowMapper;
import util.DBHelp;
public class UserDao {
private DBHelp db = new DBHelp();
public User findByName(String name){
String sql = “select id,username,password from t_user where username=?” ;
return db.executeQueryForObject(sql,new UserRowMapper(),name);
}
private class UserRowMapper implements RowMapper{
public User mapRow(ResultSet rs) throws SQLException {
User u = new User();
u.setId(rs.getInt(“id”));
u.setUsername(rs.getString(“username”));
u.setPassword(rs.getString(“password”));
return u;
}
}
}