28참조

28참조

2022. 2. 5. 17:08ㆍksmart_jsp/06_jsp_java_mysql_model01

728x90

gdelete/g_delete_action.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.SQLException"%>
<%
	String g_code=request.getParameter("send_gcode");
	
	Connection conn=null;
	PreparedStatement pstmt = null;
	
	DriverDB db=new DriverDB();
	conn=db.driverDbcon();
	
	pstmt=conn.prepareStatement("DELETE FROM tb_goods WHERE g_code=?");
	pstmt.setString(1,g_code);
	
	int result=pstmt.executeUpdate();
	
	pstmt.close();
	conn.close();
	
	response.sendRedirect(request.getContextPath()+"/gsearch/g_search_list.jsp");
%>

glist/glist.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<%@ include file="/goods/goods_insert_form.jsp"%>
<!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=EUC-KR">
<title>상품 리스트</title>
</head>
<body>
	상품 리스트
	<br>
	<table width="100%" border="1">
		<tr>
			<td>상품코드</td>
			<td>판매자</td>
			<td>상품명</td>
			<td>카테고리</td>
			<td>가격</td>
			<td>색상</td>
			<td>사이즈</td>
			<td>상세설명</td>
			<td>수정</td>
			<td>삭제</td>
		</tr>
		<%
			Connection conn = null;
			PreparedStatement pstmt = null;
			ResultSet rs = null;

			DriverDB db=new DriverDB();
			conn=db.driverDbcon();
			
			pstmt = conn.prepareStatement("SELECT * FROM tb_goods");
			rs = pstmt.executeQuery();
			while (rs.next()) {
		%>
		<tr>
			<td><%=rs.getString("g_code")%></td>
			<td><%=rs.getString("m_id")%></td>
			<td><%=rs.getString("g_name")%></td>
			<td><%=rs.getString("g_cate")%></td>
			<td><%=rs.getString("g_price")%></td>
			<td><%=rs.getString("g_color")%></td>
			<td><%=rs.getString("g_size")%></td>
			<td><%=rs.getString("g_desc")%></td>
			<td><a href="<%=request.getContextPath()%>/gupdate/g_update_form.jsp?send_gcode=<%=rs.getString("g_code")%>">수정버튼</a></td>
			<td><a href="<%=request.getContextPath()%>/gdelete/g_delete_action.jsp?send_gcode=<%=rs.getString("g_code")%>">삭제버튼</a></td>
		</tr>
		<%
			}
			rs.close();
			pstmt.close();
			conn.close();
		%>
	
</body>
</html>

goods/goods_insert_pro.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<%
	request.setCharacterEncoding("euc-kr");
	String g_code = request.getParameter("g_code");
	String m_id = request.getParameter("m_id");
	String g_name = request.getParameter("g_name");
	String g_cate = request.getParameter("g_cate");
	String g_price = request.getParameter("g_price");
	String g_color = request.getParameter("g_color");
	String g_size = request.getParameter("g_size");
	String g_desc = request.getParameter("g_desc");

	Connection conn = null;
	PreparedStatement pstmt = null;
	ResultSet rs = null;
	int gcodeSum = 0;

	DriverDB db=new DriverDB();
	conn=db.driverDbcon();

	pstmt = conn.prepareStatement("select max(CAST(substring(g_code,7) AS DECIMAL)) as maxcol from tb_goods");
	rs = pstmt.executeQuery();
	if (rs.next()) {
		gcodeSum = rs.getInt(1) + 1;
		pstmt = conn.prepareStatement("INSERT INTO tb_goods VALUES (?, ?, ?, ?, ?, ?, ?, now(), ?)");
		pstmt.setString(1, "goods_"+gcodeSum);
		pstmt.setString(2, m_id);
		pstmt.setString(3, g_name);
		pstmt.setString(4, g_cate);
		pstmt.setString(5, g_price);
		pstmt.setString(6, g_color);
		pstmt.setString(7, g_size);
		pstmt.setString(8, g_desc);
		pstmt.executeUpdate();
	}
	response.sendRedirect(request.getContextPath()+"/gsearch/g_search_list.jsp");
	rs.close();
	pstmt.close();
	conn.close();

%>

gsearch/g_search_list.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="EUC-KR">
<title>상품검색리스트</title>
<link rel="stylesheet" type="text/css"
	href="<%=request.getContextPath()%>/css/main.css" />
