記錄

DAO, DTO, PreparedStatement, 커넥션 풀(DBCP) 본문

Web/JSP

DAO, DTO, PreparedStatement, 커넥션 풀(DBCP)

surhommejk 2018. 1. 19. 13:59







memberprint.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import="java.util.*"%>
<%@ page import="com.jk.memberDAO"%>
<%@ page import="com.jk.memberDTO"%>

<!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>Insert title here</title>
</head>
<body>

    <%
        memberDAO dao = new memberDAO();
        ArrayList<memberDTO> dataset = dao.memberselect();

        for (int i = 0; i < dataset.size(); i++) {
            memberDTO temp = dataset.get(i);
            String id = temp.getId();
            String pw = temp.getPw();
            String tel = temp.getTel();
            String region = temp.getRegion();

            out.println("이름: " + id + " 비밀번호: " + pw + " 전화번호: " + tel + " 지역: " + region + "</br>");

        }
    %>


</body>
</html>





memberDAO.java

package com.jk;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.*;

public class memberDAO {

    private String url = "jdbc:oracle:thin:@localhost:1521:xe";
    private String uid = "scott";
    private String upw = "tiger";
    Connection cn;
    Statement stm;
    ResultSet rs;

    public memberDAO() {

    }

    public ArrayList<memberDTO> memberselect() {

        ArrayList<memberDTO> dtos = new ArrayList<memberDTO>();

        try {

            Class.forName("oracle.jdbc.driver.OracleDriver");
            cn = DriverManager.getConnection(url, uid, upw);
            stm = cn.createStatement();
            rs = stm.executeQuery("select * from member");

            while (rs.next()) {

                String id = rs.getString("id");
                String pw = rs.getString("pw");
                String tel = rs.getString("tel");
                String region = rs.getString("region");

                memberDTO temp = new memberDTO(id, pw, tel, region);
                // 생성자 void 넣어서 에러나서 없앴음. 유의하라.
                dtos.add(temp);
                System.out.println(temp.toString());
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
        try {
            if (rs != null)
                rs.close();
            if (stm != null)
                stm.close();
            if (cn != null)
                cn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }

        return dtos;
    }

} // class end





memberDTO.java

package com.jk;

public class memberDTO {

    public String id;
    public String pw;
    public String tel;
    public String region;

    public memberDTO() {
        super();
    }

    public memberDTO(String id, String pw, String tel, String region) {
        super();
        this.id = id;
        this.pw = pw;
        this.tel = tel;
        this.region = region;

    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getPw() {
        return pw;
    }

    public void setPw(String pw) {
        this.pw = pw;
    }

    public String getTel() {
        return tel;
    }

    public void setTel(String tel) {
        this.tel = tel;
    }

    public String getRegion() {
        return region;
    }

    public void setRegion(String region) {
        this.region = region;
    }
} // class end












PreparedStatement 실습

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import="java.sql.*"%>
<!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>Insert title here</title>
</head>
<body>

    <%!String url = "jdbc:oracle:thin:@localhost:1521:xe";
    String uid = "scott";
    String upw = "tiger";

    Connection cn;
    PreparedStatement pstm;
    ResultSet rs;

    int n;
    String query = "insert into member (id, pw, tel, region) values(?,?,?,?)";%>
    
    <%
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            cn = DriverManager.getConnection(url, uid, upw);
            pstm = cn.prepareStatement(query);

            pstm.setString(1, "jkkim");
            pstm.setString(2, "789789");
            pstm.setString(3, "01000005555");
            pstm.setString(4, "seoul");
            n = pstm.executeUpdate();

        } catch (Exception e) {
            e.printStackTrace();
        }
    %>

</body>
</html>






저작자표시

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

파일 업로드, EL, JSTL  (0) 2018.01.22
회원 인증 프로그래밍  (0) 2018.01.22
oracle database -3  (0) 2018.01.17
oracle database -2 (JDBC 상세설명 포함)  (0) 2017.12.08
oracle database -1  (0) 2017.12.08
'Web/JSP' Related Articles more
Comments