Untitled

<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>

<!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=EUC-KR">
<title>iRent</title>

<%
String host = "localhost";
String orasid = "1029j21e9j";
String url = "jdbc:oracle:thin:@" + host + ":1521:" + orasid;
String userid = "system";
String password = "********";
String STAFF_ID = "";
String STAFF_NAME = "";
String STAFF_TEL = "";
String STAFF_STORE_ID = "";
String JOB_ID = "";
String HIRE_DATE = "";
Class.forName("oracle.jdbc.driver.OracleDriver");
%>

</head>

<body>
<h2 align="center">View all the Staff</h2>
</br></br>
<h3>Enter Staff Into the Database</h3>
<form method="post">
<table border="1" cellpadding="3" width="620">

<tr style="background-color:#FF2366;color:white">
        <td><b>STAFF ID</b></td>
        <td><b>STAFF NAME</b></td>
        <td><b>STAFF TEL</b></td>
        <td><b>STAFF STORE ID</b></td>
        <td><b>JOB ID</b></td>
        <td><b>HIRE DATE</b></td>
        <td></td>
    </tr>
     <tr>
        <td><input type="text" name="STAFF_ID"></td>
        <td><input type="text" name="STAFF_NAME"><//td>
        <td><input type="text" name="STAFF_TEL"></td>
        <td><input type="text" name="STAFF_STORE_ID"></td>
        <td><input type="text" name="JOB_ID"></td>
        <td><input type="text" name="HIRE_DATE"></td>
        <td><input type="submit"></td>
    </tr>
</table></br></br>
</form>

<%
Enumeration parameters = request.getParameterNames();
if(parameters.hasMoreElements()){
    STAFF_ID = request.getParameter("STAFF_ID");
    STAFF_NAME = request.getParameter("STAFF_NAME");
    STAFF_TEL = request.getParameter("STAFF_TEL");
    STAFF_STORE_ID = request.getParameter("STAFF_STORE_ID");
    JOB_ID = request.getParameter("JOB_ID");
    HIRE_DATE = request.getParameter("HIRE_DATE");
}
String sqlAdd = "INSERT INTO STAFFS (STAFF_ID, STAFF_NAME, STAFF_TEL, STAFF_STORE_ID, JOB_ID, HIRE_DATE) VALUES ('+STAFF_ID+','+STAFF_NAME+','+STAFF_TEL+','+STAFF_STORE_ID+','+JOB_ID+','+HIRE_DATE+' ORDER BY STAFF_ID)";
if(STAFF_ID!="" && STAFF_NAME!="" && STAFF_TEL!="" && STAFF_STORE_ID!="" && JOB_ID!="" && HIRE_DATE!=""){

try{
        Connection conn3 = DriverManager.getConnection(url, userid, password);
        Statement stmt3 = conn3.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
        int result = stmt3.executeUpdate(sqlAdd);
        if(result > 0){
            out.println("Successfully inserted your desired record into Staffs Table");
        } else{
            out.println("Failed to insert records into Staffs Table");
        }
        stmt3.close();
        conn3.close();
    }
    catch(SQLException e){
        out.println("<p> There was an error doing the query!");
        out.println("<pre>" + e  + "</pre>n<p>");
    }

}
%>

<h3>Staff List</h3>

<table border="1" cellpadding="3" width="620">
     <tr style="background-color:#ABFF0D">
         <td><b>STAFF ID</b></td>
         <td><b>STAFF NAME</b></td>
         <td><b>STAFF TEL</b></td>
         <td><b>STAFF STORE ID</b></td>
         <td><b>JOB ID</b></td>
         <td><b>HIRE DATE</b></td>
     </tr>
<%
     try{
         String sqlStaff;
         sqlStaff = "SELECT STAFF_ID, STAFF_NAME, STAFF_TEL, STAFF_STORE_ID, JOB_ID, HIRE_DATE FROM STAFFS";
         Connection conn2 = DriverManager.getConnection(url, userid, password);
         Statement stmt2 = conn2.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
         ResultSet rset2 = stmt2.executeQuery(sqlStaff);
         if(rset2.first()){
             do{
     %>
     <tr>
        <td><%= rset2.getString("STAFF_ID") %></td>
         <td><%= rset2.getString("STAFF_NAME") %></td>
         <td><%= rset2.getString("STAFF_TEL") %></td>
         <td><%= rset2.getString("STAFF_STORE_ID") %></td>
         <td><%= rset2.getString("JOB_ID") %></td>
         <td><%= rset2.getString("HIRE_DATE") %></td>
     </tr>
     <%
             }while(rset2.next());
         }
         else
             out.println("no category record!");
         stmt2.close();
         conn2.close();
     }
     catch(SQLException e){
         out.println("<p> There was an error doing the query!");
         out.println("<pre>" + e  + "</pre>n<p>");
     }
%>
</table>
</br>
<input type="button" value ="Back"/>
</body>
</html>