2007년 01월 19일
실험6 JSP 독립적인 조회페이지로 가기위한 구성
1. 하나의 폼 안에 필드들이 존재해야 한다.
2. 프레임워크가 요구하는 항목들을 통일시킨다.
3. getter와 setter빈즈 사용을 위해 필드명을 매칭 시킨다.
4. 프로그램 기능을 위해 필요한 필드들을 히든 필드로 관리한다.
search.jsp
<%@ page contentType="text/html; charset=euc-kr" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head><script language="javascript">
function setJob_name(tname,selectr){
<!-- 참조할 테이블 명 -->
document.searchform.tname.value=tname;
<!-- 참조할 검색할 DB필드 -->
document.searchform.search_select.value=selectr;
}
function Searchrun(){
if(!document.searchform.tname.value | document.searchform.search_select.value)
{ alert("검색 옵션을 선택하세요");
return false;
}
if(!document.searchform.searchdata.value)
{
alert("검색어를 입력하세요");
searchform.searchdata.focus();
return false;
}
}
</script>
<title>독립적인 조회 페이지</title>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td colspan="4" valign="top"> <p align="center">조회</p>
<form name="searchform" method="post" action='Scommander.jsp' onSubmit="return Searchrun()">
<!-- 페이지가 무엇을 하는 페이지인지 나타냄 -->
<input name="job_name" type="hidden" id="job_name" value="search">
<!-- 테이블명 -->
<input name="tname" type="hidden">
<!-- 테이블 필드명 -->
<input name="search_select" type="hidden" id="search_select">
<tr>
<td width="144" valign="top">비디오</td>
<td width="144" valign="top">주인공</td>
<td width="144" valign="top">사용자</td>
<td width="144" valign="top">대여정보</td>
</tr>
<tr>
<td valign="top">
<p>코드
<input name="radiobutton" type="radio" value="vcode" onClick='setJob_name("video",this.value)'>
</p>
<p>제목
<input name="radiobutton" type="radio" value="vname" onClick='setJob_name("video",this.value)'>
</p>
</td>
<td valign="top">
<p>코드
<input name="radiobutton" type="radio" value="hcode" onClick='setJob_name("hero",this.value)'>
</p>
<p>연예인명
<input name="radiobutton" type="radio" value="hname" onClick='setJob_name("hero",this.value)' >
</p>
</td>
<td valign="top">
<p>아이디
<input name="radiobutton" type="radio" value="cid" onClick='setJob_name("customer",this.value)'>
</p>
<p>주민번호
<input name="radiobutton" type="radio" value="cjumin" onClick='setJob_name("customer",this.value)'>
</p>
</td>
<td valign="top">
<p>대여자 아이디
<input name="radiobutton" type="radio" value="cid" onClick='setJob_name("rend",this.value)'>
</p>
<p>대여 날짜
<input name="radiobutton" type="radio" value="rdate" onClick='setJob_name("rend",this.value)'>
</p>
</td>
</tr>
<tr>
<td height="29" colspan="4" valign="middle">
<p align="center">검색어
<input type="text" name="searchdata" value="">
<input type="submit" name="Submit" value="Submit">
</p>
</form></td>
</tr>
</table>
commander.jsp
<%@ page contentType="text/html; charset=euc-kr" %>
<%@ page import = "ControlBean.*" %>
<%@ page import = "DataBean.*" %>
<%@page import="java.util.*" %>
<% request.setCharacterEncoding("euc-kr");%>
<jsp:useBean id="searchdata" class="DataBean.SearchDataBean" />
<jsp:setProperty name="searchdata" property="*" />
</jsp:useBean>
<%
Iterator iter=ConnectDbBean.getInstance().SearchDbBean(searchdata);
if(iter==null){
out.print("검색된 결과가 없습니다.");
}
else{
%>
<% out.print("지금하는 job_name은"+searchdata.getJob_name()); %>
<% out.print("참조할 테이블은"+searchdata.getTname()); %>
<% out.print("찾을 필드는"+searchdata.getSearch_select()); %>
<% out.print("찾을 데이타는"+searchdata.getSearchdata()); %>
<%@ page import = "ControlBean.*" %>
<%@ page import = "DataBean.*" %>
<%@page import="java.util.*" %>
<% request.setCharacterEncoding("euc-kr");%>
<jsp:useBean id="searchdata" class="DataBean.SearchDataBean" />
<jsp:setProperty name="searchdata" property="*" />
</jsp:useBean>
<%
Iterator iter=ConnectDbBean.getInstance().SearchDbBean(searchdata);
if(iter==null){
out.print("검색된 결과가 없습니다.");
}
else{
%>
<% out.print("지금하는 job_name은"+searchdata.getJob_name()); %>
<% out.print("참조할 테이블은"+searchdata.getTname()); %>
<% out.print("찾을 필드는"+searchdata.getSearch_select()); %>
<% out.print("찾을 데이타는"+searchdata.getSearchdata()); %>
<%
while(iter.hasNext()){
HashMap data =(HashMap)iter.next();
out.print(data.get("hcode"));
}
}
%>
while(iter.hasNext()){
HashMap data =(HashMap)iter.next();
out.print(data.get("hcode"));
}
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
</head>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
</head>
<body>
# by | 2007/01/19 14:38 | JAVA 향기 | 트랙백 | 덧글(0)
☞ 내 이글루에 이 글과 관련된 글 쓰기 (트랙백 보내기) [도움말]