ssm 查询信息导出(全部代码)

最新推荐文章于 2024-04-09 17:11:13 发布

f_d_p

最新推荐文章于 2024-04-09 17:11:13 发布

阅读量1.2k

点赞数

文章标签： ssm 查询信息导出 txt

本文链接：https://blog.csdn.net/f_d_p/article/details/73933774

版权

mapper接口
List queryById(String eid);


mapper.xml
<select id="queryById" parameterType="java.lang.String"
        resultType="employee">
        select * from t_employee e,t_department d where e.did=d.id and e.eid in(${value}) 
    </select>

controller
@RequestMapping(“/queryById”)
private String queryById(HttpServletResponse response, String eid){
System.out.println(“queryById+===”);
List list = empService.queryById(eid);
File file = new File(“D://employee.txt”);
PrintWriter printWriter = null;
try {
printWriter = new PrintWriter(file);
for (Employee employee : list) {
printWriter.write(employee.getEid()+”#”+employee.getName()+”#”+employee.getPosition()+”\r\n”);
}
printWriter.flush();
} catch (FileNotFoundException e) {
e.printStackTrace();
}finally{
printWriter.close();
}
return “redirect:/emp/queryList.action”;
}

jsp  JavaScript
<script type="text/javascript">
            function daochu(){

                    var eid = "";
                    var flag = 0;
                var box = document.getElementsByName("box");
                for (var i = 0; i < box.length; i++) {
                    if (box[i].checked == true) {
                        eid+=","+box[i].value;
                        flag++;
                    }   
                }
                    eid=eid.substring(1);
                    if (flag==0) {
                        alert("请选择要导出的信息");
                        return false;
                      }else{
                      alert("导出成功");
                      window.location.href="emp/queryById.action?eid="+eid;

                      }

            }

</script>