[JSP] JSP와 데이터베이스 연동

Java Category/JSP

[JSP] JSP와 데이터베이스 연동

ReBugs

|2023. 11. 27. 00:48

JDBC(Java DataBase Connectivity)

Java에서 DBMS의 종류와 관계없이 데이터베이스를 조작하기 위한
API(Application Programming Interface)를 의미
JDBC를 간단하게 요약하면 메소드 호출용 SQL 인터페이스라고 표현할 수 있음

JDBC 드라이버

다양한 DBMS 제조사들은 본사에서 개발한 DBMS를 Sun사의 Java 프로그램과연동할 수 있도록 기술을 지원하는 것을 의미
JDBC는 MySQL 설치과정에서 이미 설치하였으므로 따로 설치할 필요는 없지만 JDBC 드라이버가 어느 폴더에 저장되어 있는지에 대해서는 알고 있어야 함
JSP프로젝트 내에 lib폴더에 JDBC 드라이버를 추가해준다.

자세한 JDBC에 대한 내용은 아래의 포스트를 참고

2023.08.17 - [Java Category/Java] - [Java] JDBC 개요 및 DB 연결하기

[Java] JDBC 개요 및 DB 연결하기

이 게시글은 이것이 자바다(저자 : 신용권, 임경균)의 책과 동영상 강의를 참고하여 개인적으로 정리하는 글임을 알립니다. JDBC 자바는 데이터베이스와 연결해서 데이터 입출력 작업을 할 수 있

rebugs.tistory.com

예제 데이터베이스 기본 (MySQL)

JDBC 연결 테스트

<%@ 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> JDBC 커넥션 테스트 </title>
</head>
<body>
	<%
		// 1. 변수 4개 선언
		String driverName="com.mysql.jdbc.Driver"; //jdbc 드라이버 이름
		String url = "jdbc:mysql://localhost:3306/odbo"; //연결 문자열, 마지막은 데이터베이스 이름
		String username = "root"; //DB 계정 id
		String password = "0000"; //DB 계정 pw
		Connection conn = null; //Connection 객체를 null로 레퍼런스
		try{
			// 2. 드라이버 로딩	
			Class.forName(driverName);  //JDBC 드라이버 메모리에 로딩
			// 3. 연동
			conn = DriverManager.getConnection(url, username, password); //연결문자열, DB 계정을 Connection객체에 대입
			// 4. 여기까지 오류가 없다면 연결 성공
			out.println(">> 연결 성공 : " + conn);
		} catch(ClassNotFoundException e){
			out.println(">> 연결 실패 : 드라이버 복사 필요!");			
		} catch(SQLException e){
			out.println(">> 연결 실패 : SQL 명령문 확인 필요!");
		} finally{
			// 5. 닫기
			try{
				if(conn != null)
					conn.close();
			} catch(SQLException e){
				;
			}
		}
	%>
</body>
</html>

회원 가입

signup.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
	<meta charset="UTF-8">
	<title> 회원 가입 </title>
</head>
<body>
	Home > Signup the Membership
	<hr>
	<form action="signup_process.jsp" name="user_info" method="post">
		<fieldset style="width:200px">
			<legend> 회원 가입 </legend><p>
	
			아이디 : <br>
			<input type="text" name="userID"><br><br>
		
			비밀번호 : <br> 
			<input type="password" name="userPW"><br><br>
			
			이메일 : <br>
			<input type="email" name="userMAIL"><br><br>		
			<hr>
			
		<div align="center">
			<input type="submit" value=" 가입하기 "> &nbsp;&nbsp;
			<input type="reset" value=" 다시작성 ">
		</div><br>
		</fieldset>
	</form>
</body>
</html>

