business.java

海鲜超市管理系统是不个错的超市管理系统

/*
 * 创建日期 2006-10-27
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package bo;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.RequestDispatcher;

import util.PageControl;

import conn.DBConn;
import dto.IncoAndDept;
import dto.ShopUserDto;
import dto.VendorDto;
import dco.DBDco;

/**
 * @author www
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class Business 
{
	DBDco db = new DBDco();
	public int check(String userName, String passWord)
	{
		int flg = 0;
		
		flg = db.check(userName,passWord);
		return flg;
	}
	
	public List seleD()
	{

		List list = db.seleD();
		return list;
	}
	
	public int inseD(String dept_Id,String daliy_Income)
	{
			Connection co = null;
			PreparedStatement ps = null;
			ResultSet rs = null;
			int flg = 0;
			
			String sql = " SELECT * FROM TABLE_INCOME WHERE ? NOT IN(SELECT DEPT_ID FROM TABLE_INCOME WHERE TO_CHAR(Business_Date,'MM-DD-YYYY')=TO_CHAR(SYSDATE,'MM-DD-YYYY')) ";
				
			try
			{
				co = DBConn.getConn();
				ps = co.prepareStatement(sql);
				ps.setInt(1,Integer.parseInt(dept_Id));
				rs = ps.executeQuery();
				if (rs.next())
				{
					flg = db.inseD(dept_Id,daliy_Income);
				}				
			}
			catch (Exception e)
			{
				e.printStackTrace();
			}
			finally
			{
				try
				{
					rs.close();
					ps.close();
					co.close();
				}
				catch (Exception e1)
				{
					e1.printStackTrace();
				}
			}
			
		return flg;
	}
	
	public int updaD(String income_ID,String dept_Id,String daliy_Income)
	{

		int flg = db.updaD(income_ID,dept_Id,daliy_Income);
		return flg;
	}
	
	public int inseDe(String dept_Name,String dept_Descreption)
	{

		int flg = db.inseDe(dept_Name,dept_Descreption);
		return flg;
	}
	
	public int updaDe(String Dept_ID,String Dept_name,String Dept_desc)
	{

		int flg = db.updaDe(Dept_ID,Dept_name,Dept_desc);
		return flg;
	}
	
	public int inseV(VendorDto vd)
	{
		
		int flg = db.inseV(vd);
		return flg;
	}
	
	public int updaV(VendorDto vd)
	{
		int flg = db.updaV(vd);
		return flg;
	}
	
	public List seleV()
	{
		List list = db.seleV();
		return list;
	}
}