728x90
반응형
SMALL
📌폴더구성
📌 search.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>
<form method="post" action="member.jsp">
이름:<input type="text" name="name"><br>
<input type ="submit" value="조회하기">
</form>
</body>
</html>
📌member.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
import="java.util.*"
import="sec02.ex01.*"
pageEncoding="UTF-8"
%>
<!DOCTYPE html>
<html>
<head>
<style>
h1 {
text-align: center;
}
</style>
<meta charset="UTF-8">
<title>회원 정보 출력창</title>
</head>
<body>
<h1>회원 정보 출력</h1>
<%
request.setCharacterEncoding( "utf-8" );
String _name = request.getParameter("name");
MemberVO memberVO = new MemberVO();
memberVO.setName(_name);
MemberDAO dao=new MemberDAO();
List membersList=dao.listMembers(memberVO);
%>
<table border='1' width='800' align='center'>
<tr align='center' bgcolor='#FFFF66'>
<td>아이디</td>
<td>비밀번호</td>
<td>이름</td>
<td >이메일</td>
<td>가입일자</td>
</tr>
<%
for (int i=0; i < membersList.size(); i++){
MemberVO vo=(MemberVO) membersList.get(i);
String id=vo.getId();
String pwd=vo.getPwd();
String name=vo.getName();
String email=vo.getEmail();
Date joinDate=vo.getJoinDate();
%>
<tr align=center>
<td><%= id %></td>
<td><%= pwd %></td>
<td><%= name %></td>
<td><%= email %></td>
<td><%=joinDate %></td>
</tr>
<%
}
%>
</table>
</body>
</html>
📌 MemberDAO
package sec02.ex01;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class MemberDAO {
private Connection con;
private PreparedStatement pstmt;
private DataSource dataFactory;
public MemberDAO() {
try {
Context ctx = new InitialContext();
Context envContext = (Context) ctx.lookup("java:/comp/env");
dataFactory = (DataSource) envContext.lookup("jdbc/oracle");
} catch (Exception e) {
e.printStackTrace();
}
}
public List listMembers(MemberVO memberVO) {
List membersList = new ArrayList();
String _name=memberVO.getName();
try {
con = dataFactory.getConnection();
String query = "select * from t_member ";
if((_name!=null && _name.length()!=0)){
query+=" where name=?";
pstmt = con.prepareStatement(query);
pstmt.setString(1, _name);
}else {
pstmt = con.prepareStatement(query);
}
System.out.println("prepareStatememt: " + query);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String id = rs.getString("id");
String pwd = rs.getString("pwd");
String name = rs.getString("name");
String email = rs.getString("email");
Date joinDate = rs.getDate("joinDate");
MemberVO vo = new MemberVO();
vo.setId(id);
vo.setPwd(pwd);
vo.setName(name);
vo.setEmail(email);
vo.setJoinDate(joinDate);
membersList.add(vo);
}
rs.close();
pstmt.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
return membersList;
}
}
📌 MemberVO
package sec02.ex01;
import java.sql.Date;
public class MemberVO {
private String id;
private String pwd;
private String name;
private String email;
private Date joinDate;
public MemberVO() {
System.out.println("MemberVO ");
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public Date getJoinDate() {
return joinDate;
}
public void setJoinDate(Date joinDate) {
this.joinDate = joinDate;
}
}
📌 servers - context.xml
<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
--><!-- The contents of this file will be loaded for each web application --><Context>
<!-- Default set of monitored resources. If one of these changes, the -->
<!-- web application will be reloaded. -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<WatchedResource>WEB-INF/tomcat-web.xml</WatchedResource>
<WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>
<!-- Uncomment this to disable session persistence across Tomcat restarts -->
<!--
<Manager pathname="" />
-->
<Resource
name="jdbc/oracle"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:xe"
username="system"
password="1234"
maxActive="50"
maxWait="-1" />
</Context>
📌 결과값
728x90
반응형
LIST
'Servlet & JSP > Servlet & JSP 공부' 카테고리의 다른 글
| [자바웹을다루는기술] MVC패턴 (0) | 2022.02.23 |
|---|---|
| [자바웹을다루는기술] JSP 액션태그 (0) | 2022.02.17 |
| [자바웹을다루는기술] 내장 객체 기능 (0) | 2022.02.17 |
| [자바웹을다루는기술] 이미지 리스트 출력 예제 (0) | 2022.02.17 |
| [자바웹을다루는기술]JSP 스크립트 요소 (0) | 2022.02.17 |