Be a groovy man by positive thinking

JSP_04_DB연동, MemberDAO 이용 본문

IT/JSP

JSP_04_DB연동, MemberDAO 이용

KhanSelf 2017. 7. 13. 12:34




미리 생성해놓아야할 자바파일들






ConnUtil.java

=============

package kr.co.study.common.util;


import java.sql.SQLException;

import java.sql.Connection;


import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.sql.DataSource;


public class ConnUtil {

public static Connection getConnection() throws SQLException, NamingException, ClassNotFoundException {

Context initCtx = new InitialContext();

Context envCtx = (Context) initCtx.lookup("java:comp/env");

DataSource ds = (DataSource) envCtx.lookup("jdbc/myoracle");

Connection conn = ds.getConnection();

return conn;

}

}




MemberBean.java

===============

package kr.co.study.member.model;


public class MemberBean {

private String id, pw, addr, tel;


public void setId(String id) {

this.id = id;

}


public void setPw(String pw) {

this.pw = pw;

}


public void setAddr(String addr) {

this.addr = addr;

}


public void setTel(String tel) {

this.tel = tel;

}


public String getId() {

return id;

}


public String getPw() {

return pw;

}


public String getAddr() {

return addr;

}


public String getTel() {

return tel;

}

}





MemberDAO.java

==============

package kr.co.study.member.model;


import java.sql.*;

import java.util.*;

import kr.co.study.common.util.ConnUtil;


public class MemberDAO {

private static MemberDAO instance;


private MemberDAO() {

}


public static MemberDAO getInstance() {

if (instance == null)

instance = new MemberDAO();

return instance;

}


public ArrayList<MemberBean> selectMemberBeanList(int sr, int er) {

ArrayList<MemberBean> v = new ArrayList<MemberBean>();

Connection con = null;

PreparedStatement pstmt = null;

try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from ");

selectQuery.append("(select rownum as rn, id from ");

selectQuery.append("(select rownum , id from MemberBean order by id) ) t1 ");

selectQuery.append("where t1.rn between ? and ?");

con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());

pstmt.setInt(1, sr);

pstmt.setInt(2, er);

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

MemberBean MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));

v.add(MemberBean);

}

return v;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

pstmt.close();

con.close();

pstmt = null;

con = null;

} catch (Exception e) {

}

}

}


}













예문



Ex_01

http://localhost:포트번호/프로젝트명/a.jsp 전송버튼을 누르면 url이 아래와 같이 나타날 수 있도록 소스코드를 작성하시오

http://localhost:포트번호/프로젝트명/b.jsp?pet=dog&pet=cat


좋아하는 동물 : dog, cat


 


Sol_01

a.jsp

============

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<form action="b.jsp">

<input type="checkbox" id="cat" name="pet" value="cat">고양이

<input type="checkbox" id="dog" name="pet" value="dog">개

<input type="submit">

</form>

</body>

</html>



b.jsp

============


<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<%

String[] pet=request.getParameterValues("pet");

out.print("좋아하는 동물 : ");

for(String s:pet){

out.print(s+"  ");

}

%>

</body>

</html>










Ex_02 http://localhost:포트번호/프로젝트명/a.jsp 

<%

String[] ar={"aa","bb","cc"};

here

%>


응답된 화면에서 소스보기를 했을 떄의 소스코드

<a href="b.jsp?id=aa">aa</a><br>

<a href="b.jsp?id=bb">bb</a><br>

<a href="b.jsp?id=cc">cc</a><br>



Sol_02

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<form action="b.jsp">

<%

String[] ar = { "aa", "bb", "cc" };

for(String s : ar){

out.println("<a href=b.jsp?id="+s+">"+s+"</a><br>");

}

%>

</form>

</body>

</html>










Ex_03 http://localhost:포트번호/프로젝트명/a.jsp 했을때 member 테이블의 id를 전부 가져오시오

<% 

db연동해서

회원 id를 출력

for(String s : ar){

out.println("<a href=b.jsp?id="+s+">"+s+"</a><br>");

}

%>

Sol_03

a.jsp

===============================

<%@page import="kr.co.study.common.util.ConnUtil"%>

<%@page import="java.sql.ResultSet"%>

<%@page import="java.sql.PreparedStatement"%>

<%@page import="java.sql.Connection"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<%

Connection conn = null;

PreparedStatement allStmt = null;

ResultSet rs = null;

try {

conn = ConnUtil.getConnection();

String all = "select * from member";

allStmt = conn.prepareStatement(all);

rs = allStmt.executeQuery();


while (rs.next()) {

String id = rs.getString("id");

out.println("<a href=b.jsp?id=" + id + ">");

out.println(id);

out.println("</a><br/>");

}


} finally {

if (rs != null) {

rs.close();

rs = null;

}

if (allStmt != null) {

allStmt.close();

allStmt = null;

}

if (conn != null) {

conn.close();

conn = null;

}

}