signup_process.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<% 
	String u_id = request.getParameter("userID");
	String u_pw = request.getParameter("userPW");
	String u_mail = request.getParameter("userMAIL");
	
	//INSERT INTO members(id, passwd, email) VALUES( 'idData', 'passwdData', 'emailData' )
	String sql = "INSERT INTO members(id, passwd, email) VALUES";
	sql += "('" + u_id + "','" + u_pw + "','" + u_mail + "')";
	
	String driverName="com.mysql.jdbc.Driver"; //jdbc 드라이버 이름
	String url = "jdbc:mysql://localhost:3306/odbo"; //연결 문자열
	String username = "root"; //DB 계정 id
	String password = "0000"; //DB 계정 pw
	Connection conn = null; //Connection 객체를 null로 레퍼런스
	
	Class.forName(driverName); //JDBC 드라이버 메모리에 로딩
	//DriverManager의 정적 메소드인 getConnection는 Connection 객체를 리턴함
	conn = DriverManager.getConnection(url, username, password); //연결문자열, DB 계정, Connection객체 대입
	//Staement는 변경되지 않는 정적 SQL 문을 실행할 때 사용, 동적 SQL문은 PreparedStatement를 사용
	Statement sm = conn.createStatement(); //Statement 얻기
	
	int count = sm.executeUpdate(sql); //쿼리 실행
	if(count == 1){ //실행한 쿼리가 1개라면
		out.println("회원가입 성공!");
	}else{
		out.println("회원가입 실패!");
	}
	sm.close(); //Statement 끊기
	conn.close(); //Connection 끊기
%>

성공적으로 DB에 저장된 것을 확인할 수 있다.

회원 탈퇴

withdraw.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
	<meta charset="UTF-8">
	<title> 회원 탈퇴 </title>
</head>
<body>
	Home > Withdraw the Membership
	<hr>
	<form action="withdraw_process.jsp" name="user_info" method="post">
		<fieldset style="width:200px">
			<legend> 회원 탈퇴 </legend><p>
	
			아이디 : <br>
			<input type="text" name="userID"><br>
			
		<div align="center">
			<input type="submit" value=" 탈퇴하기 "> &nbsp;&nbsp;
		</div><br>
		</fieldset>
	</form>
</body>
</html>

withdraw_process.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<% 
	String u_id = request.getParameter("userID");
	String sql = "DELETE FROM members WHERE id = ?"; //?에 넣어질 값은 PreparedStatement에서 처리
	
	String driverName="com.mysql.jdbc.Driver";
	String url = "jdbc:mysql://localhost:3306/odbo";
	String username = "root";
	String password = "0000";
	Connection conn = null;
	
	Class.forName(driverName);//메모리에 로딩
	conn = DriverManager.getConnection(url, username, password); //db에 연결
	
	PreparedStatement sm = conn.prepareStatement(sql); //sql 처리 준비
	sm.setString(1, u_id); //첫 번째 ?에 u_id를 대입

	int count = sm.executeUpdate(); //sql문을 처리하고 리턴되는 행의 수를 count에 저장
	
	if(count == 1){
		out.print("회원 탈퇴 성공!");
	}else{
		out.print("회원 탈퇴 실패!");
	}
	sm.close();
	conn.close();	
%>

성공적으로 DB에서 DELETE문이 이뤄진 것을 확인할 수 있다.

데이터베이스 예제 심화(Oracle SQL)

데이터베이스 구조

DTO (Data Transfer Object)

memberBean.java

public class MemberBean {
	private String id;
	private String pass1;
	private String email;
	private String tel;
	private String hobby;
	private String job;
	private String age;
	private String info;
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getPass1() {
		return pass1;
	}
	public void setPass1(String pass1) {
		this.pass1 = pass1;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getTel() {
		return tel;
	}
	public void setTel(String tel) {
		this.tel = tel;
	}
	public String getHobby() {
		return hobby;
	}
	public void setHobby(String hobby) {
		this.hobby = hobby;
	}
	public String getJob() {
		return job;
	}
	public void setJob(String job) {
		this.job = job;
	}
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	public String getInfo() {
		return info;
	}
	public void setInfo(String info) {
		this.info = info;
	}
}

DAO (Data Access Object)

memberDAO.java

package model;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;
public class MemberDAO
{
	String id = "java";
	String pass = "oracle";
	String url = "jdbc:oracle:thin:@localhost:1521/orcl";
	Connection conn = null;
	PreparedStatement pstmt = null;
	ResultSet rs; //DB의 테이블 결과를 리턴받아 저장하는 객체
	
