JSP ¼Ò½º º¸±â - ¼öÁ¤Çϱâ ÀÔ·Â ÆûJSP ¼Ò½º¿¡ ¾×Ƽºê½ºÄù¾î¸¦ Àû¿ëÇÏ´Â °ÍÀº ¸î ÁÙÀÇ °£´ÜÇÑ Äڵ带 ÀÔ·ÂÇÔÀ¸·Î½á ÀÌ·ç¾îÁý´Ï´Ù. ¼öÁ¤Çϱâ ÀÔ·Â Æû ¼Ò½º¿¡¼ ¾×Ƽºê½ºÄù¾î¸¦ ³ªÅ¸³¾ ºÎºÐ¿¡ ´ÙÀ½°ú °°ÀÌ »ðÀÔÇÔÀ¸·Î½á °£´ÜÇÏ°Ô ³ªÅ¸³¾ ¼ö ÀÖ½À´Ï´Ù.
|
<%@ include file="board.conf.jsp" %> <%@ include file="board.util.jsp" %> <%@ page import="java.io.*, java.lang.Math, java.sql.*" %> <%@ page contentType="text/html" %>
................... // ¼öÁ¤ÇÒ °Ô½Ã¹° ³»¿ë °¡Á®¿À±â
<HTML> <HEAD> <TITLE>¼öÁ¤Çϱâ</TITLE> ................... <BODY> ................... <SCRIPT Language =" Javascript"> ................... // ¼öÁ¤Çϱ⠼ҽº¿¡ Äõ¸®¸¦ º¸³¾ ¼ö Àִ ȯ°æ ¼³Á¤ </SCRIPT>
<TABLE> <FORM> <TR> <TD> ................... // ±Û¾´ÀÌ, À̸ÞÀÏ, Á¦¸ñ µî ÀÇ FORMÀ» ºÒ·¯¿À°í, ¾×Ƽºê½ºÄù¾î »ðÀÔ </TD> </TR> </FORM> // ¼öÁ¤Çϱâ ÀÔ·ÂÆû ¿Ï·á </TABLE>
</BODY> </HEAD> </HTML>
|
<%@ include file="board.conf.jsp" %> <%@ include file="board.util.jsp" %> <%@ page import="java.io.*, java.lang.Math, java.sql.*" %> <%@ page contentType="text/html" %> <% String wname; String subject; String msgbody; String homepage; String email; String dbUrl = new String(); String sql = new String(); int msgno; int offset; Connection con; Statement stmt; ResultSet rs;
msgno = Integer.parseInt(request.getParameter("msgno")); offset = Integer.parseInt(request.getParameter("offset"));
// JDBC µ¥ÀÌÅͺ£À̽º ¿¬°áÀ» À§ÇÑ URL ÃʱâÈ dbUrl = "jdbc:mysql://" + BBS_HOST + "/" + BBS_DB + "?user=" + BBS_USER + "&password=" + BBS_PASS; Class.forName("org.gjt.mm.mysql.Driver").newInstance(); con = DriverManager.getConnection(dbUrl); stmt = con.createStatement();
// °Ô½Ã¹° Á¤º¸ °¡Á®¿À±â sql = "select msgno, homepage, email, subject, msgbody, wname from board where msgno = " + msgno; rs = stmt.executeQuery(sql); rs.first();
// iso-8859-1 ·Î ÀÎÄÚµù ÇÏ´Â ÀÌÀ¯ : // Tomcat Àº ±âº»ÀûÀ¸·Î ³»ºÎ¿¡¼ ¸ðµç ¹®ÀÚ ½ºÆ®¸²À» ISO-8859-1·Î ó¸®ÇϹǷΠ// ¹®ÀÚ¿À» Ãâ·ÂÇÒ ¶§ ¾Æ·¡¿Í °°ÀÌ ÀÎÄÚµù ÇØÁÖÁö ¾ÊÀ» °æ¿ì // 2bytes ¹®ÀÚµé(Çѱ¹¾î, Áß±¹¾î, ÀϺ»¾î)À» ?? ¿Í °°ÀÌ Ç¥½ÃÇÏ´Â ¹®Á¦°¡ // ¹ß»ýÇÕ´Ï´Ù. subject = new String(rs.getBytes("subject"), "iso-8859-1"); email = new String(rs.getBytes("email"), "iso-8859-1"); wname = new String(rs.getBytes("wname"), "iso-8859-1"); homepage = new String(rs.getBytes("homepage"), "iso-8859-1"); msgbody = new String(rs.getBytes("msgbody"), "iso-8859-1");
rs.close(); %> <html>
<head> <title>¼öÁ¤Çϱâ</title> <meta name="generator" content="Namo WebEditor"> <style> <!-- .body { font-family:±¼¸²,serif; font-size:80%; line-height:130%; } --> </style> </head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<SCRIPT LANGUAGE="JavaScript"> <!-- var msgno = <%= msgno %>; var offset = <%= offset %>; var action; function DoSubmit() { var form = document.editform; form.action = action; form.submit(); }
function OnListBtn() { action = "list.jsp?offset=" + offset; DoSubmit(); }
function OnSaveBtn() { var form = document.editform; var wec = document.wec;
if(form.subject.value.length <= 0) { alert("Á¦¸ñÀ» ÀÔ·ÂÇϽʽÿÀ"); form.subject.focus(); return ; } else if(form.author.value.length <= 0) { alert("À̸§À» ÀԷ»ç½Ê½Ã¿À"); form.author.focus(); return ; } else if(form.pass.value.length <= 0) { alert("¾ÏÈ£¸¦ ÀÔ·ÂÇϽʽÿÀ"); form.pass.focus(); return ; }
form.msgbody.value = wec.MIMEValue; // ¾×Ƽºê½ºÄù¾î¿¡ ÀÔ·ÂµÈ ³»¿ëÀ» MIME Çü½ÄÀ¸·Î Hidden Field¿¡ ÀÔ·ÂÇÏ¿© POST ¹æ½ÄÀ¸·Î Àü¼ÛÇÑ´Ù action = "edit.jsp?msgno=" + msgno + "&offset=" + offset; DoSubmit(); } //--> </SCRIPT>
<SCRIPT language="JScript" FOR="wec" EVENT="OnInitCompleted()"> var form = document.editform; var wec = document.wec; wec.Value = form.contents.value; </SCRIPT>
<TABLE cellSpacing=1 cellPadding=3 width="100%" align=center border=0> <TBODY> <form method="post" name="editform"> <TR> <TD class=body align=middle bgColor=#b5c7f7> Homepage </TD> <TD bgColor=gainsboro> <INPUT type="text" name="homepage" size=50 value="<%= homepage %>"> </TD> </TR> <TR> <TD class=body align=middle bgColor=#b5c7f7> </TD> <TD bgColor=gainsboro> <INPUT type="text" name="email" size=50 value="<%= email %>"> </TD> </TR> <TR> <TD class=body align=middle bgColor=#b5c7f7> ±Û¾´ÀÌ </TD> <TD bgColor=gainsboro> <INPUT type="text" name="author" value="<%= wname %>"> </TD> </TR> <TR> <TD class=body align=middle width="15%" bgColor=#b5c7f7>Á¦ ¸ñ</TD> <TD width="85%" bgColor=gainsboro><INPUT maxLength=60 size=65 name=subject value="<%= subject %>"> </TD> </TR> <TR> <TD width="100%" bgColor=white colSpan=2> <INPUT type=hidden name=contents value="<%= convertHtmlchars(msgbody) %>"> <INPUT type=hidden name=msgbody> <!-- ¾×Ƽºê½ºÄù¾î »ðÀÔ ½ÃÀÛ--> <script language="javascript" src="/namo/NamoWec8.js"></script> <!-- ¾×Ƽºê½ºÄù¾î »ðÀÔ ³¡ --> </TD> </TR> <% sql = "select * from filelist where msgno = " + msgno + " order by id"; rs = stmt.executeQuery(sql); if(rs.first()) { while(true) { out.println("<TR>"); out.println("<TD class=body align=middle width='20%' bgColor=#b5c7f7 height=25>"); out.println("<P>÷ºÎÆÄÀÏ Áö¿ì±â</P></TD>"); out.println("<TD width='80%' class=body bgColor=gainsboro><INPUT TYPE='CHECKBOX' NAME='delFile' VALUE='" + new String(rs.getBytes("filename"), "iso-8859-1") + "'>" + new String(rs.getBytes("filename"), "iso-8859-1")); out.println("</TD>"); out.println("</TR>"); if(!rs.next()) break; } } %> <TR> <TD class=body align=middle width="15%" bgColor=#b5c7f7 height=34> <P>¾Ï È£</P></TD> <TD width="85%" bgColor=gainsboro><INPUT type="password" size=20 maxlength=20 name="pass"> <SPAN class=body>°Ô½Ã¹°À» ¼öÁ¤ÇϽ÷Á¸é ¾ÏÈ£¸¦ ÀÔ·ÂÇϼ¼¿ä</SPAN> </TD> </TR> </TBODY> </TABLE> <TABLE cellSpacing=1 cellPadding=3 width="100%" align=center bgColor=white border=0> <TBODY> <TR> <TD align=middle> <A href="javascript:OnSaveBtn()"><IMG src="images/save.gif" border=0 alt="ÀúÀåÇϱâ"></A> <A href="javascript:OnListBtn()"><IMG src="images/list.gif" border=0 alt="¸®½ºÆ®º¸±â"></A> <A href="javascript:history.go(-1)"><IMG height=19 src="images/cancel.gif" width=77 border=0 alt="Ãë¼Ò"></A> </TD> </TR> </FORM> </TBODY> </TABLE> </body>
</html> |