</head>
<body>
	<%@include file="/module/top.jsp"%>
	<%@include file="/module/left.jsp"%>
	상품검색리스트
	<br>
	<%@include file="/gsearch/g_search_form.jsp"%>
	<table width="100%" border="1">
		<tr>
			<td>상품코드</td>
			<td>판매자</td>
			<td>상품명</td>
			<td>카테고리</td>
			<td>가격</td>
			<td>색상</td>
			<td>사이즈</td>
			<td>상세설명</td>
			<td>수정</td>
			<td>삭제</td>
		</tr>
		<%
			request.setCharacterEncoding("euc-kr");

			String gs = request.getParameter("gs");
			String gt = request.getParameter("gt");
			String g_name = request.getParameter("g_name");
			String g_cate = request.getParameter("g_cate");
			String g_price = request.getParameter("g_price");
			String g_color = request.getParameter("g_color");
			String g_size = request.getParameter("g_size");

			System.out.println(gs + "<--gs gsearchlist");
			System.out.println(gt + "<--gt gsearchlist");
			Connection conn = null;
			PreparedStatement pstmt = null;
			ResultSet rs = null;

			DriverDB db=new DriverDB();
			conn=db.driverDbcon();
			
			if (gs == null && gt == null) {
				pstmt = conn.prepareStatement("SELECT * FROM tb_goods");
			} else if (gs != null && gt.equals("")) {
				pstmt = conn.prepareStatement("SELECT * FROM tb_goods");
			}else if(gs.equals("")&&gt!=null){
				pstmt = conn.prepareStatement("SELECT * FROM tb_goods");
			} else {
				if (gs.equals("m_id")) {
					pstmt = conn.prepareStatement("SELECT * FROM tb_goods WHERE m_id=?");
				} else if (gs.equals("g_name")) {
					pstmt = conn.prepareStatement("SELECT * FROM tb_goods WHERE g_name=?");
				} else if (gs.equals("g_cate")) {
					pstmt = conn.prepareStatement("SELECT * FROM tb_goods WHERE g_cate=?");
				} else if (gs.equals("g_price")) {
					pstmt = conn.prepareStatement("SELECT * FROM tb_goods WHERE g_price=?");
				} else if (gs.equals("g_color")) {
					pstmt = conn.prepareStatement("SELECT * FROM tb_goods WHERE g_color=?");
				} else if (gs.equals("g_size")) {
					pstmt = conn.prepareStatement("SELECT * FROM tb_goods WHERE g_size=?");
				}
				pstmt.setString(1, gt);
			}
			rs = pstmt.executeQuery();
			while (rs.next()) {
		%>
		<tr>
			<td><%=rs.getString("g_code") %></td>
			<td><%=rs.getString("m_id") %></td>
			<td><%=rs.getString("g_name") %></td>
			<td><%=rs.getString("g_cate") %></td>
			<td><%=rs.getString("g_price") %></td>
			<td><%=rs.getString("g_color") %></td>
			<td><%=rs.getString("g_size") %></td>
			<td><%=rs.getString("g_desc") %></td>
			<td><a href="<%=request.getContextPath()%>/gupdate/g_update_form.jsp?send_gcode=<%=rs.getString("g_code")%>">수정버튼</a></td>
			<td><a href="<%=request.getContextPath()%>/gdelete/g_delete_action.jsp?send_gcode=<%=rs.getString("g_code")%>">삭제버튼</a></td>
		</tr>
		<%
			}
			rs.close();
			pstmt.close();
			conn.close();
		%>
	</table>
	<%@include file="/module/hadan.jsp"%>
</body>
</html>

gupdate/g_update_form.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="EUC-KR">
<title>Insert title here</title>
<link rel="stylesheet" type="text/css" href="<%= request.getContextPath() %>/css/main.css" />
</head>
<body>
<%@ include file="/module/top.jsp" %>
<%@ include file="/module/left.jsp" %>
상품수정화면
<%
	String g_code=request.getParameter("send_gcode");
	String g_name=null;
	String g_cate=null;
	String g_price=null;
	String g_color=null;
	String g_size=null;
	String g_desc=null;

	Connection conn=null;
	PreparedStatement pstmt=null;
	ResultSet rs=null;
	
	DriverDB db=new DriverDB();
	conn=db.driverDbcon();
	
	pstmt=conn.prepareStatement("SELECT * FROM tb_goods WHERE g_code=?");
	pstmt.setString(1,g_code);
	rs=pstmt.executeQuery();
	if(rs.next()){
		g_name=rs.getString("g_name");
		g_cate=rs.getString("g_cate");
		g_price=rs.getString("g_price");
		g_color=rs.getString("g_color");
		g_size=rs.getString("g_size");
		g_desc=rs.getString("g_desc");
	}
	rs.close();
	pstmt.close();
	conn.close();
