addincomedao.java

cantain海鲜超市管理系统

package com.j1132.dao.income;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Date;

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

public class AddincomeDao extends AbstractDao implements Iaddincome {

	public boolean saveIncome(IncomeBean ib) {

		boolean b = true;

		long income_id = ib.getIncome_id();

		long dept_id = ib.getDept_id();

		int daily_income = ib.getDaily_income();

		Date business_date = ib.getBussiness_date();

		Date last_mod_time = ib.getLst_mod_timestemp();

		Connection conn = getConnection();

		String sql = "insert into income i(income_id,dept_id,daily_income,business_date,lst_mod_timestemp) values (?,?,?,?,?)";

		PreparedStatement ps = null;
		try {
			ps = conn.prepareStatement(sql);

			ps.setLong(1, income_id);

			ps.setLong(2, dept_id);

			ps.setInt(3, daily_income);

			ps.setDate(4, new java.sql.Date(business_date.getTime()));

			ps.setDate(5, new java.sql.Date(last_mod_time.getTime()));
			
			ps.executeUpdate();

		} catch (Exception e) {
			b = false;
			System.out.println("插入数据错误");
			e.printStackTrace();
		} finally {
			close(null, ps, conn);
		}
		return b;
	}

}