用自己的电脑做网站需要备案吗,网站建设部署视频教程,好医生网站继续教育网,wordpress的用户分利用java如何实现在删除信息后刷新页面功能发布时间#xff1a;2020-11-17 14:25:49来源#xff1a;亿速云阅读#xff1a;74作者#xff1a;Leah这篇文章给大家介绍利用java如何实现在删除信息后刷新页面功能#xff0c;内容非常详细#xff0c;感兴趣的小伙伴们可以参考…利用java如何实现在删除信息后刷新页面功能发布时间2020-11-17 14:25:49来源亿速云阅读74作者Leah这篇文章给大家介绍利用java如何实现在删除信息后刷新页面功能内容非常详细感兴趣的小伙伴们可以参考借鉴希望对大家能有所帮助。我就废话不多说了大家还是直接看代码吧~//执行的是删除信息的操作String arequest.getParameter(name);a URLEncoder.encode(a, ISO-8859-1);String name URLDecoder.decode(a, UTF-8);String numrequest.getParameter(num);System.out.println(name:namenum:num);String sqldelete from person_info where name? and num?;String sz[]{name,num};JdbcUtils.update(sql, sz);//刷新操作String sqlsselect * from person_info;ResultSet rsJdbcUtils.select(sqls, null);ArrayList listnew ArrayList();try {while(rs.next()){Person_info pinew Person_info(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6));list.add(pi);}request.setAttribute(list, list);request.getRequestDispatcher(Personnel_definition.jsp).forward(request, response);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}补充知识关于分页时怎么实现当本页面最后一条记录被删除时,自动向上一个页面跳转的实现(java实现)##问题详解在做批量删除时发现若批量删除整页时会自动跳到第一页首页而不是返回删除当前页的上一页不符合产品要求且使界面交互不好给用户带来糟糕体验。##思路详解在controller层传参时要考虑到不仅要传入需要删除的id集合同时传入pageSize,pageNum以及总条数集合的查询条件(如本示例会传入groupId(分组id)),在删除成功后初始化当前页先根据查询条件查询出总条数数量在pageSize不等于null或为0的情况下。算出余数[(pageSize*pageNum-count)%pageSize ].若余数为0则当前页等于pageNum-1;若余数不为0则当前页pageNum.将结果当前页传给前台即可。##后台代码实现#controller层#Api(description 分组下的学生,value 分组下的学生)RestControllerRequestMapping(studentGroup)public class StudentGroupController {Autowiredprivate RestStudentGroupService restStudentGroupService;RequestMapping(value deleteGroupStudent,method RequestMethod.POST)ApiOperation(value 删除分组中的学生,notes 删除分组中的学生)public ResponseObj deleteGroupStudent(RequestParam(value groupId,required true)Long groupId,RequestParam(value ids,required true)String ids,RequestParam(value pageSize,required false)Integer pagesize,RequestParam(value pageNum,required false)Integer pageNum){return restStudentGroupService.deleteGroupStudent(groupId,ids,pagesize,pageNum);}}#service层#FeignClient(value ServiceName.VALUE)public interface RestStudentGroupService {RequestMapping(value /school/cloud/student/deleteGroupStudent,method RequestMethod.POST)public ResponseObj deleteGroupStudent(RequestParam(value groupId)Long groupId,RequestParam(value ids)String ids,RequestParam(value pageSize)Integer pagesize,RequestParam(value pageNum)Integer pageNum);}#serviceImpl层#Servicepublic class RestStudentGroupServiceImpl implements RestStudentGroupService {Autowiredprivate DubboStudentGroupService dubboStudentGroupService ;Overridepublic ResponseObj deleteGroupStudent(Long groupId,String ids,Integer pageSize,Integer pageNum) {List idList TextUtils.split(ids);if(groupId null || idList null || idList.size() 0){ResponseObj responseObj ResponseObj.ERROR(参数错误);responseObj.setSuccess(true);return responseObj;}ServiceResult serviceResult dubboStudentGroupService .deleteCorpGroup(idList, groupId);if(!serviceResult.getSuccess()){throw new RuntimeException(分组下学生查询失败);}//应前端要求加此dto封装传给前台的当前页属性CurrenPageDto currenPageDtonew CurrenPageDto();//初始化当前页Integer currentPage 1;//查出该分组id下的学生数量ServiceResult itemCountLongs dubboStudentGroupService.getTotalCount(groupId);Long itemCountLong itemCountLongs.getResult();Integer itemCount itemCountLong!null ? itemCountLong.intValue() : 0;//查询到学生数量{},pageSize:{}, itemCount,pageSize;if(pageSize ! null pageSize ! 0){//算出余数Integer temp (pageNum*pageSize-itemCount)%pageSize;if(temp 0){//余数为0的话就pageNum-1currentPage (pageNum - 1) 0 ? 1 : (pageNum -1) ;}else {//余数不为0则等于pageNumcurrentPage pageNum;}currenPageDto.setPresentPage(currentPage);}ResponseObj responseObj ResponseObj.SUCCESS();responseObj.setData(currenPageDto);return responseObj;}}#dubbo接口的service层#①//删除分组下的学生ServiceResult deleteCorpGroup(List idList,Long groupId);②//根据条件查询对应的条目总数ServiceResult getTotalCount(Long groupId);#dubbo接口的serviceImpl层#①//删除分组下的学生Overridepublic ServiceResult deleteCorpGroup(List idList, Long groupId) {ServiceResult result new ServiceResult();try {studentGroupDao.deleteCorpGroup(idList, groupId);} catch (Exception e) {log.error(调用{}方法 异常, [RestStudentGroupServiceImpl .deleteCorpGroup]);log.error(方法使用参数[idList:{},groupId:{}], idList, groupId);log.error(异常信息{}, e);result.setErrMessage(调用deleteCorpGroup方法异常异常信息 e.getMessage());}return result;}②//根据条件查询对应的条目总数Overridepublic ServiceResult getTotalCount(Long groupId) {ServiceResult result new ServiceResult();try {long count studentGroupDao.getFindCorpGroupDirectoryCount(groupId);result.setResult(count);} catch (Exception e) {log.error(调用{}方法 异常, [RestStudentGroupServiceImpl .getTotalCount]);log.error(方法使用参数[groupId:{}], groupId);log.error(异常信息{}, e);result.setErrMessage(调用getTotalCount方法异常异常信息 e.getMessage());}return result;}#dubbo接口的dao层#①//删除分组下的学生Long deleteCorpGroup(Param(value idList) List idList,Param(value groupId) Long groupId);②//根据条件查询对应的条目总数Long getFindCorpGroupDirectoryCount(Param(value groupId) Long groupId);#dubbo接口的sql#①//删除分组下的学生delete from student_group where group_id #{groupId} and id inopen( close)#{id}②//根据条件查询对应的条目总数SELECT COUNT(1)FROM student_groupwhere group_id #{groupId}#Entity类(学生分组类)#(get,set函数省略)public class StudentGroup implements java.io.Serializable {/****/private static final long serialVersionUID 1L;/*** 描述:* 字段:id BIGINT(19)*/private Long StudentGroupId;/*** 描述:* 字段:group_id BIGINT(19)*/private Long groupId;/*** 描述:* 字段:id BIGINT(19)* 此id为学生表id*/private Long id;/*** 描述:创建时间* 字段:create_time DATETIME(19)*/private java.util.Date createTime;* 描述:创建人用户名* 字段:create_user_name VARCHAR(30)*/private String createUserName;/*** 描述:创建人用户ID* 字段:create_user_id BIGINT(19)*/private Long createUserId;/*** 描述:更新时间* 字段:update_time DATETIME(19)*/private java.util.Date updateTime;* 描述:更新人用户名* 字段:update_user_name VARCHAR(30)*/private String updateUserName;/*** 描述:更新人用户ID* 字段:update_user_id BIGINT(19)*/private Long updateUserId;}#Entity类(学生类)#(get,set函数省略)public class Student implements java.io.Serializable {/****/private static final long serialVersionUID 1L;private Long id;private String name ;private Integer age;}关于利用java如何实现在删除信息后刷新页面功能就分享到这里了希望以上内容可以对大家有一定的帮助可以学到更多知识。如果觉得文章不错可以把它分享出去让更多的人看到。
