ssm导出

最新推荐文章于 2023-02-12 23:09:47 发布

πππα

最新推荐文章于 2023-02-12 23:09:47 发布

阅读量1k

点赞数 1

本文链接：https://blog.csdn.net/javamengxin/article/details/76127436

版权

1.导出数据的方法

package com.han.controller;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStreamWriter;
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 org.springframework.web.bind.annotation.ResponseBody;

import com.han.pojo.Employee;
import com.han.service.ServiceDao;

@Controller
@RequestMapping("bmyg")
public class BmYgController {

@Autowired
ServiceDao ser;

@RequestMapping("selectYg")
public String selectYg(Model model,String name){

System.out.println(name);
List<Employee> list = ser.selectYg(name);
model.addAttribute("list", list);
return "ok";

}

@RequestMapping("daochu")
@ResponseBody
public String daochu(Model model,String[] idss ) throws IOException{
BufferedWriter bufferedWriter=null;
//将String类型的数组转成int类型
int[] ids=new int[idss.length];
for (int i = 0; i < idss.length; i++) {
ids[i]=Integer.parseInt(idss[i]);
}
List<Employee> list = ser.selectbfYg(ids);
//创建一个File
File file=new File("D://employees.txt");
//判断文件是否存在
if(!file.exists()){
//创建文件
file.mkdir();

}
//创建一个FileOutputStream(文件输出流) 向指定的文件输出数据
FileOutputStream outputStream = new FileOutputStream(file);
//将字节流转换为字符流如果不指定字符编码格式默认为 GBK
OutputStreamWriter writer = new OutputStreamWriter(outputStream, "utf-8");
//缓冲字符流
bufferedWriter = new BufferedWriter(writer);
for (Employee employee : list) {
//写入
bufferedWriter.write(employee.getId()+"#"+employee.getName()+"#"+employee.getPosition()+"#"+employee.getSalary()

+"#"+employee.getDepartment().getDname());
//换行
bufferedWriter.newLine();
}

//刷新
bufferedWriter.flush();
//关闭
bufferedWriter.close();
outputStream.close();

return "ok";

}
}

2.Dao层方法

package com.han.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.han.pojo.Employee;

public interface BmYgMapper {
public List<Employee> selectYg(@Param("name")String name);
public List<Employee> selectbfYg(@Param("ids")int[] ids);
}

Mapper动态代理

<?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.han.dao.BmYgMapper">

<select id="selectYg" parameterType="String" resultMap="yg">
select * from t_employee e,t_department d where e.did=d.id
<if test="name!=null and name!=''">
and e.name like '%${name}%'
</if>

</select>
<select id="selectbfYg" parameterType="int" resultMap="yg">
select * from t_employee e,t_department d where e.did=d.id

<foreach collection="ids" item="id" open="and e.id in (" separator="," close=")">
#{id}
</foreach>

</select>

<resultMap type="com.han.pojo.Employee" id="yg">
<id column="id" property="id"/>
<result column="name" property="name"/>
<result column="position" property="position"/>
<result column="salary" property="salary"/>
<association property="department" javaType="com.han.pojo.Department">
<id column="id" property="id"/>
<result column="dname" property="dname"/>
</association>
</resultMap>
</mapper>

3.jsp界面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'ok.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

<script type="text/javascript" src="${pageContext.request.contextPath }/js/jquery-1.8.3.js"></script>
<script type="text/javascript">
$(function(){
alert("aaaaa");
$("#chu").click(function(){

var a=new Array;
$("input:checkbox:checked").each(function(){

a.push($(this).val());

});
location.href="${pageContext.request.contextPath }/bmyg/daochu?idss="+a;

});

});

</script>
</head>


<body>
<table border="1">
<tr><td colspan="5">
<form action="${pageContext.request.contextPath }/bmyg/selectYg">
姓名<input type="text" name="name">
<input type="submit" value="查询">
</form>
<input type="button" value="导出" id="chu"></td>
</tr><tr>
<td>选择</td>
<td>序号</td>
<td>姓名</td>
<td>职位</td>
<td>薪资</td>
<td>部门</td>
</tr>
<c:forEach items="${list }" var="list">
<tr>
<td><input type="checkbox" name="xuan" value="${list.id }"></td>
<td>${list.id }</td>
<td>${list.name }</td>
<td>${list.position }</td>
<td>${list.salary }</td>
<td>${list.department.dname }</td>
</tr>
</c:forEach>

</table>
</body>
</html>

πππα

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
ssm导出

1.导出数据的方法 package com.han.controller;import java.io.BufferedWriter;import java.io.File;import java.io.FileOutputStream;import java.io.IOException;import java.io.OutputStreamWriter;
复制链接

扫一扫