백엔드/웹개발
[이클립스/웹개발] DataSource 이용해 회원 정보 등록/삭제하기 (커넥션풀)
김곰댕
2022. 2. 22. 17:21
728x90
1. 패키지 생성
2. 이전 글에서 작성하였던 MemberDAO, MemberServlet, MemberVO 를 생성한 패키지에 붙여넣는다.
https://kimgom2.tistory.com/274
[이클립스/웹개발] 이클립스에서 톰캣 DataSource 설정 (커넥션풀)
톰캣에서 ConnectionPool 기능을 사용하려면 이 기능을 제공하는 DBCP 라이브러리를 따로 내려 받아야 한다. 이 라이브러리 파일은 jar 압축 형태로 제공되며, 아래의 링크에서 다운받으면 된다. http://
kimgom2.tistory.com
해당 글을 참고하면 된다.
3. 해당 경로에 memberForm.html파일 생성
4. 생성한 HTML파일에 아래와 같은 내용 입력
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>회원 가입창</title>
<script type="text/javascript">
function fn_sendMember()
{
var frmMember=document.frmMember;
var id=frmMember.id.value;
var pwd=frmMember.pwd.value;
var name=frmMember.name.value;
var email=frmMember.email.value;
if(id.length==0 ||id=="")
{
alert("아이디는 필수입니다.");
}
else if(pwd.length==0 ||pwd=="")
{
alert("비밀번호는 필수입니다.");
}
else if(name.length==0 ||name=="")
{
alert("이름은 필수입니다.");
}
else if(email.length==0 ||email=="")
{
alert("이메일은 필수입니다.");
}
else
{
frmMember.method="post";
frmMember.action="member4";
frmMember.submit();
}
}
</script>
</head>
<body>
<form name="frmMember">
<table>
<th>회원 가입창</th>
<tr>
<td>아이디</td>
<td><input type="text" name="id"></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type="password" name="pwd"></td>
</tr>
<tr>
<td>이름</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>이메일</td>
<td><input type="text" name="email"></td>
</tr>
</table>
<input type="button" value="가입하기" onclick="fn_sendMember()">
<input type="reset" value="다시입력">
<input type="hidden" name="command" value="addMember" />
</form>
</body>
</html>5. 복사해놓은 MemberServlet을 아래와 같은 내용으로 변경
package sec02.ex02;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Date;
import java.util.List;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
@WebServlet("/member4")
public class MemberServlet extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doHandle(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doHandle(request, response);
}
private void doHandle(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
MemberDAO dao=new MemberDAO();
PrintWriter out=response.getWriter();
String command=request.getParameter("command");
if(command!= null && command.equals("addMember")){
String _id=request.getParameter("id");
String _pwd=request.getParameter("pwd");
String _name=request.getParameter("name");
String _email=request.getParameter("email");
MemberVO vo=new MemberVO();
vo.setId(_id);
vo.setPwd(_pwd);
vo.setName(_name);
vo.setEmail(_email);
dao.addMember(vo);
}
else if(command!= null && command.equals("delMember"))
{
String id = request.getParameter("id");
dao.delMember(id);
}
List list=dao.listMembers();
out.print("<html><body>");
out.print("<table border=1><tr align='center' bgcolor='lightgreen'>");
out.print("<td>아이디</td><td>비밀번호</td><td>이름</td><td>이메일</td><td>가입일</td><td >삭제</td></tr>");
for (int i=0; i<list.size();i++)
{
MemberVO memberVO=(MemberVO) list.get(i);
String id=memberVO.getId();
String pwd = memberVO.getPwd();
String name = memberVO.getName();
String email =memberVO.getEmail();
Date joinDate = memberVO.getJoinDate();
out.print("<tr><td>"+id+"</td><td>"+pwd+"</td><td>"+name+"</td><td>"+email+"</td><td>"+joinDate+"</td><td>"+"<a href='/pro07/member4?command=delMember&id="+id+"'>삭제 </a></td></tr>");
}
out.print("</table></body></html>");
out.print("<a href='/pro07/memberForm.html'>새 회원 등록하기</a");
}
}6. 복사해놓은 MemberDAO의 내용을 다음과 같이 변경
package sec02.ex02;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class MemberDAO {
/*
private static final String driver = "oracle.jdbc.driver.OracleDriver"; //ojdbc6를 사용
private static final String url = "jdbc:oracle:thin:@localhost:1521:XE";
private static final String user = "scott"; //사용자
private static final String pwd = "tiger"; //비밀번호
*/
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<MemberVO> listMembers() {
List<MemberVO> list = new ArrayList<MemberVO>();
try {
//connDB();
con = dataFactory.getConnection();
String query = "select * from t_member ";
System.out.println("prepareStatememt: " + query);
pstmt = con.prepareStatement(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);
list.add(vo);
}
rs.close();
pstmt.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
public void addMember(MemberVO memberVO) {
try {
con = dataFactory.getConnection();
String id = memberVO.getId();
String pwd = memberVO.getPwd();
String name = memberVO.getName();
String email = memberVO.getEmail();
String query = "insert into t_member";
query += " (id,pwd,name,email)";
query += " values(?,?,?,?)";
System.out.println("prepareStatememt: " + query);
pstmt = con.prepareStatement(query);
pstmt.setString(1, id);
pstmt.setString(2, pwd);
pstmt.setString(3, name);
pstmt.setString(4, email);
pstmt.executeUpdate();
pstmt.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public void delMember(String id) {
try {
con = dataFactory.getConnection();
String query = "delete from t_member" + " where id=?";
System.out.println("prepareStatememt:" + query);
pstmt = con.prepareStatement(query);
pstmt.setString(1, id);
pstmt.executeUpdate();
pstmt.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}7. 홈페이지 주소창에 IP주소:포트번호/프로젝트이름/html파일이름 작성 후 엔터
회원가입창 아래에 내용 입력 후 가입하기 클릭
8. 다음과 같이 회원정보가 추가된것을 확인 할 수 있다.
9. 차범근을 삭제하면 아래와 같은 결과가 나온다.
728x90