<%@ page import="java.sql.*" %>
<%@include file = "header.jsp" %>
<%
String jdbcDriver = "oracle.jdbc.driver.OracleDriver";
Class.forName(jdbcDriver);
%>
<HTML>
<HEAD>
<TITLE>DeanShoes</TITLE>
<link rel="shorcut icon" href ="d.JPG" />
<link rel="stylesheet" href="tabel.css"/>
</HEAD>
<BODY>
<div id="page">
<div class="post">
<h2><marquee><font color="green">All Staff Departement IT</font></marquee></h2>
<a href="it.jsp"><font color="red">Cari Karyawan Berdasarkan ID</a></font>
<FORM name="form1" action="karyawanit.jsp">
<%
int current = 0;
if(request.getParameter("hidden") != null) {
current = Integer.parseInt(request.getParameter("hidden"));
}
Connection conn = DriverManager.getConnection(
"jdbc:oracle:oci:@localhost:1521:xe", "saya", "saya");
Statement statement = conn.createStatement() ;
ResultSet resultset = statement.executeQuery("select * from pegawai") ;
for(int i = 0; i <= current; i++){
resultset.next();
}
%>
<TABLE id ="prodi" BORDER="1">
<tr>
<th>id</th>
<th>nip</th>
<th>nama</th>
<th>alamat</th>
<th>ttl</th>
</tr>
<% while(resultset.next()){ %>
<TR>
<TD> <%= resultset.getString(1) %></td>
<TD> <%= resultset.getString(2) %></td>
<TD> <%= resultset.getString(3) %></td>
<TD> <%= resultset.getString(4) %></td>
<TD> <%= resultset.getString(5) %></td>
</TR>
<% }
%>
</TABLE>
<br />
<INPUT TYPE="HIDDEN" NAME ="hidden" VALUE="<%= current %>" />
<INPUT TYPE="BUTTON" VALUE="Next Record" ONCLICK="moveNext()" />
<INPUT TYPE="BUTTON" VALUE="Back Record" ONCLICK="moveBack()" />
</form>
<SCRIPT LANGUAGE="JavaScript">
function moveNext()
{
var counter = 0
counter = parseInt(document.form1.hidden.value) +1
document.form1.hidden.value = counter
form1.submit()
}
function moveBack()
{
var counter = 0
counter = parseInt (document.form1.hidden.value) - 1
document.form1.hidden.value = counter
form1.submit()
}
</SCRIPT>
</div>
</div>
<%@include file = "footer.jsp" %>
</BODY>
</HTML>
<%@include file = "header.jsp" %>
<%
String jdbcDriver = "oracle.jdbc.driver.OracleDriver";
Class.forName(jdbcDriver);
%>
<HTML>
<HEAD>
<TITLE>DeanShoes</TITLE>
<link rel="shorcut icon" href ="d.JPG" />
<link rel="stylesheet" href="tabel.css"/>
</HEAD>
<BODY>
<div id="page">
<div class="post">
<h2><marquee><font color="green">All Staff Departement IT</font></marquee></h2>
<a href="it.jsp"><font color="red">Cari Karyawan Berdasarkan ID</a></font>
<FORM name="form1" action="karyawanit.jsp">
<%
int current = 0;
if(request.getParameter("hidden") != null) {
current = Integer.parseInt(request.getParameter("hidden"));
}
Connection conn = DriverManager.getConnection(
"jdbc:oracle:oci:@localhost:1521:xe", "saya", "saya");
Statement statement = conn.createStatement() ;
ResultSet resultset = statement.executeQuery("select * from pegawai") ;
for(int i = 0; i <= current; i++){
resultset.next();
}
%>
<TABLE id ="prodi" BORDER="1">
<tr>
<th>id</th>
<th>nip</th>
<th>nama</th>
<th>alamat</th>
<th>ttl</th>
</tr>
<% while(resultset.next()){ %>
<TR>
<TD> <%= resultset.getString(1) %></td>
<TD> <%= resultset.getString(2) %></td>
<TD> <%= resultset.getString(3) %></td>
<TD> <%= resultset.getString(4) %></td>
<TD> <%= resultset.getString(5) %></td>
</TR>
<% }
%>
</TABLE>
<br />
<INPUT TYPE="HIDDEN" NAME ="hidden" VALUE="<%= current %>" />
<INPUT TYPE="BUTTON" VALUE="Next Record" ONCLICK="moveNext()" />
<INPUT TYPE="BUTTON" VALUE="Back Record" ONCLICK="moveBack()" />
</form>
<SCRIPT LANGUAGE="JavaScript">
function moveNext()
{
var counter = 0
counter = parseInt(document.form1.hidden.value) +1
document.form1.hidden.value = counter
form1.submit()
}
function moveBack()
{
var counter = 0
counter = parseInt (document.form1.hidden.value) - 1
document.form1.hidden.value = counter
form1.submit()
}
</SCRIPT>
</div>
</div>
<%@include file = "footer.jsp" %>
</BODY>
</HTML>
