프로그래밍/자바20 BookDAOTest package jdbcExam; import java.util.List; public class BookDAOTest { public static void main(String[] args) {BookDAO dao = new BookDAO();//BookVO book = new BookVO();//book.setBookTitle("다이어터");//book.setPage(500);//book.setAuthor("네온비");//book.setContent("재밌당..");//System.out.println(dao.addBook(book));BookVO vo = dao.getBook(9);//System.out.println(vo.getAuthor());////System.out.println(vo);Lis.. 2016. 1. 14. BookDAO , BookVO BookVO package jdbcExam;public class BookVO {private int bookId;private String bookTitle;private int page;private String author;private String content;private String redDate;public int getBookId() {return bookId;}public void setBookId(int bookId) {this.bookId = bookId;}public String getBookTitle() {return bookTitle;}public void setBookTitle(String bookTitle) {this.bookTitle = bookTitle;}public i.. 2016. 1. 14. DBUtil 이용하기 Connection 을 얻오오고 close 할 수 있는 메소드를 가진 DBUtil package jdbcExam;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException; public class DBUtil {// 접속하는 메소드public static Connection getConnection() throws Exception{String url = "jdbc:oracle:thin:@127.0.0.1:1521:xe";String user = "smu";String password = "smu";ret.. 2016. 1. 14. BookDAO package jdbcExam; import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.SQLException; public class BookDAO {/* * */public int addBook(String bookTitle, int page, String author, String content){int insertCount = 0;Connection conn = null;PreparedStatement ps = null;try{//3. 드라이버로딩Class.forName("oracle.jdbc.driver.OracleDriver");//4.디비접속String ur.. 2016. 1. 14. 이전 1 2 3 4 5 다음