Buat dokumentasi pribadi juga,xixixi klo lupa bisa buka paririmbon lagi,semoga bermanfaat,,aamiin
<%@ page import="java.sql.*" %>
<HTML>
<HEAD>
<TITLE>Insert Data Karyawan</TITLE>
</HEAD>
<BODY>
<H1>Insert Data</H1>
<%
Connection connection = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.getConnection("jdbc:oracle:oci:@localhost:1521:xe", "saya", "saya");
Statement statement = connection.createStatement();
String command = "INSERT INTO pegawai (id_peg, nippeg, namapeg, alamatpeg, ttlpeg) VALUES ('', '', '', '','')";
statement.executeUpdate(command);
ResultSet resultset = statement.executeQuery("select * from pegawai");
while(resultset.next()){
%>
<TABLE BORDER="1">
<TR>
<th>ID</th>
<th>NIP</th>
<th>NAMA</th>
<th>ALAMAT</th>
<th>TTL</th>
</TR>
<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>
<%
}
%>
</BODY>
</HTML>
<%@ page import="java.sql.*" %>
<HTML>
<HEAD>
<TITLE>Insert Data Karyawan</TITLE>
</HEAD>
<BODY>
<H1>Insert Data</H1>
<%
Connection connection = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.getConnection("jdbc:oracle:oci:@localhost:1521:xe", "saya", "saya");
Statement statement = connection.createStatement();
String command = "INSERT INTO pegawai (id_peg, nippeg, namapeg, alamatpeg, ttlpeg) VALUES ('', '', '', '','')";
statement.executeUpdate(command);
ResultSet resultset = statement.executeQuery("select * from pegawai");
while(resultset.next()){
%>
<TABLE BORDER="1">
<TR>
<th>ID</th>
<th>NIP</th>
<th>NAMA</th>
<th>ALAMAT</th>
<th>TTL</th>
</TR>
<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>
<%
}
%>
</BODY>
</HTML>
