UpdateUserInfoVO

package com.ttc.eshop.dao;

import java.sql.*;
import java.util.*;


import javax.swing.text.html.HTMLDocument.HTMLReader.PreAction;


import com.ttc.eshop.utils.DBConnection;
import com.ttc.eshop.vo.UserInfoVO;
public class UpdateUserInfoVODao {
public boolean updateUserInfo(UserInfoVO userInfoVO){
String sql = "UPDATE Eshop_UserInfo SET LoginPwd=?,Name=?,BirthDate=?,Phone=?,Address=?,ZipCode=?,Email=? WHERE id="+userInfoVO.getId();
DBConnection dbConnection = new DBConnection();
Connection connection = dbConnection.getConnection();
try {
PreparedStatement pStatement = connection.prepareStatement(sql);
// pStatement.setInt(1,78);
pStatement.setString(1,userInfoVO.getLoginPwd());
pStatement.setString(2,userInfoVO.getName());
pStatement.setDate(3,userInfoVO.getBirthDate());
pStatement.setString(4,userInfoVO.getPhone());
pStatement.setString(5,userInfoVO.getAddress());
pStatement.setString(6,userInfoVO.getZipCode());
pStatement.setString(7,userInfoVO.getEmail());
pStatement.executeUpdate();
dbConnection.close();
if(pStatement!=null)
pStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
return true;
    }

}

2

package com.ttc.eshop.service;


import com.ttc.eshop.dao.RegisterUserInfoVODao;
import com.ttc.eshop.dao.UpdateUserInfoVODao;
import com.ttc.eshop.vo.UserInfoVO;


public class UpdateUserInfoService {
public boolean updateUserInfo(UserInfoVO userInfoVO){
boolean isSuccess = false;
UpdateUserInfoVODao  updateUserInfoDao = new UpdateUserInfoVODao();
if(updateUserInfoDao.updateUserInfo(userInfoVO)==true)
isSuccess = true;
return isSuccess;
}
}

3

package com.ttc.eshop.controller;


import java.io.IOException;
import java.sql.Date;


import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import com.ttc.eshop.service.UpdateUserInfoService;
import com.ttc.eshop.vo.UserInfoVO;


public class UpdateUserInfoVOServlet extends HttpServlet {


public UpdateUserInfoVOServlet() {
super();
}
public void destroy() {
super.destroy(); 
System.out.println("UpdateUserInfoServlet销毁");
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {


response.setContentType("text/html;charset=UTF-8");
//request.setCharacterEncoding("UTF-8");----使用了字符编码过滤器
int id = Integer.parseInt(request.getParameter("id"));
String loginName = request.getParameter("loginName");
String loginPwd = request.getParameter("loginPwd");
String name = request.getParameter("name");
String birthDate =  request.getParameter("birthDate");
String phone =  request.getParameter("phone");
String address =   request.getParameter("address");
String zipCode =  request.getParameter("zipCode");
String email =   request.getParameter("email");

/**用户名一般不能修改*/
UserInfoVO userInfoVO = new UserInfoVO();
userInfoVO.setId(id);
userInfoVO.setLoginPwd(loginPwd);
userInfoVO.setName(name);
userInfoVO.setBirthDate(Date.valueOf(birthDate));
userInfoVO.setPhone(phone);
userInfoVO.setAddress(address);
userInfoVO.setZipCode(zipCode);
userInfoVO.setEmail(email);
System.out.println(id + " " + loginPwd + " " + name + " " +birthDate + " " + address + " " +zipCode + " " + email);

UpdateUserInfoService updateUserInfoService = new UpdateUserInfoService();
if(updateUserInfoService.updateUserInfo(userInfoVO)==true)
{
/**一次跳转有效，因为页面的缓存的原因，先用request范围，页面参数有变化，不受缓存影响*/
request.setAttribute("loginName",userInfoVO.getLoginName());
request.setAttribute("loginPwd",userInfoVO.getLoginPwd());
request.setAttribute("name",userInfoVO.getName());
request.setAttribute("birthDate",userInfoVO.getBirthDate());
request.setAttribute("phone",userInfoVO.getPhone());
request.setAttribute("address",userInfoVO.getAddress());
request.setAttribute("zipCode",userInfoVO.getZipCode());
request.setAttribute("email",userInfoVO.getEmail());
/**session范围用户不安全退出时信息都有效，*/
request.getSession().setAttribute("userInfo", userInfoVO);
request.getRequestDispatcher("/edit_userInfoVO_success.jsp").forward(request, response);
}else{
request.getRequestDispatcher("/edit_userInfoVO_error.jsp").forward(request, response);
}
}


public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}


public void init() throws ServletException {
System.out.println("UpdateUserInfoServlet初始化");
}

}

4

package com.ttc.eshop.controller;


import java.io.IOException;
import java.io.PrintWriter;


import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


import com.ttc.eshop.service.LoginUserInfoVOService;
import com.ttc.eshop.vo.UserInfoVO;


public class EditUserInfoVOServlet extends HttpServlet {


public EditUserInfoVOServlet() {
super();
}


public void destroy() {
super.destroy(); 
System.out.println("EditUserInfoServlet销毁");
}


public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {


response.setContentType("text/html;charset=UTF-8");
//request.setCharacterEncoding("UTF-8");----使用了字符编码过滤器
String loginName = request.getParameter("loginName");
HttpSession session = request.getSession();
System.out.println(loginName +"跳转修改信息页面");
LoginUserInfoVOService loginUserInfoVOService = new LoginUserInfoVOService();
UserInfoVO userInfoVO = loginUserInfoVOService.loginbyLoginName(loginName);
if(loginName != null){
session.setAttribute("userInfoVO", userInfoVO);
request.getRequestDispatcher("/edit_userInfoVO.jsp").forward(request, response);
}else{
request.getRequestDispatcher("/edit_userInfoVO_error.jsp").forward(request, response);
}
}


public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}


public void init() throws ServletException {
System.out.println("EditUserInfoServlet初始化");
}


}