JSP 홈페이지 소스( 캡쳐 이미지 정리 ppt 포함 ) - 방명록 AccessDB연동 구현
*석*
다운로드
장바구니
소개글
jsp 로 만든 간단한 홈페이지 입니다.방명록을 access 디비로 처리해서 관리가 가능합니다.
회원 관리기능은 세션으로 처리하여 관리하고 있습니다.
방문자 카운트도 처리하고 있습니다.
로그인 로그아웃 기능도 지원합니다.
ROOT.zip
ROOT.zip 파일을 푸시면 ROOT 폴더안에 파일들을 보실 수 있습니다.
톰캣 webappsROOT 폴더안에 복사한후
톰캣을 시작하신 후 접속하시면 되네요
http://localhost:8080/template.jsp
즐거운 하루 되시기 바랍니다.
컴파일 실행환경
JSP (Apache Tomcat) , JDBC, ODBC본문내용
<%@ page contentType="text/html;charset=euc-kr"%><%@ page import="madvirus.member.Member" %>
<%@ page import="java.util.ArrayList" %>
<jsp:useBean id="member" class="madvirus.member.Member">
<jsp:setProperty name="member" property="*"/>
</jsp:useBean>
<%
try {
if ( member != null ) {
if ( session.getAttribute("MEMBER") == null ) {
if ( session.getAttribute("MEMBERLIST") == null ) {
} else {
ArrayList memberlist = (ArrayList)session.getAttribute("MEMBERLIST");
for ( int i = 0; i < memberlist.size(); i++ ) {
Member member2 = (Member)memberlist.get(i);
if ( member.getId().equals(member2.getId()) && member.getPass().equals(member2.getPass()) ) {
session.setAttribute("MEMBER", member2);
break;
}
}
}
} else {
if ( member.getLoginflag() != null && member.getLoginflag().equals("N") ) {
session.setAttribute("MEMBER", null);
}
}
}
} catch ( Exception e ) {
}
%>
<!doctype html public "-//w3c//dtd html 4.0 transitional//en" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html>
<head>
</title>
</head>
<_badtags rows="50, *, 50" border="0" frameborder="0" scrolling="auto">
<frame noresize scrolling="no" marginwidth="0" marginheight="0" src="header.jsp">
<_badtags cols="300, *" border="0">
<frame noresize scrolling="no" marginwidth="0" marginheight="0" name="sidebar" src=`sidebar.jsp`>
<frame noresize scrolling="auto" marginwidth="0" marginheight="0" name="index" src="index.jsp?cp=intro">
</_badtags>
<frame noresize scrolling="no" marginwidth="0" marginheight="0" src="footer.jsp">
</_badtags>
<noframes>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<p> 페이지를 보려면, 프레임을 볼 수 있는 브라우저가 필요합니다.</p>
</body>
</noframes>
</html>
압축파일 내 파일목록
ROOT/
ROOT/doc/
ROOT/doc/jsp홈페이지화면캡쳐.pptx
ROOT/error.jsp
ROOT/footer.jsp
ROOT/guest/
ROOT/guest/delete.jsp
ROOT/guest/deleteForm.jsp
ROOT/guest/guestdb.mdb
ROOT/guest/list.jsp
ROOT/guest/update.jsp
ROOT/guest/updateForm.jsp
ROOT/guest/write.jsp
ROOT/guest/writeForm.jsp
ROOT/header.jsp
ROOT/hobby.jsp
ROOT/img/
ROOT/img/2007Greeting.gif
ROOT/img/3_days.jpg
ROOT/img/counter/
ROOT/img/counter/0.jpg
ROOT/img/counter/1.jpg
ROOT/img/counter/2.jpg
ROOT/img/counter/3.jpg
ROOT/img/counter/4.jpg
ROOT/img/counter/5.jpg
ROOT/img/counter/6.jpg
ROOT/img/counter/7.jpg
ROOT/img/counter/8.jpg
ROOT/img/counter/9.jpg
ROOT/img/house.jpg
ROOT/img/kunnen.jpg
ROOT/img/snowqueen.jpg
ROOT/img/usb_turntable.jpg
ROOT/img/winter.jpg
ROOT/img/xmas_contest.jpg
ROOT/index.jsp
ROOT/intro.jsp
ROOT/photo.jsp
ROOT/register.jsp
ROOT/registerForm.jsp
ROOT/sidebar.jsp
ROOT/speciality.jsp
ROOT/template.jsp
ROOT/update.jsp
ROOT/updateForm.jsp
ROOT/WEB-INF/
ROOT/WEB-INF/classes/
ROOT/WEB-INF/classes/madvirus/
ROOT/WEB-INF/classes/madvirus/counter/
ROOT/WEB-INF/classes/madvirus/counter/Count.class
ROOT/WEB-INF/classes/madvirus/DBUtil.class
ROOT/WEB-INF/classes/madvirus/guestbook/
ROOT/WEB-INF/classes/madvirus/guestbook/GuestBook.class
ROOT/WEB-INF/classes/madvirus/guestbook/GuestBookException.class
ROOT/WEB-INF/classes/madvirus/guestbook/GuestBookManager.class
ROOT/WEB-INF/classes/madvirus/member/
ROOT/WEB-INF/classes/madvirus/member/Member.class
ROOT/WEB-INF/src/
ROOT/WEB-INF/src/madvirus/
ROOT/WEB-INF/src/madvirus/counter/
ROOT/WEB-INF/src/madvirus/counter/Count.java
ROOT/WEB-INF/src/madvirus/DBUtil.java
ROOT/WEB-INF/src/madvirus/guestbook/
ROOT/WEB-INF/src/madvirus/guestbook/GuestBook.java
ROOT/WEB-INF/src/madvirus/guestbook/GuestBookException.java
ROOT/WEB-INF/src/madvirus/guestbook/GuestBookManager.java
ROOT/WEB-INF/src/madvirus/member/
ROOT/WEB-INF/src/madvirus/member/Member.java
ROOT/WEB-INF/web.xml
ROOT/doc/
ROOT/doc/jsp홈페이지화면캡쳐.pptx
ROOT/error.jsp
ROOT/footer.jsp
ROOT/guest/
ROOT/guest/delete.jsp
ROOT/guest/deleteForm.jsp
ROOT/guest/guestdb.mdb
ROOT/guest/list.jsp
ROOT/guest/update.jsp
ROOT/guest/updateForm.jsp
ROOT/guest/write.jsp
ROOT/guest/writeForm.jsp
ROOT/header.jsp
ROOT/hobby.jsp
ROOT/img/
ROOT/img/2007Greeting.gif
ROOT/img/3_days.jpg
ROOT/img/counter/
ROOT/img/counter/0.jpg
ROOT/img/counter/1.jpg
ROOT/img/counter/2.jpg
ROOT/img/counter/3.jpg
ROOT/img/counter/4.jpg
ROOT/img/counter/5.jpg
ROOT/img/counter/6.jpg
ROOT/img/counter/7.jpg
ROOT/img/counter/8.jpg
ROOT/img/counter/9.jpg
ROOT/img/house.jpg
ROOT/img/kunnen.jpg
ROOT/img/snowqueen.jpg
ROOT/img/usb_turntable.jpg
ROOT/img/winter.jpg
ROOT/img/xmas_contest.jpg
ROOT/index.jsp
ROOT/intro.jsp
ROOT/photo.jsp
ROOT/register.jsp
ROOT/registerForm.jsp
ROOT/sidebar.jsp
ROOT/speciality.jsp
ROOT/template.jsp
ROOT/update.jsp
ROOT/updateForm.jsp
ROOT/WEB-INF/
ROOT/WEB-INF/classes/
ROOT/WEB-INF/classes/madvirus/
ROOT/WEB-INF/classes/madvirus/counter/
ROOT/WEB-INF/classes/madvirus/counter/Count.class
ROOT/WEB-INF/classes/madvirus/DBUtil.class
ROOT/WEB-INF/classes/madvirus/guestbook/
ROOT/WEB-INF/classes/madvirus/guestbook/GuestBook.class
ROOT/WEB-INF/classes/madvirus/guestbook/GuestBookException.class
ROOT/WEB-INF/classes/madvirus/guestbook/GuestBookManager.class
ROOT/WEB-INF/classes/madvirus/member/
ROOT/WEB-INF/classes/madvirus/member/Member.class
ROOT/WEB-INF/src/
ROOT/WEB-INF/src/madvirus/
ROOT/WEB-INF/src/madvirus/counter/
ROOT/WEB-INF/src/madvirus/counter/Count.java
ROOT/WEB-INF/src/madvirus/DBUtil.java
ROOT/WEB-INF/src/madvirus/guestbook/
ROOT/WEB-INF/src/madvirus/guestbook/GuestBook.java
ROOT/WEB-INF/src/madvirus/guestbook/GuestBookException.java
ROOT/WEB-INF/src/madvirus/guestbook/GuestBookManager.java
ROOT/WEB-INF/src/madvirus/member/
ROOT/WEB-INF/src/madvirus/member/Member.java
ROOT/WEB-INF/web.xml
참고 자료
열혈자바http://mybox.happycampus.com/moviel0ve/4565879