	public void getCon()
	{
		 try{	
		    Class.forName("oracle.jdbc.OracleDriver");
	   		conn = DriverManager.getConnection(url, id, pass);
		}
		catch(Exception e) { e.printStackTrace(); }
	}
	
	public void insertMember(MemberBean mbean)
	{
		try
		{
			getCon();
	  		String SQL = "INSERT INTO member VALUES(?,?,?,?,?,?,?,?)";
			pstmt = conn.prepareStatement(SQL);
	  		pstmt.setString(1,mbean.getId());
	  		pstmt.setString(2,mbean.getPass1());
	  		pstmt.setString(3,mbean.getEmail());
	  		pstmt.setString(4,mbean.getTel());
	  		pstmt.setString(5,mbean.getHobby());
	  		pstmt.setString(6,mbean.getJob());
	  		pstmt.setString(7,mbean.getAge());
	  		pstmt.setString(8,mbean.getInfo());
	  		pstmt.executeUpdate();
		}
		catch(Exception e) { e.printStackTrace(); }
		finally { if(conn != null) { try { } catch (Exception e) { e.printStackTrace(); } } }
	}
	
	public Vector<MemberBean> allSelectMember()
	{
		Vector<MemberBean> v = new Vector<>();
		try 
		{
			getCon();
			String SQL = "SELECT * FROM member";
			pstmt = conn.prepareStatement(SQL);
			rs = pstmt.executeQuery();
			
			while(rs.next())
			{
				MemberBean bean = new MemberBean();
				bean.setId(rs.getString(1));
				bean.setPass1(rs.getString(2));
				bean.setEmail(rs.getString(3));
				bean.setTel(rs.getString(4));
				bean.setHobby(rs.getString(5));
				bean.setJob(rs.getString(6));
				bean.setAge(rs.getString(7));
				bean.setInfo(rs.getString(8));
				v.add(bean);
			}
		}
		catch(Exception e) { e.printStackTrace(); }
		finally { if(conn != null) { try { } catch (Exception e) { e.printStackTrace(); } } }
		return v;
	}
	
	public MemberBean oneSelectMember(String id)
	{
		MemberBean bean = new MemberBean();
		try 
		{
			getCon();
			String SQL = "SELECT * FROM member WHERE id=?";
			pstmt = conn.prepareStatement(SQL);
			pstmt.setString(1, id);
			rs = pstmt.executeQuery();
			if(rs.next())
			{
				bean.setId(rs.getString(1));
				bean.setPass1(rs.getString(2));
				bean.setEmail(rs.getString(3));
				bean.setTel(rs.getString(4));
				bean.setHobby(rs.getString(5));
				bean.setJob(rs.getString(6));
				bean.setAge(rs.getString(7));
				bean.setInfo(rs.getString(8));
			}
		}
		catch(Exception e) { e.printStackTrace(); }
		finally { if(conn != null) { try { } catch (Exception e) { e.printStackTrace(); } } }
		return bean;
	}
	
	public String getPass(String id)
	{
		String pass="";
		try 
		{
			getCon();
			String SQL = "SELECT * FROM member WHERE id=?";
			pstmt = conn.prepareStatement(SQL);
			pstmt.setString(1, id);
			rs = pstmt.executeQuery();
			if(rs.next()) pass = rs.getString(2);
		}
		catch(Exception e) { e.printStackTrace(); }
		finally { if(conn != null) { try { } catch (Exception e) { e.printStackTrace(); } } }
		return pass;
	}
	
	public void updateMember(MemberBean bean)
	{
		try 
		{
			getCon();
			String SQL = "UPDATE member SET email=?, tel=? WHERE id=?";
			pstmt = conn.prepareStatement(SQL);
			pstmt.setString(1, bean.getEmail());
			pstmt.setString(2, bean.getTel());
			pstmt.setString(3, bean.getId());
			pstmt.executeQuery();
		}
		catch(Exception e) { e.printStackTrace(); }
		finally { if(conn != null) { try { } catch (Exception e) { e.printStackTrace(); } } }
	}
	
