JSP - 10일날 (1203)
-jsp로 방명록만들기-쓰기 .삭제. 수정. 다음페이지
************************************************************
<pre>
***이봉용님이 제공한자료입니다.***
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: guestbook.sql -----------------------------------
create table guestbook(
seq int auto_increment primary key,
name varchar(20),
email varchar(50),
home varchar(50),
passwd varchar(20),
content text not null,
now_date varchar(10),
ip varchar(20)
);
insert into guestbook values(\,a,a,a,a,a,a,a);
create table guestreply(
replynum int auto_increment primary key,
seq int,
replyname varchar(20),
replycontent text,
replydate varchar(10),
replypasswd varchar(15)
);
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: list.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ include file=
epcontent.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%!
int no = 0;//글 번호
int total_record = 0;//전체 글수
int block = 0;//현재 블록
int total_block = 0;//전체 블록
int total_page=0;//전체 페이지
int page_size = 3;//한페이지에 보여줄 글수
int block_size = 10;//한 블록의 묶음
int cnt_page=0;//현재 페이지
int first = 0;//처음 레코드를 가져올 위치
int first_page = 0;//
int last_page = 0;//
int prev = 0;//이전 목록보기
int next = 0;//다음 목록보기
int go_page = 0;//보여줄 실질적인 현재 페이지
%>
<html>
<head>
<script>
function replysendit(form){
///*
if(form.replyname.value == \){
alert(이름을 입력하시오);
form.replyname.focus();
return false;
}
if(form.replycontent.value == \){
alert(이메일을 입력하시오);
form.replycontent.focus();
return false;
}
if(form.replypass.value == \){
alert(비번을 입력하시오);
form.replypass.focus();
return false;
}
//*/
form.submit();
}
function open_window(replynum){
url =
eplydelete_prev.jsp?replynum=+replynum;
window.open(url,post,width=300,height=150);
}
</script>
</head>
<body>
<center><h1>방명록</h1></center>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs,rs1= null;
try{
request.setCharacterEncoding(euc-kr);
con = DriverManager.getConnection(dbhost, dbuser, dbpassword);
stmt = con.createStatement();
rs1 = stmt.executeQuery(select count(*) from guestbook);
if(rs1.next()){
total_record = rs1.getInt(1);
}
String str = request.getParameter(page);
if(str == null)
str = 1;
cnt_page = Integer.parseInt(str);
first = page_size * (cnt_page - 1);
no = total_record - first;
total_page = (int)Math.ceil((double)total_record / page_size );//0
total_block =(int)Math.ceil((double) total_page / block_size);//0
block = (int)Math.ceil((double)cnt_page / block_size);//0
first_page = (block - 1) * block_size;
last_page = block * block_size;
prev = first_page;
next = last_page + 1;
//go_page = first_page + 1;
if(total_block <= block)
last_page = total_page;
String sql = select seq,name,email,home,passwd,content,now_date,ip from guestbook order by seq desc limit +first+,+ page_size;
rs = stmt.executeQuery(sql);
%>
<table width = 500 align = center>
<tr>
<td align=right>
<font color=blue>Total: <%=total_record%>개의 레코드    (<%= cnt_page%>/<%=total_page %> 페이지)</font>
</td>
</tr>
</table>
<table align = center width=650 border=1>
<tr bgcolor=#99CCFF>
<td width = 50 align=center><font size=2 face=굴림>번호</font></td>
<td width = 60 align=center><font size=2 face=굴림>이름</font></td>
<td width = 250 align=center><font size=2 face=굴림>홈페이지</font></td>
<td width = 100 align=center><font size=2 face=굴림>ip</font></td>
<td width = 90 align=center><font size=2 face=굴림>날짜</font></td>
<td width = 50 align=center><font size=2 face=굴림>수정</font></td>
<td width = 50 align=center><font size=2 face=굴림>삭제</font></td>
</tr>
</table>
<%
while(rs.next()) {
int seq=rs.getInt(1);
String name=rs.getString(2);
String email=rs.getString(3);
String home=rs.getString(4);
String passwd=rs.getString(5);
String content=rs.getString(6);
content = repcon(content,\
,<br>);
String now_date=rs.getString(7);
String ip=rs.getString(8);
%>
<table align=center width=650>
<tr>
<table align = center width=650 border=1>
<tr>
<td width = 50 align=center><font size=2 face=굴림><%= no%></font></td>
<td width = 60 align=center><font size=2 face=굴림><a href=mailto:<%= email%>><%= name%></font></td>
<td width = 250 align=center><font size=2 face=굴림><%= home%></font></td>
<td width = 100 align=center><font size=2 face=굴림><%= ip%></font></td>
<td width = 90 align=center><font size=2 face=굴림><%= now_date%></font></td>
<td width = 50 align=center><font size=2 face=굴림><a href=update_pre.jsp?seq=<%= seq %>>수정</a></font></td>
<td width = 50 align=center><font size=2 face=굴림><a href = delete_pre.jsp?seq=<%= seq %>>삭제</a></font></td>
</tr>
<tr>
<td colspan = 7 align=left><%= content %></td>
</tr>
</table>
</tr>
<%
Statement stmt1 = con.createStatement();
rs1 = stmt1.executeQuery(select * from guestreply where seq =+seq);
int cnt = 0;
while(rs1.next()){
cnt++;
int replynum = rs1.getInt(1);
String name2 = rs1.getString(3);
String replycontent = rs1.getString(4);
replycontent = repcon(replycontent,\
,<br>);
%>
<tr>
<table align = center width=650 border=1 bgcolor=#C9C9C9 cellspacing=0>
<tr>
<td width=130><font color= blue><%= no %></font>의 <font color=red><%= cnt %></font>번째 답글</td>
<td width = 70><%= name2 %></td>
<td width=400> <%= replycontent %></td>
<td width = 50 align=center><font size=2 face=굴림><!--<a href =
eplydelete_pre.jsp?replynum=<%= replynum %>>-->
<a href=javascript:open_window(<%= replynum %>);>삭제</a></font></td>
</tr>
</table>
</tr>
<%
}
%>
<tr>
<table align = center width=650 bgcolor=#EAFAC9 cellspacing=0>
<form name = form1 method =post action=
eply_proc.jsp?seq=<%= seq %>>
<tr ><td colspan=4 align=center>답글달기</td>
</tr>
<tr>
<td width=50>이름</td>
<td width=100><input type=text name=replyname></td>
<td rowspan=2><textarea cols=50 rows=3 name=replycontent></textarea></td>
<td rowspan=2 width=50><input type=button onclick=replysendit(this.form) value=쓰기 ></td>
</tr>
<tr>
<td>비번</td>
<td><input type=password name=replypass></td>
</tr>
</form>
</table>
</tr>
</table>
<%
no--;
}//while
rs1.close();
rs.close();
stmt.close();
con.close();
}catch(SQLException se) {
out.println(se.getMessage());
}
%>
<table align = center width=500 >
<tr>
<td align = right><a href=write.html >글쓰기</a>
</td>
</tr>
</table>
<table align=center>
<tr>
<td align = center>
<%
//if(cntpage > 1){
//front = cntpage - 1;
%>
<%
if(block > 1){
%>
<a href = list.jsp?page=<%= prev %> ><font color=blue>prev </font></a>
<%
}
for(go_page= first_page + 1;go_page<=last_page;go_page++){
if(go_page == cnt_page){
%>
<font size=2 color=red face=굴림>[<a href = list.jsp?page=<%= go_page %>><font color=red><%= go_page %></font></a>]</font>
<%
}else{
%>
<font size=2 face=굴림>[<a href = list.jsp?page=<%= go_page %>><%= go_page %></a>]</font>
<%
}
}
if(block < total_block){
%>
<a href = list.jsp?page=<%= next %> ><font color=blue> next</font></a>
<%
}
%>
</td>
</tr>
</table>
</body>
</html>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: db.jsp -----------------------------------
<%
String drivers = org.gjt.mm.mysql.Driver;
String dbhost = jdbc:mysql://localhost:3306/jsp_db;
//String dbhost = jdbc:mysql://localhost:3306/jsp_db?useUnicode=true&characterEncoding=Euc-KR;
String dbuser = captain7606;
String dbpassword = lby0321;
try{
Class.forName(drivers).newInstance();
}catch(ClassNotFoundException e){
out.println(e);
}
%>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: write.html -----------------------------------
<HTML>
<HEAD>
<script>
function sendit(form){
if(form.name.value == \){
alert(이름을 입력하시오);
form.name.focus();
return false;
}
if(form.email.value == \){
alert(이메일을 입력하시오);
form.email.focus();
return false;
}
if(form.pass.value == \){
alert(비번을 입력하시오);
form.pass.focus();
return false;
}
//if(form.home.value == form.home.defaultValue || form.home.value.length <=7){
if(form.home.value == \){
alert(홈페이지 주소를 입력해주시오);
form.home.focus();
return false;
}
if(form.content.value == \){
alert(내용을 입력하시오);
form.content.focus();
return false;
}
form.submit();
}
</script>
</HEAD>
<BODY>
<br>
<h1>방명록</h1>
<br>
<form name = form method = post action=post.jsp>
<table width=600><tr><td align=right><a href=list.jsp?page=1>목록보기</a></td></tr>
</table>
<table border=1 width=600>
<tr>
<td>이 름</td>
<td><input type=text name=name></td>
</tr>
<tr>
<td>이 메 일</td>
<td><input type=text name=email></td>
</tr>
<tr>
<td>홈페이지</td>
<td><input type=text name=home ></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type=password name=pass></td>
</tr>
<tr>
<td>내 용</td>
<td><textarea name=content rows=10 cols=70></textarea></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=button value=전송 onclick=sendit(this.form) ><input type=reset value=취소>
</td>
</tr>
</BODY>
</HTML>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: delete_exec.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%
request.setCharacterEncoding(euc-kr);
Connection con = null;
Statement stmt = null;
ResultSet rs= null;
String dbpass = null;
int seq = Integer.parseInt(request.getParameter(seq));
String pass = request.getParameter(pass);
String query = delete from guestbook where seq = +seq;
try{
con = DriverManager.getConnection(dbhost,dbuser,dbpassword);
stmt = con.createStatement();
String query2 = select passwd from guestbook where seq = +seq;
rs = stmt.executeQuery(query2);
if(rs.next()){
dbpass = rs.getString(1);
}
if(pass.equals(dbpass)){
stmt.executeUpdate(query);
rs.close();
stmt.close();
con.close();
response.sendRedirect(list.jsp);
}else{
%>
<script>
alert(password가 틀립니다.);
history.back(-1);
</script>
<%
}
}catch(Exception e){
out.println(sql error);
//}catch(ClassNotFoundException ee){
// out.println(driver error);
}
%>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: delete_pre.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ include file=
epcontent.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%!
String name=null;
String email=null;
String home=null;
//String passwd=rs.getString(5);
String content=null;
%>
<%
request.setCharacterEncoding(euc-kr);
Connection con = null;
Statement stmt = null;
ResultSet rs= null;
int seq = Integer.parseInt(request.getParameter(seq));
String query = select * from guestbook where seq = +seq;
//String query = select * from guestbook where seq = 148;
try{
con = DriverManager.getConnection(dbhost,dbuser,dbpassword);
stmt = con.createStatement();
rs = stmt.executeQuery(query);
if(rs.next()){
//int seq=rs.getInt(1);
name=rs.getString(2);
email=rs.getString(3);
home=rs.getString(4);
//String passwd=rs.getString(5);
content=rs.getString(6);
content = repcon(content,\
,<br>);
//String now_date=rs.getString(7);
//String ip=rs.getString(8);
}
stmt.close();
con.close();
//response.sendRedirect(list.jsp);
}catch(Exception e){
out.println(sql error);
//}catch(ClassNotFoundException ee){
// out.println(driver error);
}
%>
<html>
<head>
<script>
function start1(){
document.form.pass.focus();
}
function sendit(form){
if(form.pass.value == \){
alert(삭제를 위한 비밀번호를 입력하시오);
form.pass.focus();
return false;
}
form.submit();
}
</script>
</head>
<BODY onload=start1()>
<br>
<h1>방명록</h1>
<br>
<form name = form method = post action=delete_exec.jsp?seq=<%= seq %> >
<table width=600><tr><td align=right><a href=list.jsp?page=1>목록보기</a></td></tr>
</table>
<table border=1 width=600>
<tr>
<td>이 름</td>
<td><%= name %></td>
</tr>
<tr>
<td>이 메 일</td>
<td><%= email %></td>
</tr>
<tr>
<td>홈페이지</td>
<td><%= home %></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type=password name=pass></td>
</tr>
<tr>
<td>내 용</td>
<td><%= content %></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=button value=삭제 onclick=sendit(this.form) ><input type=reset value=취소>
</td>
</tr>
</BODY>
</HTML>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: post.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%
request.setCharacterEncoding(euc-kr);
Connection con = null;
Statement stmt = null;
ResultSet rs= null;
String name = request.getParameter(
ame).trim();
String email = request.getParameter(email).trim();
String home = request.getParameter(home).trim();
String pass = request.getParameter(pass).trim();
String content = request.getParameter(content).trim();
java.util.Date now = new java.util.Date();
SimpleDateFormat date = new SimpleDateFormat(yyyy/MM/dd);
String now_date = date.format(now);
String ip = request.getRemoteAddr();
String query = insert into guestbook values(\,\+ name +\,\+email+\,\+home+\,\+pass+\,\+content+\,\+now_date+\,\+ip+\);;
try{
con = DriverManager.getConnection(dbhost,dbuser,dbpassword);
stmt = con.createStatement();
stmt.executeUpdate(query);
stmt.close();
con.close();
response.sendRedirect(list.jsp);
}catch(Exception e){
out.println(sql error);
//}catch(ClassNotFoundException ee){
// out.println(driver error);
}
%>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: repcontent.jsp -----------------------------------
<%!
String repcon(String str,String n1,String n2){
int itmp = 0;
if(str == null)
return \;
String tmp = str;
StringBuffer sb = new StringBuffer();
sb.append(\);
while(tmp.indexOf(n1) > -1){
itmp = tmp.indexOf(n1);
sb.append(tmp.substring(0,itmp));
sb.append(n2);
tmp = tmp.substring(itmp+n1.length());
}
sb.append(tmp);
return sb.toString();
}
%>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: reply_proc.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%
request.setCharacterEncoding(euc-kr);
Connection con = null;
Statement stmt = null;
ResultSet rs= null;
int seq = Integer.parseInt(request.getParameter(seq).trim());
String replyname = request.getParameter(
eplyname).trim();
String replypass = request.getParameter(
eplypass).trim();
String replycontent = request.getParameter(
eplycontent).trim();
java.util.Date now = new java.util.Date();
SimpleDateFormat date = new SimpleDateFormat(yyyy/MM/dd);
String replydate = date.format(now);
String query = insert into guestreply values(\,+seq+,\+ replyname +\,\+replycontent+\,\+replydate+\,\+replypass+\);;
try{
con = DriverManager.getConnection(dbhost,dbuser,dbpassword);
stmt = con.createStatement();
stmt.executeUpdate(query);
stmt.close();
con.close();
response.sendRedirect(list.jsp);
}catch(Exception e){
out.println(sql error);
//}catch(ClassNotFoundException ee){
// out.println(driver error);
}
%>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: replydelete_exec.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%
request.setCharacterEncoding(euc-kr);
Connection con = null;
Statement stmt = null;
ResultSet rs= null;
String dbpass = null;
int replynum = Integer.parseInt(request.getParameter(
eplynum));
String pass = request.getParameter(pass);
String query = delete from guestreply where replynum = +replynum;
try{
con = DriverManager.getConnection(dbhost,dbuser,dbpassword);
stmt = con.createStatement();
String query2 = select replypasswd from guestreply where replynum = +replynum;
rs = stmt.executeQuery(query2);
if(rs.next()){
dbpass = rs.getString(1);
}
if(pass.equals(dbpass)){
stmt.executeUpdate(query);
rs.close();
stmt.close();
con.close();
//response.sendRedirect(list.jsp);
%>
<script>
opener.document.location = list.jsp;
self.close();
</script>
<%
}else{
%>
<script>
alert(password가 틀립니다.);
history.back(-1);
</script>
<%
}
}catch(Exception e){
out.println(sql error);
//}catch(ClassNotFoundException ee){
// out.println(driver error);
}
%>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: replydelete_pre.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%
request.setCharacterEncoding(euc-kr);
Connection con = null;
Statement stmt = null;
ResultSet rs= null;
String dbpass = null;
int seq = Integer.parseInt(request.getParameter(seq));
String pass = request.getParameter(pass);
String query = delete from guestreply where replynum = +replynum;
try{
con = DriverManager.getConnection(dbhost,dbuser,dbpassword);
stmt = con.createStatement();
String query2 = select passwd from guestbook where replynum = +replynum;
rs = stmt.executeQuery(query2);
if(rs.next()){
dbpass = rs.getString(1);
}
if(pass.equals(dbpass)){
stmt.executeUpdate(query);
rs.close();
stmt.close();
con.close();
response.sendRedirect(list.jsp);
}else{
%>
<script>
alert(password가 틀립니다.);
history.back(-1);
</script>
<%
}
}catch(Exception e){
out.println(sql error);
//}catch(ClassNotFoundException ee){
// out.println(driver error);
}
%>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: replydelete_prev.jsp -----------------------------------
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%
request.setCharacterEncoding(euc-kr);
String replynum = request.getParameter(
eplynum);
%>
<html>
<head>
<script>
function sendform(form){
if(form.pass.value==\){
alert(비번 을 입력하시오);
form.pass.focus();
return false;
}
form.submit();
//self.close();
}
</script>
</head>
<body>
<form name = form method=post action =
eplydelete_exec.jsp?replynum=<%=replynum %>>
<table>
<tr><td>비밀번호</td>
<td><input type=password name=pass></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=button value=삭제 onclick=sendform(this.form)><input type=reset value=취소>
</td>
</tr>
</table>
</form>
</body>
</html>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: update_exec.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%!
String sql(String str){
return \+str+\;
}
%>
<%
request.setCharacterEncoding(euc-kr);
Connection con = null;
Statement stmt = null;
ResultSet rs= null;
String dbpass = null;
int seq = Integer.parseInt(request.getParameter(seq));
String name = request.getParameter(
ame).trim();
String email = request.getParameter(email).trim();
String home = request.getParameter(home).trim();
String pass = request.getParameter(pass).trim();
String content = request.getParameter(content).trim();
java.util.Date now = new java.util.Date();
SimpleDateFormat date = new SimpleDateFormat(yyyy/MM/dd);
String now_date = date.format(now);
String ip = request.getRemoteAddr();
//String query = update guestbook set name = \+name+\,email = \+email+\,home = \+home+\,content = \+content+\,passwd = \+pass+\,now_date = \+now_date+\,ip = \+ip+\ where seq = +seq + and passwd = \+pass+\;
String query = update guestbook set name = +sql(name)+,email = +sql(email)+,home = +sql(home)+,content = +sql(content)+,passwd = +sql(pass)+,now_date = +sql(now_date)+,ip = +sql(ip)+ where seq = +seq + and passwd = +sql(pass);
try{
con = DriverManager.getConnection(dbhost,dbuser,dbpassword);
stmt = con.createStatement();
//stmt.executeUpdate(query);
String query2 = select passwd from guestbook where seq = +seq;
rs = stmt.executeQuery(query2);
if(rs.next())
dbpass = rs.getString(1);
if(pass.equals(dbpass)){
stmt.executeUpdate(query);
rs.close();
stmt.close();
con.close();
response.sendRedirect(list.jsp);
}else{
%>
<script>
alert(password가 틀립니다.);
history.back(-1);
</script>
<%
}
}catch(Exception e){
out.println(sql error);
//}catch(ClassNotFoundException ee){
// out.println(driver error);
}
%>
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: update_pre.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%!
String name=null;
String email=null;
String home=null;
//String passwd=rs.getString(5);
String content=null;
%>
<%
request.setCharacterEncoding(euc-kr);
Connection con = null;
Statement stmt = null;
ResultSet rs= null;
int seq = Integer.parseInt(request.getParameter(seq));
String query = select * from guestbook where seq = +seq;
//String query = select * from guestbook where seq = 148;
try{
con = DriverManager.getConnection(dbhost,dbuser,dbpassword);
stmt = con.createStatement();
rs = stmt.executeQuery(query);
if(rs.next()){
//int seq=rs.getInt(1);
name=rs.getString(2);
email=rs.getString(3);
home=rs.getString(4);
//String passwd=rs.getString(5);
content=rs.getString(6);
//content = repcon(content,\
,<br>);
//String now_date=rs.getString(7);
//String ip=rs.getString(8);
}
stmt.close();
con.close();
//response.sendRedirect(list.jsp);
}catch(Exception e){
out.println(sql error);
//}catch(ClassNotFoundException ee){
// out.println(driver error);
}
%>
<html>
<head>
<script>
function sendit(form){
if(form.pass.value == \){
alert(수정을 위한 비밀번호를 입력하시오);
form.pass.focus();
return false;
}
form.submit();
}
</script>
</head>
<BODY onload=javascript:document.form.pass.focus()>
<br>
<h1>방명록</h1>
<br>
<form name = form method = post action=update_exec.jsp?seq=<%= seq %>>
<table width=600><tr><td align=right><a href=list.jsp?page=1>목록보기</a></td></tr>
</table>
<table border=1 width=600>
<tr>
<td>이 름</td>
<td><input type=text name=name value=<%= name %>></td>
</tr>
<tr>
<td>이 메 일</td>
<td><input type=text name=email value = <%= email %>></td>
</tr>
<tr>
<td>홈페이지</td>
<td><input type=text name=home value = <%= home %>></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type=password name=pass></td>
</tr>
<tr>
<td>내 용</td>
<td><textarea name=content rows=10 cols=70 ><%= content %></textarea></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=button value=수정 onclick=sendit(this.form) ><input type=reset value=취소>
</td>
</tr>
</BODY>
</HTML>
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
JSP스터디 2004 12 03
소스자세히보기
http://www.6VJ.com/jsp/jap1203.txt
더자세히는 오른쪽마우스로 소스보기
</pre>
************************************************************
***이봉용님이 제공한자료입니다.***
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: guestbook.sql -----------------------------------
create table guestbook(
seq int auto_increment primary key,
name varchar(20),
email varchar(50),
home varchar(50),
passwd varchar(20),
content text not null,
now_date varchar(10),
ip varchar(20)
);
insert into guestbook values(\,a,a,a,a,a,a,a);
create table guestreply(
replynum int auto_increment primary key,
seq int,
replyname varchar(20),
replycontent text,
replydate varchar(10),
replypasswd varchar(15)
);
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: list.jsp -----------------------------------
<%@ include file=db.jsp %>
<%@ include file=
epcontent.jsp %>
<%@ page import=java.sql.*,java.io.* ,java.text.* ,java.util.* contentType= ext/html;charset=euc-kr %>
<%!
int no = 0;//글 번호
int total_record = 0;//전체 글수
int block = 0;//현재 블록
int total_block = 0;//전체 블록
int total_page=0;//전체 페이지
int page_size = 3;//한페이지에 보여줄 글수
int block_size = 10;//한 블록의 묶음
int cnt_page=0;//현재 페이지
int first = 0;//처음 레코드를 가져올 위치
int first_page = 0;//
int last_page = 0;//
int prev = 0;//이전 목록보기
int next = 0;//다음 목록보기
int go_page = 0;//보여줄 실질적인 현재 페이지
%>
방명록
<%
Connection con = null;
Statement stmt = null;
ResultSet rs,rs1= null;
try{
request.setCharacterEncoding(euc-kr);
con = DriverManager.getConnection(dbhost, dbuser, dbpassword);
stmt = con.createStatement();
rs1 = stmt.executeQuery(select count(*) from guestbook);
if(rs1.next()){
total_record = rs1.getInt(1);
}
String str = request.getParameter(page);
if(str == null)
str = 1;
cnt_page = Integer.parseInt(str);
first = page_size * (cnt_page - 1);
no = total_record - first;
total_page = (int)Math.ceil((double)total_record / page_size );//0
total_block =(int)Math.ceil((double) total_page / block_size);//0
block = (int)Math.ceil((double)cnt_page / block_size);//0
first_page = (block - 1) * block_size;
last_page = block * block_size;
prev = first_page;
next = last_page + 1;
//go_page = first_page + 1;
if(total_block <= block)
last_page = total_page;
String sql = select seq,name,email,home,passwd,content,now_date,ip from guestbook order by seq desc limit +first+,+ page_size;
rs = stmt.executeQuery(sql);
%>
Total: <%=total_record%>개의 레코드 (<%= cnt_page%>/<%=total_page %> 페이지)
|
<%
while(rs.next()) {
int seq=rs.getInt(1);
String name=rs.getString(2);
String email=rs.getString(3);
String home=rs.getString(4);
String passwd=rs.getString(5);
String content=rs.getString(6);
content = repcon(content,\
,
);
String now_date=rs.getString(7);
String ip=rs.getString(8);
%>
| 
방송
