<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:jsp="http://java.sun.com/xml/ns/javaee/jsp" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
<servlet>
<servlet-name>memberjoin</servlet-name>
<servlet-class>
org.springframework.web.servlet.DispatcherServlet
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>memberjoin</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<!-- 한글 처리 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>
org.springframework.web.filter.CharacterEncodingFilter
</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>EUC-KR</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
- /WebContent/WEB-INF/memberjoin-servlet.xml 소스
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
<!-- Controller 작성 -->
<!-- MemberJoin - Insert 실행 -->
<bean id="memberjoin" name="/MemberJoin.do" class="controller.MemberJoin"
p:memberDao-ref="memberDao"
>
</bean>
<!-- MemberList - Select * 실행 -->
<bean id="memberlist" name="/MemberList.do" class="controller.MemberList"
p:memberDao-ref="memberDao"
>
</bean>
<!-- MemberInfo - Select 실행 -->
<bean id="memberinfo" name="/MemberInfo.do" class="controller.MemberInfo"
p:memberDao-ref="memberDao"
>
</bean>
<!-- MemberUpdate - Update 실행 -->
<bean id="memberupdate" name="/MemberUpdate.do" class="controller.MemberUpdate"
p:memberDao-ref="memberDao"
>
</bean>
<!-- MemberDelete - Delete 실행 -->
<bean id="memberdelete" name="/MemberDelete.do" class="controller.MemberDelete"
p:memberDao-ref="memberDao"
>
</bean>
<bean id="memberDao" class="member.MemberDao"
p:dataSource-ref="dataSource"
>
</bean>
<!-- Controller 실행 후 결과를 result할 jsp 페이지를 설정 -->
<bean id = "internalResolver"
class = "org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name = "viewClass">
<value>org.springframework.web.servlet.view.JstlView</value>
</property>
<property name="prefix">
<value>/jsp/</value>
</property>
<property name="suffix">
<value>.jsp</value>
</property>
</bean>
<!-- 데이터 베이스 객체를 사용할 수 있게 설정해주는 Datasource 선언 -->
<bean id = "dataSource"
class = "org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name = "driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="url">
<value>jdbc:oracle:thin:@127.0.0.1:1521:XE</value>
</property>
<property name="username">
<value>system</value>
</property>
<property name="password">
<value>123456</value>
</property>
</bean>
</beans>
- /WebContent/jsp/MemberJoin.jsp 소스
<%@ 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">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title> 회 원 가 입 </title>
</head>
<body>
<center>
<font face="휴먼아미체">
<h2> 회 원 가 입 </h2>
<!-- MemberJoin.do라는 컨트롤러를 호출하라는 뜻 -->
<form action="../MemberJoin.do" method="post">
<table border = "1" bgcolor = "lightyellow" cellpadding = "5">
<tr>
<td> 아이디 </td>
<td> <input type = "text" name = id> </td>
<td colspan = "2" align = "right"><b> *10자이내 </b> </td>
</tr>
<tr>
<td> 비밀번호 </td>
<td> <input type = "password" name = pass></td>
<td> 성명 </td>
<td> <input type = "text" name = "name"></td>
</tr>
<tr>
<td> 성별 </td>
<td><input type = "radio" name = "gender" value = "남"> 남
<input type = "radio" name = "gender" value = "여"> 여 </td>
<td> 취미 </td>
<td><input type = "checkbox" name = "hobby1" value = "음악감상"> 음악감상
<input type = "checkbox" name = "hobby2" value = "영화감상"> 영화감상 </td>
</tr>
<tr>
<td> 주소 </td>
<td> <input type = "text" name = "address"> </td>
<td> 이메일 </td>
<td> <input type = "text" name = "email"> </td>
</tr>
<tr>
<td> H.P </td>
<td><select name = "phone1">
<option value = "010"> 010 </option>
<option value = "011"> 011 </option>
<option value = "070"> 070 </option>
</select>
- <input type = "text" name = "phone2" size = "4">
- <input type = "text" name = "phone3" size = "4"> </td>
<td colspan = "2" align = "right"> <b>*필수입력 </b> </td>
</tr>
<tr>
<td> 자기소개 </td>
<td colspan = "3">
<textarea cols = "50" rows = "3" name = "introduce"></textarea> </td>
</tr>
<tr>
<td colspan = "4" align = "center">
<input type = "submit" value = "전송">
<input type = "reset" value = "취소">
<input type = "button" value = "목록" onclick = "window.location='../MemberList.do'"> </td>
</tr>
</table>
</form>
</font>
</center>
</body>
</html>
- /WebContent/jsp/MemberListView.jsp 소스
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<center>
<font face="휴먼아미체">
<h2> 회 원 정 보 목 록 </h2>
<table border="1" width="630" cellpadding="3" cellspacing="2">
<tr>
<th width="90" bgcolor="lightyellow">아이디</th>
<th width="90" bgcolor="lightyellow">이름</th>
<th width="100" bgcolor="lightyellow">주소</th>
<th width="100" bgcolor="lightyellow">이메일</th>
<th width="100" bgcolor="lightyellow">H.P</th>
<th width="150" bgcolor="lightyellow">자기소개</th>
</tr>
<c:forEach var="listbean" items="${listbean}">
<tr>
<td width="90"><a href="MemberInfo.do?id=${listbean.id}">${listbean.id}</a> </td>
<td width="90">${listbean.name}</td>
<td width="100">${listbean.address}</td>
<td width="100">${listbean.email}</td>
<td width="100">${listbean.phone1}-${listbean.phone2}-${listbean.phone3}</td>
<td width="150">${listbean.introduce}</td>
</tr>
</c:forEach>
<tr>
<td colspan="7" align="right"><a href="/MemberJoin/jsp/MemberJoin.jsp">회원가입</a></td>
</tr>
</table>
</font>
</center>
</body>
</html>
- /WebContent/jsp/MemberInfoView.jsp
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<center>
<font face="휴먼아미체">
<h2> 회 원 정 보 </h2>
<form action="MemberUpdate.do" method="post">
<table border = "1" bgcolor = "lightyellow" cellpadding = "5">
<tr>
<td> 아이디 </td>
<td> <input type="text" name="id" value="${mbean.id}" disabled> </td>
<td colspan = "2" align = "right"><b> *8자이내 </b> </td>
</tr>
<tr>
<td> 비밀번호 </td>
<td> <input type = "password" name = "pass" value = "${mbean.pass}"> </td>
<td> 성명 </td>
<td> <input type = "text" name = "name" value = "${mbean.name}"> </td>
</tr>
<tr>
<td> 성별 </td>
<td><input type = "radio" name = "gender" value = "남"> 남
<input type = "radio" name = "gender" value = "여"> 여 </td>
<td> 취미 </td>
<td><input type = "checkbox" name = "hobby1" value = "음악감상"> 음악감상
<input type = "checkbox" name = "hobby2" value = "영화감상"> 영화감상 </td>
</tr>
<tr>
<td> 주소 </td>
<td> <input type = "text" name = "address" value = "${mbean.address}"> </td>
<td> 이메일 </td>
<td> <input type = "text" name = "email" value = "${mbean.email}"> </td>
</tr>
<tr>
<td> H.P </td>
<td> <select name = "phone1">
<option value = "010"> 010 </option>
<option value = "011"> 011 </option>
<option value = "070"> 070 </option>
</select>
- <input type = "text" name = "phone2" size = "4">
- <input type = "text" name = "phone3" size = "4"> </td>
<td colspan = "2" align = "right"> <b>*필수입력 </b> </td>
</tr>
<tr>
<td> 자기소개 </td>
<td colspan = "3"><textarea cols = "50" rows = "3" name = "introduce">${mbean.introduce}</textarea> </td>
</tr>
<tr>
<td colspan = "4" align = "center">
<input type = "submit" value = "수정">
<input type="button" value="삭제" onclick = "window.location='MemberDelete.do?id=${mbean.id}'">
<input type = "button" value = "목록" onclick = "window.location='MemberList.do'"> </td>
</tr>
</table>
<input type = "hidden" name="updateid" value="${mbean.id}">
</form>
</font>
</center>
</body>
</html>
- /src/member/MemberBean.java 소스
package member;
public class MemberBean {
// form 데이터의 name과 똑같은 이름의 멤버변수를 만듬
private String id;
private String pass;
private String name;
private String gender;
private String hobby1;
private String hobby2;
private String address;
private String email;
private String phone1;
private String phone2;
private String phone3;
private String introduce;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getPass() {
return pass;
}
public void setPass(String pass) {
this.pass = pass;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getHobby1() {
return hobby1;
}
public void setHobby1(String hobby1) {
this.hobby1 = hobby1;
}
public String getHobby2() {
return hobby2;
}
public void setHobby2(String hobby2) {
this.hobby2 = hobby2;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPhone1() {
return phone1;
}
public void setPhone1(String phone1) {
this.phone1 = phone1;
}
public String getPhone2() {
return phone2;
}
public void setPhone2(String phone2) {
this.phone2 = phone2;
}
public String getPhone3() {
return phone3;
}
public void setPhone3(String phone3) {
this.phone3 = phone3;
}
public String getIntroduce() {
return introduce;
}
public void setIntroduce(String introduce) {
this.introduce = introduce;
}
}
- /src/member/MemberDao.java 소스 (중요)
package member;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;
import org.springframework.jdbc.core.simple.SimpleJdbcTemplate;
public class MemberDao {
// Statement 객체와 유사한 쿼리를 실행시켜주는 객체
SimpleJdbcTemplate template;
// 참조할땐 set을 사용 (자동 등록)
// memberJoin-servlet.xml 파일에서 MemberDao가 DataSource 객체를 참조하게 선언했기에
// 실제 MemberDao에서 DataSource를 사용할 수 있도록 선언
/* public void setDataSource(DataSource dataSource){
// SimpleJdbcTemplate를 사용하려면 dataSource 객체가 필요하기 때문에 받아와야 함
// 쿼리를 실행하기 위해서 커넥션과 드라이버 클래스가 저장되어있는 DataSource를 이용하여 객체를 생성
template = new SimpleJdbcTemplate(dataSource);
} */
// memberJoin-servlet.xml 파일에서 MemberDao가 DataSource 객체를 참조하게 선언
// 자동 매핑을 위해서 위 방식 보다는 아래 방식을 추천 (위 방식은 직접 받는 방식, 아래 방식은 인터페이스를 사용한 방식)
DataSource dataSource;
public void setDataSource(DataSource dataSource){
template = new SimpleJdbcTemplate(dataSource);
}
// 1. 멤버 데이터를 입력할 메소드 선언
public void memberInsert(MemberBean mbean){
// String gender = bean.getGender(); // gender를 미리 선언해놓은 경우에 아래처럼 사용가능
// String sql = "insert into member values(:id, :pass, :name, '"+gender"', :hobby1, :hobby2, :address, :email, :phone1, :phone2, :phone3, :introduce)";
String sql = "insert into member values(:id, :pass, :name, :gender, :hobby1, :hobby2, :address, :email, :phone1, :phone2, :phone3, :introduce)";
// 준비된 쿼리를 스프링용 SimpleJdbcTemplate 형태로 바꿔줌
// 알아서 bean 클래스와 매핑 시킴
SqlParameterSource sqlsource = new BeanPropertySqlParameterSource(mbean);
// 쿼리 실행
template.update(sql, sqlsource);
}
// 2. 모든 회원을 리턴하는 메소드 작성
public List<MemberBean> getAllMember(){
// 쿼리 준비
String sql = "select * from member";
// 멤버빈타입 속성과 member 테이블의 레코드, 컬럼명을 일치시켜주는 객체
RowMapper<MemberBean> rm = new BeanPropertyRowMapper<MemberBean>(MemberBean.class);
return template.query(sql, rm);
}
// 3. 하나의 회원을 리턴하는 메소드 작성
public MemberBean getOneMember(String id){
// 쿼리 준비
String sql = "select * from member where id=?";
// 멤버빈타입 속성과 member 테이블의 레코드, 컬럼명을 일치시켜주는 객체
RowMapper<MemberBean> rm = new BeanPropertyRowMapper<MemberBean>(MemberBean.class);
return template.queryForObject(sql, rm, id); // 물음표가 여러개면 (sql, rm, id, ...) 이런식으로 다 써주면 됨
}
// 4. 하나의 회원을 수정하는 메소드 작성
public void updateMember(String id, String address, String email){
// 쿼리 준비
String sql = "update member set address=?, email=? where id=?";
template.update(sql, address, email, id);
}
// 5. 하나의 회원을 삭제하는 메소드 작성
public void deleteMember(String id){
// 쿼리 준비
String sql = "delete from member where id=?";
template.update(sql, id);
}
}
- /src/controller/MemberJoin.java 소스 (Insert 문)
package controller;
import member.MemberBean;
import member.MemberDao;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.view.RedirectView;
@Controller
public class MemberJoin {
// memberJoin-servlet.xml 파일에서 MemberDao가 DataSource 객체를 참조하게 선언
MemberDao memberDao;
// memberDao를 참조하겠다고 선언 - memberDao를 별도의 선언 없이 사용 가능
public void setMemberDao(MemberDao memberDao) {
this.memberDao = memberDao;
}
@RequestMapping("/MemberJoin") // RequestMapping이 있어야 호출이 됨
// RequestMapping에 의해서 사용자가 요청을 실행하는 순간 실행되는 CallBack 메소드
// 데이터를 같이 떠넘기지 않으면 Model을 필요 없다.
public ModelAndView setMember(MemberBean mbean){
// 참조했기에 객체를 생성 시킬 필요없이 갖다 쓸 수 있음
memberDao.memberInsert(mbean);
// model과 view를 동시에 지정 가능한 객체 선언
ModelAndView mav = new ModelAndView();
// 컨트롤러에서 컨트롤러를 호출
mav.setView(new RedirectView("MemberList.do"));
return mav; // bean 클래스에 선언한 ViewResolver 클래스를 호출
}
}
- /src/controller/MemberList.java 소스 (Select * 문)
package controller;
import java.util.List;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import member.MemberBean;
import member.MemberDao;
public class MemberList {
MemberDao memberDao;
// 데이터베이스 객체를 사용할 수 있도록 설정
public void setMemberDao(MemberDao memberDao){
this.memberDao = memberDao;
}
@RequestMapping("/MemberList")
public ModelAndView getAllMember(){
// 데이터베이스에 접근해서 데이터를 받아옴
List<MemberBean> listbean = memberDao.getAllMember();
return new ModelAndView("MemberListView", "listbean", listbean);
}
}
- /src/controller/MemberInfo.java 소스 (Select 문)
package controller;
import member.MemberBean;
import member.MemberDao;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
public class MemberInfo {
MemberDao memberDao;
// 데이터베이스 객체를 사용할 수 있도록 설정
public void setMemberDao(MemberDao memberDao){
this.memberDao = memberDao;
}
@RequestMapping("/MemberInfo")
public ModelAndView getOneMember(String id){
// 데이터베이스에 접근해서 데이터를 받아옴
MemberBean mbean = memberDao.getOneMember(id);
return new ModelAndView("MemberInfoView", "mbean", mbean);
}
}
- /src/controller/MemberUpdate.java 소스 (Update 문)
package controller;
import member.MemberDao;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.view.RedirectView;
public class MemberUpdate {
MemberDao memberDao;
// 데이터베이스 객체를 사용할 수 있도록 설정
public void setMemberDao(MemberDao memberDao){
this.memberDao = memberDao;
}
@RequestMapping("/MemberUpdate")
public ModelAndView updateMember(String updateid, String address, String email){
// 데이터베이스에 접근해서 데이터를 받아옴
memberDao.updateMember(updateid, address, email);
// model과 view를 동시에 지정 가능한 객체 선언
ModelAndView mav = new ModelAndView();
// 컨트롤러에서 컨트롤러를 호출
mav.setView(new RedirectView("MemberList.do"));
return mav; // bean 클래스에 선언한 ViewResolver 클래스를 호출
}
}
- /src/controller/MemberDelete.java 소스 (Delete 문)
package controller;
import member.MemberDao;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.view.RedirectView;
public class MemberDelete {
MemberDao memberDao;
// 데이터베이스 객체를 사용할 수 있도록 설정
public void setMemberDao(MemberDao memberDao){
this.memberDao = memberDao;
}
@RequestMapping("/MemberDelete")
public ModelAndView deleteMember(String id){
// 데이터베이스에 접근해서 데이터를 받아옴
memberDao.deleteMember(id);
// model과 view를 동시에 지정 가능한 객체 선언
ModelAndView mav = new ModelAndView();
// 컨트롤러에서 컨트롤러를 호출
mav.setView(new RedirectView("MemberList.do"));
return mav; // bean 클래스에 선언한 ViewResolver 클래스를 호출
}
}
- 결과
