MemberDTO.java
package com.test.ex;
public class MemberDTO {
private String name;
private String id;
private String pw;
private String hp,hp2,hp3;
private String gender;
public MemberDTO(String name,String id,String pw,String hp,String hp2,String hp3,String gender){
this.name=name;
this.id=id;
this.pw=pw;
this.hp=hp;
this.hp2=hp2;
this.hp3=hp3;
this.gender=gender;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
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 getHp() {
return hp;
}
public void setHp(String hp) {
this.hp = hp;
}
public String getHp2() {
return hp2;
}
public void setHp2(String hp2) {
this.hp2 = hp2;
}
public String getHp3() {
return hp3;
}
public void setHp3(String hp3) {
this.hp3 = hp3;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
}
-----------------------------------------------------------------------------------------------------------------------------
MemberDAO.java
package com.test.ex;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
public class MemberDAO {
private String url="jdbc:oracle:thin:@localhost:1521:XE";
private String uid="scott";
private String upw="1234";
public MemberDAO(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(Exception e){
e.printStackTrace();
}finally{
}
}
public ArrayList<MemberDTO> selectMember(){
ArrayList<MemberDTO> mdtos = new ArrayList<MemberDTO>();
Connection dbconn = null;
Statement stmt= null;
ResultSet rs= null;
String sql="select * from member";
try{
dbconn=DriverManager.getConnection(url,uid,upw);
stmt=dbconn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
String name=rs.getString("name");
String id=rs.getString("id");
String pw=rs.getString("pw");
String hp=rs.getString("hp");
String hp2=rs.getString("hp2");
String hp3=rs.getString("hp3");
String gender=rs.getString("gender");
MemberDTO mdto = new MemberDTO(name,id,pw,hp,hp2,hp3,gender);
mdtos.add(mdto);
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(dbconn!=null) dbconn.close();
}catch(Exception e){}
}
return mdtos;
}
} //MemberDAO
'기존카테고리 > JSP' 카테고리의 다른 글
| [회원가입] 싱글톤 패턴 방식 - 회원입력, ID중복검사 (0) | 2017.06.08 |
|---|---|
| 커넥션 풀 설정 방법 (0) | 2017.06.07 |
| 회원정보 수정 및 로그아웃 (0) | 2017.06.07 |
| 로그인 입력, 처리페이지 (0) | 2017.06.07 |
| [회원가입] 회원가입 폼, 입력 (0) | 2017.06.07 |