Develop/JavaScript JQuery JSP

0713~15 JSP JDBC 응용을 통해 테이블 작성

포페PostFace 2022. 7. 15. 17:46

3일간 여러번의 JSP/JDBC 응용 실습이 있었고 가장 마지막에 했던 프로젝트를 업로드합니다.

총 11개의 파일로 구성됐네요. 이전에도 여러가지 프로젝트를 실습했지만

그 사이에 배웠던 코드들의 집합체와 같은 이 프로젝트 한개로 대체합니다.

 

1.myPkg.StudentBean.java

package myPkg;

public class StudentBean {
	private int num;
	private String id;
	private String passwd;
	private String name;
	private int year;
	private int month;
	private int day;
	private String hobby;
	private int c;
	private int java;
	private int jsp;
	private int sum;
	public StudentBean() {
		
	}
	public int getNum() {
		return num;
	}
	public void setNum(int num) {
		this.num = num;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getPasswd() {
		return passwd;
	}
	public void setPasswd(String passwd) {
		this.passwd = passwd;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getYear() {
		return year;
	}
	public void setYear(int year) {
		this.year = year;
	}
	public int getMonth() {
		return month;
	}
	public void setMonth(int month) {
		this.month = month;
	}
	public int getDay() {
		return day;
	}
	public void setDay(int day) {
		this.day = day;
	}
	public String getHobby() {
		return hobby;
	}
	public void setHobby(String hobby) {
		this.hobby = hobby;
	}
	public int getC() {
		return c;
	}
	public void setC(int c) {
		this.c = c;
	}
	public int getJava() {
		return java;
	}
	public void setJava(int java) {
		this.java = java;
	}
	public int getJsp() {
		return jsp;
	}
	public void setJsp(int jsp) {
		this.jsp = jsp;
	}
	public int getSum() {
		return sum;
	}
	public void setSum(int sum) {
		this.sum = sum;
	}
	
}

2. myPkg.StudentDao.java

package myPkg;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class StudentDao {
	String driver="oracle.jdbc.driver.OracleDriver";
	String url="jdbc:oracle:thin:@localhost:1521:orcl";
	String id="sqlid";
	String pw="sqlpw";
	Connection conn=null;
	public StudentDao() {
		try{
			Class.forName(driver);
			System.out.println("드라이버 로드 성공");
		}catch(ClassNotFoundException e) {
			System.out.println("드라이버 로드 실패");			
		}
	}
	public void connect() {
		try {
			conn=DriverManager.getConnection(url,id,pw);
			System.out.println("접속 성공");
		} catch (SQLException e) {
			System.out.println("접속 실패");
			e.printStackTrace();
		}
	}
	public ArrayList<StudentBean> getAllStudent(){
		connect();
		String sql="select * from student order by num";
		PreparedStatement ps=null;
		ResultSet rs=null;
		ArrayList<StudentBean> lists=new ArrayList<StudentBean>();
		try {
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()) {
				StudentBean sb=new StudentBean();
				sb.setNum(rs.getInt("num"));
				sb.setId(rs.getString("id"));
				sb.setPasswd(rs.getString("passwd"));
				sb.setName(rs.getString("name"));
				sb.setYear(rs.getInt("year"));
				sb.setMonth(rs.getInt("month"));
				sb.setDay(rs.getInt("day"));
				sb.setHobby(rs.getString("hobby"));
				sb.setC(rs.getInt("c"));
				sb.setJava(rs.getInt("java"));
				sb.setJsp(rs.getInt("jsp"));
				sb.setSum(rs.getInt("sum"));
				lists.add(sb);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if(conn!=null)
					conn.close();
				if(ps!=null)
					ps.close();
				if(rs!=null)
					rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return lists;
	}
	public int insertStudent(StudentBean sb) {
		connect();
		String sql="insert into student values(stu_seq.nextval,?,?,?,?,?,?,?,?,?,?,?)";
		PreparedStatement ps=null;
		int result=-1;
		try {
			ps=conn.prepareStatement(sql);
			ps.setString(1, sb.getId());
			ps.setString(2, sb.getPasswd());
			ps.setString(3, sb.getName());
			ps.setInt(4, sb.getYear());
			ps.setInt(5, sb.getMonth());
			ps.setInt(6, sb.getDay());
			ps.setString(7,sb.getHobby());
			ps.setInt(8, sb.getC());
			ps.setInt(9, sb.getJava());
			ps.setInt(10, sb.getJsp());
			ps.setInt(11, sb.getSum());
			result=ps.executeUpdate();			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				if(conn!=null)
					conn.close();
				if(ps!=null)
					ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

		return result;
	}
	public StudentBean getStudentByNum(int num) {
		connect();
		String sql="select * from student where num="+num;
		PreparedStatement ps=null;
		ResultSet rs=null;
		StudentBean sb=null;
		try {
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
			if(rs.next()) {
				sb=new StudentBean();
				sb.setNum(rs.getInt("num"));
				sb.setId(rs.getString("id"));
				sb.setPasswd(rs.getString("passwd"));
				sb.setName(rs.getString("name"));
				sb.setYear(rs.getInt("year"));
				sb.setMonth(rs.getInt("month"));
				sb.setDay(rs.getInt("day"));
				sb.setHobby(rs.getString("hobby"));
				sb.setC(rs.getInt("c"));
				sb.setJava(rs.getInt("java"));
				sb.setJsp(rs.getInt("jsp"));
				sb.setSum(rs.getInt("sum"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if(conn!=null)
					conn.close();
				if(ps!=null)
					ps.close();
				if(rs!=null)
					rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return sb;
	}
	public int updateStudent(StudentBean sb) {
		connect();
		String sql="update student set id=?,passwd=?,name=?,year=?,month=?,day=?,hobby=?,"+
				"c=?,java=?,jsp=?,sum=? where num=?";
		PreparedStatement ps=null;		
		int result =-1;
		
		try {
			ps=conn.prepareStatement(sql);
			ps.setString(1, sb.getId());
			ps.setString(2, sb.getPasswd());
			ps.setString(3, sb.getName());
			ps.setInt(4, sb.getYear());
			ps.setInt(5, sb.getMonth());
			ps.setInt(6, sb.getDay());
			ps.setString(7,sb.getHobby());
			ps.setInt(8, sb.getC());
			ps.setInt(9, sb.getJava());
			ps.setInt(10, sb.getJsp());
			ps.setInt(11, sb.getSum());
			ps.setInt(12, sb.getNum());
			result=ps.executeUpdate();		
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				if(conn!=null)
					conn.close();
				if(ps!=null)
					ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return result;
	}
	public int deleteStudent(int num) {
		connect();
		String sql="delete student where num="+num;
		PreparedStatement ps=null;
		int result=-1;
		try {
			ps=conn.prepareStatement(sql);
			result=ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				if(conn!=null)
					conn.close();
				if(ps!=null)
					ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}		
		return result;
	}
	public int deleteCheckData(String[] rowcheckArr) {
		//'delete student where num=4 or num=6 or num=9';
		connect();
		String sql="delete student where num=?";
		for(int i=0;i<rowcheckArr.length-1;i++) {
			sql += " or num=?";
		}
		PreparedStatement ps=null;
		int result=-1;
		try {
			ps=conn.prepareStatement(sql);
			for(int i=0;i<rowcheckArr.length;i++) {
				ps.setString(i+1,rowcheckArr[i]);
			}
			result=ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if(conn!=null)
					conn.close();
				if(ps!=null)
					ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return result;
	}
	public boolean searchId(String userid) {
		connect();
		String sql="select id from student where id=?";
		PreparedStatement ps=null;
		ResultSet rs=null;
		boolean flag=false;
		try {
			ps=conn.prepareStatement(sql);
			ps.setString(1, userid);
			rs=ps.executeQuery();
			while(rs.next()) {
				flag=true; //있으면 true
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				if(conn!=null)
					conn.close();
				if(ps!=null)
					ps.close();
				if(rs!=null)
					rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}		
		return flag;
	}
}

3. SQL-Memo.txt

drop table student;
create table student(
	num number primary key,
	id varchar2(10) not null,
	passwd varchar2(10) not null,
	name varchar2(10) not null,
	year number not null,
	month number not null,
	day number not null,
	hobby varchar2(50),
	c number default 0,
	java number default 0,
	jsp number default 0,
	sum number default 0
);

drop sequence stu_seq;
create sequence stu_seq
	increment by 1
	start with 1 
	minvalue 1
	maxvalue 10000
	nocache;

insert into student(num,id,passwd,name,year,month,day,hobby,c,java,jsp,sum)
values(stu_seq.nextval,'k1','1111','태연',1999,4,9,'달리기',20,50,90,160);

commit;
col num for 999
col id for a5
col passwd for a4
col name for a8
col year for 9999
col month for 99
col day for 99
col hobby for a16
col c for 999
col java for 999
col jsp for 999
col sum for 999
select * from student;

4. select.jsp 

<%@page import="myPkg.StudentBean"%>
<%@page import="java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<style>
	table {
		width: 80%;
		margin: 0 auto;
		border: 3px pink;
	}
	
	table th {
		background: pink;
	}
	
	table td {
		text-align: center;
	}
	
	table td, table th {
		border: 1px solid blue;
	}
</style>
select.jsp<br>
<%request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="sb" class="myPkg.StudentBean"/>
<jsp:useBean id="sdao" class='myPkg.StudentDao'/>
<form name="myform" action="deleteAll.jsp">
	<table border='1'>
		<tr>
			<th><input type="checkbox" name="allcheck" onclick="allDelete()"></th>
			<th>번호</th>
			<th>아이디</th>
			<th>비밀번호</th>
			<th>이름</th>
			<th>가입일자</th>
			<th>취미</th>
			<th>C</th>
			<th>Java</th>
			<th>JSP</th>
			<th>합계</th>
			<th>수정</th>
			<th>삭제</th>
		</tr>
		<%
		ArrayList<StudentBean> lists=sdao.getAllStudent(); 
		for(int i=0;i<lists.size();i++){ //for(StudentBean sb : lists){
			sb=lists.get(i);%>
		<tr>
			<td><input type="checkbox" name="rowcheck" value="<%=sb.getNum()%>"></td>
			<td><%=sb.getNum()%></td>
			<td><%=sb.getId() %></td>
			<td><%=sb.getPasswd() %></td>
			<td><%=sb.getName() %></td>
			<td><%=sb.getYear()+"-"+sb.getMonth()+"-"+sb.getDay()%></td>
			<td><%=sb.getHobby() %></td>
			<td><%=sb.getC() %></td>
			<td><%=sb.getJava() %></td>
			<td><%=sb.getJsp() %></td>
			<td><%=sb.getSum() %></td>
			<td><a href="updateForm.jsp?num=<%=sb.getNum()%>">수정</a></td>		
			<td><a href="deleteProc.jsp?num=<%=sb.getNum()%>">삭제</a></td>		
		</tr>
		<%}	%>
	</table>
	<br><br>
	<input type="button" value="삽입" onclick=insert()>
	<input type="button" value="삭제" onclick=selectDelete()>
</form>
<script type="text/javascript">
	function insert(){
		location.href="insertForm.jsp";
	}
	function allDelete(){
		
		//alert(1);	
		rc =document.myform.rowcheck;
	
		if(document.myform.allcheck.checked==true){
			for(i=0;i<rc.length;i++){
				rc[i].checked=true;	
			}
		} else {
			for(i=0;i<rc.length;i++){
				rc[i].checked=false;	
			}							
		}		
	}
	function selectDelete(){
		rc=document.myform.rowcheck;
		flag=false;
		for(i=0;i<rc.length;i++){
			if(rc[i].checked==true){
				flag=true;	
			}
		}
		if(flag==false){
			alert("삭제할 체크박스를 선택하세요.");
			return;
		}
		document.myform.submit();					
	}	
</script>

5.insertForm.jsp //jsp/jquery/ajax 등 사용

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript">
	$(document).ready(function(){
		//alert(1);
		var use;
		var isCheck=false;
		var isChange=false;
		var isBlank=false;
		$('#id_check').click(function(){
			isChange=false;
			isCheck=true;
			if($('input[name="id"]').val()==""){
				alert("입력하세요");
				isBlank=true;
				return;
			}
			isBlank=false;
			$.ajax({
				url : 'id_check_proc.jsp', //중복 확인하는 페이지 주소
				data : {
					userid : $('input[name="id"]').val() //변수명 : 값
				}  ,
				success : function(data){ //data=응답정보
					/* alert('data:'+$.trim(data)); */ 
					if($.trim(data)=='YES'){
						$('#idmessage').html("<font color=green>사용 가능한 아이디입니다.</font>");
						$('#idmessage').show();
						use='possible';
						
					}
					else{
						$('#idmessage').html("<font color=red>이미 사용중인 아이디입니다.</font>");
						$('#idmessage').show();
						use='impossible';						
					}
				}//success
			});//ajax
		});//click
		$('input[id="sub"]').click(function(){
			//alert(1);
			/* if(use==null){
				alert("중복체크 먼저 해주세요.");
				return false;				
			} */
			if(use=="impossible"){
				alert("이미 사용중인 아이디입니다.");				
				return false;
			}
			else if(isCheck==false||isChange==true){
				alert("중복체크 먼저 하세요.");
				return false;
			}
			else if(isBlank==true){
				alert("아이디를 입력하세요.");
				return false;
			}
		});//sub/click
		$('input[name="id"]').keydown(function(){ //키보드 입력시 메세지 사라지게하는 함수
			//alert(4);
			isCheck=false;
			isChange=true;
			use=null;
			$('#idmessage').css('display','none');
		})
	});//ready
</script>
</head>
<body>
	<h2>회원가입 insertForm.jsp</h2>
	<form action="inputProc.jsp" method="post" name='myform'>
		아이디 : <input type="text" name="id" value="IU">
		<input type="button" value='중복체크' id="id_check">
		<span id='idmessage'></span>
		<br><br>  
		비밀번호 :
		<input type="password" name="passwd" value="1234"><br><br>  
		이름
		: <input type="text" name="name" value="아이유"><br><br>  
		생년월일 :
		<select name="year">
			<%for(int i=2022;i>1930;i--){%>
				<option value="<%=i%>"><%=i%></option>	
			<%}	%>
			
		</select> 년 
		
		<select name="month">
			<%for(int i=1;i<=12;i++){%>
				<option value="<%=i%>"><%=i%></option>	
			<% }%>
			
		</select> 월
		
		<select name="day">
			<%for(int i=1;i<=31;i++){%>
				<option value="<%=i%>"><%=i%></option>	
			<% }%>
        </select> 일 <br>
		<br> 취미 : 
		<input type="checkbox" name="hobby" value="달리기">달리기
		<input type="checkbox" name="hobby" value="수영">수영 
		<input type="checkbox" name="hobby" value="게임">게임 
		<input type="checkbox" name="hobby" value="영화">영화<br> <br><br> 

		[점수입력]<br> 
		C언어 : 	<input type="text" name="c" size="10">
		JAVA : <input type="text" name="java" size="10">
		JSP : <input type="text" name="jsp" size="10"><br><br>  
		<input type="submit" value="가입하기" id="sub">
	</form>

</body>
</html>

6.inputProc.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
inputProc.jsp<br>
<%request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="sb" class="myPkg.StudentBean"/>
<jsp:useBean id="sdao" class="myPkg.StudentDao"/>
<jsp:setProperty property="*" name="sb"/>
<% 
	sb.setSum(sb.getC()+sb.getJava()+sb.getJsp());
	String[] hobbys=request.getParameterValues("hobby");
	String hobby="";
	if(hobbys==null){
		hobby += "선택한 항목 없음";
	} else {
		for(int i=0;i<hobbys.length;i++){
			if(i==0){
				hobby += hobbys[i];			
			} else{
				hobby += ","+hobbys[i];			
			}
		}		
	}
	sb.setHobby(hobby);
	int result=sdao.insertStudent(sb);
	String msg;
	String url;
	if(result>0){
		msg="삽입 성공";
		url="select.jsp";
	} else{
		msg="삽입 성공";
		url="select.jsp";		
	}
%>
<script type="text/javascript">
	alert("<%=msg%>");
	location.href="<%=url%>";
</script>

7.updateForm.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<%request.setCharacterEncoding("UTF-8");%>
<jsp:useBean id="sb" class="myPkg.StudentBean"/>
<jsp:useBean id="sdao" class="myPkg.StudentDao"/>
<%
	int num=Integer.parseInt(request.getParameter("num"));
	sb=sdao.getStudentByNum(num); 
%>
<body>
	<h2>회원수정 updateForm.jsp</h2>
	<form action="updateProc.jsp" method="post">
		<input type="hidden" name='num' value="<%=sb.getNum()%>">
		아이디 : <input type="text" name="id" value="<%=sb.getId() %>"><br><br>  
		비밀번호 :
		<input type="password" name="passwd" value="<%=sb.getPasswd() %>"><br><br>  
		이름
		: <input type="text" name="name" value="<%=sb.getName() %>"><br><br>  
		생년월일 :
		<select name="year">
			<%for(int i=2022;i>1930;i--){%>
				<option value="<%=i%>"<%
				if(sb.getYear()==i){
				%>
				selected="selected"
				<%} %>><%=i%></option>	
			<%}	%>
			
		</select> 년 
		
		<select name="month">
			<%for(int i=1;i<=12;i++){%>
				<option value="<%=i%>"<%
				if(sb.getMonth()==i){
				%>
				selected="selected"
				<%} %>><%=i%></option>	
			<% }%>
			
		</select> 월
		
		<select name="day">
			<%for(int i=1;i<=31;i++){%>
				<option value="<%=i%>"<%
				if(sb.getDay()==i){
				%>
				selected="selected"
				<%} %>><%=i%></option>	
			<% }%>
        </select> 일 <br>
		<br> 취미 : 
		<input type="checkbox" name="hobby" value="달리기" 
		<%if(sb.getHobby().contains("달리기")){ %>
		checked
		<%} %>>달리기
		<input type="checkbox" name="hobby" value="수영"
		<%if(sb.getHobby().contains("수영")){ %>
		checked
		<%} %>>수영 
		<input type="checkbox" name="hobby" value="게임"
		<%if(sb.getHobby().contains("게임")){ %>
		checked
		<%} %>>게임 
		<input type="checkbox" name="hobby" value="영화"
		<%if(sb.getHobby().contains("영화")){ %>
		checked
		<%} %>>영화<br> <br><br> 

		[점수입력]<br> 
		C언어 : 	<input type="text" name="c" size="10" value="<%=sb.getC() %>">
		JAVA : <input type="text" name="java" size="10" value="<%=sb.getJava() %>">
		JSP : <input type="text" name="jsp" size="10" value="<%=sb.getJsp() %>"><br><br>  
		<input type="submit" value="수정하기">
	</form>

</body>
</html>

8.updateProc.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
updateProc.jsp<br>
<%request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="sb" class="myPkg.StudentBean"/>
<jsp:useBean id="sdao" class="myPkg.StudentDao"/>
<jsp:setProperty property="*" name="sb"/>

<% 
	sb.setSum(sb.getC()+sb.getJava()+sb.getJsp());
	String[] hobbys=request.getParameterValues("hobby");
	String hobby=hobbys[0]+",";
	for(int i=1;i<hobbys.length;i++){
		if(i==hobbys.length-1)
			hobby += hobbys[i];
		else
			hobby += hobbys[i]+",";
	}
	sb.setHobby(hobby);
	int result=sdao.updateStudent(sb);
	String msg;
	String url;
	if(result>0){
		msg="수정 성공";
		url="select.jsp";
	} else{
		msg="수정 실패";
		url="updateForm.jsp?num="+sb.getNum();		
	}
%>
<script type="text/javascript">
	alert("<%=msg%>");
	location.href="<%=url%>";
</script>

9. deleteProc.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
deleteProc.jsp<br>
<jsp:useBean id="sdao" class="myPkg.StudentDao"></jsp:useBean>
<%
	int num=Integer.parseInt(request.getParameter("num"));
	int result=sdao.deleteStudent(num);
	String msg;
	if(result>0){
		msg="삭제 성공";
	} else{
		msg="삭제 실패";	
	}
%>
<script type="text/javascript">
	alert("<%=msg%>");
	location.href="select.jsp";
</script>

10. deleteAll.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
deleteAll.jsp<br>
<jsp:useBean id="sdao" class="myPkg.StudentDao"/>
<% 
	String[] rowcheckArr=request.getParameterValues("rowcheck");
	int[] deleteArr=new int[rowcheckArr.length];
	for(int i=0;i<rowcheckArr.length;i++){
		deleteArr[i]=Integer.parseInt(rowcheckArr[i]);
		System.out.println(deleteArr[i]);
	}
	int result=sdao.deleteCheckData(rowcheckArr);
	String msg= result+"개 삭제 완료";
%>
<script type="text/javascript">
	alert('<%=msg%>');
	location.href='select.jsp';
</script>

11. id_check_proc.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
 
<jsp:useBean id="sdao" class="myPkg.StudentDao"/>
<% 
	//insertForm.jsp에서 중복체크 클릭했을때 => id_check_proc.jsp<br> 
	String userid=request.getParameter("userid");
	System.out.println("userid:"+userid);
	boolean isCheck=sdao.searchId(userid); 
	System.out.println("isCheck:"+isCheck);
	String str;
	if(isCheck){ //이미 존재하면
		str="No";
		out.print(str); //웹페이지에 띄우는게 아니라 요청한 Ajax쪽으로 넘긴다.
	} else { //존재하지 않으면
		str="YES";
		out.print(str);
	}
	
%>

 

'Develop > JavaScript JQuery JSP' 카테고리의 다른 글

0719 DBCP 커넥션풀  (0) 2022.07.22
0718 Singleton 패턴  (0) 2022.07.22
0712 JSP 3일차  (0) 2022.07.15
0711 JSP 2일차  (0) 2022.07.15
0708 JQuery 마무리와 JSP Start!  (0) 2022.07.08

'Develop/JavaScript JQuery JSP'의 다른글

  • 현재글0713~15 JSP JDBC 응용을 통해 테이블 작성

관련글

티스토리툴바