<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>게시판</title>
</head>
<body>
<form action="movie_02.jsp">
id:<input type="text" name="id"><br>
title:<input type="text" name="movietitle"><br>
content:<input type="text" name="bcontent"><br>
<input type="submit" value="작성"><br>
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%
String id = request.getParameter("id");
String movietitle = request.getParameter("movietitle");
String bcontent = request.getParameter("bcontent");
String url_mysql = "jdbc:mysql://localhost/movieReview?serverTimezone=UTC&characterEncoding=utf8&useSSL=false";
String id_mysql = "root";
String pw_mysql = "qwer1234";
PreparedStatement ps = null;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn_mysql = DriverManager.getConnection(url_mysql, id_mysql, pw_mysql);
Statement stmt_mysql =conn_mysql.createStatement();
String A = "insert into board (id,movietitle,bcontent,insertdate) ";
String B = "values (?,?,?,now())";
ps = conn_mysql.prepareStatement(A+B);
ps.setString(1,id);
ps.setString(2,movietitle);
ps.setString(3,bcontent);
ps.executeUpdate();
conn_mysql.close();
out.println("성공");
}catch(Exception e){
e.printStackTrace();
out.println("ㅠ");
}
response.sendRedirect("movie_03.jsp");
%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>게시판</title>
</head>
<body>
<h3>게시판</h3>
<%
String url_mysql = "jdbc:mysql://localhost/movieReview?serverTimezone=UTC&characterEncoding=utf8&useSSL=false";
String id_mysql = "root";
String pw_mysql = "qwer1234";
PreparedStatement ps = null;
int cnt=0;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn_mysql = DriverManager.getConnection(url_mysql, id_mysql, pw_mysql);
Statement stmt_mysql =conn_mysql.createStatement();
String A = "select bseqno, movietitle, id, insertdate from board";
ResultSet rs = stmt_mysql.executeQuery(A);
//WhereDefault -얘는 가져오는거!
%>
<table border="1">
<tr><th>seq</th><th>movie</th><th>id</th><th>입력일</th></tr>
<%
while(rs.next()){
%>
<tr><td OnClick="location.href='movie_04.jsp?seqno=<%=rs.getInt(1) %>'"><%=rs.getInt(1) %></td><td><%=rs.getString(2) %></td><td><%=rs.getString(3) %>
</td><td><%=rs.getString(4) %></td></tr>
<%
cnt++;
}
%>
</table>
<%
conn_mysql.close();
}catch(Exception e){
e.printStackTrace();
}
%>
<br><br>
총 게시글은 <%=cnt %>건 입니다.
<form action="movie_01.jsp">
<input type="submit" value="작성">
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
int bseqno = Integer.parseInt(request.getParameter("seqno"));
String url_mysql = "jdbc:mysql://localhost/movieReview?serverTimezone=UTC&characterEncoding=utf8&useSSL=false";
String id_mysql = "root";
String pw_mysql = "qwer1234";
PreparedStatement ps = null;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn_mysql = DriverManager.getConnection(url_mysql, id_mysql, pw_mysql);
Statement stmt_mysql =conn_mysql.createStatement();
String A = "select board.bseqno, board.id, movietitle, bcontent from board where board.bseqno="+bseqno ;
ResultSet rs = stmt_mysql.executeQuery(A);
//WhereDefault -얘는 가져오는거!
if(rs.next()){
session.setAttribute("bseqno", rs.getInt(1));
session.setAttribute("boardid", rs.getString(2));
session.setAttribute("movietitle", rs.getString(3));
session.setAttribute("boardcontent", rs.getString(4));
}conn_mysql.close();
}catch(Exception e){
e.printStackTrace();
}
%>
board seqno: <%=bseqno %><br>
제목: ${movietitle }<br>
id: ${boardid }<br>
content: ${boardcontent } <br>
<%
try{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn_mysql = DriverManager.getConnection(url_mysql, id_mysql, pw_mysql);
Statement stmt_mysql =conn_mysql.createStatement();
String B = "select comment.id,ccontent from board,comment where board.bseqno=comment.bseqno and board.bseqno="+bseqno;
ResultSet rs = stmt_mysql.executeQuery(B);
//WhereDefault -얘는 가져오는거!
while(rs.next()){
%>
id:<%=rs.getString(1) %>
content:<%=rs.getString(2) %><br>
<%
}conn_mysql.close();
}catch(Exception e){
e.printStackTrace();
}
%>
<form action="movie_05.jsp">
댓글:<input type="text" name="reple">
id:<input type="text" name="id">
<input type="hidden" name="bseqno" value="${bseqno }">
<input type="submit" value="작성">
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%
int bseqno=Integer.parseInt(request.getParameter("bseqno"));
String commentid = request.getParameter("id");
String ccontent= request.getParameter("reple");
/* out.println(boardseqno);
out.println(commentid);
out.println(content); */
String url_mysql = "jdbc:mysql://localhost/movieReview?serverTimezone=UTC&characterEncoding=utf8&useSSL=false";
String id_mysql = "root";
String pw_mysql = "qwer1234";
PreparedStatement ps = null;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn_mysql = DriverManager.getConnection(url_mysql, id_mysql, pw_mysql);
Statement stmt_mysql =conn_mysql.createStatement();
String A = "insert into comment (id,bseqno,ccontent) ";
String B = "values (?,?,?)";
ps = conn_mysql.prepareStatement(A+B);
ps.setString(1,commentid);
ps.setInt(2,bseqno);
ps.setString(3,ccontent);
ps.executeUpdate();
conn_mysql.close();
out.println("성공");
}catch(Exception e){
e.printStackTrace();
out.println("ㅠ");
}
response.sendRedirect("movie_04.jsp");
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>