bookshop_dao.java

来自「这是一个Struts网上商城(图书)的管理系统源代码.」· Java 代码 · 共 56 行

package com.bookshop.dao;

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

import com.bookshop.db.DBConnection;
import com.bookshop.dto.bookinfo_dto;
import com.bookshop.dto.bookshop_dto;
//购物车
public class bookshop_dao {
//向购物车里添加商品
	public bookshop_dto book_add(String isbn)
	{
	Connection conn =null;
	conn=DBConnection.getConnection();
	Statement st = null;
	ResultSet rs = null;
	String strSQL=null;
	bookshop_dto dto=new bookshop_dto();
	try {
		st = conn.createStatement();
		strSQL="SELECT * FROM tb_bookinfo where isbn='"+isbn+"'";
		rs = st.executeQuery(strSQL);
		System.out.print(strSQL);
		if(rs.next()) {
			
			dto.setIsbn(rs.getString("isbn"));
			dto.setBookname(rs.getString("bookname"));
			dto.setPrice(Float.parseFloat(rs.getString("price")));
			dto.setNumber(Integer.parseInt(rs.getString("number")));
			dto.setAmount(Float.parseFloat(rs.getString("amount")));
		}
	} catch (SQLException e) {
		e.printStackTrace();
		System.out.print(strSQL);
	}
	finally
	{
	 try {
	        rs.close();
	        st.close();
	        conn.close();
	    } catch (SQLException ex1) {
	        ex1.printStackTrace();
	    }    	
    }				
	return dto;
}
	
	
	

}