yuu di cek !!
<%--
Document : dft_kary
Created on : Dec 29, 2014, 8:44:13 AM
Author : IT03
--%>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Laporan Data BPJS</title>
<link href="table.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<%
String exportToExcel = request.getParameter("exportToExcel");
if (exportToExcel != null && exportToExcel.toString().equalsIgnoreCase("YES")) {
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "inline; filename="+ "excel.xls");
}
%>
<table BORDER="1">
<TR><TD>
<div style="overflow: auto; height:550px;width:900px;">
<!--<div style="border:1px solid white;width:900px;height:550px;overflow-y:hidden;overflow-x:scroll;">-->
<table border="0" cellspacing="1" cellpadding="0" bgcolor="#99CCFF">
<%
Connection conn = null;
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn = DriverManager.getConnection("jdbc:oracle:thin:@
ResultSetMetaData rsmd;
ResultSet rs1 =null;
ResultSet rsnew=null;
PreparedStatement ps1=null;
String st="SELECT EMPNIK,EMPNAM,EMPKEL,EMPTLH,EMPSTS,EMPPDD,EMPTMT,EMPDPK,EMPDPN,EMPJGR,EMPJNM,EMPNKK from BPJS_KARY ORDER BY EMPNAM ASC";
try{%>
<tr><%
ps1=conn.prepareStatement(st);
rsnew=ps1.executeQuery();
rs1=rsnew;
rsmd=rs1.getMetaData();
int cou=rsmd.getColumnCount();
for(int i=1;i<=cou;i++){
%>
<td><b>
<%=rsmd.getColumnName(i)%>
<%
}
%> </td></b></tr>
<%
while(rs1.next())
{
%>
<tr><td><%=rs1.getString(1)%></td><td><%=rs1.getString(2)%></td><td><%=rs1.getString(3)%></td>
<td><%=rs1.getString(4)%></td>
<td><%=rs1.getString(5)%></td>
<td><%=rs1.getString(6)%></td>
<td><%=rs1.getString(7)%></td>
<td><%=rs1.getString(8)%></td>
<td><%=rs1.getString(9)%></td>
<td><%=rs1.getString(10)%></td>
<td><%=rs1.getString(11)%></td>
<td><%=rs1.getString(12)%></td>
</div>
</tr>
<%
}
}
catch(Exception e)
{
out.println(e);
}
%>
</table> </div></div>
<%
if (exportToExcel == null) {
%>
<a href="dft_kary.jsp?exportToExcel=YES">Export to Excel</a>
<%
}
%>
</div>
</body>
</html>
Kurang lebih seperti itu yah...ini hasil tampilannya di bawah.
Tidak ada komentar:
Posting Komentar