	public void deleteMember(String id)
	{
		try 
		{
			getCon();
			String SQL = "DELETE FROM member WHERE id=?";
			pstmt = conn.prepareStatement(SQL);
			pstmt.setString(1, id);
			pstmt.executeQuery();
		}
		catch(Exception e) { e.printStackTrace(); }
		finally { if(conn != null) { try { } catch (Exception e) { e.printStackTrace(); } } }
	}
}

MemberJoin.jsp

<%@ 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>
<body>
	<center>
		<h2>회원 가입</h2>
		<form action="MemberJoinProc.jsp">
			<table width="500" border="1">
				<tr height="50">
					<td width="150" align="center">아이디 </td>
					<td width="350" align="center">
						<input type="text" name="id" size="40" placeholder="id를 넣으세요">						
					</td>
				</tr>
		
				<tr height="50">
					<td width="150" align="center">패스워드</td>
					<td width="350" align="center">
						<input type="password" name="pass1" size="40"
						placeholder="비밀번호는 숫자와 영어만 넣어주세요">						
					</td>
				</tr>
				
				<tr height="50">
					<td width="150" align="center">패스워드 확인</td>
					<td width="350" align="center">
						<input type="password" name="pass2" size="40">						
					</td>
				</tr>
				
				<tr height="50">
					<td width="150" align="center">이메일</td>
					<td width="350" align="center">
						<input type="email" name="email" size="40">						
					</td>
				</tr>
				
				<tr height="50">
					<td width="150" align="center">전화 번호 </td>
					<td width="350" align="center">
						<input type="tel" name="tel" size="40">				
					</td>
				</tr>
				
				<tr height="50">
					<td width="150" align="center">당신의 관심 분야</td>
					<td width="350" align="center">
						<input type="checkbox" name="hobby" value="캠핑">캠핑&nbsp;
						<input type="checkbox" name="hobby" value="등산">등산&nbsp;
						<input type="checkbox" name="hobby" value="독서">독서&nbsp;
						<input type="checkbox" name="hobby" value="음악">음악&nbsp;				
					</td>
				</tr>
				
			   <tr height="50">
					<td width="150" align="center">당신의 직업은</td>
					<td width="350" align="center">
						<select name="job">
						<option value="교사">교사</option>
						<option value="의사">의사</option>
						<option value="변호사">변호사</option>
						<option value="기술사">기술사</option>
						</select>				
					</td>
				</tr>
				
				<tr height="50">
					<td width="150" align="center">당신의 연령은</td>
					<td width="350" align="center">
						<input type="radio" name="age" value="10">10대&nbsp;
						<input type="radio" name="age" value="20">20대&nbsp;
						<input type="radio" name="age" value="30">30대&nbsp;
						<input type="radio" name="age" value="40">40대&nbsp;			
					</td>
				</tr>
				
				<tr height="50">
					<td width="150" align="center">하고 싶은말</td>
					<td width="350" align="center">
							<textarea rows="5" cols="40" name="info"></textarea>	
					</td>
				</tr>
					
