/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html; charset=UTF-8");
request.setCharacterEncoding("UTF-8");
// 取得自己的User对象
User signinUser = (User) request.getSession().getAttribute("SigninUser");
if (signinUser == null) {
response.sendRedirect("./jsp/index.jsp");
return;
}
// 取得被关注者的User ID
int userId = Integer.parseInt(request.getParameter("uid"));
UserRelationDAOImpl urdi = new UserRelationDAOImpl();
try {
if (urdi.unFollow(signinUser.getUID(), userId) == false) {
request.setAttribute("UnFollowMsg", "UnFollow Faild!");
request.getRequestDispatcher("./jsp/result.jsp").forward(request, response);
return;
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
request.setAttribute("UnFollowMsg", "UnFollow success!");
request.getRequestDispatcher("./jsp/result.jsp").forward(request, response);
/*
* 根据uid1，uid2
* unFollow（）删除记录
*/
}
@Override
public User signin(String email, String password) throws Exception {
// TODO Auto-generated method stub
// 连接数据库
DatabaseConnection dbc = new DatabaseConnection();
Connection conn = dbc.getConnection();
PreparedStatement pStatement = null;
// 声明变量用于存取结果
User user = new User();
// 搜索语句
String query = "select * from user where email= ? and password= ?";
try {
// 执行搜索
pStatement = conn.prepareStatement(query);
pStatement.setString(1, email);
pStatement.setString(2, password);
ResultSet rs = pStatement.executeQuery();
while (rs.next()) {
user.setMBID(rs.getInt("MBID"));
user.setFullName(rs.getString("FullName"));
user.setAvatarUrl(rs.getString("AvatarUrl"));
user.setEmail(rs.getString("Email"));
user.setPassWord(rs.getString("PassWord"));
user.setUID(rs.getInt("UID"));
}
// 判断是否为空
if (user.getUID() != 0) {
System.out.println("Signin Successfully!");
} else {
System.out.println("Signin Faild!");
user = null;
}
// 关闭连接，返回结果
// rs.close();
dbc.close();
return user;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public User updateProfile(User user) throws Exception {
// TODO Auto-generated method stub
// 连接数据库
DatabaseConnection dbc = new DatabaseConnection();
Connection conn = dbc.getConnection();
PreparedStatement pStatement = null;
// 声明变量用于存取结果
User updatedUser = new User();
// 搜索语句
String query =
"UPDATE user SET Email = ?, FullName = ?, AvatarUrl = ?, Password = ? " + "WHERE uid = ?";
try {
// 执行搜索
pStatement = conn.prepareStatement(query);
pStatement.setString(1, user.getEmail());
pStatement.setString(2, user.getFullName());
pStatement.setString(3, user.getAvatarUrl());
pStatement.setString(4, user.getPassWord());
pStatement.setInt(5, user.getUID());
int row = pStatement.executeUpdate();
// 判断是否为空
if (row > 0) {
updatedUser = user;
System.out.println("updateProfile Successful!");
} else {
System.out.println("updateProfile No record satisfied!");
user = null;
}
// 关闭连接，返回结果
// rs.close();
dbc.close();
return updatedUser;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