%>	
<form action="<%=request.getContextPath()%>/gupdate/g_update_action.jsp" method="post">
	<input type="hidden" name="g_code" value="<%=g_code %>">
	<input type="hidden" name="m_id" value="<%=S_ID%>">
<table>
	<tr>
		<td>상품명</td>
		<td><input type="text" name="g_name" value=<%=g_name %>></td>
	</tr>
	<tr>
		<td>카테고리</td>
		<td><input type="text" name="g_cate" value=<%=g_cate %>></td>
	</tr>
	<tr>
		<td>가격</td>
		<td><input type="text" name="g_price" value=<%=g_price %>></td>
	</tr>
	<tr>
		<td>색상</td>
		<td><input type="text" name="g_color" value=<%=g_color %>></td>
	</tr>
	<tr>
		<td>사이즈</td>
		<td><input type="text" name="g_size" value=<%=g_size %>></td>
	</tr>
	<tr>
		<td>상세설명</td>
		<td><input type="text" name="g_desc" value=<%=g_desc %>></td>
	</tr>
</table>
	<input type="submit" value="상품등록버튼">
</form>
<%@ include file="/module/hadan.jsp" %>
</body>
</html>

gupdate/g_update_action.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%
	String g_code=request.getParameter("g_code");
	String g_name=request.getParameter("g_name");
	String g_cate=request.getParameter("g_cate");
	String g_price=request.getParameter("g_price");
	String g_color=request.getParameter("g_color");
	String g_size=request.getParameter("g_size");
	String g_desc=request.getParameter("g_desc");

	Connection conn=null;
	PreparedStatement pstmt=null;
	
	DriverDB db=new DriverDB();
	conn=db.driverDbcon();
	
	pstmt = conn.prepareStatement("UPDATE tb_goods SET g_name=?,g_cate=?,g_price=?,g_color=?,g_size=?,g_desc=? WHERE g_code=?");
	pstmt.setString(1,g_name);
	pstmt.setString(2,g_cate);
	pstmt.setString(3,g_price);
	pstmt.setString(4,g_color);
	pstmt.setString(5,g_size);
	pstmt.setString(6,g_desc);
	pstmt.setString(7,g_code);
	
	int result = pstmt.executeUpdate();
	response.sendRedirect(request.getContextPath()+"/gsearch/g_search_list.jsp");
	pstmt.close();
	conn.close();
%>

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.SQLException"%>
<%
	request.setCharacterEncoding("euc-kr");
	String uid = request.getParameter("uid");
	String upw = request.getParameter("upw");
	String dbid = null;
	String dbpw = null;
	String dblevel = null;
	String dbname = null;
	String dbemail = null;
	String alert = null;

	Connection conn = null;
	PreparedStatement pstmt = null;
	ResultSet rs = null;

	DriverDB db=new DriverDB();
	conn=db.driverDbcon();
	
	pstmt = conn.prepareStatement("SELECT * FROM tb_member WHERE m_id=?");
	pstmt.setString(1, uid);
	rs = pstmt.executeQuery();
	if (rs.next()) {
		System.out.println("1-1 아이디 일치");
		dbid = rs.getString("m_id");
		dbpw = rs.getString("m_pw");
		dblevel = rs.getString("m_level");
		dbname = rs.getString("m_name");
		dbemail = rs.getString("m_email");
		System.out.println(dbid + "<-dbid login_action.jsp");
		System.out.println(dbpw + "<-dbpw login_action.jsp");
		System.out.println(dblevel + "<-dblevel login_action.jsp");
		System.out.println(dbname + "<-dbname login_action.jsp");
		System.out.println(dbemail + "<-dbemail login_action.jsp");
		if (upw.equals(dbpw)) {
			System.out.println("2-1 로그인 성공");
			session.setAttribute("S_ID", dbid);
			session.setAttribute("S_NAME", dbname);
			session.setAttribute("S_LEVEL", dblevel);
			alert="로그인성공";
		} else {
			System.out.println("2-2 비밀번호 불일치");
			alert="비밀번호불일치";
		}
	} else {
		System.out.println("1-2 아이디 불일치");
		alert="아이디불일치";
	}
%>
<script type="text/javascript"> 
	alert('<%=alert%>');
	location.href='<%= request.getContextPath()%>/index.jsp';
</script>

