Java操作Jxl实现导出数据生成Excel表格数据文件
帅爆了的吴彦祖 人气:0实现：前台用的框架是Easyui+Bootstrap结合使用，需要引入相应的Js、Css文件。页面：Jsp、拦截请求：Servlet、逻辑处理：ClassBean、数据库：SQLserver。
注意：Bean中操作SQL语句进行处理是公司内部方法，可替换为其它方法自行扩展！主要看代码逻辑业务处理！
使用SQLserver数据库进行多表连接查询得出需要展出的数据
则前台数据展示使用的是Easyui中的datagrid数据列表进行展示。
随机点击一行数据，点击详情个人信息弹窗打开，数据以及被填充到弹窗中！
拉到底部可见导出按钮，点击导出发送请求：传入个人就诊编号及卡号进行SQL查询个人数据实现导出
此时此刻Java操作Jxl生成Excel文件成功直接，让我们打开文件查看数据是否和我们后台设置的预期效果一致！
表格数据和预期效果一致代码如下：
Bean代码：
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import jxl.CellView;
import jxl.Workbook;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
public class ImportBean {
private HttpServletRequest request;//客户端请求对象
private DBSource db; //操作SQL语句对象
private String MSG; //提示信息
//构造函数
public ImportBean(HttpServletRequest request) {
this.request = request;
this.db = new DBSource(request); // 数据库对象
}
//主诉与症状下拉框
public Vector loadZSZZCombo() throws SQLException{
Vector vec = null;
String sql =" select '' as comboValue,'请选择' as comboName, '' as combotext "+
"union all " +
"select [编号],[主诉与症状],[查体] FROM [V_医务管理_主诉症状信息表]";
sql+=" ORDER BY comboValue ";
vec = db.getConttexJONSArr(sql, 0, 0);
return vec;
}
//页面初始化读取就诊信息
public Vector queryJZXX(int pageNum, int pageSize,String JZBH,String KH) throws SQLException{
String sql = ""; // 查询用SQL语句
Vector vec = null; // 结果集
sql="select 就诊编号,卡号,姓名,班级或部门,人员类型,就诊医生,convert(nvarchar(19),就诊时间,21) as 就诊时间,主诉与症状,查体,是否隔离,诊断结果,诊疗意见,病历类型,isnull(转院原因,'') as 转院原因,isnull(转诊医院,'') as 转诊医院,isnull(转诊医生,'') as 转诊医生,isnull(convert(nvarchar(19),转院时间,21),'') as 转院时间 from ( SELECT l.就诊编号,a.[卡号],a.[姓名],b.班级名称 as 班级或部门,'1' as 人员类型,j.就诊医生,j.就诊时间 as 就诊时间,l.主诉与症状,l.查体,l.是否隔离,l.诊断结果,l.诊疗意见,l.病历类型,z.转院原因,z.转诊医院,z.转诊医生,z.转院时间" +
" from [V_基础信息_学生信息表] a "+
" left join [V_医务管理_就诊信息] j on j.卡号=a.卡号 left join [V_医务管理_病历信息] l on l.就诊编号=j.编号 " +
" left join [V_医务管理_转院信息] z on z.就诊编号=j.编号 left join dbo.V_基础信息_班级信息表 b on a.[行政班代码]=b.班级代码 "+
" union all SELECT l.就诊编号,a.[卡号],a.[姓名],c.CNAME as 班级或部门,'2' as 人员类型,j.就诊医生,convert(nvarchar(19),j.就诊时间,21) as 就诊时间,l.主诉与症状,l.查体,l.是否隔离,l.诊断结果,l.诊疗意见,l.病历类型,isnull(z.转院原因,'') as 转院原因,isnull(z.转诊医院,'') as 转诊医院,isnull(z.转诊医生,'') as 转诊医生,isnull(convert(nvarchar(19),z.转院时间,21),'')as 转院时间 " +
" from [V_基础信息_教职工信息表] a "+
" left join [V_医务管理_就诊信息] j on j.卡号=a.卡号 left join [V_医务管理_病历信息] l on l.就诊编号=j.编号 "+
" left join [V_医务管理_转院信息] z on z.就诊编号=j.编号 left join [sysUserDept] b on a.卡号=b.[UserCode] "+
" left join [sysDepartment] c on b.[DeptCode]=c.[DeptCode] ) x WHERE 1=1 AND x.就诊医生!='null' ";
if(!"".equalsIgnoreCase(JZBH)){
sql+=" AND x.就诊编号='"+ MyTools.fixSql(JZBH) +"' ";
}
if(!"".equalsIgnoreCase(KH)){
sql+=" AND x.卡号='"+ MyTools.fixSql(KH) +"' ";
}
sql+=" ORDER BY x.人员类型,x.[卡号] desc";
vec = db.getConttexJONSArr(sql, pageNum, pageSize);
return vec;
}
//导出excel表格
public String outputGRXX(String JZBH,String KH)throws SQLException {
Vector vec = null;
Vector vec2 = null;
String sql="";
String sql2="";
String savePath="";
sql="select 卡号,姓名,班级或部门,人员类型,就诊医生,convert(nvarchar(19),就诊时间,21) as 就诊时间,主诉与症状,查体,是否隔离,诊断结果,诊疗意见,病历类型,是否转院,isnull(转院原因,'') as 转院原因,isnull(转诊医院,'') as 转诊医院,isnull(转诊医生,'') as 转诊医生,isnull(convert(nvarchar(19),转院时间,21),'') as 转院时间 from ( SELECT l.就诊编号,a.[卡号],a.[姓名],b.班级名称 as 班级或部门,'1' as 人员类型,j.就诊医生,j.就诊时间 as 就诊时间,l.主诉与症状,l.查体,l.是否隔离,l.诊断结果,l.诊疗意见,l.病历类型,是否转院='',z.转院原因,z.转诊医院,z.转诊医生,z.转院时间" +
" from [V_基础信息_学生信息表] a "+
" left join [V_医务管理_就诊信息] j on j.卡号=a.卡号 left join [V_医务管理_病历信息] l on l.就诊编号=j.编号 " +
" left join [V_医务管理_转院信息] z on z.就诊编号=j.编号 left join dbo.V_基础信息_班级信息表 b on a.[行政班代码]=b.班级代码 "+
" union all SELECT l.就诊编号,a.[卡号],a.[姓名],c.CNAME as 班级或部门,'2' as 人员类型,j.就诊医生,convert(nvarchar(19),j.就诊时间,21) as 就诊时间,l.主诉与症状,l.查体,l.是否隔离,l.诊断结果,l.诊疗意见,l.病历类型,是否转院='',isnull(z.转院原因,'') as 转院原因,isnull(z.转诊医院,'') as 转诊医院,isnull(z.转诊医生,'') as 转诊医生,isnull(convert(nvarchar(19),z.转院时间,21),'')as 转院时间 " +
" from [V_基础信息_教职工信息表] a "+
" left join [V_医务管理_就诊信息] j on j.卡号=a.卡号 left join [V_医务管理_病历信息] l on l.就诊编号=j.编号 "+
" left join [V_医务管理_转院信息] z on z.就诊编号=j.编号 left join [sysUserDept] b on a.卡号=b.[UserCode] "+
" left join [sysDepartment] c on b.[DeptCode]=c.[DeptCode] ) x WHERE 1=1 AND x.就诊医生!='null' AND x.就诊编号='"+ MyTools.fixSql(JZBH) +"' AND x.卡号='"+ MyTools.fixSql(KH) +"' ";
vec=db.GetContextVector(sql);
//查询主诉与症状下拉框
sql2="select [编号],[主诉与症状],[查体] FROM [V_医务管理_主诉症状信息表]";
vec2=db.GetContextVector(sql2);
//生成excel表
if (vec != null && vec.size() > 0) {
Calendar c = Calendar.getInstance();// 可以对每个时间域单独修改
savePath = MyTools.getProp(request, "Base.exportExcelPath");//导出excel文件服务器保存路径:F\:/UPLOAD/XZLMS/exportExcel/
//创建文件夹
File file = new File(savePath);
if (!file.exists()) {
file.mkdirs();
}
savePath +=vec.get(1).toString() +"就诊记录详情"+ ".xls";
System.out.println(savePath);
try {
OutputStream os = new FileOutputStream(savePath);
WritableWorkbook wbook = Workbook.createWorkbook(os);// 建立excel文件
WritableSheet wsheet1 = wbook.createSheet(vec.get(1).toString(), 0);// 对第一张sheete,生成的工作表名称
WritableFont fontStyle;
WritableCellFormat contentStyle;
Label content;
//生成标题
String[] title1=new String[]{"卡号","姓名","班级或部门","人员类型","就诊医生","就诊时间","主诉与症状","查体","是否隔离","诊断结果","诊疗意见","病历类型","是否转院","转院原因","转诊医院","转诊医生","转院时间"};
int counum1=0;//excel表中行数
String cellContent1 = ""; //当前单元格的内容
for(int i=0;i<title1.length;i++) {
wsheet1.setColumnView(i, 25);//设置每列列宽
}
//第1行生成标题设置行列字体大小
fontStyle = new WritableFont(WritableFont.createFont("宋体"), 20, WritableFont.BOLD,false, jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLACK);
contentStyle = new WritableCellFormat(fontStyle);
contentStyle.setShrinkToFit(true);
contentStyle.setWrap(true);
contentStyle.setAlignment(jxl.format.Alignment.CENTRE);//水平居中
contentStyle.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//垂直居中
wsheet1.mergeCells(0, counum1, 16, counum1); //合并单元格mergeCells(a,b,c,d) a 单元格的列号,b 单元格的行号,c 从单元格[a,b]起，向左合并到c列,d 从单元格[a,b]起，向下合并到d行
cellContent1 = "个人就诊信息详情表";
content = new Label(0, counum1, cellContent1, contentStyle); //单元格内容
wsheet1.addCell(content);
wsheet1.setRowView(counum1, 600); //设置行高
//第2行生成对应数据标题名称。
counum1++;
for(int colNum=0; colNum<17; colNum++){
fontStyle = new WritableFont(WritableFont.createFont("宋体"), 12, WritableFont.NO_BOLD,false, jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLACK);
contentStyle = new WritableCellFormat(fontStyle);
contentStyle.setShrinkToFit(true);
contentStyle.setAlignment(jxl.format.Alignment.CENTRE);//水平居中
contentStyle.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//垂直居中
//设置边框;
contentStyle.setBorder(jxl.format.Border.TOP, BorderLineStyle.THIN);
contentStyle.setBorder(jxl.format.Border.LEFT, BorderLineStyle.THIN);
contentStyle.setBorder(jxl.format.Border.RIGHT, BorderLineStyle.THIN);
contentStyle.setBorder(jxl.format.Border.BOTTOM, BorderLineStyle.THIN);
//创建单元格 ，一行一个格子的增加
cellContent1=title1[colNum];
content = new Label(colNum, counum1, cellContent1, contentStyle);
//添加到行中;
wsheet1.addCell(content);
}
wsheet1.setRowView(counum1, 1000); //设置行高
//第3行生成内容数据
counum1++;
for(int i=0;i<vec.size();i=i+18){//控制行数
for(int colNum=0; colNum<17; colNum++){//控制列数
fontStyle = new WritableFont(WritableFont.createFont("宋体"), 12, WritableFont.NO_BOLD,false, jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLACK);
contentStyle = new WritableCellFormat(fontStyle);
contentStyle.setWrap(true);
contentStyle.setShrinkToFit(true);
contentStyle.setAlignment(jxl.format.Alignment.CENTRE);//水平居中
contentStyle.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//垂直居中
//边框
contentStyle.setBorder(jxl.format.Border.TOP, BorderLineStyle.THIN);
contentStyle.setBorder(jxl.format.Border.LEFT, BorderLineStyle.THIN);
contentStyle.setBorder(jxl.format.Border.RIGHT, BorderLineStyle.THIN);
contentStyle.setBorder(jxl.format.Border.BOTTOM, BorderLineStyle.THIN);
//对某一列进行判断进行单独处理
if(colNum==3) {
if(vec.get(i+colNum).toString().equalsIgnoreCase("1")) {
cellContent1="学生";
}else {
cellContent1="教师";
}
content = new Label(colNum, counum1, cellContent1, contentStyle);//创建单元格 第？列单元格Y坐标 ，第？行X坐标，内容，样式
wsheet1.addCell(content); //添加到行中;
}else if(colNum==6) {//症状
for(int j=0;j<vec2.size();j=j+3) {
if(vec2.get(j+0).toString().equalsIgnoreCase(vec.get(i+colNum).toString())) {
cellContent1=vec2.get(j+1).toString();
}
}
content = new Label(colNum, counum1, cellContent1, contentStyle);//创建单元格 第？列单元格Y坐标 ，第？行X坐标，内容，样式
wsheet1.addCell(content); //添加到行中;
}else if(colNum==8) {//隔离
if(vec.get(i+colNum).toString().equalsIgnoreCase("0")) {
cellContent1="否";
}else {
cellContent1="是";
}
content = new Label(colNum, counum1, cellContent1, contentStyle);//创建单元格 第？列单元格Y坐标 ，第？行X坐标，内容，样式
wsheet1.addCell(content); //添加到行中;
}else if(colNum==11) {//病历类型
if(vec.get(i+colNum).toString().equalsIgnoreCase("1")) {
cellContent1="初诊";
}else {
cellContent1="复诊";
}
content = new Label(colNum, counum1, cellContent1, contentStyle);//创建单元格 第？列单元格Y坐标 ，第？行X坐标，内容，样式
wsheet1.addCell(content); //添加到行中;
}else if(colNum==12) {//是否转院
if(vec.get(i+(colNum+1)).toString().equalsIgnoreCase("")) {
cellContent1="否";
}else {
cellContent1="是";
}
content = new Label(colNum, counum1, cellContent1, contentStyle);//创建单元格 第？列单元格Y坐标 ，第？行X坐标，内容，样式
wsheet1.addCell(content); //添加到行中;
}else{
//正常拼接值
cellContent1=vec.get(i+colNum).toString();
content = new Label(colNum, counum1, cellContent1, contentStyle);//创建单元格 第？列单元格Y坐标 ，第？行X坐标，内容，样式
wsheet1.addCell(content); //添加到行中;
}
}
wsheet1.setRowView(counum1, 1500); //设置行高
counum1++;
}
// 写入数据
wbook.write();
// 关闭文件
wbook.close();
os.close();
this.setMSG("文件生成成功");
} catch (FileNotFoundException e) {
this.setMSG("导出前请先关闭相关EXCEL");
} catch (WriteException e) {
this.setMSG("文件生成失败");
} catch (IOException e) {
this.setMSG("文件生成失败");
}
} else {
this.setMSG("没有符合条件的成绩信息");
}
return savePath;
}
//Get&Set
public String getMSG() {
return MSG;
}
public void setMSG(String mSG) {
MSG = mSG;
}
}
Servlet代码：
public class ImportBean_Servlet extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//设置字符编码为UTF-8
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
String active = MyTools.StrFiltr(request.getParameter("active"));// 拿取前台的active值
int pageNum = MyTools.parseInt(request.getParameter("page")); //获得页面page参数 分页
int pageSize = MyTools.parseInt(request.getParameter("rows")); //获得页面rows参数 分页
TraceLog.Trace("active...:"+active);
Vector jsonV = null;//返回结果集
JSONArray jal = null;//返回json对象
ImportBean bean = new ImportBean(request); //对象
//查询主诉与症状
if("loadZSZZCombo".equalsIgnoreCase(active)){
try {
jsonV = bean.loadZSZZCombo();
jal = (JSONArray) jsonV.get(2);
response.getWriter().write(jal.toString());
} catch (Exception e) {
e.printStackTrace();
}
}
//查询就诊信息
if("queryJZXX".equalsIgnoreCase(active)){
try {
String JZBH=URLDecoder.decode(MyTools.StrFiltr(request.getParameter("JZBH")), "UTF-8");//就诊编号
String KH=URLDecoder.decode(MyTools.StrFiltr(request.getParameter("KH")), "UTF-8");//卡号
jsonV = bean.queryJZXX(pageNum,pageSize,JZBH,KH);
if (jsonV != null && jsonV.size() > 0) {
//最终处理：传回AJAX 结果集
jal = (JSONArray)jsonV.get(2);
response.getWriter().write("{\"total\":" + MyTools.StrFiltr(jsonV.get(0)) + ",\"rows\":" + jal.toString() + "}");//生成datagrid所需数据类型
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
jal = JsonUtil.addJsonParams(jal, "MSG", "查询错误!"+ bean.getMSG() );
response.getWriter().write(jal.toString());
}
}
//导出个人信息详情Exls表格
if("outputGRXX".equalsIgnoreCase(active)){
String JZBH=URLDecoder.decode(MyTools.StrFiltr(request.getParameter("JZBH")), "UTF-8");//就诊编号
String KH=URLDecoder.decode(MyTools.StrFiltr(request.getParameter("KH")), "UTF-8");//卡号
try {
String filePath=bean.outputGRXX(JZBH,KH); //调用bean方法入参，返回生成文件路径
jal = JsonUtil.addJsonParams(jal, "MSG",bean.getMSG()); //生成json格式数据，返回状态值
jal = JsonUtil.addJsonParams(jal, "filePath", filePath);//生成json格式数据，返回路径
response.getWriter().write(jal.toString());
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
Jsp:代码：
<body>
<%-- 遮罩层 --%>
<div id="divPageMask" class="maskStyle">
<div id="maskFont">文件生成中，请稍后...</div>
</div>
<div class="bg-box indexBox" >
<div class="box">
<div class="col-lg-10 col-md-10 col-sm-12 col-xs-12 content" style="width:100%;">
<div class="content-border">
<ol class="breadcrumb">
<li>就诊信息</li>
<li class="active"><b>查询条件</b></li>
</ol>
<!-- 列表区 -->
<div id="tableDIV" class="list-table table-responsive" style="height:400px;">
<table id="JZXXList" width="100%"></table>
</div>
</div>
</div>
</div>
</div>
<!-- 个人详细详情dialog -->
<div id="grxxInfoDialog" style="overflow:auto;">
<div class="col-lg-10 col-md-10 col-sm-12 col-xs-12 content" style="width:100%;">
<div class="content-border">
<div id="querybox">
<form id="form3" name="form3" method="post" class="colorForm">
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">姓名</label>
</div>
<div class="col-lg-8 col-md-8 col-sm-4 col-xs-4" style="height:34px;">
<span id="BRXM_DC" style="font-size:16px;"></span>
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">班级或部门</label>
</div>
<div class="col-lg-8 col-md-8 col-sm-4 col-xs-4" style="height:34px;">
<span id="BJBM_DC" style="font-size:16px;"></span>
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">人员类型</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:40px;">
<input class="form-control" id="SRYLX_DC" name="SRYLX" style="width:100%;" />
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">就诊医生</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:40px;">
<input class="form-control" id="JZYS_DC" name="JZYS" style="width:100%;" />
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">就诊时间</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:34px;">
<input class="form-control" id="JZSJ_DC" name="JZSJ" style="width:100%;" />
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">主诉与症状</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:40px;">
<input class="form-control" id="ZSYZZ_DC" name="ZSYZZ" style="width:100%;" />
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">查体</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:80px;">
<textarea class="form-control" id="CT_DC" name="CT" style="width:100%; height:80px;"></textarea>
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">是否隔离</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:40px;">
<input class="form-control" id="SFGL_DC" name="SFGL" style="width:100%;" />
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">类型</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:40px;">
<input class="form-control" id="BLLX_DC" name="BLLX" style="width:100%;" />
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">诊断结果</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:80px;">
<textarea class="form-control" id="ZDJG_DC" name="ZDJG" style="width:100%; height:80px;"></textarea>
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">诊疗意见</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:80px;">
<textarea class="form-control" id="ZLYJ_DC" name="ZLYJ" style="width:100%; height:80px;"></textarea>
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">是否转院</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:40px;">
<input class="form-control" id="SFZY_DC" name="SFZY" style="width:100%;" />
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">转院原因</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:80px;">
<textarea class="form-control" id="ZYYY_DC" name="ZYYY" style="width:100%; height:80px;"></textarea>
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">转诊医院</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:40px;">
<input class="form-control" id="ZZYY_DC" name="ZZYY" style="width:100%;" maxlength="20"/>
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">转诊医生</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:40px;">
<input class="form-control" id="ZZYS_DC" name="ZZYS" style="width:100%;" maxlength="20"/>
</div>
</div>
<div class="row">
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2" style="height:34px;">
<label class="formRowTitle">转院时间</label>
</div>
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10" style="height:40px;">
<input class="form-control" id="ZYSJ_DC" name="ZYSJ" style="width:100%;" />
</div>
</div>
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 text-center">
<input type="button" id="outputGRXX" class="btn form-control btn-success dialogButtom-btn" value="导出" onclick="doToolbar(this.id);"/>
</div>
</div>
<input type="hidden" id="active2" name="active"/>
<input type="hidden" id="JZBH_DC" name="JZBH"/><!-- 人员姓名 -->
<input type="hidden" id="KH_DC" name="KH"/><!-- 班级或部门 -->
</form>
</div>
</div>
</div>
</div>
<iframe id="exportIframe" src="" style="width:0; height:0;"></iframe>
</body>
<script type="text/javascript">
var userCode = '<%=usercode%>';
var sAuth = '<%=sAuth%>';
var curPageNumber = 1;
var curPageSize = 20;
var lodata='';
var jzbh='';//就诊编号
var kh='';//卡号
$(document).ready(function(){
$('#hideQueryArea').collapse('hide');
var tableheight=($(window).height()-308); //浏览器当前窗口可视区域高度
$('#tableDIV').css("height", tableheight);
if(screen.height>900){
dialogheight=160;
}else{
dialogheight=10;
}
initDialog();//初始化对话框
loadfiand();//初始化主诉症状
loadGridJZXX();//页面初始化datagrid
});
//加载主诉症状
function loadfiand(){
$.ajax({
type:"post",
url:'<%=request.getContextPath()%>/ImportBean_Servlet?active=loadZSZZCombo',
dataType:"json",
success: function(data){
lodata='';
lodata=data;
}
});
}
/**加载 dialog控件**/
function initDialog(){
//个人详细信息弹窗
$('#grxxInfoDialog').dialog({
width: 580,//宽度设置
height: 480,//高度设置
top: dialogheight,
modal:true,
closed: true,
cache: false,
draggable:false,//是否可移动dialog框设置
//打开事件
onOpen:function(data){},
//读取事件
onLoad:function(data){},
//关闭事件
onClose:function(data){}
});
}
//页面初始化datagrid:查询就诊信息
function loadGridJZXX(){
$('#JZXXList').datagrid({
url: '<%=request.getContextPath()%>/ImportBean_Servlet',
queryParams:{"active":"queryJZXX"},
nowrap: false,//当数据长度超出列宽时将会自动截取
fit:true,//自动折叠容器的大小将填充父容器
showFooter:true,//显示视图的页脚
striped:true, //隔行变色
pagination:true,//开启分页
pageSize:curPageSize,//每页查看的记录数量
singleSelect:true,//开启单选模式
pageNumber:curPageNumber,//初始的页面为第一页
rownumbers:true,//显示行数
fitColumns: true,//自适应
fit:true,
width:'100%',
nowrap:false,
striped:true,
pageSize:20,
pageNumber:1,
showFooter:true,
rownumbers:true,
singleSelect:true,
pagination:true,
fitColumns:false,
//不使用后台排序
remoteSort :false,
async:false,
//下面是表单中加载显示的信息
columns:[[
{field:'姓名',align:'center',title:'姓名',width:fillsize(0.1)},
{field:'班级或部门',align:'center',title:'班级/部门',width:fillsize(0.16)},
{field:'主诉与症状',align:'center',title:'主诉与症状',width:fillsize(0.15),
formatter:function(value){
for(var i=0; i<lodata.length; i++){
if (lodata[i].comboValue == value) {
return lodata[i].comboName;
}
}
return value;
}},
{field:'病历类型',align:'center',title:'类型',width:fillsize(0.1),
formatter:function(value,rec){
var bllx="";
if(rec.病历类型=='1'){
bllx="初诊";
}else{
bllx="复诊";
}
return bllx;
}
},
{field:'就诊医生',align:'center',title:'就诊医生',width:fillsize(0.1)},
{field:'就诊时间',align:'center',title:'就诊时间',width:fillsize(0.2)},
{field:'info',align:'center',title:'操作',width:fillsize(0.1),
formatter:function(value,rec){
var info='<input type="button" class="btn btn-primary" id="queBL" style="width:60px;" value="详情" onclick="openPersonBLSY(\''+rec.就诊编号+'\',\''+rec.卡号+'\')"">';
return info;
}
}
]],
//双击某行时触发
onDblClickRow:function(rowIndex,rowData){
},
//读取datagrid之前加载
onBeforeLoad:function(){},
//单击某行时触发
onClickRow:function(rowIndex,rowData){
rowxx = rowData;
},
//加载成功后触发
onLoadSuccess: function(data){
iKeyCode = '';
row = '';
curPageNumber = $(this).datagrid('options').pageNumber;
curPageSize = $(this).datagrid('options').pageSize;
},
error:function(data){}
});
}
//工具栏按钮调用方法，传入按钮的id@id 当前按钮点击事件
function doToolbar(iToolbar){
//导出个人信息EXCl表格
if(iToolbar == 'outputGRXX'){
$('#active2').val('outputGRXX');//传隐藏值active
$("#form3").submit();//表单提交方法
}
}
//提交的表单
$('#form3').form({
//定位到servlet位置的url
url:'<%=request.getContextPath()%>/ImportBean_Servlet',
//当点击事件后触发的事件
onSubmit: function(data){
return $(this).form('validate');//验证
},
//当点击事件并成功提交后触发的事件
success:function(data){
var json = eval("("+data+")");
if(json[0].MSG == '文件生成成功'){
//下载文件到本地
$("#exportIframe").attr("src", '<%=request.getContextPath()%>https://img.qb5200.com/download-x/download.jsp?filePath=' + encodeURIComponent(json[0].filePath));
$('#grxxInfoDialog').dialog("close");
}else{
alertMsg(json[0].MSG);
}
}
});
//进行数据填充到个人信息弹窗,JZBH:就诊编号,KH:卡号
function openPersonBLSY(JZBH,KH){
$('#grxxInfoDialog').dialog({
title:"个人详细信息",
});
$.ajax({
type : "POST",
url : '<%=request.getContextPath()%>/ImportBean_Servlet',
data : 'active=queryJZXX&JZBH='+JZBH+"&KH="+KH,
dataType:"json",
success : function(data){
$("#JZBH_DC").val(data.rows[0].就诊编号);
$("#KH_DC").val(data.rows[0].卡号);
$("#BRXM_DC").html(data.rows[0].姓名);
$("#BJBM_DC").html(data.rows[0].班级或部门);
$("#JZYS_DC").val(data.rows[0].就诊医生);
$("#JZSJ_DC").val(data.rows[0].就诊时间);
$("#CT_DC").val(data.rows[0].查体);
$("#ZDJG_DC").val(data.rows[0].诊断结果);
$("#ZLYJ_DC").val(data.rows[0].诊疗意见);
$("#ZYYY_DC").val(data.rows[0].转院原因);
$("#ZZYY_DC").val(data.rows[0].转诊医院);
$("#ZZYS_DC").val(data.rows[0].转诊医生);
$("#ZYSJ_DC").val(data.rows[0].转院时间);
if (data.rows[0].是否隔离=='0') {
$('#SFGL_DC').val('否');
}else{
$('#SFGL_DC').val('是');
}
if(data.rows[0].人员类型=='1'){
$("#SRYLX_DC").val('学生');
}else{
$('#SRYLX_DC').val('老师');
}
if(data.rows[0].病历类型=='1'){
$('#BLLX_DC').val('初诊');
}else{
$('#BLLX_DC').val('复诊');
}
if(data.rows[0].转院原因!=''&&data.rows[0].转诊医院!=''){
$("#SFZY_DC").val('是');
}else{
$("#SFZY_DC").val('否');
}
for(var i=0; i<lodata.length; i++){
if (lodata[i].comboValue == data.rows[0].主诉与症状) {
$('#ZSYZZ_DC').val(lodata[i].comboName);
}
}
//表单禁用
$('#JZYS_DC').attr('readonly',true);
$('#CT_DC').attr('readonly',true);
$('#ZDJG_DC').attr('readonly',true);
$("#JZSJ_DC").attr('readonly',true);
$('#ZLYJ_DC').attr('readonly',true);
$('#ZYYY_DC').attr('readonly',true);
$('#ZZYY_DC').attr('readonly',true);
$('#ZZYS_DC').attr('readonly',true);
$("#ZYSJ_DC").attr('readonly',true);
$('#SFGL_DC').attr('readonly',true);
$('#ZSYZZ_DC').attr('readonly',true);
$('#SRYLX_DC').attr('readonly',true);
$('#BLLX_DC').attr('readonly',true);
$('#SFZY_DC').attr('readonly',true);
$('#grxxInfoDialog').dialog('open');
}
});
}
</script>
至此Java操作Jxl生成Excel表格数据完结，本人只是写了一个简单的小案例可自行扩展功能及所需表格格式
此文章来自一个努力做IT界中一股清流的小伙子。喜欢的朋友记得帮我顶一下！！
加载全部内容