%>

</body>

</html>











Ex_04 here부분을 완성하여 http://localhost:포트번호/프로젝트명/a.jsp를 하면 id 값들이 모두 출력되도록 하시오

MemberDAO.java를 다음과 같이 수정(기존소스에서 selectMemberBeanList() 메서드 추가)

=====================

package kr.co.study.member.model;


import java.sql.*;

import java.util.*;

import kr.co.study.common.util.ConnUtil;


public class MemberDAO {

private static MemberDAO instance;


private MemberDAO() {

}


public static MemberDAO getInstance() {

if (instance == null)

instance = new MemberDAO();

return instance;

}


public ArrayList<MemberBean> selectMemberBeanList(int sr, int er) {

ArrayList<MemberBean> v = new ArrayList<MemberBean>();

Connection con = null;

PreparedStatement pstmt = null;

try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from ");

selectQuery.append("(select rownum as rn, id from ");

selectQuery.append("(select rownum , id from MemberBean order by id) ) t1 ");

selectQuery.append("where t1.rn between ? and ?");

con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());

pstmt.setInt(1, sr);

pstmt.setInt(2, er);

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

MemberBean MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));

v.add(MemberBean);

}

return v;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

pstmt.close();

con.close();

pstmt = null;

con = null;

} catch (Exception e) {

}

}

}


public ArrayList<MemberBean> selectMemberBeanList() {

ArrayList<MemberBean> v = new ArrayList<MemberBean>();

Connection con = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from member");


con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());


rs = pstmt.executeQuery();

while (rs.next()) {

MemberBean MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));

v.add(MemberBean);

}

return v;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

if (rs != null) {

rs.close();

rs = null;

}

if (pstmt != null) {

pstmt.close();

pstmt = null;

}

if (con != null) {

con.close();

con = null;

}

} catch (Exception e) {

}

}

}

}




a.jsp

==========

<%@page import="kr.co.study.member.model.MemberBean"%>

<%@page import="java.util.ArrayList"%>

<%@page import="kr.co.study.member.model.MemberDAO"%>


<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<%

ArrayList<MemberBean> list = MemberDAO.getInstance().selectMemberBeanList();

for (MemberBean bean : list) {

//here

}

%>

</body>

</html>



Sol_04

a.jsp

==========

<%@page import="kr.co.study.member.model.MemberBean"%>

<%@page import="java.util.ArrayList"%>

<%@page import="kr.co.study.member.model.MemberDAO"%>


<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<%

ArrayList<MemberBean> list = MemberDAO.getInstance().selectMemberBeanList();

for (MemberBean bean : list) {

out.println(bean.getId() + "<br/>");

}

%>

</body>

</html>





Ex_05 회원정보 출력하기 

here부분을 완성하여 http://localhost:포트번호/프로젝트명/a.jsp?id=id1이라고 하면

회원의 비번, 전화번호 주소까지 나오게 MemberDAO.java에 소스를 추가하시오


MemberDAO.java

=================

package kr.co.study.member.model;


import java.sql.*;

import java.util.*;

import kr.co.study.common.util.ConnUtil;


public class MemberDAO {

private static MemberDAO instance;


private MemberDAO() {

}


public static MemberDAO getInstance() {

if (instance == null)

instance = new MemberDAO();

return instance;

}


public ArrayList<MemberBean> selectMemberBeanList(int sr, int er) {

ArrayList<MemberBean> v = new ArrayList<MemberBean>();

Connection con = null;

PreparedStatement pstmt = null;

try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from ");

selectQuery.append("(select rownum as rn, id from ");

selectQuery.append("(select rownum , id from MemberBean order by id) ) t1 ");

selectQuery.append("where t1.rn between ? and ?");

con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());

pstmt.setInt(1, sr);

pstmt.setInt(2, er);

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

MemberBean MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));

v.add(MemberBean);

}

return v;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

pstmt.close();

con.close();

pstmt = null;

con = null;

} catch (Exception e) {

}

}

}


public ArrayList<MemberBean> selectMemberBeanList() {

ArrayList<MemberBean> v = new ArrayList<MemberBean>();

Connection con = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from member");


con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());


rs = pstmt.executeQuery();

while (rs.next()) {

MemberBean MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));

v.add(MemberBean);

}

return v;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

if (rs != null) {

rs.close();

rs = null;

}

if (pstmt != null) {

pstmt.close();

pstmt = null;

}

if (con != null) {

con.close();

con = null;

}

} catch (Exception e) {

}

}

}