mdelete/m_delete_action.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- DELETE FROM tb_member WHERE m_id='id008'; -->
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.SQLException"%>
<%
	String send_id=request.getParameter("send_id");
	
	Connection conn = null;
	PreparedStatement pstmt = null;

	DriverDB db=new DriverDB();
	conn=db.driverDbcon();

	pstmt = conn.prepareStatement("DELETE FROM tb_member WHERE m_id=?");
	pstmt.setString(1,send_id);

	int result=pstmt.executeUpdate();
	
	pstmt.close();
	conn.close();
	response.sendRedirect(request.getContextPath()+"/msearch/m_search_list.jsp");
%>

minsert/m_insert_action.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.SQLException"%>
<%
	request.setCharacterEncoding("euc-kr");
	Connection conn = null;
	PreparedStatement pstmt=null;
	String m_id=request.getParameter("m_id");
	String m_pw=request.getParameter("m_pw");
	String m_level=request.getParameter("m_level");
	String m_name=request.getParameter("m_name");
	String m_email=request.getParameter("m_email");

	DriverDB db=new DriverDB();
	conn=db.driverDbcon();
	
	pstmt=conn.prepareStatement("INSERT INTO tb_member VALUES(?,?,?,?,?)");	
	pstmt.setString(1,m_id);
	pstmt.setString(2,m_pw);
	pstmt.setString(3,m_level);
	pstmt.setString(4,m_name);
	pstmt.setString(5,m_email);
	
	int result=pstmt.executeUpdate();
	pstmt.close();
	conn.close();
	response.sendRedirect(request.getContextPath()+"/msearch/m_search_list.jsp");
%>

mlist/mlist.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.SQLException"%>
<%@ include file="/minsert/m_insert_form.jsp" %>
회원 리스트
<br>
<table width="100%" border="1">
	<tr>
		<td>아이디</td>
		<td>비번</td>
		<td>권한</td>
		<td>이름</td>
		<td>이메일</td>
		<td>수정</td>
		<td>삭제</td>
	</tr>
	<%
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;

		DriverDB db=new DriverDB();
		conn=db.driverDbcon();
		
		pstmt = conn.prepareStatement("SELECT * FROM tb_member");

		rs = pstmt.executeQuery();

		while (rs.next()) {
	%>
	<tr>
		<td><%=rs.getString("m_id")%></td>
		<td><%=rs.getString("m_pw")%></td>
		<td><%=rs.getString("m_level")%></td>
		<td><%=rs.getString("m_name")%></td>
		<td><%=rs.getString("m_email")%></td>
		<td><a href="<%=request.getContextPath()%>/mupdate/m_update_form.jsp?send_id=<%=rs.getString("m_id")%>">수정버튼</a></td>
		<td><a href="<%=request.getContextPath()%>//mdelete/m_delete_action.jsp?send_id=<%=rs.getString("m_id")%>">삭제버튼</a></td>
	</tr>
	<%
		}
		rs.close();
		pstmt.close();
		conn.close();
	%>
</table>

msearch/m_search_list.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<link rel="stylesheet" type="text/css" href="<%= request.getContextPath() %>/css/main.css" />
<%@include file="/module/top.jsp"%>
<%@include file="/module/left.jsp"%>
<%@ include file="/msearch/m_search_form.jsp"%>
<table border="1" width="100%">
	<tr>
		<th>아이디</th>
		<th>권한</th>
		<th>이름</th>
		<th>이메일</th>
		<th>수정</th>
		<th>삭제</th>
	</tr>
	<%
		request.setCharacterEncoding("euc-kr");
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;

		DriverDB db=new DriverDB();
		conn=db.driverDbcon();
		
		String sk = request.getParameter("sk");
		String sv = request.getParameter("sv");
		if (sk==null && sv==null) {
			pstmt = conn.prepareStatement("SELECT*FROM tb_member");
		} else if (sk != null && sv.equals("")) {
			System.out.println("1-2 sk!=null, sv=null");
			pstmt = conn.prepareStatement("SELECT*FROM tb_member");
		} else {
			if (sk.equals("m_id")) {
				pstmt = conn.prepareStatement("SELECT*FROM tb_member WHERE m_id=?");
			} else if (sk.equals("m_level")) {
				pstmt = conn.prepareStatement("SELECT*FROM tb_member WHERE m_level=?");
			} else if (sk.equals("m_name")) {
				pstmt = conn.prepareStatement("SELECT*FROM tb_member WHERE m_name=?");
			} else if (sk.equals("m_email")) {
				pstmt = conn.prepareStatement("SELECT*FROM tb_memer WHERE m_email=?");
			}
			pstmt.setString(1, sv);
		}
		rs = pstmt.executeQuery();
		while (rs.next()) {
	%>
	<tr>
		<td><%=rs.getString("m_id")%></td>
		<td><%=rs.getString("m_level")%></td>
		<td><%=rs.getString("m_name")%></td>
		<td><%=rs.getString("m_email")%></td>
		<td><a
			href="<%=request.getContextPath()%>/mupdate/m_update_form.jsp?send_id=<%=rs.getString("m_id")%>">수정버튼</a></td>
		<td><a
			href="<%=request.getContextPath()%>/mdelete/m_delete_action.jsp?send_id=<%=rs.getString("m_id")%>">삭제버튼</a></td>
	</tr>
	<%
		}
		rs.close();
		pstmt.close();
		conn.close();
	%>
