financedao.java

来自「仓库管理系统,适合各种行业的仓库管理系统」· Java 代码 · 共 47 行

package com.bean.DAO;

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

import com.bean.DTO.CheckProductDTO;

public class FinanceDAO {
	private final String CHECK="select s.productID, pr.inputtime, pr.amount, s.realprice,s.budgetprice,s.projectID, p.productname " +
			                  "from stock s,productregister pr, product p" +
			                  " where p.productID=s.productID and s.realamount=pr.amount and s.projectID=?";
 
	private Connection con;
	private ResultSet rs;

public FinanceDAO(Connection con) {
	
	this.con = con;
}
 
public CheckProductDTO checkInformation(int projectID){
	CheckProductDTO dto=null;
	try {
		PreparedStatement ps=con.prepareStatement(CHECK);
		ps.setInt(1,projectID);
		rs=ps.executeQuery();
		if(rs.next()){
			dto=new CheckProductDTO();
			dto.setProductID(rs.getInt(1));
			dto.setInputtime(rs.getString(2));
			dto.setAmount(rs.getInt(3));
			dto.setRealprice(rs.getFloat(4));
			dto.setBudgetprice(rs.getFloat(5));
			dto.setProjectID(rs.getInt(6));
			dto.setProductname(rs.getString(7));
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	
	return dto;
}
}