//here


}




Sol_05

MemberDAO.java

================

public MemberBean selectMemberBean(String id) {


Connection con = null;

PreparedStatement pstmt = null;


try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from member where id=?");

con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());

pstmt.setString(1, id);

ResultSet rs = pstmt.executeQuery();

MemberBean MemberBean = null; /* 없으면 null */

if (rs.next()) {

MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));


}

return MemberBean;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

pstmt.close();

con.close();

pstmt = null;

con = null;

} catch (Exception e) {

}

}

}



a.jsp

=====================

<%@page import="kr.co.study.member.model.MemberBean"%>

<%@page import="java.util.ArrayList"%>

<%@page import="kr.co.study.member.model.MemberDAO"%>


<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<%

String id = request.getParameter("id");

MemberBean member = MemberDAO.getInstance().selectMemberBean(id);

out.println("비번 :" + member.getPw() + "<br/>");

out.println("주소 :" + member.getAddr() + "<br/>");

out.println("전번 :" + member.getTel() + "<br/>");

%>

</body>

</html>






Ex_06 id1에 대한 비번 전화번호 주소가 나오게 소스를 작성하시오

# 회원정보출력하기

http://localhost:포트번호/프로젝트명/a.jsp?id=id1



Sol_06


a.jsp

=============

<%@page import="kr.co.study.member.model.MemberDAO"%>

<%@page import="kr.co.study.member.model.MemberBean"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<%

String id = request.getParameter("id");

MemberBean member = MemberDAO.getInstance().selectMemberBean(id);

out.println("비번 :" + member.getPw() + "<br/>");

out.println("주소 :" + member.getAddr() + "<br/>");

out.println("전번 :" + member.getTel() + "<br/>");

%>

</body>

</html>




MemberDAO.jsp

=================

package kr.co.study.member.model;


import java.sql.*;

import java.util.*;

import kr.co.study.common.util.ConnUtil;


public class MemberDAO {

private static MemberDAO instance;


private MemberDAO() {

}


public static MemberDAO getInstance() {

if (instance == null)

instance = new MemberDAO();

return instance;

}


public ArrayList<MemberBean> selectMemberBeanList(int sr, int er) {

ArrayList<MemberBean> v = new ArrayList<MemberBean>();

Connection con = null;

PreparedStatement pstmt = null;

try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from ");

selectQuery.append("(select rownum as rn, id from ");

selectQuery.append("(select rownum , id from MemberBean order by id) ) t1 ");

selectQuery.append("where t1.rn between ? and ?");

con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());

pstmt.setInt(1, sr);

pstmt.setInt(2, er);

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

MemberBean MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));

v.add(MemberBean);

}

return v;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

pstmt.close();

con.close();

pstmt = null;

con = null;

} catch (Exception e) {

}

}

}


public ArrayList<MemberBean> selectMemberBeanList() {

ArrayList<MemberBean> v = new ArrayList<MemberBean>();

Connection con = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from member");


con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());


rs = pstmt.executeQuery();

while (rs.next()) {

MemberBean MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));

v.add(MemberBean);

}

return v;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

if (rs != null) {

rs.close();

rs = null;

}

if (pstmt != null) {

pstmt.close();

pstmt = null;

}

if (con != null) {

con.close();

con = null;

}

} catch (Exception e) {

}

}

}


public MemberBean selectMemberBean(String id) {


Connection con = null;

PreparedStatement pstmt = null;


try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from member where id=?");

con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());

pstmt.setString(1, id);

ResultSet rs = pstmt.executeQuery();

MemberBean MemberBean = null; /* 없으면 null */

if (rs.next()) {

MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));


}

return MemberBean;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

pstmt.close();

con.close();

pstmt = null;

con = null;

} catch (Exception e) {

}

}

}


}







Ex_07 MemberDAO.java에 insertMemberBean메서드를 추가하고 b.jsp를 만들어 회원가입 폼을 완성 하시오

a.jsp

=============

<%@page import="kr.co.study.member.model.MemberDAO"%>

<%@page import="kr.co.study.member.model.MemberBean"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<form action="b.jsp">

ID : <input type="text" name="id"><br/>

PW : <input type="text" name="pw"><br/>

ADDR : <input type="text" name="addr"><br/>

TEL : <input type="text" name="tel"><br/>

<input type="submit" value="가입">

</form>

</body>

</html>





Sol_07

b.jsp

===========

<%@page import="kr.co.study.member.model.MemberDAO"%>

<%@page import="kr.co.study.member.model.MemberBean"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!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=UTF-8">

<title>Insert title here</title>

</head>

<body>

<%

MemberBean bean = new MemberBean();


