2024 05 23

   
 
 
  
 
    방송
    VJ
    홈페이지
    프로그램
    네트워크
    html
    JAVA
    C언어
    드림위버
    플래시
    포토샵
    일러스트
    PHP
    JSP
    XML
  - 비디오저널의
    사상과 철학

  - 운영자 핫라인
  - 문의사항
  - 제 휴

-모바일인터넷방송
-VJ(PD)
   인터넷공간

-VJ(PD)
   인터넷방송

-시민제작
   인터넷방송

-시사 NEWS
-VJ(PD),
   기자, 작가

-후원쇼핑몰운영

- VJ 인터넷공간
- VJ 네트워크연결
- VJ 협회구성
- VJ 홍보
- Video
   Journalist

- VJ 이메일서비스

- 우리찾기
- 친일파적극적청산
- 독도/고구려 찾기
- 남북통일국호
   이젠Corea

- 잃어버린정신
   36년 일제침략

- 조선500년왕조
   부활운동

- 새마을운동
   국가가치관
   (사상이 있었다.)

- 시민운동연대
- 모바일 방송

- 영문 국제
   국내도메인

- 한글도메인
- 한글키워드
  * 도메인 기획 *
고객 지원 센터
☎ 02) 2202 - 1009  
평일 : 10:00 ~ 18:00  
주말 : 10:00 ~ 14:00  
휴무 & 휴일(공휴일포함)
♡긴급사항 :
Mobile : 010-3079-1009

<%
   }
%>


  


HOME >> 교육 >> [ JSP ]
▣ 제목 : JSP - 10일날 (1203)
▣ 부제목 : jsp로 방명록만들기-쓰기 .삭제. 수정. 다음페이지
 
JSP - 1일날 (1122)

JSP - 2일날 (1123)

JSP - 3일날 (1124)

JSP - 4일날 (1125)

JSP - 5일날 (1126)

JSP - 6일날 (1129)

JSP - 7일날 (1130)

JSP - 8일날 (1201)

JSP - 9일날 (1202)

JSP - 11일날 (1206)

JSP - 12일날 (1207)

JSP - 13일날 (1208)

JSP - 14일날 (1209)

JSP - 15일날 (1210)

JSP - 16일날 (1213)

JSP - 17일날 (1214)

JSP - 18일날 (1215)

JSP - 19일날 (1216)

JSP - 20일날 (1217)

JSP - 21일날 (1220)

JSP - 22일날 (1221)

JSP - 23일날 (1222)

JSP - 24일날 (1223)

JSP - 25일날 (1224)

JSP - 26일날 (1226)

JSP - 27일날 (1228)

JSP - 28일날 (1229)


<%
   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,\
,
);
%>

  


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%>개의 레코드 &nbsp&nbsp (<%= 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>&nbsp;<%= 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&nbsp;&nbsp;</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>&nbsp;&nbsp;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>이&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;름</td>
 <td><input type=text name=name></td>
</tr>
<tr>
 <td>이&nbsp;&nbsp;메&nbsp;일</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>내&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;용</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>이&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;름</td>
 <td><%= name %></td>
</tr>
<tr>
 <td>이&nbsp;&nbsp;메&nbsp;일</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>내&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;용</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>이&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;름</td>
 <td><input type=text name=name value=<%= name %>></td>
</tr>
<tr>
 <td>이&nbsp;&nbsp;메&nbsp;일</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>내&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;용</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 %> 페이지)
 






   번호   
   이름
   홈페이지
   ip
   날짜
   수정
   삭제


<%
 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);


%>





  


  


   <%= no%>   
   ><%= name%>
   <%= home%>
   <%= ip%>
   <%= now_date%>
   
>수정
   >삭제
  

  

   

  
  
<%= content %>
 


  


   

   

   

   
   );>삭제

  

  
<%= no %><%= cnt %>번째 답글 <%= name2 %>  <%= replycontent %>


  
>
  



  
  

   

   

   

   

  
  

   

   
  
  
  
  
답글달기
이름
비번



  
<%
 no--;
   
  }//while 
 rs1.close();
 rs.close();
 stmt.close();
 con.close();
}catch(SQLException se) {
 out.println(se.getMessage());
}
%>








