회원가입을 배워서 게시판 만들기를 도전하는데요

DB에 입력까지는 되는데 게시판에 DB를 불러와서 뿌리는게 잘 안되네요...

회원가입처럼 응용해서 해보려고 한건데 너무 답답해요.. ㅠ 도와주시면 정말 감사하겠습니다..


<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"EUC-KR\" %>
<%
String id=(String)session.getAttribute(\"db_id\");
String name=(String)session.getAttribute(\"db_name\");


%>
<%
 if(id == null){
%>
    <html>

    <head>


   

 

    </head>

    <body>


  <form action=\"pan_join_ok.jsp\" method=\"post\" >
  
<table width = \"700\">
<tr>
 <td align = \"right\" >
  <a href = \"pan_join.jsp\">글쓰기</a></td>
  </table>


<table border = \"1\" width = \"700\" cellpadding = \"0\" cellspacing = \"0\" align = \"center\">
<tr height = \"30\">
 <td align = \"center\" width = \"50\">번 호</td>
 <td align = \"center\" width = \"250\">제 목 </td>
 <td align = \"center\" width = \"100\">작성자</td>
 <td align = \"center\" width = \"150\">작성일</td>
 <td align = \"center\" width = \"50\">조 회</td>
</tr>

<tr height = \"30\">
 <td width = \"50\"> &nbsp<br><br></td>
 <td width = \"250\">우선 작성자만 출력해 보려고 합니다.
<td><%=name%>


<td>&nbsp
<td>&nbsp

 
</tr>

</table>
</form>
 
<%}%>


ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
<%@ page contentType=\"text/html; charset=euc-kr\" %>
<%@ page import=\"java.sql.*\" %>
<%@ page import=\"java.util.*\" %>

    <%

    String writer=request.getParameter(\"writer\");


  
Class.forName(\"com.microsoft.sqlserver.jdbc.SQLServerDriver\");
try{
   String connectionUrl = \"jdbc:sqlserver://203.230.158.236:1433;database=db_2008141085;user=db_2008141085;password=1184921\";
   Connection con = DriverManager.getConnection(connectionUrl);
 Statement stmt = con.createStatement();
 // sql 내용처리
 String SQL=\"SELECT * FROM board where writer=\'\" + writer + \"\' nad content=\'\"+content+\"\'\";
 ResultSet RS=stmt.executeQuery(SQL);

 if(RS.next()){
 
 session.setAttribute(\"db_name\",writer);
 session.setMaxInactiveInterval(60*2);
 %>
<>
 href=\"list.jsp\";
</>
 <%
 }else{
  %>
  
  <>
  alert(\'<%=writer%>님의 \\n 아이디가 없거나 비밀번호가 틀렸습니다\');
  href=\"list.jsp\";
</>
  <%
 }
 
 stmt.close();
 con.close();
} catch(SQLException ex){
    out.println(\"연결실패\");
}
%>
ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"EUC-KR\" %>
<%
String id=(String)session.getAttribute(\"db_id\");
String name=(String)session.getAttribute(\"db_name\");


%>
<%
 if(id == null){
%>

    <html>

    <head>


    </head>

    <body >


<form action =\"pan_join_ok.jsp\" method = \"post\" name = \"write\" >
<input type=\"hidden\" value=\'1\' name=\'q\'>
<table width = \"400\" border = \"1\" cellspacing = \"0\" cellpadding = \"0\" align = \"center\">
<tr>
 <td align = \"right\" colspan = \"2\">
  <a href = \"list.jsp\">글 목록</a>
 </td>
</tr>
<tr>
 <td width = \"70\" name=\"writer\" align= \"center\"><br>
 이 름</td>
 <td width = \"330\">
 <input type=\"text\" name=\'writer\' style=\"IME-MODE: disabled\"><br>
  
 </td>
</tr>
<tr>
 <td width = \"70\"  align = \"center\">제 목</td>
 <td width = \"330\">
  
   <input type = \"text\" size = \"40\" maxlength = \"50\" name = \"subject\">
  
   <input type = \"text\" size = \"40\" maxlength = \"50\" name = \"subject\" value = \"[답변]\">
 
 </td>
</tr>
<tr>
 <td width = \"70\"  align = \"center\" name =\"email\">Email</td>
 <td width = \"330\">
  <input type = \"text\" size = \"40\" maxlength = \"30\" name = \"email\">
 </td>
</tr>
<tr>
 <td width = \"70\" align = \"center\" name=\"content\">내 용</td>
 <td width = \"330\">
  <textarea name = \"content\" rows = \"13\" cols = \"40\"></textarea>
 </td>
</tr>
<tr>
 <td width = \"70\"  align = \"center\">비밀번호</td>
 <td width = \"330\">
  <input type = \"password\" size = \"8\" maxlength = \"12\" name = \"password\">
 </td>
</tr>
<tr>
 <td colspan = \"2\"  align = \"center\">
  <input type = \"submit\" value = \"글 쓰기\">
   <a href=\"pan_join.jsp\"><input type=\"button\" name=\"button\" id=\"button\" value=\"글 쓰기\" > </a></td></td>
   

  
 </td>
</tr>
</table>
</form>
<%}else{%> <center>
<%=name%>님 안녕하세요<br>
아이디는 <%=id%> 입니다.<br>

 

<%}%>
</center>
</body>
</html>
ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
<%@ page contentType=\"text/html; charset=euc-kr\" %>
<%@ page import=\"java.sql.*\" %>
<%@ page import=\"java.util.*\" %>

   <%

    String writer = new String(request.getParameter(\"writer\").getBytes(\"ISO-8859-1\"),\"euc-kr\");
    String email = new String(request.getParameter(\"email\").getBytes(\"ISO-8859-1\"),\"euc-kr\");
 String subject = new String(request.getParameter(\"subject\").getBytes(\"ISO-8859-1\"),\"euc-kr\");
 String password = new String(request.getParameter(\"password\").getBytes(\"ISO-8859-1\"),\"euc-kr\");
 String content = new String(request.getParameter(\"content\").getBytes(\"ISO-8859-1\"),\"euc-kr\");
 
Class.forName(\"com.microsoft.sqlserver.jdbc.SQLServerDriver\");
try{
   String connectionUrl = \"jdbc:sqlserver://203.230.158.236:1433;database=db_2008141085;user=db_2008141085;password=1184921\";
   Connection con = DriverManager.getConnection(connectionUrl);
 Statement stmt = con.createStatement();
 // sql 내용처리
 String SQL= \"insert into board(writer,email,subject,password,content) values\"+\"(\'\"+writer+\"\',\'\"+email+\"\',\'\"+subject+\"\',\'\"+password+\"\',\'\"+content+\"\')\";
 ResultSet RS=stmt.executeQuery(SQL);
 stmt.close();
 con.close();
} catch(SQLException ex){
 %>
<>
  alert(\'게시물이 등록되었습니다.\');
  href=\"list.jsp\";
</>
 <%
}

%>