게시판 1단계 10

 

write_ok.jsp

<%@page import="java.net.InetAddress"%>
<%@page import="java.sql.Timestamp"%>
<%@page import="java.util.Date"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="magic.board.BoardDBBean"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<% request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="board" class="magic.board.BoardBean"></jsp:useBean>
<jsp:setProperty property="*" name="board"/>
<%
     InetAddress address = InetAddress.getLocalHost();
    String ip = address.getHostAddress();
    board.setB_ip(ip);
    BoardDBBean manager = BoardDBBean.getInstance();
     board.setB_date(new Timestamp(System.currentTimeMillis()));
         
    if(manager.insertBoard(board)==1){
        response.sendRedirect("list.jsp");
    }else{
        response.sendRedirect("write.jsp");
    }
%>
 

 

- 위에 0만 나온거는

 

 

- 이렇게 구했을 때 나온 거

BoardDBBean.java

package magic.board;
 
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
 
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
 
import magic.member.MemberBean;
 
public class BoardDBBean {
    
private static BoardDBBean instance = new BoardDBBean();
    
    public static BoardDBBean getInstance() {
        return instance;
    }
    
    public Connection getConnection() throws Exception {
        Context ctx = new InitialContext();
        DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/oracle");
        return ds.getConnection();
    }
    public int insertBoard(BoardBean board) {
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        String sql="";
        int re = -1;
        int number;
        try {
            con = getConnection();
            sql = "select max(b_id) from boardT";
            ps = con.prepareStatement(sql);
            rs = ps.executeQuery();
            
            if(rs.next()) {
                number = rs.getInt(1)+1;
            }else {
                number=1;
            }
//            sql = "insert into boardT (b_id,b_name,b_email,b_title,b_content,b_date,b_hit,b_pwd) values(?,?,?,?,?,?,?,?)";
            sql = "insert into boardT (b_id,b_name,b_email,b_title,b_content,b_date,b_pwd,b_ip) values(?,?,?,?,?,?,?,?)";
            ps = con.prepareStatement(sql);
            ps.setInt(1, number);
            ps.setString(2, board.getB_name());
            ps.setString(3, board.getB_email());
            ps.setString(4, board.getB_title());
            ps.setString(5, board.getB_content());
            ps.setTimestamp(6, board.getB_date());
//            ps.setInt(7, board.getB_hit());
//            ps.setString(8, board.getB_pwd());
            ps.setString(7, board.getB_pwd());
            ps.setString(8, board.getB_ip());
            ps.executeUpdate();
            re = 1;
            ps.close();
            con.close();
            System.out.println("추가 성공");
        } catch (Exception e) {
            System.out.println("추가 실패");
            e.printStackTrace();
        }finally {
            try {
                if (ps != null) ps.close();
                if (con != null) con.close();
            } catch (Exception e2) {
                e2.printStackTrace();
            }
        }
        return re;
    }
    public ArrayList<BoardBean> listBoard(){
        ArrayList<BoardBean> boardList = new ArrayList<BoardBean>();
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;;
        String sql = "select * from boardt order by b_id";
        
        try {
            con = getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            
            while (rs.next()) {
                BoardBean board = new BoardBean();        
                board.setB_id(rs.getInt("b_id"));
                board.setB_name(rs.getString("b_name"));
                board.setB_email(rs.getString("b_email"));
                board.setB_title(rs.getString("b_title"));
                board.setB_content(rs.getString("b_content"));
                board.setB_date(rs.getTimestamp("b_date"));
                board.setB_hit(rs.getInt("b_hit"));
                board.setB_pwd(rs.getString("b_pwd"));
                board.setB_ip(rs.getString("b_ip"));
                
                boardList.add(board);
            }
            rs.close();
            st.close();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            try {
                if(rs != null) rs.close();
                if(st != null) st.close();
                if(con != null) con.close();
            } catch (Exception e2) {
                e2.printStackTrace();
            }
        }
        return boardList;
    }
    
    public BoardBean getBoard(int id, boolean bo) {
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        BoardBean board = new BoardBean();
        
        String sql = "";
        
        try {
            con = getConnection();
            if(bo==true) {
            sql = "update boardt set b_hit=b_hit+1 where b_id=?";
            ps = con.prepareStatement(sql);
            ps.setInt(1, id);            
            ps.executeUpdate();
            
            sql = "select * from boardT where b_id=?";
            ps = con.prepareStatement(sql);
            ps.setInt(1, id);
            rs = ps.executeQuery();
            }else {
            sql = "select * from boardT where b_id=?";
            ps = con.prepareStatement(sql);
            ps.setInt(1, id);
            rs = ps.executeQuery();
            }
            if (rs.next()) {
                board.setB_id(rs.getInt("b_id"));
                board.setB_name(rs.getString("b_name"));
                board.setB_email(rs.getString("b_email"));
                board.setB_title(rs.getString("b_title"));
                board.setB_content(rs.getString("b_content"));
                board.setB_date(rs.getTimestamp("b_date"));
                board.setB_hit(rs.getInt("b_hit"));
                board.setB_pwd(rs.getString("b_pwd"));
                board.setB_ip(rs.getString("b_ip"));
                
            }
            rs.close();
            ps.close();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return board;
    }
    
    public int deleteBoard(int id, String b_pwd) {
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        int re=-1;
        String pwd="";
        String sql="";
        
        try {
            con = getConnection();
            sql = "select b_pwd from boardT where b_id=?";
            ps = con.prepareStatement(sql);
            ps.setInt(1, id);
            rs = ps.executeQuery();
            
            if (rs.next()) {
                pwd = rs.getString(1);
                
                if (!pwd.equals(b_pwd)) {
                    re=0;
                } else {
                    sql="delete from boardT where b_id=?";
                    ps = con.prepareStatement(sql);
                    ps.setInt(1, id);
                    ps.executeUpdate();
                    re=1;
                }
            }
            rs.close();
            ps.close();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return re;    
    }
    
    public int editBoard(BoardBean board) {
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        String pwd="";
        String sql="";
        int re = -1;
        
        try {
            con = getConnection();
            sql = "select b_pwd from boardT where b_id=?";
            ps = con.prepareStatement(sql);
            ps.setInt(1, board.getB_id());
            rs = ps.executeQuery();
            
            if(rs.next()) {
                pwd = rs.getString(1);
                if (!pwd.equals(board.getB_pwd())) {
                    re=0;
                } else {
                    sql = "update boardT set b_name=?, b_email=?, b_title=?, b_content=? where b_id=?";
                    ps = con.prepareStatement(sql);
                    ps.setString(1, board.getB_name());
                    ps.setString(2, board.getB_email());
                    ps.setString(3, board.getB_title());
                    ps.setString(4, board.getB_content());
                    ps.setInt(5, board.getB_id());
                    ps.executeUpdate();
                    re=1;
                }
            }
            rs.close();
            ps.close();
            con.close();            
        } catch (Exception e) {
            e.printStackTrace();
        }
        return re;
    }
}