bookinfodao.java

网上书店 源代码和数据库网上书店 源代码和数据库

package com.shop.model.dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.DateFormat;
import java.util.ArrayList;
import java.util.List;

import com.shop.model.utils.DataBaseConn;
import com.shop.vo.BookInfoVo;

public class BookInfoDAO {

	public List<BookInfoVo> findBookVO(String condition) {
		Connection conn = null;
		Statement st = null;
		ResultSet rst=null;
		DateFormat df=DateFormat.getInstance();
		String select = "select * from BookInfo where "+condition;
		List<BookInfoVo> booklist=new ArrayList<BookInfoVo>();
		
		DataBaseConn dbconn = new DataBaseConn();
		conn = dbconn.getConnection();
		try {
			st = conn.createStatement();
			rst=st.executeQuery(select);
			while(rst.next()){
				BookInfoVo book=new BookInfoVo();
				book.setIsbn(rst.getString("ISBN"));
				book.setBookNum(rst.getString("BOOKNUM"));
				book.setAuthor(rst.getString("AUTHOR"));
				book.setPrintAddr(rst.getString("PRINTADDRESS"));
				book.setPrice(rst.getString(5));
				book.setPrintNum(rst.getInt(7));
				book.setPrintDate(rst.getDate(8));
				book.setRemainNum(rst.getInt(10));
				booklist.add(book);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(rst!=null){
				try {
					rst.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if(st!=null){
				try {
					st.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
		return booklist;
		
	}
	
	public BookInfoVo findBookByName(String iisbn) {
		Connection conn = null;
		Statement st = null;
		ResultSet rst=null;
		String select = "select * from BookInfo where ISBN='"+iisbn+"'";
		//List<BookInfoVo> booklist=new ArrayList<BookInfoVo>();
		BookInfoVo book=new BookInfoVo();
		DataBaseConn dbconn = new DataBaseConn();
		conn = dbconn.getConnection();
		try {
			st = conn.createStatement();
			rst=st.executeQuery(select);
			if(rst.next()){
				
				book.setIsbn(rst.getString("ISBN"));
				book.setBookNum(rst.getString("BOOKNUM"));
				book.setAuthor(rst.getString("AUTHOR"));
				book.setPrintAddr(rst.getString("PRINTADDRESS"));
				book.setPrice(rst.getString(5));
				book.setSellPrice(rst.getString(6));
				book.setPrintNum(rst.getInt(7));
				book.setPrintDate(rst.getDate(8));
				book.setRemainNum(rst.getInt(10));
				book.setDescrip(rst.getString(13));
				book.setBookType(rst.getString(14));
				//booklist.add(book);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(rst!=null){
				try {
					rst.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if(st!=null){
				try {
					st.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
		return book;
		
	}
}