package com.neuq.control; //视图层
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.neuq.dao.UserDao;
import com.neuq.service.UserService;
import com.neuq.vo.UserVO;
public class UserManage extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
this.doPost(request, response);
}
//增加用户
public void addUser(HttpServletRequest request, HttpServletResponse response)
//获取客户端传进来的数据
String telephone
= (String)request.
getParameter("telephone");
UserVO user = new UserVO(); //建立一个实例,利用控制层
user.setUserName(userName);
user.setPassword(password);
user.setSex(sex);
user.setHobby(hobby);
user.setEmail(email);
user.setTelephone(telephone);
user.setProvince(province);
UserService userService = new UserService();
int resultCount=userService.addUser(user);
if(resultCount<=0){
request.setAttribute("info","添加失败!" );
}else{
request.setAttribute("info", "添加成功!");
}
request.getRequestDispatcher("../info.jsp").forward(request, response);//请求转发
}
//删除用户
public void deleteUser(HttpServletRequest request,
String userName
= request.
getParameter("userName");
UserService userService = new UserService();
boolean flag =userService.deleteUser(userName);
if (flag) {
request.setAttribute("info", "删除数据成功!");
} else {
request.setAttribute("info", "删除数据失败!");
}
try {
request.getRequestDispatcher("../info.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//查询用户
public void selectUser(HttpServletRequest request,
HttpServletResponse response
) throws ServletException,
IOException {
UserDao userDao = new UserDao();
List list
= (List)userDao.
getUsers(userName
);
request.setAttribute("result", list);
request.getRequestDispatcher("../ShowMessage.jsp").forward(request, response);
}
//修改用户
public void updateUser(HttpServletRequest request, HttpServletResponse response)
String telephone
= (String)request.
getParameter("telephone");
UserVO user = new UserVO(); //建立一个实例,利用控制层
user.setUserName(userName);
user.setPassword(password);
user.setSex(sex);
user.setHobby(hobby);
user.setEmail(email);
user.setTelephone(telephone);
user.setProvince(province);
UserService userService = new UserService();
int resultCount=userService.updateUser(user);
if(resultCount<=0){
request.setAttribute("info", "修改数据失败!");
}else{
request.setAttribute("info", "修改数据成功!");
}
try {
request.getRequestDispatcher("../info.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
try {
if("add".equals(method)){
addUser(request,response);
}else if("select".equals(method)){
selectUser(request,response);
}else if("update".equals(method)){
updateUser(request,response);
}else if("delete".equals(method)){
deleteUser(request,response);
}
e.printStackTrace();
}
}
}
//java/1344