departmentoperate.java

完整的合同管理信息系统

package com.ICT.AFC.user.beans;

import com.ICT.AFC.DB.DB;
import java.sql.ResultSet;
import com.ICT.AFC.util.*;
import java.sql.Date;
import java.util.ArrayList;
import com.ICT.AFC.DB.DB;
import com.ICT.AFC.user.beans.Department;
import com.ICT.AFC.user.actions.modifyDepartmentAction;
import com.ICT.AFC.user.forms.DepartmentForm;
import javax.servlet.http.HttpServletRequest;
import java.util.Vector;

/**
 * <p>Title:部门类相关操作 </p>
 * <p>Description:部门类相关操作，包括部门插入、修改、删除。 </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: 电子所AFC事业部</p>
 * @author 朱韦桥
 * @version 1.0
 */

public class DepartmentOperate {
  public DepartmentOperate() {
  }

  /**
   * 添加新部门信息方法
   * @param db DB
   * @param department Department
   * @throws Exception
   * @return boolean
   */
  public static boolean addDepartment(DB db, Department department) throws
      Exception {
    String conditions;
    conditions = "select seq_department.nextval from dual";
    ResultSet rs = db.OpenSql(conditions);
    rs.next();
    int departmentId = rs.getInt(1); //提取id

    //从参数department对象中提取部门属性
    String departmentName = department.getDepartmentName();
    String departmentTel = department.getDepartmentTel();
    String departmentRemark = department.getDepartmentRemark();

    //合同属性提取结束
    String sqlstr =
        "INSERT INTO CONFIG_DEPARTMENT(DEPID,DEPNAME,DEPTEL,DEPREMARK)values("
        + departmentId + ",'"
        + departmentName + "','"
        + departmentTel + "','"
        + departmentRemark + "')";
    System.out.println(departmentTel);
    System.out.println("addsql=" + sqlstr);
    //部门信息插入成功返回true，插入失败返回false。
    if (db.ExecSql(sqlstr) == 0) {
      return false;
    }
    else {
      return true;
    }
  }

  /**
   * 查找所有部门信息
   * @param db DB
   * @param departmentid int
   * @throws Exception
   * @return Contract
   */
  public static Department searchDepartment(DB db, int departmentId) throws
      Exception {
    String strSql = null;
    if (departmentId == 0) {

      strSql = "select * from CONFIG_DEPARTMENT ";
    }
    else {

      strSql = "select * from CONFIG_DEPARTMENT where DEPID=" + departmentId;
      System.out.println("strSql=" + strSql);
    }
    ResultSet rs = db.OpenSql(strSql);
    Department department = new Department();
    if (rs.next()) {
      department.setDepartmentId(Integer.parseInt(rs.getString("DEPID")));
      department.setDepartmentName(rs.getString("DEPNAME"));
      department.setDepartmentTel(rs.getString("DEPTEL"));
      department.setDepartmentRemark(rs.getString("DEPREMARK"));
    }

    return department;
  }

  /**
   * 删除指定部门信息
   * @param db DB
   * @param departmentid int
   * @throws Exception
   * @return Department
   */

  public static boolean deleteDepartment(DB db, int departmentId) throws
      Exception {
    String strSql = null;

    strSql = "delete from CONFIG_DEPARTMENT where DEPID=" + departmentId;
    System.out.println("strSql=" + strSql);

    if (db.ExecSql(strSql) == 0) {
      System.out.println("order false");
      return false;

    }
    else {
      System.out.println("order true");
      return true;
    }

  }

  /**
   * 查找所有部门信息
   * @param db DB
   * @param
   * @throws Exception
   * @return ArrayList
   */
  public static ArrayList searchAllDepartment(DB db) throws
      Exception {
    ArrayList AllDepartment = new ArrayList();
    String strSql = null;
    strSql = "select * from CONFIG_DEPARTMENT ";
    ResultSet rs1 = db.OpenSql(strSql);

    while (rs1.next()) {
      Department department = new Department();
      department.setDepartmentId(Integer.parseInt(rs1.getString("DEPID")));
      department.setDepartmentName(rs1.getString("DEPNAME"));
      department.setDepartmentTel(rs1.getString("DEPTEL"));
      department.setDepartmentRemark(rs1.getString("DEPREMARK"));

      AllDepartment.add(department);
    }
    return AllDepartment;
  }

  /**
   * 修改部门信息
   * @param db DB
   * @throws Exception
   * @return ArrayList
   */

  public static boolean modifyDepartment(DB db, Department department,int departmentId) throws
      Exception {

 //   Department aDepartment = new Department();
    //从参数department对象中提取部门属性
   // int departmentId = aDepartment.getDepartmentId();


     String departmentName = department.getDepartmentName();
     String departmentTel = department.getDepartmentTel();
     String departmentRemark = department.getDepartmentRemark();


  /*  String temsql = "select * from CONFIG_DEPARTMENT where DEPID='"
        + departmentId + "'";

    db.OpenSql(temsql).next();
    // db.setInt(1, departmentId);
    db.setString(1, departmentName);
    db.setString(2, departmentTel);
    db.setString(3, departmentRemark);
*/
    //合同属性提取结束
    String sqlstr =
        "UPDATE CONFIG_DEPARTMENT SET DEPNAME='" + departmentName + "',DEPTEL='" +
        departmentTel + "',DEPREMARK='" + departmentRemark + " 'WHERE  DEPID = " +
        departmentId;

    System.out.println(departmentId);
    System.out.println("modifysql=" + sqlstr);
    //部门信息插入成功返回true，插入失败返回false。
    if (db.ExecSql(sqlstr) == 0) {
      return false;
    }
    else {
      return true;
    }
  }

  /**
   * 查找指定部门（供修改用）
   * @param db DB
   * @param departmetnid int
   * @throws Exception
   * @return Contract
   */
  public static Department searchDepartmentByDepartmentID(DB db,
      int departmentId) throws Exception {

    String exsql = null;
    boolean flag = false;
    String s = "□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
    Vector vector = new Vector();

    // 查询
    exsql = "SELECT * from CONFIG_DEPARTMENT where DEPID=" +
        departmentId;
    System.out.println("exsql=" + exsql);
      Department department = new Department();
    ResultSet rs = db.OpenSql(exsql);

    if (rs.next()) {
      department.setDepartmentId(Integer.parseInt(rs.getString("DEPID")));
      department.setDepartmentName(rs.getString("DEPNAME"));
      department.setDepartmentTel(rs.getString("DEPTEL"));
      department.setDepartmentRemark(rs.getString("DEPREMARK"));
    }
    return department;
  }

}