用户使用过程中一定需要取消关注等功能,首先后端实现数据库关注表的修改,添加DAO方法:
@Override
public int deleteFollow(String user_name, String follow_name) {
Connection conn=getConnection();
String sql="";
PreparedStatement pstmt;
sql="DELETE FROM follow WHERE user_name = ? AND follow_name = ?";
try{
pstmt=conn.prepareStatement(sql);
pstmt.setString(1, user_name);
pstmt.setString(2, follow_name);
return pstmt.executeUpdate();
}catch(SQLException e){
e.printStackTrace();
return 0;
}finally{
closeConnection(conn);
}
}
servlet,实现得到前端传来的数据,根据数据更改数据库:
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
resp.setCharacterE