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

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>