글쓰기








<%
 //if(cntpage > 1){
 //front = cntpage - 1;
%>
<%
 if(block > 1){
%>
>prev  
<%
    }
 for(go_page= first_page + 1;go_page<=last_page;go_page++){
  if(go_page == cnt_page){
%>
[><%= go_page %>]
<%
  }else{
%>
[><%= go_page %>]
<%
  }
 }
 if(block < total_block){  
%>
>  next
<%
 }
%>





::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: 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 -----------------------------------










방명록











목록보기






 

 




 

 




 

 




 

 




 

 





 






::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: 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{
%>


  


<%
 }
 
}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,\
,
);
  //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);
}
%>












방명록




>

이      름
이  메 일
홈페이지
비밀번호
내      용

 
 





목록보기






 

 




 

 




 

 




 

 




 

 





 





::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: 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);
  %>
  


<%
 }else{
%>


  


<%
 }
 
}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{
%>


  


<%
 }
 
}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);
%>







>


이      름 <%= name %>
이  메 일 <%= email %>
홈페이지 <%= home %>
비밀번호
내      용 <%= content %>

 
 







  




 



비밀번호

  
 





::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
--- 파일명: 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{
%>
  


<%
 }


 
}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,\
,
);
 //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);
}
%>












방명록





>

Home| 정치| 국제| 사회| 경제| 휴먼| 자연| 동물| 역사| 기록| 건강| 과학| 전시| 갤러리| 박물관| 스타| 가수| 배우| 탤런트| 모델| 데뷔| 문인| 서적| 연극| 음악| 미슬| 교육 사는이야기 | 영화| 언론| 여행| 책동네| 포토갤러리| e기사는 논쟁중 광주전남| 대구경북| 전북희망| 전남동부| 부산경남| 대전충남| 미주소식| 아시아| 유럽 6VJ-TV| 비디오 저널리스트(PD) 비디오저널리스네트워크 비디오저널리스협회 기자만들기 | 6VJ게시판 | 공개편집회의 방송편집회의
  6VJ 이용 약관 개인정보 보호정책 인터넷언론편집회의 Contact Us    
  Copyright © 2003 by 6VJ.com All rights reserved [비디오저널리스트 네트워크 / 웹멀티커뮤니케이션]
상 호: 비디오저널리스트『VJ』[천국커뮤니케이션]
감독。이 기 용     email: Lee@KY.co.kr
전국대표번호: 고객서비스-전지역
☎1544♥0404
 
(4랑해요♥영사영사:2006.03.01~서비스☞방송제작 및 방송제보)

방송: KBS MBC SBS CableTV
광고: Business Product_CF AD
IT: WebProgram Design
BtoB: BusinessNetwork. WebBusinessConsulting
    모바일 : 010 - 3079 - 1009   (050-2221-1009: 평생번호)
    대 표 :  02) 2202 - 1009   |  (050-2222-1009)
    기 획 :  031) 709 - 1009   |  (050-2223-1009)
    제 작 :  031) 707 - 1009   |  (050-2224-1009)
    팩 스 :  031) 702 - 1009   |  (050-2225-1009)
    팩 스 :  031) 758 - 1009   |  (050-2226-1009)
    ♣평생번호(050)는 보름동안(2007년1월16일~) 시험방송관계로 서비스에 혼동을 드릴 수 있으니 이용하지 마시길 바랍니다.(평상시에는 일반전화와 동일하게 사용됩니다.)
우 편: 463-839.경기도 성남시 분당구 야탑동526번지 경남아파트상가.컴앤넷 벤처오피스 111호 천국커뮤니케이션
【비디오저널리스트-6VJ.com】 비디오저널리스트 (프리렌서 프로듀서들의 네트워크 웹멀티커뮤니케이션)
::::::: 우리가 살아가는 이세상에서 사랑과 행복 혹은 미움과 슬픔이 존재하는 이세상을 바라볼 수 있는 내가 현재 숨쉬고 있는 동안에
존재하는 세상과 더불어 우주속에 먼지와 같이 돌고도는 이세상이 천국입니다. ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::