[53일차] chap11. 데이터베이스와 jsp 연동

기존꺼 clear all 해주고 씨드라이브 안에 경로선택 해줘서 추가하기

myphpadmin 에 존재하는 database명 적어주기 (korea)

p.356 insert

select 하기

p.367jdbc 를 사용한 db 연동

p.374 statement ~

form 에서부터 값 넘겨보기

DBConn.jsp 만들어서 중복 내용 빼고 <@ include file 하기

표로 만들어주기

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
<%@ include file="DBConn.jsp" %>

<%
	try{
	conn= DriverManager.getConnection(url,id,pass);
	
	String sql="select * from member";
	
	pstmt=conn.prepareStatement(sql);
	rs= pstmt.executeQuery();
	%>
	
	<div align=center>
	<br><h2>목록보기</h2>
	<table border=1>
	<tr><td>아이디</td><td>암호</td><td>이름</td><td>날짜</td></tr>
	
	<% 
	while(rs.next()){
		%>
		<tr>
		<td><%=rs.getString("id") %></td>
		<td><%=rs.getString("passwd") %></td>
		<td><%=rs.getString("name") %></td>
		<td><%=rs.getString("reg_date") %></td>
		</tr><br>	
		<%
	}
	%>
	</table>
	</div>
	<% 
	}catch(Exception e){
		e.printStackTrace();
	}finally{
		rs.close();
		pstmt.close();
		conn.close();
	}
%>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<div align=center>
<br>
<a href="Form.jsp">글쓰기</a>
</div>
</body>
</html>

insert 파일에 마지막에 <jsp:forward page="select.jsp"></jsp:forward> 로 셀렉트 파일로 넘겨주기

날짜에 링크 걸어서 삭제하기

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
<%@ page import="java.sql.*"%>
    
<%@ include file="DBConn.jsp" %>

<%
	try{
	conn= DriverManager.getConnection(url,id,pass);
	
	String sql="select * from member";
	
	pstmt=conn.prepareStatement(sql);
	rs= pstmt.executeQuery();
	%>
	
	<div align=center>
	<br><h2>목록보기</h2>
	<table border=1>
	<tr><td>아이디</td><td>암호</td><td>이름</td><td>날짜</td></tr>
	
	<% 
	while(rs.next()){
		%>
		<tr>
		<td><%=rs.getString("id") %></td>
		<td><%=rs.getString("passwd") %></td>
		<td><%=rs.getString("name") %></td>
		<td><a href="delete.jsp?id=<%=rs.getString("id") %>"><%=rs.getString("reg_date") %></a></td>
		</tr>
		<%
	}
	%>
	</table>
	</div>
	<% 
	}catch(Exception e){
		e.printStackTrace();
	}finally{
		rs.close();
		pstmt.close();
		conn.close();
	}
%>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<div align=center>
<br>
<a href="Form.jsp">글쓰기</a>
</div>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
<%@ page import="java.sql.*" %>
<%@ include file="DBConn.jsp" %>

<% request.setCharacterEncoding("utf-8"); %>


<%
	String idK= request.getParameter("id");

	try{
	conn= DriverManager.getConnection(url,id,pass);
	
	String sql="delete from member where id=?"; 
	
	pstmt=conn.prepareStatement(sql);
	pstmt.setString(1, idK);
	int k= pstmt.executeUpdate();

	if(k==1){
		response.sendRedirect("select.jsp");
	}else{
		out.print("삭제실패");
	}
	}
	
	catch(Exception e){
		out.print("예외발생");
		e.printStackTrace();
	}finally{
		pstmt.close();
		conn.close();
	}
%>


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

</body>
</html>

'JAVA' 카테고리의 다른 글

[55일차] 자바로 mysql연동, 이미지 추가해서 자료실 만들기 (0)	2022.08.09
[54일차] mysql연동 form,insert,select,delete,검색창 만들기 (0)	2022.08.05
[53일차] JSP 교재 p.242 ~ (0)	2022.08.04
[52일차] chap6. p187 switch문 ~ (0)	2022.08.03
[51일차]JSP교재 chap4. jsp페이지의 디렉티브 ~ (0)	2022.08.02