				<tr height="50" align="center">
					<td width="150" colspan="2">
						<input type="submit" value="회원 가입">	
						<input type="reset" value="취소">			
					</td>
				</tr>	
			</table>
		</form>	
	</center>
</body>
</html>

MemberJoinProc.jsp

<%@page import="model.MemberDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<body>
	<%
		request.setCharacterEncoding("UTF-8");
		String hobby[] = request.getParameterValues("hobby");
		String textHobby = "";
		for(int i = 0; i < hobby.length; ++i) textHobby += hobby[i] + " ";
	%>
	<jsp:useBean id="mbean" class="model.MemberBean">
		<jsp:setProperty name="mbean" property="*"/>
	</jsp:useBean>
	<%
	mbean.setHobby(textHobby);
	MemberDAO mdao = new MemberDAO();
	mdao.insertMember(mbean);
	response.sendRedirect("MemberList.jsp");
	%>
</body>
</html>

MemberList.jsp

<%@page import="model.MemberBean" %>
<%@page import="model.MemberDAO" %>
<%@page import="java.util.Vector" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<body>
	<%
		MemberDAO mdao = new MemberDAO();
		Vector<MemberBean> vec = mdao.allSelectMember();
	%>
	<center>
	<h2>모든 회원 정보</h2>
	<table width="800" border="1">
		<tr height="50">
			<td align="center" width="150">아이디</td>
			<td align="center" width="250">이메일</td>
			<td align="center" width="200">전화번호</td>
			<td align="center" width="200">취미</td>
		</tr>
		<%
			for(int i = 0; i < vec.size(); ++i)
			{
				MemberBean bean = vec.get(i);
		%>
		<tr height="50">
			<td align="center" width="150"><a href="MemberInfo.jsp?id=<%= bean.getId() %>"><%= bean.getId() %></a></td>
			<td align="center" width="250"><%= bean.getEmail() %></td>
			<td align="center" width="200"><%= bean.getTel() %></td>
			<td align="center" width="200"><%= bean.getHobby() %></td>
		</tr>
		<%}%>
	</table>
	</center>
</body>
</html>

MemberUpdateForm.jsp

<%@page import="model.MemberBean"%>
<%@page import="model.MemberDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<body>
<%
	String id = request.getParameter("id");
	MemberDAO mdao = new MemberDAO();
	MemberBean mbean = mdao.oneSelectMember(id);
%>
<center>
	<h2>회원 정보</h2>
		
		<table width="400" border="1">
			<form action="MemberUpdateProc.jsp" method="post">
			<tr height="50">
				<td align="center" width="150">아이디</td>
				<td width="250"><%= mbean.getId() %></td>
			</tr>
			<tr height="50">
				<td align="center" width="150">이메일</td>
				<td width="250"><input type="email" name="email" value="<%= mbean.getEmail() %>"></td>
			</tr>
			<tr height="50">
				<td align="center" width="150">전화</td>
				<td width="250"><input type="tel" name="tel" value="<%= mbean.getTel() %>"></td>
			</tr>
			<tr height="50">
				<td align="center" width="150">패스워드</td>
				<td width="250"><input type="password" name="pass1"></td>
			</tr>
			<tr height="50">
				<td align="center" colspan="2">
				<input type="hidden" name="id" value="<%= mbean.getId() %>">
				<input type="submit" value="회원 수정하기"> &nbsp;&nbsp;
			</form>
				<button onclick="location.href='MemberList.jsp'">회원 전체 보기</button>
				
