À§·Î

JSP ¼Ò½º º¸±â - ¼öÁ¤Çϱâ ÀÔ·Â Æû

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>

 

JSP ¼Ò½ºÀÇ ¼öÁ¤Çϱâ ÀÔ·ÂÆû ÇüÅÂ

<%@ 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>

E-Mail

</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>

 

 JSP Ãʱâ È­¸é | ¼öÁ¤Çϱ⠼ҽº