updatedao.java

cantain海鲜超市管理系统

package com.j1132.dao.income;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.List;

import com.j1132.bean.IncomeBean;
import com.j1132.dao.AbstractDao;

public class UpdateDao extends AbstractDao implements Iincome {

	public IncomeBean getIncomeById(long income_id) {
		// TODO Auto-generated method stub
		return null;
	}

	public List<IncomeBean> selectIncome() {
		// TODO Auto-generated method stub
		return null;
	}

	public boolean updateIncome(IncomeBean ib) {
		
		boolean b = true ;
		
        Connection conn = getConnection();
		
		String sql = "select i.*from income i where i.income_id =?";
		
		PreparedStatement ps = null;
		
		ResultSet rs =null;
	try {
				
		ps = conn.prepareStatement(sql);
		
		ps.setLong(1,ib.getIncome_id());
		
		rs = ps.executeQuery();
		
		while(rs.next()){
			
			long income_id1 = rs.getLong(1);
			
			long dept_id = rs.getLong(2);
			
			int daily_income = rs.getInt(3);
			
			Date bussiness_date = rs.getDate(4);
			
			Date lst_mod_timestemp = rs.getDate(5);
			
			String dept_name = rs.getString(6);
			
			ib.setIncome_id(income_id1);
			
			ib.setDept_id(dept_id);
			
			ib.setDaily_income(daily_income);
			
			ib.setBussiness_date(bussiness_date);
			
			ib.setLst_mod_timestemp(lst_mod_timestemp);
			
			ib.setDept_name(dept_name);
			
		} 
		}catch (Exception e) {
			System.out.println("数据库查询有误");
			e.printStackTrace();
			}finally{
				close(rs, ps, conn);
			}
	
		
		
		return b;
	}

}