utamiresti: 2015-04-19

Hi all, kali ini mau nampilin sorce code yang udah berhasil saya praktekkan tentang menampilkan data dengan JSP dan Oracle menggunakan Netbeans.

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;">
                

                <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:@~~10.12.131.219:1521:ITDB01","tes", "tes"~~);// bisa diganti sesuai letak database yang dibuat

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.

Semoga tulisan ini bermanfaat..

utamiresti

Selasa, 21 April 2015

View Data dan Export ke Excel File dengan JSP dan Oracle di Netbeans

Followers

Blogger news

Follow The Author