오류는 없는데 테이블 안에 저장이 되지 않습니다... 어느 부분이 잘못되었을까요.. ㅠ
쓰레드 생성되는 부분에
Connection connect=null;
Statement st = null;
ResultSet rset =null;
==============================
케이스 문 안에
PreparedStatement ps2 = null;
PreparedStatement ps3 = null;
StringBuffer sb2 = new StringBuffer();
StringBuffer sb3 = new StringBuffer();
//String memberId=null;
//String memberPw=null;
//String memberName=null;
//String phoneNumber=null;
try {
Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
connect = DriverManager.getConnection("jdbc:odbc:GorgeousDB","sa","3478");
sb2.setLength(0);
sb2.append("select * from memberTbl where memberId='taejin'"); <==멤버 테이블 안에 taejin 이라는 열을 불러오려고 할때
ps2 = connect.prepareStatement(sb2.toString()); 이렇게 쓰는것이 맞는지...
ps2.execute();
rset = ps2.getResultSet();
//ps2.close();
while(rset.next()) {
String memberId=rset.getString("memberId");
String memberPw=rset.getString("memberPw");
String memberName=rset.getString("memberName");
String phoneNumber=rset.getString("phoneNumber");
sb3.setLength(0);
sb3.append("INSERT INTO SaleTbl(memberId, phoneNumber, TItle, Product, eventS, evnetE, Detail, Picture, Latitude, Longitude) \n");
sb3.append("VALUES ( ?,?,?,?,?,?,?,?,?,?)");
ps3=connect.prepareStatement(sb3.toString());
ps3.setString(1,memberId);
ps3.setString(2,phoneNumber);
ps3.setString(3,saleNameText);
ps3.setString(4,saleProcText);
ps3.setString(5,eventStartText);
ps3.setString(6,eventEndText);
ps3.setString(7,saleDetailText);
ps3.setString(8,memberPw);
ps3.setString(9,memberName);
ps3.setString(10,phoneNumber);
ps3.execute();
}
} catch(SQLException se) {
System.out.println(se);
} catch(ClassNotFoundException ce) {
}finally {
try {
if(rset!=null)rset.close();
if(st!=null)st.close();
if(connect!=null)connect.close();
} catch(SQLException se) {}
}