[파이썬] 오라클 DB 연동 CRUD - 2 / detail, add, mod, del (HELLO_EMP_MVC)

jychae·2022년 11월 15일
0

파이썬

목록 보기
7/8

emp_detail.html


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>

<script type="text/javascript">
var e_id = '{{emp.e_id}}';
function fn_mod(){
	location.href = "emp_mod?e_id="+e_id;
}

function fn_del_act(){
	var flag = confirm("한번 지워진 데이터는 복구가 불가합니다.\n 정말 실행하시렵니까?");
	if(!flag){
		return; //아래로 내려가지못하게 흐름 제어
	}
	document.frm.submit();
}

</script>

</head>
<body>
<form action="emp_del_act" method="post" name="frm" >
	<input type="hidden" name="e_id" value="{{emp.e_id}}"/>
</form>
<table border="1px">
	<tr>
		<td>사번</td>
		<td>{{emp.e_id}}</td>
	</tr>
	<tr>
		<td>이름</td>
		<td>{{emp.e_name}}</td>
	</tr>
	<tr>
		<td>성별</td>
		<td>{{emp.sex}}</td>
	</tr>
	<tr>
		<td>주소</td>
		<td>{{emp.addr}}</td>
	</tr>
	<tr>
		<td colspan="2">
		<input type="button" value="수정" onclick="fn_mod()"/>
		<input type="button" value="삭제" onclick="fn_del_act()"/>
		</td>
	</tr>
	
</table>

</body>
</html> 

emp_add.html


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>

<script type="text/javascript">

function fn_add_act(){
	var f = document.frm;
	f.submit();
}

</script>

</head>
<body>
<form action="emp_add_act" name="frm" method="post" >
<!-- {% csrf_token %} 이거......-->
<table border="1px">
	<tr>
		<td>사번</td>
		<td>
		자동생성됩니다.
		</td>
	</tr>
	<tr>
		<td>이름</td>
		<td>
		<input type="text" name="e_name" />
		</td>
	</tr>
	<tr>
		<td>성별</td>
		<td>
		<input type="text" name="sex" />
		</td>
	</tr>
	<tr>
		<td>주소</td>
		<td>
		<input type="text" name="addr" />
		</td>
	</tr>
	<tr>
		<td colspan="2">
		<input type="button" value="실행" onclick="fn_add_act()"/>
		</td>
	</tr>
	
</table>
</form>

</body>
</html>

emp_add_act.html


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>

<script type="text/javascript">
var cnt = "{{cnt}}";
if(cnt == "1"){
	location.href = "emp_list";
} else {
	alert("추가작업 진행 중 문제가 발생했습니다.")
	history.back();
}
</script>

</head>
<body>
EMP_ADD_ACT

</body>
</html>

emp_mod.html


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript">
function fn_mod_act(){
	var f = document.frm;
	f.submit();
}

</script>
</head>
<body>
<form action="emp_mod_act" name="frm" method="post" >
<!-- {% csrf_token %} 이거......-->
<table border="1px">
	<tr>
		<td>사번</td>
		<td>
		<input type="text" name="e_id" value="{{emp.e_id}}"/>
		</td>
	</tr>
	<tr>
		<td>이름</td>
		<td>
		<input type="text" name="e_name" value="{{emp.e_name}}"/>
		</td>
	</tr>
	<tr>
		<td>성별</td>
		<td>
		<input type="text" name="sex" value="{{emp.sex}}"/>
		</td>
	</tr>
	<tr>
		<td>주소</td>
		<td>
		<input type="text" name="addr" value="{{emp.addr}}"/>
		</td>
	</tr>
	<tr>
		<td colspan="2">
		<input type="button" value="실행" onclick="fn_mod_act()"/>
		</td>
	</tr>
	
</table>
</form>

</body>
</html>

emp_mod_act.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>

<script type="text/javascript">
var cnt = "{{cnt}}";
if(cnt == "1"){
	location.href = "emp_list";
} else {
	alert("수정작업 진행 중 문제가 발생했습니다.")
	history.back();
}
</script>

</head>
<body>
EMP _MOD_act

</body>
</html>

emp_del_act.html


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>

<script type="text/javascript">
var cnt = "{{cnt}}";
if(cnt == "1"){
	location.href = "emp_list";
} else {
	alert("삭제작업 진행 중 문제가 발생했습니다.")
	history.back();
}
</script>

</head>
<body>
EMP _DEL_act

</body>
</html>![업로드중..](blob:https://velog.io/ddf0a9c6-3aaa-4bbc-ae11-5645caa3f8aa)
profile
안녕하세요! 초보개발자 공부 시작!

0개의 댓글