수다닷컴

과제로 bd연동을 해서 명함관리 프로그램을 만드는 겁니다....
NullpointException이 나와서 지금 진도를 못 나가고 있습니다..
초보라 에러 이유는 알겠는데... 해결방법을 모르겠습니다..

import java.io.*;
import java.sql.*;
public class Exchange_Card {
public static void main(String[] ar)throws IOException {
BufferedReader in = new BufferedReader(
new InputStreamReader(System.in));
Exchange e = new Exchange();
InsertMember im = new InsertMember();
UpdateMember um = new UpdateMember();
DeleteMember dm = new DeleteMember();
String str;
while(true){

System.out.println(################################################);
System.out.println( 명 함 초 기 화 면 );
System.out.println(################################################);
System.out.println();
System.out.print(이름 : );
String name = in.readLine();
System.out.print(전화 번호 : );
String tel = in.readLine();
System.out.print(이메일 : );
String email = in.readLine();
System.out.print(팩스 : );
String fax = in.readLine();
System.out.print(홈페이지 : );
String homepage = in.readLine();
System.out.print(회사명 : );
String company = in.readLine();
System.out.print(직책 : );
String position = in.readLine();
System.out.print(주소 : );
String add = in.readLine();

boolean bool = e.loginMember(name,tel,email,fax,homepage,company,position,add); ---NullPointException발생
if(bool){
System.out.println(이름 : + name);
System.out.println(전화번호 + tel);
System.out.println(이메일 + email);
System.out.println(팩스 + fax);
System.out.println(홈페이지 + homepage);
System.out.println(회사명 + company);
System.out.println(직책 + position);
System.out.println(주소 + add);
System.out.print(명함관리 [P(revious), N(ext), I(nsert), U(pdate), D(elete)]?);
str = in.readLine();
}

else{
System.out.println([현재, 입력된 내용이 없습니다!]);
System.out.print(명함관리 [P(revious), N(ext), I(nsert), U(pdate), D(elete)]?);
str = in.readLine();
}
if(str.equals(I) || str.equals(i)){
im.display();

if(str.equals(P) || str.equals(p)){ continue;}
else if(str.equals(N) || str.equals(n)){ um.display();}

}

else if(str.equals(U)|| str.equals(u)){
um.display();
if(str.equals(P) || str.equals(p)){ continue;}
else if(str.equals(N) || str.equals(n)){ dm.display();}

}

else if(str.equals(D) || str.equals(d)){
dm.display();
if(str.equals(P) || str.equals(p)){ continue;}
else if(str.equals(N) || str.equals(n)){
System.out.println(더이상 페이지가 없습니다.);}
}
else{
System.out.println(잘못 입력하셨습니다.);
}
}
} //method
} //classimport java.sql.*;
public class Exchange {
private Connection dc;
public Exchange(){
try{
Class.forName(oracle.jdbc.driver.OracleDriver);
}
catch(ClassNotFoundException ee){return;}
Connection conn = null;
String url = jdbc:oracle:thin:@192.168.1.3:9625:ora92;
String id = scott;
String pass = tiger;
try{
conn = DriverManager.getConnection(url,id,pass);
}
catch(SQLException ee){ }
}
//데이터가 있는지 확인위해..(로그인)
public boolean loginMember(String name, String tel, String email, String fax,
String homepage, String company, String position, String add){
String query =
select * form exchange_card where name = ? or tel = ? or email = ? or fax = ? or homepage = ? or conpany = ? or position = ? or addr = ? ;
try{
PreparedStatement pstmt = dc.prepareStatement(query); ---NullPointException발생
pstmt.setString(1,name);
pstmt.setString(2,tel);
pstmt.setString(3,email);
pstmt.setString(4,fax);
pstmt.setString(5,homepage);
pstmt.setString(6,company);
pstmt.setString(7,position);
pstmt.setString(8,add);
ResultSet rs = pstmt.executeQuery();
if(!rs.next()){
rs.close();
&nbsbsp;pstmt.close();
return false;
}
rs.close();
pstmt.close();
}catch(SQLException ee){}
return true;
}
//삭제를 위해
public boolean deleteMember(String name, String email){
String query =
delete form exchange_card where name =?, email = ?;;
try{
PreparedStatement pstmt = dc.prepareStatement(query);---NullPointException발생
pstmt.setString(1, name);
pstmt.setString(2, email);
pstmt.executeUpdate();
pstmt.close();
}catch(SQLException ee){
return false;
}
return true;
}
//입력을 위해서...
public boolean insertMember(String name,String tel,
String email,String fax,String homepage,String conpany,
String position,String addpost,String add ){
String query =
insert into exchange_card value(s_seq.NEXTVAL,?,?,?,?,?,?,?,?,?;
try{
PreparedStatement pstmt = dc.prepareStatement(query);---NullPointException발생
pstmt.setString(1,name);
pstmt.setString(2,tel);
pstmt.setString(3,email);
pstmt.setString(4,fax);
pstmt.setString(5,homepage);
pstmt.setString(6,conpany);
pstmt.setString(7,position);
pstmt.setString(8,addpost);
pstmt.setString(9,add);
pstmt.executeUpdate();
pstmt.close();
}catch(SQLException se){
System.out.println(데이터 입력 실패);
return false;
}
return true;
}
//수정을 위해서...
public boolean updateMember(String newname, String newtel,
String newemail,String newfax, String newhomepage, String newconpany,
String newposition, String newaddpost,String newadd, String name, String email){

String query =
update exchange_card set name = ?,tel = ?,email = ? +
fax = ?,homepage = ?,conpany = ?,position = ?,addpost = ? +
,addr =? where name =? and email = ?;
try{
PreparedStatement pstmt = dc.prepareStatement(query);---NullPointException발생
pstmt.setString(1,newname);
pstmt.setString(2,newtel);
pstmt.setString(3,newemail);
pstmt.setString(4,newfax);
pstmt.setString(5,newhomepage);
pstmt.setString(6,newconpany);
pstmt.setString(7,newposition);
pstmt.setString(8,newaddpost);
pstmt.setString(9,newadd);
pstmt.setString(10,name);
pstmt.setString(11,email);
pstmt.executeQuery();
pstmt.close();
}catch(SQLException ee){
System.err.println(정보 수정 실패);
return false;
}
return true;
}
}

===============insert ===================
import java.io.*;
import java.sql.*;
class InsertMember{
public void display() throws IOException{
BufferedReader in = new BufferedReader(
new InputStreamReader(System.in));
Exchange e = new Exchange();
System.out.print(이름은(*) [최대10자]?);
String name = in.readLine();
System.out.print(전화번호는(*) [최대20자]?);
String tel = in.readLine();
System.out.print(이메일은(*) [최대30자]?);
String email = in.readLine();
System.out.print(팩스는 [최대20자]?);
String fax = in.readLine();
System.out.print(홈페이지 [최대0자]?);
String homepage = in.readLine();
System.out.print(회사명은 [최대20자]?);
String conpany = in.readLine();
System.out.print(직책은 [최대10자]?);
String position = in.readLine();
System.out.print(우편번호 [최대7자]?);
String addpost = in.readLine();
System.out.print(주소 [최대50자]?);
String add = in.readLine();
System.out.print(위의 내용을 입력하시겠습니까?(y/n) );
String str = in.readLine();
if(str.equals(Y) || str.equals(y)){
boolean bool = e.insertMember(name,add,email,fax,
homepage,conpany,position,addpost,add);---NullPointException발생
System.out.println(데이터를 입력 합니다.);
if(bool){
System.out.println(데이터가 입력 되었습니다.);
}else{
System.out.println(데이터가 입력 되지않았습니다.);
}
return;
}
else if(str.equals(N) || str.equals(n)){
System.out.println(데이터가 입력 하지않았습니다.);
return;
}
}//method
}//class

===============update ===================
import java.io.*;
import java.sql.*;
class UpdateMember{
public void display() throws IOException{
BufferedReader in = new BufferedReader(
new InputStreamReader(System.in));
Exchange e = new Exchange();

System.out.print(이름 : );
String name = in.readLine();
System.out.print(새값 : );
String newname = in.readLine();
System.out.println();

System.out.print(전화전호 : );
String tel = in.readLine();
System.out.print(새값 : );
String newtel = in.readLine();
System.out.println();
System.out.print(이메일 : );
String email = in.readLine();
System.out.print(새값 : );
String newemail = in.readLine();
System.out.println();
System.out.print(팩스 : );
String fax = in.readLine();
System.out.print(새값 : );
String newfax = in.readLine();
System.out.println();

System.out.print(홈페이지 : );
String homepage = in.readLine();
System.out.print(새값 : );
String newhomepage = in.readLine();
System.out.println();

System.out.print(회사명 : );
String company = in.readLine();
System.out.print(새값 : );
String newcompany = in.readLine();
System.out.println();

System.out.print(직책 : );
String position = in.readLine();
System.out.print(새값 : );
String newposition = in.readLine();
System.out.println();

System.out.print(우편번호 : );
String addpost = in.readLine();
System.out.print(새값 : );
String newaddpost = in.readLine();
System.out.println();

System.out.print(주소 : );
String add = in.readLine();
System.out.print(새값 : );
String newadd = in.readLine();
System.out.println();
Systesp;System.out.print(위의 내용으로 수정 하시겠습니까?(y/n));
String str = in.readLine();
if(str.equals(Y) || str.equals(y)){
boolean bool = e.updateMember(newname,newtel,newemail,newfax,
newhomepage,newcompany,newposition,newaddpost,newadd,name,email);---NullPointException발생
System.out.println(데이터를 수정 합니다.);
if(bool){
System.out.println(데이터가 수정 되었습니다.);
}
else{
System.out.println(데이터가 수정되지 않았습니다.);
}
return;
}
else if(str.equals(N) || str.equals(n)){
System.out.println(데이터를 수정하지 않습니다.);
return;
}

}//method
}// class

=============== delete ===================

import java.io.*;
import java.sql.*;
class DeleteMember{
public void display()throws IOException{
BufferedReader in = new BufferedReader(
new InputStreamReader(System.in));
Exchange e = new Exchange();
String str;
System.out.print(정말 삭제를 하시겠습니까?(y/n));
str = in.readLine();
if(str.equals(Y) || str.equals(y)){
System.out.print(이름 :);
String name = in.readLine();
System.out.print(이메일 :);
String email = in.readLine();
boolean bool = e.deleteMember(name,email);---NullPointException발생
System.out.println(데이터를 삭제합니다.);
if(bool){
System.out.println(데이터가 삭제되었습니다.);
}else{
System.out.println(데이터가 삭제되지 않았습니다.);
}
return;
}
else if(str.equals(N) || str.equals(n)){
System.out.println(데이터를 삭제하지 않습니다.);
return;
}

}
}

신청하기