728x90
BoardDBBean.java
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
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) 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.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"));
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;
}
}
|
cs |
write_ok.jsp
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<%@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"/>
<%
BoardDBBean manager = BoardDBBean.getInstance();
//manager.insertBoard(board);
if(manager.insertBoard(board)==1){
response.sendRedirect("list.jsp");
}else{
response.sendRedirect("write.jsp");
}
%>
|
cs |
list.jsp
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
<%@page import="java.util.ArrayList"%>
<%@page import="magic.member.MemberBean"%>
<%@page import="magic.board.BoardDBBean"%>
<%@page import="magic.board.BoardBean"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%
BoardDBBean bd = BoardDBBean.getInstance();
ArrayList<BoardBean> boardList = bd.listBoard();
int b_id = 0;
String b_name, b_email, b_title, b_content;
%>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
<center>
<h1>게시판에 등록된 글 목록 보기</h1>
<table width="600">
<tr>
<td align="right">
<a href="write.jsp">글쓰기</a>
</td>
</tr>
</table>
</center>
<table border="1" width="800" cellspacing="0">
<tr height="25">
<td width="40" align="center">번호</td>
<td width="450" align="center">글제목</td>
<td width="120" align="center">작성자</td>
</tr>
<%
for(int i=0;i<boardList.size();i++){
BoardBean board = boardList.get(i);
b_id = board.getB_id();
b_name = board.getB_name();
b_email = board.getB_email();
b_title = board.getB_title();
b_content = board.getB_content();
%>
<tr height="25" bgcolor="#f7f7f7"
onmouseover="this.style.backgroundColor='#eeeeef'"
onmouseout="this.style.backgroundColor='#f7f7f7'">
<td align="center"><%= b_id %></td>
<td><%= b_title %></td>
<td align="center">
<a href="mailto:<%=b_email %>">
<%= b_name %>
</a>
</td>
</tr>
<%
}
%>
</table>
</body>
</html>
|
cs |
write.jsp
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
<script type="text/javascript" src="board.js" charset="utf-8"></script>
<style type="text/css">
div{
text-align: center;
}
</style>
</head>
<body>
<h1 align="center">글 올 리 기</h1>
<form action="write_ok.jsp" method="post" name="reg_form">
<div>
작성자<input type="text" size="20" name="b_name">
이메일<input type="text" size="20" name="b_email"><br><br>
글제목<input type="text" size="50" name="b_title"><br>
<textarea rows="10" cols="70" name="b_content"></textarea><br>
<input type="button" value="글쓰기" onclick="check_ok()">
<input type="reset" value="다시작성">
<input type="button" value="글목록" onclick="location = 'list.jsp'">
</div>
</form>
</body>
</html>
|
cs |
728x90
'학원 > JSP - 학원' 카테고리의 다른 글
| 게시판 1단계 5~6 (0) | 2022.03.28 |
|---|---|
| 게시판 1단계 4 (0) | 2022.03.28 |
| 게시판 1단계 2 (0) | 2022.03.25 |
| 게시판 1단계 1 (0) | 2022.03.23 |
| 사용자 관리 3단계 2번 (0) | 2022.03.23 |
