어제는 코드를 따라쳐서 만든거고 오늘은 구글링과 조금의 커닝으로... 만들어 보라고 해서 만들어봄
list.jsp
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.*"%>
<%@ 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>
</head>
<style>
table { width:780px;
background-color: antiquewhite;
text-align:center;}
td { background-color: white;}
th { background-color: antiquewhite;}
</style>
<%
Class.forName("org.mariadb.jdbc.Driver");
try {
Connection conn = DriverManager.getConnection(
"jdbc:mariadb://localhost:3307/jspdb", "root", "maria");
//쿼리 실행
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from board order by num desc");
{
%>
<table border="1">
<tr>
<th style="width: 10px;">번호</th>
<th style="width: 30px;">제목</th>
<th style="width: 10px;">작성자</th>
<th style="width: 10px;">등록일</th>
<th style="width: 0px; padding: 10px;"> 조회</th>
</tr>
<%
while(rs.next()){
%>
<tr>
<td><%=rs.getInt("num") %></td>
<td style="text-align:left;">
<a href="view.jsp?num=<%=rs.getInt("num") %>">
<%=rs.getString("title") %>
</a>
</td>
<td><%=rs.getString("writer") %></td>
<td><%=rs.getString("regtime") %></td>
<td><%=rs.getInt("hits") %></td>
</tr>
<%
}
}}catch(Exception e){
e.printStackTrace();
}
%>
</table>
<br>
<input type="button" value="글쓰기" onclick="location.href='view.jsp'">
</body>
</html>
view.jsp
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
int num = Integer.parseInt(request.getParameter("num"));
String writer = "";
String title = "";
String content = "";
String url = "jdbc:mariadb://localhost:3307/jspdb";
String user = "root";
String pass = "maria";
int hits = 0;
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<style>
table { width:680px;
background-color: antiquewhite;
text-align:center;}
td { background-color: white;
width:600px; text-align:left;
}
th { background-color: antiquewhite; }
.content { height:500px;}
</style>
<body>
<%
try {
Class.forName("org.mariadb.jdbc.Driver");
con = DriverManager.getConnection(url, user, pass);
stmt = con.createStatement();
rs = stmt.executeQuery("select * from board where num=" + num);
System.out.println("DB접속 확인");
if(rs.next()){
writer = rs.getString("writer");
title = rs.getString("title");
content = rs.getString("content");
hits = rs.getInt("hits");
}
//조회수
stmt.executeUpdate(
"update board set hits=hits+1 where num=" + num);
%>
<table border="1">
<tr>
<th>조회수</th>
<td><%=hits %></td>
</tr>
<tr>
<th>제목</th>
<td><%=writer %></td>
</tr>
<tr>
<th>작성자</th>
<td><%=title %></td>
</tr>
<tr>
<th>내용</th>
<td class="content" ><%=content %></td>
</tr>
</table>
<%
}catch (Exception e){
e.printStackTrace();
}
%>
<input type="button" value="목록보기" onclick="location.href='list.jsp'">
<input type="button" value="수정" onclick="location.href='write.jsp?num=<%=num%>'">
<input type="button" value="삭제" onclick="location.href='delete.jsp?num=<%=num%>'">
</body>
</html>
