29_jsp_java_DTO(bean)_insert처리_jsp
2022. 2. 5. 17:09ㆍksmart_jsp/06_jsp_java_mysql_model01
728x90
JSP 액션태그와 JavaBean , DTO&DAO 이론
2022.02.05 - [jsp] - JavaBean, DTO& DAO_jsp
JavaBean, DTO& DAO_jsp
JavaBean DTO 클래스로서 자바빈의 규격서에 따라 작성된 클래스 더보기 DTO는 Data Transfer Object의 약자로 데이터를 운반하는 객체이다. 데이터만을 가지는 private 필드와 getter, setter만을 가지는 객체
moon09-developer.tistory.com
jsp:useBean 사용 할 수 있는 환경 만드는 과정
1) DTO 생성
| 패키지 명 | kr.or.ksmart.dto |
| 클래스 명 | Member |
| 전역변수 | m_id |
| m_pw | |
| m_level | |
| m_name | |
| m_email |
더보기
더보기
더보기
package kr.or.ksmart.dto;
public class Member {
private String m_id;
private String m_pw;
private String m_level;
private String m_name;
private String m_email;
public String getM_id() {
return m_id;
}
public void setM_id(String m_id) {
System.out.println(m_id+"<--m_id setM_id Member..java");
this.m_id = m_id;
}
public String getM_pw() {
return m_pw;
}
public void setM_pw(String m_pw) {
System.out.println(m_pw+"<--m_pw setM_id Member..java");
this.m_pw = m_pw;
}
public String getM_level() {
return m_level;
}
public void setM_level(String m_level) {
System.out.println(m_level+"<--m_level setM_id Member..java");
this.m_level = m_level;
}
public String getM_name() {
return m_name;
}
public void setM_name(String m_name) {
System.out.println(m_name+"<--m_name setM_id Member..java");
this.m_name = m_name;
}
public String getM_email() {
return m_email;
}
public void setM_email(String m_email) {
System.out.println(m_email+"<--m_email setM_id Member..java");
this.m_email = m_email;
}
}2) 테스트
더보기
더보기
더보기
테스트 페이지
출력된 문자
<%@ 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 ="kr.or.ksmart.dto.Member"%>
<%
Member m=new Member();
//1)콘솔창 출력
m.setM_id("id001");
m.setM_pw("pw001");
m.setM_level("관리자");
m.setM_name("김길동");
m.setM_email("email01");
//2)out 객체 활용 화면 출력
out.println(m.getM_id()+"m.getM_id()");
out.println(m.getM_pw()+"m.getM_pw()");
out.println(m.getM_level()+"m.getM_level()");
out.println(m.getM_name()+"m.getM_name()");
out.println(m.getM_email()+"m.getM_email()");
%>
//표현식으로 화면 출력
아이디 : <%=m.getM_id()%>
비 번 : <%=m.getM_pw()%>
권 한 : <%=m.getM_level()%>
이 름 : <%=m.getM_name()%>
이메일 : <%=m.getM_email()%>3. Member 클래스 연결
<%@page import="kr.or.ksmart.dto.Member"%>
<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ 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();
Member m=new Member();
m.setM_id(m_id);
m.setM_pw(m_pw);
m.setM_level(m_level);
m.setM_name(m_name);
m.setM_email(m_email);
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");
%>3. jsp:useBean 사용
<%@ page import = "kr.or.ksmart.dto.Member" %>
Member m = new Member();↓
<jsp:useBean id="m" class="kr.or.ksmart.dto.Member"/>
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");
m.setM_id(m_id);
m.setM_pw(m_pw);
m.setM_level(m_level);
m.setM_name(m_name);
m.setM_email(m_email);↓
<jsp:setProperty name="m" property="*"/>
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);↓
pstmt=conn.prepareStatement("INSERT INTO tb_member VALUES(?,?,?,?,?)");
pstmt.setString(1,m.getM_id());
pstmt.setString(2,m.getM_pw());
pstmt.setString(3,m.getM_level());
pstmt.setString(4,m.getM_name());
pstmt.setString(5,m.getM_email());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 |
| 28참조 (0) | 2022.02.05 |
| 28_jsp_java_driver로딩_db연결분리_처리_jsp (0) | 2022.02.05 |