ssm批量删除和模糊查询

来源：互联网发布：网络论坛营销方案编辑：程序博客网时间：2024/06/06 11:02

1.Dao层方法

package com.tcc.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.tcc.bean.student;
import com.tcc.bean.type;

public interface usermapper {

//此处用到了注解@param它可以用来拼接到sql中
public List<student> list(@Param("sname")String sname);
public void delete(Integer id);
public student inli(student st);
}

2.Dao层实现类

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.tcc.dao.usermapper">

<select id="list" parameterType="student" resultMap="stu">
select * from t_student s,t_class c where s.cid=c.id

<if test="sname!=null">
and s.name like '%${sname}%' //判断出条件拼接sql
</if>
</select>

<delete id="delete">
delete from t_student where id=#{id}
</delete>

</mapper>

3.Controller

package com.tcc.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.tcc.bean.student;
import com.tcc.bean.type;
import com.tcc.service.userservice;

@Controller
@RequestMapping("user")
public class controller {
@Autowired
private userservice us;

@RequestMapping("list")
public String list(String sname,Model model){

List<student> list = us.list(sname);
model.addAttribute("list", list);
return "success";
}
@RequestMapping("delete")

//批量删除会有多个id这里用String[] ids来接收

public String delete(String[] ids){

//循环遍历让每一个id都执行删除方法

for (String string : ids) {
us.delete(Integer.parseInt(string));
}
return "redirect:/user/list";
}

}

3.jsp-jquery

$(".qx").click(function () {    $("input[type=checkbox]:gt(0)").prop("checked",this.checked);})//全选反选

$("#全选标签id").click(function(){
var array=new Array;
$("input[type=checkbox]:gt(0):checked").each(function(){
array.push($(this).parent().next().text());
});
alert(array);
location.href="${pageContext.request.contextPath}/user/delete?ids="+array;
});
});
</script>

<form action="****.action">//调用查询方法,把sname传到后台    <input type="text" name="sname">//sanme就是@param里面所写的参数    <input type="submit" value="查询"></form>

阅读全文

3 0