DA: 신입SW인력을 위한 실전 자바(Java) 스프링(Spring) 동영상과정 16~21 게시판 작성하기

이 게시물은
http://www.wiz.center/246
http://www.wiz.center/247
http://www.wiz.center/248
http://www.wiz.center/249
http://www.wiz.center/250

해당 링크를 청취하고 작성한 글입니다.

본인 이해도 확인을 위해서 작성한 것이니
스프링에 대해서 알고 있다면 쑥 훝어보고 끝내시고

좀 깊게 알고 싶다면 위의 링크부터 시작해서
총 30개 강의로 이루어진 스프링 과정을 청취하세요

1. 게시판 설계
기본 진행 혹은 db 작업을 요청한 경우
: 사용자요청 -> dispatcher-> Controller
-> command(s) -> DAo -> DB
DB작업 후 혹은 db를 거치지 않는 요청
: Controller -> view(s) (jsp 파일)
* 데이터 객체는 DTO로 작성

2. DB 작성
예제는 Oracle 테이블 구축이지만 여기서는 Mysql 로 작성
Mysql 설치방법은 Oracle.com 에서 받는데 이중 mysqld 로
프로세스만 띄워서 진행하는 방법으로 (pc에 주는 부하가 싫어서)
진행함.
테이블 작성의 경우 Oracle과 다른점은 크게 없지만

bId 의 경우 AUTO_INCREMENT 설정을 줘서
자동으로 번호 부여가 가능하다

varchar2 -> varchar

sysdate -> current_timestamp or now() or 트리거 사용
으로 설정 가능 버전마다 상이함

CHARSET=utf8 인데 세부 옵션은 utf8_general_ci

CREATE TABLE IF NOT EXISTS `mvc_board` (
  `bId` int(4) NOT NULL AUTO_INCREMENT,
  `bName` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `bTitle` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `bContent` varchar(300) CHARACTER SET latin1 DEFAULT NULL,
  `bDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `bHit` int(4) DEFAULT '0',
  `bGroup` int(4) DEFAULT NULL,
  `bStep` int(4) DEFAULT NULL,
  `bIndent` int(4) DEFAULT NULL,
  PRIMARY KEY (`bId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

복습 : 계층형 게시판 참고사항

bGroup <> 로 표시함
게시판 원글부터 시작하여 같은 글에 포함된 댓글 모두는
같은 번호를 가지게 된다.
원글 <1>
└답변 <1>
└답변 <1>
  └답변 <1>
└답변 <1>
원글 <2>
  └답변 <2>
└답변 <2>

bStep ()로 표시
몇번째 글인지를 표시
원글 <1> (1)
└답변 <1> (2)
└답변 <1> (3)
  └답변 <1> (4)
└답변 <1> (5)
원글 <2> (1)
  └답변 <2> (2)
└답변 <2> (3)

bIndent []로 표시
위에서 몇번째 들여쓰기 대상인가 (원본글의 댓글인가 댓글의 댓글인가)
원글 <1> (1) [1]
└답변 <1> (2) [2]
└답변 <1> (3) [2]
  └답변 <1> (4) [3]
└답변 <1> (5) [2]
원글 <2> (1) [1]
  └답변 <2> (2) [2]
└답변 <2> (3) [3]

3. 프로젝트 생성
1) spring Project - spring MVC Project 로 생성
프로젝트명은 : spring_pjt_board
패키지는 : com.javalec.spring_pjt_board

