[15] 빈즈를 이용한 JSP 구성 (성적테이블)
[빈즈를 이용한 JSP 구성]
성적테이블 목록
파일명 : sungjukList.jsp
-----------------------------------------------------
<%@ page contentType="text/html; charset=utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.Iterator" %>
<%@ page import="www.sungjuk.*" %>
<jsp:useBean id="dto" class="www.sungjuk.SungjukDTO" scope="page" />
<jsp:useBean id="dao" class="www.sungjuk.SungjukDAO" scope="page" />
<%
request.setCharacterEncoding("utf-8");
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-ｅquiv="Content-Type" content="text/html; charset=utf-8" />
<title> sungjukList.jsp </title>
</head>
<body>
<center>
** 성적 리스트 **<br>
<table border=1>
<tr>
<td>번호</td>
<td>이름</td>
<td>국어</td>
<td>영어</td>
<td>수학</td>
</tr>
<%
ArrayList list=dao.list();
Iterator iter=list.iterator();
while(iter.hasNext()){
dto=(SungjukDTO)iter.next();
int sno=dto.getSno();
String uname=dto.getUname();
int kor=dto.getKor();
int eng=dto.getEng();
int mat=dto.getMat();
int aver=dto.getAver();
String address=dto.getAddress();
%>
<tr>
<td><%=sno%></td>
<td><a href="./sungjukRead.jsp?sno=<%=sno%>"><%=uname%></a></td>
<td><%=kor%></td>
<td><%=eng%></td>
<td><%=mat%></td>
</tr>
<%
}
%>
</table>
<a href="./sungjukForm.jsp">[성적등록]</a>
<br>
</center>
</body>
</html>
-----------------------------------------------------
성적테이블 추가 폼
파일명 : sungjukForm.jsp
-----------------------------------------------------
<%@ page contentType="text/html; charset=utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-ｅquiv="Content-Type" content="text/html; charset=utf-8" />
<title> sungjukForm.jsp </title>
</head>
<body>
<center>
** 성적등록 **<br>
<form name="myform" method="post" action="sungjukIns.jsp">
이름:<input type="text" name="uname" value="홍길동"><br>
국어:<input type="text" name="kor" value="90"><br>
영어:<input type="text" name="eng" value="80"><br>
수학:<input type="text" name="mat" value="70"><br>
주소:<input type="text" name="address" value="Guri"><br>
<input type="submit" value="등록">
</form>
</center>
</body>
</html>
-----------------------------------------------------
성적테이블 추가
파일명 : sungjukIns.jsp
-----------------------------------------------------
<%@ page contentType="text/html; charset=utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.Iterator" %>
<%@ page import="www.sungjuk.*" %>
<jsp:useBean id="dto" class="www.sungjuk.SungjukDTO" scope="page" />
<jsp:useBean id="dao" class="www.sungjuk.SungjukDAO" scope="page" />
<%
request.setCharacterEncoding("utf-8");
%>
<%
String uname=request.getParameter("uname");
int kor=Integer.parseInt(request.getParameter("kor"));
int mat=Integer.parseInt(request.getParameter("eng"));
int eng=Integer.parseInt(request.getParameter("mat"));
int aver=(kor+mat+eng)/3;
String address=request.getParameter("address");
dto.setUname(uname);
dto.setKor(kor);
dto.setMat(mat);
dto.setEng(eng);
dto.setAver(aver);
dto.setAddress(address);
int cnt=dao.create(dto);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-ｅquiv="Content-Type" content="text/html; charset=utf-8" />
<title> sungjukIns.jsp </title>
</head>
<body>
<center>
<%
if (cnt == 1){
response.sendRedirect("./sungjukList.jsp");
return;
}else{
out.println("등록 실패!!.");
}
%>
<a href='./sungjukList.jsp'>[성적목록]</a>
</center>
</body>
</html>
-----------------------------------------------------
성적테이블 상세보기
파일명 : sungjukRead.jsp
-----------------------------------------------------
<%@ page contentType="text/html; charset=utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.Iterator" %>
<%@ page import="www.sungjuk.*" %>
<jsp:useBean id="dto" class="www.sungjuk.SungjukDTO" scope="page" />
<jsp:useBean id="dao" class="www.sungjuk.SungjukDAO" scope="page" />
<%
request.setCharacterEncoding("utf-8");
%>
<%
int sno = Integer.parseInt(request.getParameter("sno"));
dto=dao.read(sno);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-ｅquiv="Content-Type" content="text/html; charset=utf-8">
<title>sungjukRead.jsp</title>
<script type="text/javascript">
<!--
function MoveTo(flag,frm){
switch(flag){
case 'E':
frm.action="./sungjukUpdate.jsp";
frm.submit();
break;
case 'D':
frm.action="./sungjukDelete.jsp";
frm.submit();
break;
case 'L':
location.href="./sungjukList.jsp";
}
}
//-->
</script>
</head>
<body>
<center>
** 성적 상세보기 **<br>
<form name="myform" method="post">
<input type="hidden" name="sno" value="<%=sno%>">
이름:<input type="text" name="uname" value="<%=dto.getUname()%>"><br>
국어:<input type="text" name="kor" value="<%=dto.getKor()%>"><br>
영어:<input type="text" name="eng" value="<%=dto.getEng()%>"><br>
수학:<input type="text" name="mat" value="<%=dto.getMat()%>"><br>
평균:<input type="text" name="aver" value="<%=dto.getAver()%>" readonly><br>
주소:<input type="text" name="address" value="<%=dto.getAddress()%>"><br>
<input type="button" value="수정" onClick="MoveTo('E',this.form)">
<input type="button" value="삭제" onClick="MoveTo('D',this.form)">
<input type="button" value="목록" onClick="MoveTo('L',this.form)">
</form>
</center>
</body>
</html>
-----------------------------------------------------
성적테이블 수정
파일명 : sungjukUpdate.jsp
-----------------------------------------------------
<%@ page contentType="text/html; charset=utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.Iterator" %>
<%@ page import="www.sungjuk.*" %>
<jsp:useBean id="dto" class="www.sungjuk.SungjukDTO" scope="page" />
<jsp:useBean id="dao" class="www.sungjuk.SungjukDAO" scope="page" />
<%
request.setCharacterEncoding("utf-8");
%>
<%
//폼의 값 가져오기
String uname=request.getParameter("uname");
int kor=Integer.parseInt(request.getParameter("kor"));
int mat=Integer.parseInt(request.getParameter("eng"));
int eng=Integer.parseInt(request.getParameter("mat"));
int aver=(kor+mat+eng)/3;
String address=request.getParameter("address");
int sno = Integer.parseInt(request.getParameter("sno"));
dto.setUname(uname);
dto.setKor(kor);
dto.setMat(mat);
dto.setEng(eng);
dto.setAver(aver);
dto.setAddress(address);
dto.setSno(sno);
int cnt=dao.update(dto);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-ｅquiv="Content-Type" content="text/html; charset=EUC-KR">
<title>sungjukUpdate.jsp</title>
</head>
<body>
<center>
<%
if (cnt == 1){
out.println("수정 성공!!");
}else{
out.println("수정 실패!!");
}
%>
<a href="./sungjukList.jsp">[성적목록]</a>
</center>
</body>
</html>
-----------------------------------------------------
성적테이블 삭제
파일명 : sungjukDelete.jsp
-----------------------------------------------------
<%@ page contentType="text/html; charset=utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.Iterator" %>
<%@ page import="www.sungjuk.*" %>
<jsp:useBean id="dto" class="www.sungjuk.SungjukDTO" scope="page" />
<jsp:useBean id="dao" class="www.sungjuk.SungjukDAO" scope="page" />
<%
request.setCharacterEncoding("utf-8");
%>
<%
//폼의 값 가져오기
int sno = Integer.parseInt(request.getParameter("sno"));
int cnt=dao.delete(sno);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-ｅquiv="Content-Type" content="text/html; charset=utf-8">
<title>sungjukDelete.jsp</title>
</head>
<body>
<center>
<%
if (cnt == 1){
out.println("삭제 성공!!");
}else{
out.println("삭제 실패!!");
}
%>
<a href="./sungjukList.jsp">[성적목록]</a>
</center>
</body>
</html>
-----------------------------------------------------