我就廢話不多說了，大家還是直接看代碼吧~

//執(zhí)行的是刪除信息的操作 String a=request.getParameter('name'); a = URLEncoder.encode(a, 'ISO-8859-1'); String name = URLDecoder.decode(a, 'UTF-8'); String num=request.getParameter('num'); System.out.println('name:'+name+'num:'+num); String sql='delete from person_info where name=? and num=?'; String sz[]={name,num}; JdbcUtils.update(sql, sz); //刷新操作 String sqls='select * from person_info'; ResultSet rs=JdbcUtils.select(sqls, null); ArrayList<Person_info> list=new ArrayList<Person_info>(); try { while(rs.next()){ Person_info pi=new 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 block e.printStackTrace(); } }

補充知識：關(guān)于分頁時怎么實現(xiàn)當本頁面最后一條記錄被刪除時,自動向上一個頁面跳轉(zhuǎn)的實現(xiàn)（java實現(xiàn)）

##問題詳解

在做批量刪除時，發(fā)現(xiàn)若批量刪除整頁時，會自動跳到第一頁首頁，而不是返回刪除當前頁的上一頁，不符合產(chǎn)品要求且使界面交互不好，給用戶帶來糟糕體驗。

##思路詳解

在controller層傳參時要考慮到不僅要傳入需要刪除的id集合，同時傳入pageSize,pageNum以及總條數(shù)集合的查詢條件（如：本示例會傳入groupId(分組id)）,在刪除成功后初始化當前頁，先根據(jù)查詢條件查詢出總條數(shù)數(shù)量，在pageSize不等于null或為0的情況下。算出余數(shù)[（pageSize*pageNum-count）%pageSize ].若余數(shù)為0，則當前頁等于pageNum-1;若余數(shù)不為0，則當前頁=pageNum.將結(jié)果當前頁傳給前臺即可。

##后臺代碼實現(xiàn)

#controller層#

@Api(description = '分組下的學生',value = '分組下的學生')@RestController@RequestMapping('studentGroup')public class StudentGroupController { @Autowired private 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 { @Autowired private DubboStudentGroupService dubboStudentGroupService ; @Override public ResponseObj deleteGroupStudent(Long groupId,String ids,Integer pageSize,Integer pageNum) { List<Long> idList = TextUtils.split(ids); if(groupId == null || idList== null || idList.size() == 0){ ResponseObj responseObj = ResponseObj.ERROR('參數(shù)錯誤'); responseObj.setSuccess(true); return responseObj; } ServiceResult<Long> serviceResult = dubboStudentGroupService .deleteCorpGroup(idList, groupId); if(!serviceResult.getSuccess()){ throw new RuntimeException('分組下學生查詢失敗'); } //應前端要求加此dto，封裝傳給前臺的當前頁屬性 CurrenPageDto currenPageDto=new CurrenPageDto(); //初始化當前頁 Integer currentPage = 1; //查出該分組id下的學生數(shù)量 ServiceResult<Long> itemCountLongs = dubboStudentGroupService.getTotalCount(groupId); Long itemCountLong= itemCountLongs.getResult(); Integer itemCount = itemCountLong!=null ? itemCountLong.intValue() : 0; //'查詢到學生數(shù)量：{},pageSize:{}', itemCount,pageSize; if(pageSize != null && pageSize != 0){ //算出余數(shù) Integer temp = (pageNum*pageSize-itemCount)%pageSize; if(temp == 0){ //余數(shù)為0的話就pageNum-1 currentPage = (pageNum - 1) == 0 ? 1 : (pageNum -1) ; }else { //余數(shù)不為0則等于pageNum currentPage = pageNum; } currenPageDto.setPresentPage(currentPage); } ResponseObj responseObj = ResponseObj.SUCCESS(); responseObj.setData(currenPageDto); return responseObj; }}

#dubbo接口的service層#

①：//刪除分組下的學生ServiceResult<Long> deleteCorpGroup(List<Long> idList,Long groupId);②：//根據(jù)條件查詢對應的條目總數(shù)ServiceResult<Long> getTotalCount(Long groupId);

#dubbo接口的serviceImpl層#

①：//刪除分組下的學生 @Override public ServiceResult<Long> deleteCorpGroup(List<Long> idList, Long groupId) { ServiceResult<Long> result = new ServiceResult<>(); try { studentGroupDao.deleteCorpGroup(idList, groupId); } catch (Exception e) { log.error('調(diào)用{}方法 異常', '[RestStudentGroupServiceImpl .deleteCorpGroup]'); log.error('方法使用參數(shù)：[idList:{},groupId:{}]', idList, groupId); log.error('異常信息：{}', e); result.setErrMessage('調(diào)用deleteCorpGroup方法異常，異常信息：' + e.getMessage()); } return result; }②：//根據(jù)條件查詢對應的條目總數(shù) @Override public ServiceResult<Long> getTotalCount(Long groupId) { ServiceResult<Long> result = new ServiceResult<>(); try { long count = studentGroupDao.getFindCorpGroupDirectoryCount(groupId); result.setResult(count); } catch (Exception e) { log.error('調(diào)用{}方法 異常', '[RestStudentGroupServiceImpl .getTotalCount]'); log.error('方法使用參數(shù)：[groupId:{}]', groupId); log.error('異常信息：{}', e); result.setErrMessage('調(diào)用getTotalCount方法異常，異常信息：' + e.getMessage()); } return result; }

#dubbo接口的dao層#

①：//刪除分組下的學生 Long deleteCorpGroup(@Param(value = 'idList') List<Long> idList,@Param(value = 'groupId') Long groupId);②：//根據(jù)條件查詢對應的條目總數(shù)Long getFindCorpGroupDirectoryCount(@Param(value = 'groupId') Long groupId);

#dubbo接口的sql#

①：//刪除分組下的學生 <delete id='deleteCorpGroup'> delete from student_group where group_id = #{groupId} and id in <foreach collection='idList' index='index' separator=',' item='id' open='(' close=')'> #{id} </foreach> </delete>②：//根據(jù)條件查詢對應的條目總數(shù) <select resultType='long'> SELECT COUNT(1) FROM student_group where group_id = #{groupId} </select>

#Entity類(學生分組類)#（get,set函數(shù)省略）

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; /** * @描述:創(chuàng)建時間 * @字段:create_time DATETIME(19) */ private java.util.Date createTime; * @描述:創(chuàng)建人用戶名 * @字段:create_user_name VARCHAR(30) */ private String createUserName; /** * @描述:創(chuàng)建人用戶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函數(shù)省略）

public class Student implements java.io.Serializable { /** * */ private static final long serialVersionUID = 1L; private Long id; private String name ; private Integer age; }

以上這篇java實現(xiàn)刪除某條信息并刷新當前頁操作就是小編分享給大家的全部內(nèi)容了，希望能給大家一個參考，也希望大家多多支持好吧啦網(wǎng)。