public void insert(EmailVo vo) {
Connection connection = null;
PreparedStatement pstmt = null;
try {
// 1 driver load
Class.forName("oracle.jdbc.driver.OracleDriver");
// 2. db con
String dbUrl = "jdbc:oracle:thin:@localhost:1521:xe";
connection = DriverManager.getConnection(dbUrl, "webdb", "webdb");
// DriverManager.getConnection(dbUrl,"webdb","webdb");
// 3. statement ready
String sql = "insert into email_list values(email_list_no_seq.nextval,?,?,?)";
pstmt = connection.prepareStatement(sql);
// 4. binding
pstmt.setString(1, vo.getFirstName());
pstmt.setString(2, vo.getLastName());
pstmt.setString(3, vo.getEmail());
// 5. sql
pstmt.executeUpdate();
System.out.println("쿼리 insert 됨요");
pstmt.close();
connection.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("드라이버 로딩 실패");
} catch (SQLException ex) {
System.out.println("에러 - " + ex);
}
}
