<%@ page import="common.JDBConnect"%>
<%@ page import = "java.sql.Statement" %>
<%@ page import = "java.sql.ResultSet" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.Connection" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
Insert title here
<%
String action = request.getParameter("action");
String employee_id = request.getParameter("employee_id");
String employee_name = request.getParameter("employee_name");
String department = request.getParameter("department");
String hire_date = request.getParameter("hire_date");
String salary = request.getParameter("salary");
JDBConnect jdbc = new JDBConnect();
switch (action) {
case "insert":
String sql = "insert into employees (employee_id, employee_name, department, hire_date, salary) values (?, ?, ?, sysdate, ?)";
PreparedStatement psmt = jdbc.con.prepareStatement(sql);
psmt.setString(1, employee_id);
psmt.setString(2, employee_name);
psmt.setString(3, department);
psmt.setString(4, salary);
int inResult = psmt.executeUpdate();
if (inResult > 0) {
out.println("Employee inserted successfully.");
} else {
out.println("Failed to insert employee.");
}
break;
case "update":
String update_sql = "UPDATE employees SET employee_name = ?, department = ?, hire_date = ?, salary = ? WHERE employee_id = ?";
PreparedStatement psmt1 = jdbc.con.prepareStatement(update_sql);
psmt1.setString(1, employee_name);
psmt1.setString(2, department);
psmt1.setString(3, hire_date);
psmt1.setString(4, salary);
psmt1.setString(5, employee_id);
int inResult1 = psmt1.executeUpdate();
if (inResult1 > 0) {
out.println("회원정보가 성공적으로 업데이트되었습니다.");
} else {
out.println("회원정보 업데이트에 실패했습니다.");
}
break;
case "delete":
String delete_sql = "delete from employees where employee_id = ?";
PreparedStatement psmt2 = jdbc.con.prepareStatement(delete_sql);
psmt2.setString(1, employee_id);
int inResult2 = psmt2.executeUpdate();
if (inResult2 > 0) {
out.println("회원정보가 성공적으로 삭제되었습니다.");
} else {
out.println("회원정보를 삭제하는데 실패했습니다.");
}
break;
case "select":
sql = "select * from employees"; // 블록 내부에서 값만 할당
Statement stmt = jdbc.con.createStatement();
//쿼리 수행
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
out.println("");
out.println("| " + rs.getString(1) +" | ");
out.println("" + rs.getString(2) +" | ");
out.println("" + rs.getString(3) +" | ");
out.println("" + rs.getString(4) +" | ");
out.println("" + "
");
}
break;
}
%>
|