2) web.xml 에 다음 내용을 추가(한글 깨짐 방지)


 encodingFilter
 org.springframework.web.filter.CharacterEncodingFilter

 
  encoding
  UTF-8
 



 encodingFilter
 /*

3. list 페이지 작성
1) 패키지 및 클래스 생성

ps. 이때 BCommand 는
void execute(Model model);
함수를 가지는 interface고
나머지는 Command를 implements 할 것.

2) 컨트롤러를 인식하기 위한 servlet 셋팅
servlet-context.xml 의 context:component-scan base-package
를 아래와 같이 변경

3) 컨트롤러 작성 및 메소드별 유형
(3-1) 단순한 페이지 요청
- 작업 화면 지시

 @RequestMapping("/write_view")
 public String write_view(Model model){
  System.out.println("write_view()");
  //작성화면 호출이라 입력할수 있는 화면으로 이동만 담당
  return "write_view";
 }

(3-2) DB에서 자료를 가지고 화면에 보여줘야 되는 경우
- list

 @RequestMapping("/list")
 public String like(Model model){
  System.out.println("list()");
  command = new BListCommand();
  command.execute(model);
  
  return "list";
 }

(3-3) form 객체를 받아 처리해야하는 경우
- 수정, 변경 작업 진행시

 @RequestMapping("/content_view")
 public String content_view(HttpServletRequest request, Model model){
  System.out.println("content_view()");
  
  model.addAttribute("request", request);
  command = new BContentCommand();
  command.execute(model);
  
  return "content_view";
 }

작업 환경에 따라 변경 적용 하여 진행

package com.javalec.spring_pjt_board.controller;

import javax.servlet.http.HttpServletRequest;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import com.javalec.spring_pjt_board.command.BCommand;
import com.javalec.spring_pjt_board.command.BContentCommand;
import com.javalec.spring_pjt_board.command.BDeleteCommand;
import com.javalec.spring_pjt_board.command.BListCommand;
import com.javalec.spring_pjt_board.command.BModifyCommand;
import com.javalec.spring_pjt_board.command.BReplyCommand;
import com.javalec.spring_pjt_board.command.BReplyViewCommand;
import com.javalec.spring_pjt_board.command.BWriteCommand;

@Controller
public class BController {
 BCommand command;
 
 @RequestMapping("/list")
 public String like(Model model){
  System.out.println("list()");
  command = new BListCommand();
  command.execute(model);
  
  return "list";
 }
 
 @RequestMapping("/write_view")
 public String write_view(Model model){
  System.out.println("write_view()");
  //작성화면 호출이라 입력할수 있는 화면으로 이동만 담당
  return "write_view";
 }
 
 @RequestMapping("/write")
 public String write(HttpServletRequest request, Model model){
  System.out.println("write()");
  model.addAttribute("request", request);
  command = new BWriteCommand();
  command.execute(model);
  
  return "redirect:list";
 }
 
 @RequestMapping("/content_view")
 public String content_view(HttpServletRequest request, Model model){
  System.out.println("content_view()");
  
  model.addAttribute("request", request);
  command = new BContentCommand();
  command.execute(model);
  
  return "content_view";
 }
 
 @RequestMapping(method=RequestMethod.POST, value="/modify")
 public String modify(HttpServletRequest request, Model model){
  System.out.println("modify");
  
  model.addAttribute("request", request);
  command = new BModifyCommand();
  command.execute(model);
  
  return "redirect:list";
 }
 
 @RequestMapping("/reply_view")
 public String reply_view(HttpServletRequest request, Model model){
  System.out.println("reply_view()");
  
  model.addAttribute("request", request);
  command = new BReplyViewCommand();
  command.execute(model);
  
  return "reply_view";
 }
 
 @RequestMapping("/reply")
 public String reply(HttpServletRequest request, Model model){
  System.out.println("reply()");
  
  model.addAttribute("request", request);
  command = new BReplyCommand();
  command.execute(model);
  
  return "redirect:list";
 }
 @RequestMapping("/delete")
 public String delete(HttpServletRequest request, Model model){
  System.out.println("delete()");
  
  model.addAttribute("request", request);
  command = new BDeleteCommand();
  command.execute(model);
  
  return "redirect:list";
 }
}

3) DTO 객체 작성

- 테이블 구조와 같은 멤버변수를 지니도록 작성

, set 및 get 함수를 생성

, list() 라는 함수를 만들어 각 멤버변수가 들어가도록 생성

package com.javalec.spring_pjt_board.dto;

import java.sql.Timestamp;

public class BDto {
 int bId;
 String bName;
 String bTitle;
 String bContent;
 Timestamp bDate;
 int bHit;
 int bGroup;
 int bStep;
 int bIndent;
 
 public BDto(){
  
 }
 
 public BDto(int bId, String bName, String bTitle, String bContent, Timestamp bDate, int bHit, int bGroup, int bStep, int bIndent){
  this.bId = bId;
  this.bName = bName;
  this.bTitle = bTitle;
  this.bContent = bContent;
  this.bDate = bDate;
  this.bHit = bHit;
  this.bGroup = bGroup;
  this.bStep = bStep;
  this.bIndent = bIndent;
    
 }
 
 public String getbContent() {
  return bContent;
 }

 public void setbContent(String bContent) {
  this.bContent = bContent;
 }

 

 public int getbId() {
  return bId;
 }

 public void setbId(int bId) {
  this.bId = bId;
 }

 public String getbName() {
  return bName;
 }

 public void setbName(String bName) {
  this.bName = bName;
 }

 public String getbTitle() {
  return bTitle;
 }

 public void setbTitle(String bTitle) {
  this.bTitle = bTitle;
 }

 public Timestamp getbDate() {
  return bDate;
 }

 public void setbDate(Timestamp bDate) {
  this.bDate = bDate;
 }

 public int getbHit() {
  return bHit;
 }

 public void setbHit(int bHit) {
  this.bHit = bHit;
 }

 public int getbGroup() {
  return bGroup;
 }

 public void setbGroup(int bGroup) {
  this.bGroup = bGroup;
 }

 public int getbStep() {
  return bStep;
 }

 public void setbStep(int bStep) {
  this.bStep = bStep;
 }

 public int getbIndent() {
  return bIndent;
 }

 public void setbIndent(int bIndent) {
  this.bIndent = bIndent;
 }
}

3-1) DB설정을 Mysql로 하기위해 다음 작업을 추가

아래 링크 참고하여 작성

http://www.mkyong.com/tomcat/how-to-configure-mysql-datasource-in-tomcat-6/

4) DAO 작성

* query 작성시 주의

* 현재는 내용대로 불편한 방식으로 작성 후

차후 좀더 편한방식

(mybatis, ibatis, xml) 이나

사용목적에 따라 (ajax 등)

으로 변경예정

package com.javalec.spring_pjt_board.dao;

import java.sql.Connection; 
import java.sql.PreparedStatement;
import java.sql.ResultSet; 
           //mysql 에서도 같은걸 제공하는데 그냥 sql꺼 쓸것.
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;

import javax.annotation.Resource;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

import com.javalec.spring_pjt_board.dto.BDto;

public class BDao {
 
 @Resource(name="jdbc/mysql")
 DataSource datasource;
 
 public BDao(){
  try {
   Context context = new InitialContext();
   datasource = (DataSource) context.lookup("java:comp/env/jdbc/mysql");
   
   
  } catch (NamingException e) {
   e.printStackTrace();
  }
 }
 
 public ArrayList list(){
  ArrayList dtos = new ArrayList();
  
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  ResultSet resultSet = null;
  
  try{
   connection = (Connection) datasource.getConnection();
   String query = "select bId, bName, bTitle, bContent, bDate, bHit, bGroup, bStep, bIndent from mvc_board order by bGroup desc, bStep asc";
   preparedStatement = (PreparedStatement) connection.prepareStatement(query);
   resultSet = preparedStatement.executeQuery();
   
   while(resultSet.next()){
    int bId = resultSet.getInt("bId");
    String bName = resultSet.getString("bName");
    String bTitle = resultSet.getString("bTitle");
    String bContent = resultSet.getString("bContent");
    Timestamp bDate = resultSet.getTimestamp("bDate");
    int bHit = resultSet.getInt("bHit");
    int bGroup = resultSet.getInt("bGroup");
    int bStep = resultSet.getInt("bStep");
    int bIndent = resultSet.getInt("bIndent");
    
    BDto dto = new BDto(bId, bName, bTitle, bContent, bDate, bHit, bGroup, bStep, bIndent);
    
    dtos.add(dto);
   }
   
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   
    try {
     if(resultSet != null)resultSet.close();
     if(preparedStatement != null)preparedStatement.close();
     if(connection != null)connection.close();
    } catch (SQLException e2) {
     // TODO Auto-generated catch block
     e2.printStackTrace();
    }
   
  }
  
  return dtos;
 }
}

5) list를 가져올 list.jsp 작성

(jstl + jsp 문법을 알고 진행)

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Insert title here</title>

</head>

<body>

<tr>

</tr>

<c:forEach items="${list}" var="dto">

<tr>

<td>${dto.bName}</td>

<td>

<c:forEach begin="1" end="${dto.bIndent}">-</c:forEach>

<a href="content_view?bId=${dto.bId}">${dto.bTitle}</a></td>

<td>${dto.bDate}</td>

</tr>

</c:forEach>

<tr>

</tr>

</table>

</body>

</html>

6) 실행

4. write 작성

1) write_view.jsp 작성

controller 에 아래와 같이 작성되어 있는 상태인데

 @RequestMapping("/write_view")
 public String write_view(Model model){
  System.out.println("write_view()");
  //작성화면 호출이라 입력할수 있는 화면으로 이동만 담당
  return "write_view";
 }

이중 앞에 건 그대로 페이지만 이동하게끔 하면 됨

이에 따라서 write_view.jsp 를 아래와 같이 작성한다.

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Insert title here</title>

</head>

<body>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr >

</tr>

</form>

</table>

</body>

</html>

2) write 라는 요청에 대해 대응 하기 위한 컨트롤러 작성 내용 확인

 @RequestMapping("/write")
 public String write(HttpServletRequest request, Model model){
  System.out.println("write()");
  model.addAttribute("request", request);
  command = new BWriteCommand();
  command.execute(model);
  
  return "redirect:list";
 }

그리고

BWriteCommand() 클래스 작성

package com.javalec.spring_pjt_board.command;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.ui.Model;

import com.javalec.spring_pjt_board.dao.BDao;

public class BWriteCommand implements BCommand {

 @Override
 public void execute(Model model) {
  // TODO Auto-generated method stub
  Map map = model.asMap();
  HttpServletRequest request = (HttpServletRequest) map.get("request");
  
  String bName = request.getParameter("bName");
  String bTitle = request.getParameter("bTitle");
  String bContent = request.getParameter("bContent");
  
  BDao dao = new BDao();
  
  dao.write(bName, bTitle, bContent);
  
 }

}

여기에서 호출하는 DAO 의 함수 작성

mysql에서는 시퀀스 증가값을 테이블에 하나씩 밖에 줄수 없기

때문에 id max 값을 가져와서 group 를 짓도록 작성함

그냥 조회해서 write 했다고 생각하면 됨.

 
 public void write(String bName, String bTitle, String bContent){
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  ResultSet resultSet = null;
  //mysql 추가분 group 의 경우 id와 같은 값이지만 (글 작성시)
  // mysql에는 증가값이 테이블당 1개만 작성가능해서 따로 구해서 insert를 진행하기로 함
  // 해당 예제는 처음 작성시에 대한 대응이 안되어 있음.
  
  int maxid=0;
  try{
   connection = (Connection) datasource.getConnection();
   String query = "select max(bId) as maxId from mvc_board";
   preparedStatement = (PreparedStatement) connection.prepareStatement(query);
   resultSet = preparedStatement.executeQuery();
   
   if(resultSet.next()){
    maxid = resultSet.getInt("maxId");
   }
   
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   
    try {
     if(resultSet != null)resultSet.close();
     if(preparedStatement != null)preparedStatement.close();
     if(connection != null)connection.close();
    } catch (SQLException e2) {
     // TODO Auto-generated catch block
     e2.printStackTrace();
    }
  }
  
  try{
   connection = datasource.getConnection();
   String query ="insert into test.mvc_board (bName, bTitle, bContent, bDate, bHit, bGroup, bStep, bIndent) "
     + "        values (?,?,?,now(),0,? ,0,0)";
      
   preparedStatement = connection.prepareStatement(query);
   preparedStatement.setString(1, bName);
   preparedStatement.setString(2, bTitle);
   preparedStatement.setString(3, bContent);
   preparedStatement.setInt(4, maxid);
   int rm = preparedStatement.executeUpdate();
   System.out.println("insert number :"+rm);
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   try{
    if(preparedStatement != null)preparedStatement.close();
    if(connection != null)connection.close();
   }catch(Exception e2){
    e2.printStackTrace();
   }
  }
 }

5. 게시글 보기 작성

1) 게시글에 대한 content_view.jsp 파일 작성

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Insert title here</title>

</head>

<body>

<tr>

<td> ${content_view.bId} </td>

</tr>

<tr>

<td> ${content_view.bHit} </td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td> <textarea rows="10" name="bContent" >${content_view.bContent}</textarea></td>

</tr>

<tr >

</tr>

</form>

</table>

</body>

</html>

2) 컨트롤러에서는 BContentCommand() 클래스에서

작성토록 설정하였기 때문에 해당 클래스를 작성한다.

 @Override
 public void execute(Model model) {
  // TODO Auto-generated method stub
  Map map = model.asMap();
  HttpServletRequest request = (HttpServletRequest) map.get("request");
  String bId = request.getParameter("bId");
  // after write
  BDao dao = new BDao();
  BDto dto = dao.contentView(bId);
  
  model.addAttribute("content_view", dto);
 }

3) BContentCommand() 에서 호출하는 dao.contentView(bId)

를 구현한다.

Content 가져올때 hit 숫자를 증가시키는 메소드를 포함하였음.

public BDto contentView(String strid){
  upHit(strid);
  
  BDto dto = null;
  
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  ResultSet resultSet = null;
  
  try{
   connection = (Connection) datasource.getConnection();
   
   String query = "select bId, bName, bTitle, bContent, bDate, bHit, bGroup, bStep, bIndent from mvc_board where bId=?";
   
   preparedStatement = (PreparedStatement) connection.prepareStatement(query);
   preparedStatement.setInt(1, Integer.parseInt(strid));
   resultSet = preparedStatement.executeQuery();
   
   if(resultSet.next()){
    int bId = resultSet.getInt("bId");
    String bName = resultSet.getString("bName");
    String bTitle = resultSet.getString("bTitle");
    String bContent = resultSet.getString("bContent");
    Timestamp bDate = resultSet.getTimestamp("bDate");
    int bHit = resultSet.getInt("bHit");
    int bGroup = resultSet.getInt("bGroup");
    int bStep = resultSet.getInt("bStep");
    int bIndent = resultSet.getInt("bIndent");
    dto = new BDto(bId, bName, bTitle, bContent, bDate, bHit, bGroup, bStep, bIndent);
    
   }
   
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   try{
   if(resultSet != null)resultSet.close();
   if(preparedStatement != null)preparedStatement.close();
   if(connection != null)connection.close();
   }catch(Exception e2){
    e2.printStackTrace();
   }
  }
  System.out.println(dto.toString());
  return dto;
 }

  private void upHit( String bId) {
  // TODO Auto-generated method stub
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  
  try {
   connection = (Connection) datasource.getConnection();
   String query = "update test.mvc_board set bHit = bHit + 1 where bId = ?";
   preparedStatement = connection.prepareStatement(query);
   preparedStatement.setString(1, bId);
   
   int rn = preparedStatement.executeUpdate();
     
  } catch (Exception e) {
   // TODO: handle exception
   e.printStackTrace();
  } finally {
   try {
    if(preparedStatement != null) preparedStatement.close();
    if(connection != null) connection.close();
   } catch (Exception e2) {
    // TODO: handle exception
    e2.printStackTrace();
   }
  }
 }

6. 글 수정 하기
1) jsp는 content_view.jsp 에서 보내는 form 을 확인
modify - POST 방식으로 보내는걸 확인 가능함

2) BCommand 인터페이스를 implements 한 BModifyCommand
를 작성한다.

package com.javalec.spring_pjt_board.command;

import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.ui.Model;

import com.javalec.spring_pjt_board.dao.BDao;
import com.javalec.spring_pjt_board.dto.BDto;

public class BModifyCommand implements BCommand {

 @Override
 public void execute(Model model) {
  // TODO Auto-generated method stub
  Map map = model.asMap();
  HttpServletRequest request = (HttpServletRequest) map.get("request");
  
  String bId = request.getParameter("bId");
  String bName = request.getParameter("bName");
  String bTitle = request.getParameter("bTitle");
  String bContent = request.getParameter("bContent");
  
  BDao dao = new BDao();
  dao.modify(bId, bName, bTitle, bContent);
 }
}

3) dao 에 트렌젝션 처리를 위한 작업을 진행한다.

public void modify(String bId, String bName, String bTitle, String bContent){
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  
  try{
   connection = (Connection) datasource.getConnection();
   
   String query = "update mvc_board set bName =?, bTitle=?, bContent=? where bId = ?";
   
   preparedStatement = (PreparedStatement) connection.prepareStatement(query);
   
   preparedStatement.setString(1, bName);
   preparedStatement.setString(2, bTitle);
   preparedStatement.setString(3, bContent);
   preparedStatement.setInt(4,Integer.parseInt(bId));
   
   int rn=preparedStatement.executeUpdate();
   
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   try{
   if(preparedStatement != null)preparedStatement.close();
   if(connection != null)connection.close();
   }catch(Exception e2){
    e2.printStackTrace();
   }
  }
 }

7. 글 삭제 하기
1) Controller 는 그대로 진행

2) BModifyCommand .java 작성

package com.javalec.spring_pjt_board.command;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.ui.Model;

import com.javalec.spring_pjt_board.dao.BDao;
import com.javalec.spring_pjt_board.dto.BDto;

public class BModifyCommand implements BCommand {

 @Override
 public void execute(Model model) {
  // TODO Auto-generated method stub
  Map map = model.asMap();
  HttpServletRequest request = (HttpServletRequest) map.get("request");
  
  String bId = request.getParameter("bId");
  String bName = request.getParameter("bName");
  String bTitle = request.getParameter("bTitle");
  String bContent = request.getParameter("bContent");
  
  BDao dao = new BDao();
  dao.modify(bId, bName, bTitle, bContent);

 }
}

3) Dao 에 delete 함수 작성

public void delete(String bId) {
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  
  try{
   connection = (Connection) datasource.getConnection();
   
   String query = "delete from mvc_board where bId = ?";
   
   preparedStatement = (PreparedStatement) connection.prepareStatement(query);
   
   preparedStatement.setInt(1,Integer.parseInt(bId));
   
   int rn=preparedStatement.executeUpdate();
   
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   try{
   if(preparedStatement != null)preparedStatement.close();
   if(connection != null)connection.close();
   }catch(Exception e2){
    e2.printStackTrace();
   }
  }
 }

8. 글 답변 페이지 만들기

1) 글에서 답변을 눌렀을때 뜨는 화면인 reply_view.jsp를
아래와 같이 작성

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>

<table width="500" cellpadding="0" cellspacing="0" border="1">
<form action="reply" method="post">
<input type="hidden" name="bId" value="${reply_view.bId}">
<input type="hidden" name="bGroup" value="${reply_view.bGroup}">
<input type="hidden" name="bStep" value="${reply_view.bStep}">
<input type="hidden" name="bIndent" value="${reply_view.bIndent}">
<tr>
<td> 번호 </td>
<td> ${reply_view.bId} </td>
</tr>
<tr>
<td> 히트 </td>
<td> ${reply_view.bHit} </td>
</tr>
<tr>
<td> 이름 </td>
<td> <input type="text" name="bName" value="${reply_view.bName}"></td>
</tr>
<tr>
<td> 제목 </td>
<td> <input type="text" name="bTitle" value="${reply_view.bTitle}"></td>
</tr>
<tr>
<td> 내용 </td>
<td> <textarea rows="10" name="bContent">${reply_view.bContent}</textarea></td>
</tr>
<tr >
<td colspan="2"><input type="submit" value="답변"> <a href="list" >목록</a></td>
</tr>
</form>
</table>

</body>
</html>

2) 컨트롤러에서 해당 내용 확인 및 ReplyViewCommand.java 구현

package com.javalec.spring_pjt_board.command;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.ui.Model;

import com.javalec.spring_pjt_board.dao.BDao;
import com.javalec.spring_pjt_board.dto.BDto;

public class BReplyViewCommand implements BCommand {

 @Override
 public void execute(Model model) {
  Map map = model.asMap();
  HttpServletRequest request = (HttpServletRequest) map.get("request");
  
  String bId = request.getParameter("bId");
  
  BDao dao = new BDao();
  BDto dto = dao.reply_view(bId);
  
  model.addAttribute("replay_view", dto);
 }
}

3) dto.reply_view(bID) 구현

 public BDto reply_view(String bid) {
  BDto dto = new BDto();
  
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  ResultSet resultSet = null;
  
  
  try{
   connection = (Connection) datasource.getConnection();
   
   String query = "select * from mvc_board where bId = ?";
   
   preparedStatement = (PreparedStatement) connection.prepareStatement(query);
   preparedStatement.setInt(1,Integer.parseInt(bid));
   
   resultSet = preparedStatement.executeQuery();
   
   if(resultSet.next()){
    int bId = resultSet.getInt("bId");
    String bName = resultSet.getString("bName");
    String bTitle = resultSet.getString("bTitle");
    String bContent = resultSet.getString("bContent");
    Timestamp bDate = resultSet.getTimestamp("bDate");
    int bHit = resultSet.getInt("bHit");
    int bGroup = resultSet.getInt("bGroup");
    int bStep = resultSet.getInt("bStep");
    int bIndent = resultSet.getInt("bIndent");
    
    dto = new BDto(bId, bName, bTitle, bContent, bDate, bHit, bGroup, bStep, bIndent);
    
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   try{
   if(resultSet != null)connection.close();
   if(preparedStatement != null)preparedStatement.close();
   if(connection != null)connection.close();
   
   }catch(Exception e2){
    e2.printStackTrace();
   }
  }
  
  return dto;
 }

4) BReplyCommand.java 작성

package com.javalec.spring_pjt_board.command;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.ui.Model;

import com.javalec.spring_pjt_board.dao.BDao;

public class BReplyCommand implements BCommand {

 @Override
 public void execute(Model model) {
  Map map = model.asMap();
  HttpServletRequest request = (HttpServletRequest) map.get("request");
  
  String bId =  request.getParameter("bId");
  String bName =  request.getParameter("bName");
  String bTitle =  request.getParameter("bTitle");
  String bContent =  request.getParameter("bContent");
  String bGroup =  request.getParameter("bGroup");
  String bStep =  request.getParameter("bStep");
  String bIndent =  request.getParameter("bIndent");
  
  BDao dao = new BDao();
  dao.reply(bId, bName, bTitle, bContent, bGroup, bStep, bIndent);
 }

}

5) dao 에 다음 두개 함수를 추가

 public void reply(String bId, String bName, String bTitle, String bContent, String bGroup, String bStep, String bIndent) {
  replyShape(bGroup, bStep);
  
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  
  try{
   connection = (Connection) datasource.getConnection();
   
   String query = "insert into test.mvc_board(bName, bTitle, bContent, bDate, bHit, bGroup, bStep, bIndent) values (?,?,?,now(),0,?,?,?)";
   
   preparedStatement = (PreparedStatement) connection.prepareStatement(query);
   
   preparedStatement.setString(1,bName);
   preparedStatement.setString(2,bTitle);
   preparedStatement.setString(3,bContent);
   preparedStatement.setInt(4,Integer.parseInt(bGroup));
   preparedStatement.setInt(5,Integer.parseInt(bStep)+1);
   preparedStatement.setInt(6,Integer.parseInt(bIndent)+1);
   
   int rn=preparedStatement.executeUpdate();
   
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   try{
   if(preparedStatement != null)preparedStatement.close();
   if(connection != null)connection.close();
   }catch(Exception e2){
    e2.printStackTrace();
   }
  }
 }
 

 private void replyShape( String strGroup, String strStep) {
  // TODO Auto-generated method stub
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  
  try {
   connection = datasource.getConnection();
   String query = "update mvc_board set bStep = bStep + 1 where bGroup = ? and bStep > ?";
   preparedStatement = connection.prepareStatement(query);
   preparedStatement.setInt(1, Integer.parseInt(strGroup));
   preparedStatement.setInt(2, Integer.parseInt(strStep));
   
   int rn = preparedStatement.executeUpdate();
  } catch (Exception e) {
   // TODO: handle exception
   e.printStackTrace();
  } finally {
   try {
    if(preparedStatement != null) preparedStatement.close();
    if(connection != null) connection.close();
   } catch (Exception e2) {
    // TODO: handle exception
    e2.printStackTrace();
   }
  }
 }

9. 게시판 작성중 한글 처리 관련 오류 수정 방법
자세한 방법은 아래 링크를 참고할 것.
http://blog.naver.com/akrmak6/203238987

포인트는 db 설정을 바꿈 -> 컬럼, 테이블 설정 문자셋을 교체
(컬럼별로도로 문자셋이 있음) -> mysql 재시작
ok
Oracle 로 하면 잘되는데 Mysql, MariaDB 두가지는
위처럼 set 별, table, 컬럼별 설정이 동일해야
정상적으로 한글을 표현 할 수 있다.
그렇지만 결론은 플잭 초기에 확인되기 때문에 이것때문에
고생할 일은 없다.

DA

2015년 7월 28일 화요일

신입SW인력을 위한 실전 자바(Java) 스프링(Spring) 동영상과정 16~21 게시판 작성하기

댓글 없음:

댓글 쓰기