bean.setId(request.getParameter("id"));


bean.setPw(request.getParameter("pw"));


bean.setAddr(request.getParameter("addr"));


bean.setTel(request.getParameter("tel"));


try {

out.println("가입성공~");

MemberDAO.getInstance().insertMemberBean(bean);


out.println("<a href=c.jsp>회원리스트</a>");


} catch (Exception e) {


out.println("가입실패~");


}

%>

</body>

</html>




MemberDAO.java

=============

package kr.co.study.member.model;


import java.sql.*;

import java.util.*;

import kr.co.study.common.util.ConnUtil;


public class MemberDAO {

private static MemberDAO instance;


private MemberDAO() {

}


public static MemberDAO getInstance() {

if (instance == null)

instance = new MemberDAO();

return instance;

}


public ArrayList<MemberBean> selectMemberBeanList(int sr, int er) {

ArrayList<MemberBean> v = new ArrayList<MemberBean>();

Connection con = null;

PreparedStatement pstmt = null;

try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from ");

selectQuery.append("(select rownum as rn, id from ");

selectQuery.append("(select rownum , id from MemberBean order by id) ) t1 ");

selectQuery.append("where t1.rn between ? and ?");

con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());

pstmt.setInt(1, sr);

pstmt.setInt(2, er);

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

MemberBean MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));

v.add(MemberBean);

}

return v;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

pstmt.close();

con.close();

pstmt = null;

con = null;

} catch (Exception e) {

}

}

}


public ArrayList<MemberBean> selectMemberBeanList() {

ArrayList<MemberBean> v = new ArrayList<MemberBean>();

Connection con = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from member");


con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());


rs = pstmt.executeQuery();

while (rs.next()) {

MemberBean MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));

v.add(MemberBean);

}

return v;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

if (rs != null) {

rs.close();

rs = null;

}

if (pstmt != null) {

pstmt.close();

pstmt = null;

}

if (con != null) {

con.close();

con = null;

}

} catch (Exception e) {

}

}

}


public MemberBean selectMemberBean(String id) {


Connection con = null;

PreparedStatement pstmt = null;


try {

StringBuffer selectQuery = new StringBuffer();

selectQuery.append("select * from member where id=?");

con = ConnUtil.getConnection();

pstmt = con.prepareStatement(selectQuery.toString());

pstmt.setString(1, id);

ResultSet rs = pstmt.executeQuery();

MemberBean MemberBean = null; /* 없으면 null */

if (rs.next()) {

MemberBean = new MemberBean();

MemberBean.setId(rs.getString("id"));

MemberBean.setPw(rs.getString("pw"));

MemberBean.setAddr(rs.getString("addr"));

MemberBean.setTel(rs.getString("tel"));


}

return MemberBean;

} catch (Exception sqle) {

throw new RuntimeException(sqle.getMessage());

} finally {

try {

pstmt.close();

con.close();

pstmt = null;

con = null;

} catch (Exception e) {

}

}

}


public void insertMemberBean(MemberBean bean) {


Connection con = null;


PreparedStatement pstmt = null;


try {


StringBuffer selectQuery = new StringBuffer();


selectQuery.append("insert into member values(?,?,?,?)");


con = ConnUtil.getConnection();


pstmt = con.prepareStatement(selectQuery.toString());


pstmt.setString(1, bean.getId());


pstmt.setString(2, bean.getPw());


pstmt.setString(3, bean.getAddr());


pstmt.setString(4, bean.getTel());


pstmt.executeUpdate();


} catch (Exception sqle) {


throw new RuntimeException(sqle.getMessage());


} finally {


try {


if (pstmt != null) {


pstmt.close();

pstmt = null;


}


if (con != null) {


con.close();

con = null;


}


} catch (Exception e) {

}


}


}

}






BeanUtil.java 

======================

package kr.co.study.common.util;


import java.lang.reflect.Method;

import java.util.Map;


import kr.co.study.member.model.MemberBean;


public class BeanUtil {


public static MemberBean toBean(Class<MemberBean> beanclass, Map<String, String[]> map) throws Exception {


MemberBean bean = beanclass.newInstance();


Method[] mArray = beanclass.getDeclaredMethods();


for (Method m : mArray) {


if (m.getName().startsWith("set")) {


String key = m.getName().substring(3).toLowerCase();


for (String value : map.get(key)) {


m.invoke(bean, value);


}


}


}

return bean;


}


}


저작자표시 (새창열림)

'IT > JSP' 카테고리의 다른 글

JSP_03_DB연동  (0) 2017.07.09
JSP_02_request객체들  (0) 2017.07.07
JSP_01_JSP시작  (0) 2017.07.06
'IT/JSP' Related Articles more