leavebo.java

一个毕业设计网络招标系统实现了招标的业务逻辑内含了数据库sql server备份文件

package com.BO;

import java.sql.ResultSet;
import java.util.ArrayList;

import com.VO.leaveVO;

import C03.CDB.dataBase;

public class leaveBO {
	dataBase db;

	public leaveBO() {
		db = new dataBase();
	}

	public ArrayList shrowLeave() {
		ArrayList list = new ArrayList();
		String sql = "select * from leave";
		ResultSet rs = db.sqlFind(sql);
		try {
			while (rs.next()) {
				String leave_id = rs.getString(1);
				String User_Name = rs.getString(2);
				String leave_date = rs.getString(3);
				String leave_content = rs.getString(4);
				leaveVO vo = new leaveVO();
				vo.setLeave_id(leave_id);
				vo.setUser_Name(User_Name);
				vo.setLeave_date(leave_date);
				vo.setLeave_content(leave_content);
				list.add(vo);
			}

		} catch (Exception e) {
			System.out.println("shrowleave Error!!" + e.getMessage());
		}
		return list;
	}

	public boolean delLeave(String leave_id) {
		String sql = "delete leave where leave_id='" + leave_id + "'";
		db.sqlUpdata(sql);
		return true;
	}
}