getbookbyiddao.java

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

package com.shop.model.dao.addbook;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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


public class GetBookbyIDDAO {
	public BookInfoVo getBookbyID(String id) {
		BookInfoVo book=new BookInfoVo();
		
		Connection conn = null;
		Statement st = null;
		ResultSet rst=null;
		String select="select * from bookinfo where isbn='"+id+"'";

		DataBaseConn dataBaseConn = new DataBaseConn();
		conn = dataBaseConn.getConnection();
		try {
			st = conn.createStatement();
			rst=st.executeQuery(select);
			if(rst.next()){
			book.setIsbn(rst.getString(1));
			book.setBookName(rst.getString(2));
			book.setAuthor(rst.getString(3));
			book.setPrintAddr(rst.getString(4));
			book.setPrice(rst.getFloat(5));
			book.setSellPrice(rst.getFloat(6));
			book.setRemainNumber(String.valueOf(rst.getInt(10)));
			
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(st!=null){
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				
			}
			
			
		}
		return book;

	}
	

}