			</td>
		</tr>
	</table>
</center>
</body>
</html>

MemberUpdateProc.jsp

<%@page import="model.MemberDAO"%>
<%@page import="model.MemberBean"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<body>
	<%
		request.setCharacterEncoding("UTF-8");
	%>
	<jsp:useBean id="mbean" class="model.MemberBean">
		<jsp:setProperty name="mbean" property="*"/>
	</jsp:useBean>
	<%
		MemberDAO mdao = new MemberDAO();
		String pass = mdao.getPass(mbean.getId());
		if(mbean.getPass1().equals(pass))
		{
			mdao.updateMember(mbean);
			response.sendRedirect("MemberList.jsp");
		}
		else
		{
	%>
		<script type="text/javascript">
		alert("패스워드가 맞지 않습니다. 다시 확인해 주세요")
		history.go(-1);
		</script>
	<%
		}
	%>
</body>
</html>

MemberInfo.jsp

<%@page import="model.MemberBean" %>
<%@page import="model.MemberDAO" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<body>
	<%
		String id = request.getParameter("id");
		MemberDAO mdao = new MemberDAO();
		MemberBean mbean = mdao.oneSelectMember(id);
	%>
	<center>
		<h2>회원 정보</h2>
			<table width="400" border="1">
				<tr height="50">
					<td align="center" width="150">아이디</td>
					<td width="250"><%= mbean.getId() %></td>
				</tr>
				<tr height="50">
					<td align="center" width="150">이메일</td>
					<td width="250"><%= mbean.getEmail() %></td>
				</tr>
				<tr height="50">
					<td align="center" width="150">전화</td>
					<td width="250"><%= mbean.getTel() %></td>
				</tr>
				<tr height="50">
					<td align="center" width="150">취미</td>
					<td width="250"><%= mbean.getHobby() %></td>
				</tr>
				<tr height="50">
					<td align="center" width="150">직업</td>
					<td width="250"><%= mbean.getJob() %></td>
				</tr>
				<tr height="50">
					<td align="center" width="150">나이</td>
					<td width="250"><%= mbean.getAge() %></td>
				</tr>
				<tr height="50">
					<td align="center" width="150">정보</td>
					<td width="250"><%= mbean.getInfo() %></td>
				</tr>
				<tr height="50">
					<td align="center" colspan="2">
						<button onclick="location.href='MemberUpdateForm.jsp?id=<%=mbean.getId()%>'">회원수정</button>
						<button onclick="location.href='MemberDeleteForm.jsp?id=<%=mbean.getId()%>'">회원삭제</button>
						<button onclick="location.href='MemberList.jsp?id=<%=mbean.getId()%>'">목록보기</button>
						<button onclick="location.href='MemberJoin.jsp?id=<%=mbean.getId()%>'">회원가입</button>
					</td>
				</tr>
			</table>
	</center>
</body>
</html>

MemberDeleteForm.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<body>
<center>
	<h2>회원 삭제 하기</h2>
		<table width="400" border="1">
			<form action="MemberDeleteProc.jsp" method="post">
			<tr height="50">
				<td align="center" width="150">아이디</td>
				<td width="250"><%= request.getParameter("id") %></td>
			</tr>
			<tr height="50">
				<td align="center" width="150">패스워드</td>
				<td width="250"><input type="password" name="pass1"></td>
			</tr>
			<tr height="50">
				<td align="center" colspan="2">
				<input type="hidden" name="id" value="<%= request.getParameter("id") %>">
				<input type="submit" value="회원 삭제하기"> &nbsp;&nbsp;
			</form>
				<button onclick="location.href='MemberList.jsp'">회원 전체 보기</button>
			</td>
		</tr>
	</table>
</center>
</body>
</html>

MemberDeleteProc.jsp

<%@page import="model.MemberDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<body>
	<%
		request.setCharacterEncoding("UTF-8");
	%>
	<jsp:useBean id="mbean" class="model.MemberBean">
		<jsp:setProperty name="mbean" property="*"/>
	</jsp:useBean>
	<%
		MemberDAO mdao = new MemberDAO();
		String pass = mdao.getPass(mbean.getId());
		if(mbean.getPass1().equals(pass))
		{
			mdao.deleteMember(mbean.getId());
			response.sendRedirect("MemberList.jsp");
		}
		else
		{
	%>
		<script type="text/javascript">
		alert("패스워드가 맞지 않습니다. 다시 확인해 주세요")
		history.go(-1);
		</script>
	<%
		}
	%>
</body>
</html>

저작자표시 비영리 변경금지

'Java Category > JSP' 카테고리의 다른 글

[JSP] IntelliJ 에서 JSP 개발환경 만들기 (1)	2024.01.08
[JSP] 파일 업로드 (0)	2023.12.25
[JSP] 액션 태그(Action tag) (1)	2023.11.27
[JSP] 세션(Session) (1)	2023.11.25
[JSP] 쿠키(Cookie) (2)	2023.11.24

[JSP] JSP와 데이터베이스 연동

JDBC(Java DataBase Connectivity)

JDBC 드라이버

예제 데이터베이스 기본 (MySQL)

JDBC 연결 테스트

회원 가입

회원 탈퇴

데이터베이스 예제 심화(Oracle SQL)

데이터베이스 구조

DTO (Data Transfer Object)

DAO (Data Access Object)

MemberJoin.jsp

MemberJoinProc.jsp

MemberList.jsp

MemberUpdateForm.jsp

MemberUpdateProc.jsp

MemberInfo.jsp

MemberDeleteForm.jsp

MemberDeleteProc.jsp

'Java Category > JSP' 카테고리의 다른 글

티스토리툴바