1. WebContent\list.jsp
jsp파일을 하나 만들고, 다음 코드를 입력한다.
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>게시판</title>
</head>
<body>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr height="5"><td width="5"></td></tr>
<tr style="background:url('img/table_mid.gif') repeat-x; text-align:center;">
<td width="5"><img src="img/table_left.gif" width="5" height="30"/></td>
<td width="73">번호</td>
<td width="379">제목</td>
<td width="73">작성자</td>
<td width="163">작성일</td>
<td width="58">조회수</td>
<td width="7"><img src="img/table_right.gif" width="5" height="30"/></td>
</tr>
<tr height="25" align="center">
</tr>
<tr height="1" bgcolor="#D2D2D2"><td colspan="6"></td></tr>
<tr height="1" bgcolor="#82B5DF"><td colspan="6" width="752"></td></tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td colspan="4" height="5">
</td>
</tr>
<tr align="center">
<td> <input type=button value="글쓰기"></td>
</tr>
</table>
</body>
</html>
2. WebContent\img 폴더 생성 및 이미지 추가
3. MySql 테이블 생성
4. MySql 연결
1) MySql Connector을 다운받아, WebContent> WEB-INF> lib에 붙여넣는다.
http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.1.12.zip/from/pick
2) 다음 코드를 입력하면 DB연결을 할 수 있다.
5. 데이터 출력
<%@ page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>게시판</title>
</head>
<body>
<%
String dbUrl = "jdbc:mysql://localhost:3306/board";
Class.forName("com.mysql.jdbc.Driver");
try {
Connection conn = DriverManager.getConnection(dbUrl, "root","1234");
Statement stmt = conn.createStatement();
int total = 0;
String SQL = "select count(*) from board";
ResultSet rs = stmt.executeQuery(SQL);
if(rs.next()){
total = rs.getInt(1);
}
rs.close();
out.print("총 게시물 : " + total + "개");
String sqlList = "SELECT ID, USERNAME, TITLE, TIME, HIT FROM BOARD ORDER BY ID DESC";
rs = stmt.executeQuery(sqlList);
%>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr height="5"><td width="5"></td></tr>
<tr style="background:url('img/table_mid.gif') repeat-x; text-align:center;">
<td width="5"><img src="img/table_left.gif" width="5" height="30"/></td>
<td width="73">번호</td>
<td width="379">제목</td>
<td width="73">작성자</td>
<td width="163">작성일</td>
<td width="58">조회수</td>
<td width="7"><img src="img/table_right.gif" width="5" height="30"/></td>
</tr>
<%
if(total==0) {
%>
<tr align="center" bgcolor="#FFFFFF" height="30">
<td colspan="6">등록된 글이 없습니다.</td>
</tr>
<%
} else {
while(rs.next()){
int idx = rs.getInt(1);
String name = rs.getString(2);
String title = rs.getString(3);
String time = rs.getString(4);
int hit = rs.getInt(5);
%>
<tr height="25" align="center">
<td> </td>
<td><%=idx %></td>
<td align="left"><%=title %></td>
<td align="center"><%=name %></td>
<td align="center"><%=time %></td>
<td align="center"><%=hit %></td>
<td> </td>
</tr>
<tr height="1" bgcolor="#D2D2D2"><td colspan="6"></td></tr>
<%
}
}
rs.close();
stmt.close();
conn.close();
} catch(SQLException e) {
out.print(e.toString());
}
%>
<tr height="1" bgcolor="#82B5DF"><td colspan="6" width="752"></td></tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td colspan="4" height="5">
</td>
</tr>
<tr align="center">
<td> <input type=button value="글쓰기"></td>
</tr>
</table>
</body>
</html>
'JSP > 게시판' 카테고리의 다른 글
| [6] JSP_게시판_글수정 (0) | 2014.02.12 |
|---|---|
| [5] JSP_게시판_글삭제 (0) | 2014.02.12 |
| [4] JSP_게시판_내용보기 (0) | 2014.02.12 |
| [3] JSP_게시판_글쓰기 (3) | 2014.02.12 |
| [1] JSP_게시판_게시판 설계 (0) | 2014.02.11 |