</table>

<%@ include file="/module/hadan.jsp"%>

mupdate/m_update_action.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>

<%
	request.setCharacterEncoding("euc-kr");
	String m_id = request.getParameter("m_id");
	String m_pw = request.getParameter("m_pw");
	String m_level = request.getParameter("m_level");
	String m_name = request.getParameter("m_name");
	String m_email = request.getParameter("m_email");
	Connection conn = null;
	PreparedStatement pstmt = null;

	DriverDB db=new DriverDB();
	conn=db.driverDbcon();
	
	pstmt = conn.prepareStatement("UPDATE tb_member SET m_pw=?,m_level=?,m_name=?,m_email=? WHERE m_id=?");
	pstmt.setString(1, m_pw);
	pstmt.setString(2, m_level);
	pstmt.setString(3, m_name);
	pstmt.setString(4, m_email);
	pstmt.setString(5, m_id);
	int result = pstmt.executeUpdate();
	System.out.println(result);
	pstmt.close();
	conn.close();
	response.sendRedirect(request.getContextPath()+"/msearch/m_search_list.jsp");

%>

mupdate/m_update_form.jsp

<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.SQLException"%>
<link rel="stylesheet" type="text/css" href="<%= request.getContextPath() %>/css/main.css" />
<%@include file="/module/top.jsp"%>
<%@include file="/module/left.jsp"%>
회원수정화면
<%
	String send_id = request.getParameter("send_id");
	Connection conn = null;
	PreparedStatement pstmt = null;
	ResultSet rs = null;

	String dbid = null;
	String dbpw = null;
	String dblevel = null;
	String dbname = null;
	String dbemail = null;

	DriverDB db=new DriverDB();
	conn=db.driverDbcon();
	
	pstmt = conn.prepareStatement("SELECT *FROM tb_member WHERE m_id=?");
	pstmt.setString(1, send_id);
	rs = pstmt.executeQuery();

	if (rs.next()) {
		dbid = rs.getString("m_id");
		dbpw = rs.getString("m_pw");
		dblevel = rs.getString("m_level");
		dbname = rs.getString("m_name");
		dbemail = rs.getString("m_email");
	}
	rs.close();
	pstmt.close();
	conn.close();
%>
<form action="<%=request.getContextPath()%>/mupdate/m_update_action.jsp" method="post">
<table border="0">
	<tr>
	<td>아이디</td>
	<td><input type="text" name="m_id" size="20" value="<%=dbid%>" readonly></td>
<tr>
<tr>
	<td>암호</td>
	<td><input type="text" name="m_pw" size="20" value="<%=dbpw%>"></td>
<tr>
<tr>
	<td>권한</td>
	<td><input type="text" name="m_level" size="20" value="<%=dblevel%>"></td>
<tr>
<tr>
	<td>이름</td>
	<td><input type="text" name="m_name" size="20" value="<%=dbname%>"></td>
<tr>
<tr>
	<td>이메일</td>
	<td><input type="text" name="m_email" size="20" value="<%=dbemail%>"></td>
<tr>
<tr>
	<td colspan="4"><input type="submit" value="회원수정버튼"></td>
</tr>
</table>
</form>
<%@ include file="/module/hadan.jsp"%>

728x90

'ksmart_jsp > 06_jsp_java_mysql_model01' 카테고리의 다른 글

31_jsp_java_DTO(bean)_DAO_insert처리_jsp (0)	2022.02.05
30_jsp_java_DTO(bean)_update처리_jsp (0)	2022.02.05
url 주소 가져오는 함수_jsp (0)	2022.02.05
29_jsp_java_DTO(bean)_insert처리_jsp (0)	2022.02.05
28_jsp_java_driver로딩_db연결분리_처리_jsp (0)	2022.02.05

dev-std

dev-std

태그

최근글

댓글

공지사항

아카이브

'ksmart_jsp > 06_jsp_java_mysql_model01' 카테고리의 다른 글

관련글

티스토리툴바