mysql statementlist_PreparedStatement用法【mysql jdbc List<Book>】

packagecom.java1234.jdbc.chap05.sec02;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.util.ArrayList;importjava.util.List;importcom.java1234.jdbc.model.Book;importcom.java1234.jdbc.util.DbUtil;public classDemo1 {private static DbUtil dbUtil = newDbUtil();

//查找所有图书

private static void listBook() throwsException {

Connection con=dbUtil.getCon();

String sql= "select * from t_book";

PreparedStatement pstmt=con.prepareStatement(sql);

ResultSet rs=pstmt.executeQuery();while(rs.next()) {int id = rs.getInt(1);

String bookName= rs.getString(2);float price = rs.getFloat(3);

String author= rs.getString(4);int bookTypeId = rs.getInt(5);

System.out.println("图书编号" + id + "书名" + bookName + "价格"

+ price + "作者" + author + "图书类别编号" +bookTypeId);

System.out

.println("=======================================================================");

}

}private static void listBook2() throwsException {

Connection con=dbUtil.getCon();

String sql= "select * from t_book";

PreparedStatement pstmt=con.prepareStatement(sql);

ResultSet rs=pstmt.executeQuery();while(rs.next()) {int id = rs.getInt("id");

String bookName= rs.getString("bookName");float price = rs.getFloat("price");

String author= rs.getString("author");int bookTypeId = rs.getInt("bookTypeId");

System.out.println("图书编号" + id + "书名" + bookName + "价格"

+ price + "作者" + author + "图书类别编号" +bookTypeId);

System.out

.println("=======================================================================");

}

}

//获取所有图书，保存到 List 中private static List listBook3()throwsException{

List bookList=new ArrayList();

Connection con=dbUtil.getCon();

String sql= "select * from t_book";

PreparedStatement pstmt=con.prepareStatement(sql);

ResultSet rs=pstmt.executeQuery();while(rs.next()) {int id = rs.getInt("id");

String bookName= rs.getString("bookName");float price = rs.getFloat("price");

String author= rs.getString("author");int bookTypeId = rs.getInt("bookTypeId");

Book book=newBook(id, bookName, price, author, bookTypeId);

bookList.add(book);

}returnbookList;

}public static void main(String[] args) throwsException {//listBook();//listBook2();

List bookList=listBook3();for(Book book : bookList) {

System.out.println(book);

}

}

}