实训笔记7

注册功能
public interface UserDao {
void addUser(User user);
void getUser(String name,String pass);

}

public class UserDaoImpl implements UserDao {
private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDs());
public void addUser(User user) {
String sql = “insert into user values (null,?,?)”;
template.update(sql, user.getName(), user.getPass());
}
public void getUser(String name,String pass) {
String sql = "select * from user where name=? ";
template.query(sql, new BeanPropertyRowMapper(User.class), name,pass);
}
}

public class RegServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding(“UTF-8”);
String name = request.getParameter(“username”);
String pas = request.getParameter(“pass”);
User user = new User(null, name, pas);
System.out.println(user);
UserDao dao = new UserDaoImpl();
dao.addUser(user);
request.setAttribute(“msg”, user.getName())
request.getRequestDispatcher(“login.jsp”).forward(request, response);
}