<div id="innersidebar">
             <div id="sidebar-topimg"><!--工具条顶部图象--></div>
              <%=side_html%>
             <div id="sidebar-bottomimg"></div>
       </div>

<div id="centerbar"><!--#include file="centerbar.asp" --></div>

<controller contentType="text/html;charset=UTF-8" locale="true" processorClass="companypj.MyProRequestProcessor" />

import org.apache.struts.action.RequestProcessor;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.tiles.TilesRequestProcessor;

public class MyProRequestProcessor extends TilesRequestProcessor
{
protected boolean processPreprocess (HttpServletRequest request,
HttpServletResponse response)
{
try
{
request.setCharacterEncoding("UTF-8");
//other code
}
catch(Exception e){}
return true;
}
}

<message-resources parameter="ApplicationResources" />

<plug-in className="org.apache.struts.tiles.TilesPlugin">
    <set-property property="definitions-config" value="/WEB-INF/tiles-congfig.xml" />
    <set-property property="definition-parser-validate" value="true"/>
  </plug-in>
  <plug-in className="org.apache.struts.validator.ValidatorPlugIn">
    <set-property property="pathnames" value="/WEB-INF/validator-rules.xml,/WEB-INF/validation.xml" />
  </plug-in>

<%=companypj.OtherBean.getTime()%>
<img src="<%=companypj.OtherBean.bgPhoto()%>" alt="" >

import java.util.*;
import java.text.SimpleDateFormat;

public class OtherBean {
    public static String getTime() {

        Date now = new Date();
        SimpleDateFormat smpDateFormat =
                new SimpleDateFormat("yyyy-MM-dd");

        String buf = smpDateFormat.format(now);
        return buf;
    }

    public static String bgPhoto() {
        GregorianCalendar calendar = new GregorianCalendar();
        String bgcolor = "";
        String path1="img/time/1.gif";
        String path2="img/time/2.gif";
        int hour = calendar.get(Calendar.HOUR_OF_DAY)+8;
        if(hour>6&&hour<18)
        {
            bgcolor=path1;

            //return bgcolor;
        }
        else if(hour<=6)
        {
            bgcolor=path2;

            //return bgcolor;
        }
        else if(hour>=18)
        {
            bgcolor=path2;

            //return bgcolor;
        }
      System.out.println(hour);
      System.out.println(bgcolor);
      return bgcolor;
    }

    public static void main(String arg[]) {
        new OtherBean().bgPhoto();
    }
}

<html:link page="/link4_one_loaddown.do" paramId="id" paramName="ID"><bean:message key="lable.emp.read.open"/></html:link>

<action input="/link4_one_view.jsp" path="/link4_one_loaddown" parameter="link4_one_loaddown" type="companypj.LoadDownAction" validate="false" >
<forward name="link4_one_success" path="/link4_one_view.jsp">
</forward>

import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import java.util.Collection;
import javax.sql.*;
import org.apache.commons.logging.LogFactory;
import org.apache.commons.logging.Log;
import org.apache.struts.validator.DynaValidatorForm;
import java.io.*;

public class LoadDownAction extends Action {
    public ActionForward execute(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) {
       // DynaValidatorForm empDynForm = (DynaValidatorForm) form;
        javax.servlet.ServletOutputStream servletoutputstream = null;
        DataSource ds = getDataSource(request);
        Log log = LogFactory.getLog("A");
        String type = mapping.getParameter();
        if (type.equals("link4_one_loaddown")) {
            File f = null;
            FileInputStream fileinputstream = null;
            String downloadfilepath = "/WEB-INF/download/";//定义temp文件存在的目录
            String filename = "testDownload.txt";//文件名
            String path= request.getRealPath("/");//表示网站所在文件夹
            String filepathname = path + downloadfilepath;

            //写入文件完成
            EmployeeBean empbean = new EmployeeBean(ds);
            EmployeeVO emp = empbean.getEmployee(request.getParameter("id"));
            //读出文件开始
            try {
                f = new File(filepathname, filename);
                f.createNewFile();//创建文件
                LoadDownBean loadbean=new LoadDownBean();
                loadbean.writeFile(emp,f); //把人员信息和具体文件传入，写文件的具体过程

                //做读出过程
                fileinputstream = new FileInputStream(
                        filepathname+ filename);

                servletoutputstream = response.getOutputStream();
                response.reset();
                response.setHeader("Content-disposition",
                                   "attachment; filename=" + filename);
                response.setContentType("text/plain;charset=gb2312");
                int j = 0;
                int k = 0;
                byte abyte0[] = new byte[1024];
                while ((k = fileinputstream.read(abyte0)) != -1) {
                    j += k;
                    servletoutputstream.write(abyte0);
                }

            } catch (Exception ex) {
                ex.printStackTrace();
            } finally {
                //最后删除文件
                try {
                    servletoutputstream.close();
                    fileinputstream.close();
                    File f1 = new File(filepathname+filename);
                    if (f1.exists()) {
                        System.out.println("linnan");
                        f1.delete(); //删除File.txt文件
                    }
                } catch (Exception ex1) {
                    ex1.printStackTrace();
                }
            }
            //跳转回页完成，把原来信息再显示
            emp = empbean.getEmployee(request.getParameter("id"));
            request.setAttribute(Constants.EMP_KEY, emp);
            return mapping.findForward("link4_one_success");
        }
        return null;
    }
}

package companypj;

import org.apache.commons.logging.LogFactory;
import org.apache.commons.logging.Log;
import java.io.*;


public class LoadDownBean {
    Log log = LogFactory.getLog("A");



    public void writeFile(EmployeeVO emp, File f) {

            try {
                FileWriter fw = new FileWriter(f);
                BufferedWriter bw = new BufferedWriter(fw);
                byte[] line = new byte[128];
                bw.write("*****************************");
                bw.write("*****************************");
                bw.write("员工ID号："+emp.getId());
                bw.newLine(); //断行
                //bw.write("\r\n");
                bw.write("员工姓名："+emp.getName());
                bw.newLine();
                bw.write("*****************************");
                bw.write("*****************************");
                bw.write("性别："+emp.getSex());
                bw.newLine();
                bw.write("年龄："+emp.getAge());
                bw.newLine();
                bw.write("月薪："+emp.getSalary());
                bw.newLine();
                bw.write("所在部门："+emp.getDepartment());
                bw.newLine();
                bw.write("婚否："+emp.getMarriage());
                bw.newLine();
                bw.write("家庭住址："+emp.getAddress());
                bw.newLine();
                bw.write("联系电话："+emp.getPhone());
                bw.newLine();
                bw.write("员工简历：");
                bw.write("\r\n");
                bw.write(emp.getResume());
                bw.flush(); //将数据更新至文件
                fw.close(); //关闭文件流
                bw.close();

        } catch (Exception e) {
            // out.println(e);
            e.printStackTrace();
        }

    }

}

<action path="/link3" parameter="link3" type="companypj.Link3Action" validate="false" >
<forward name="link3_success" path="/link3.jsp">
</forward>

if (type.equals("link3")) {
            log.info("return_link3..");
            DepartmentBean depbean=new DepartmentBean(ds);
            Collection DEPARTMENTS=depbean.getDepartments(); //取得所有部门信息
            request.setAttribute(Constants.DEPARTMENTS_KEY,DEPARTMENTS);//request到下一个页面
            return mapping.findForward(Constants_url.RETURN_LINK3_SUCCESS);//给sturts mapping传一个值
        }

public Collection getDepartments()
    {
        log.info("提交所有部门数据集合");
        return this.getDepartmentsHelper(Constants_sql.DEPARTMENT_ALL_SQL);
    }

public class Constants_sql {
    public Constants_sql() {
    }
    public static final String DEPARTMENT_ADD_SQL=
"insert into department(name,description,leader,phone,address,starttime,info)values(?,?,?,?,?,?,?)";
    public static final String DEPARTMENT_ALL_SQL="select * from department where name!='无部门' order by id desc"; //这里就是我们调用的常量
    public static final String EMP_ADD_SQL=
"insert into employee (name,sex,age,salary,department,marriage,address,phone,resume) values(?,?,?,?,?,?,?,?,?)";
    public static final String EMP_ALL_SQL="select * from employee where department!='无部门' order by id desc";
    public static final String EMP_TEMP_ALL_SQL="select * from employee where department='无部门' order by id desc";
    //public static final String

}

private Collection getDepartmentsHelper(String sql) //遍历集合 帮助方法
    {
        Collection list=new ArrayList();
        try {
            Connection conn=ds.getConnection();
            Statement stmt=conn.createStatement();
            ResultSet rs=stmt.executeQuery(sql);
            while(rs.next())
            {
                DepartmentVO departmentvo=new DepartmentVO();
               // log.info("取部门数据开始");
                departmentvo.setId(rs.getInt("id"));
                departmentvo.setName(rs.getString("name"));
                departmentvo.setDescription(rs.getString("description"));
                log.info(rs.getString("description"));
                departmentvo.setLeader(rs.getString("leader"));
                departmentvo.setPhone(rs.getString("phone"));
                departmentvo.setAddress(rs.getString("address"));
                departmentvo.setStarttime(rs.getString("starttime"));
                departmentvo.setInfo(rs.getString("info"));
                list.add(departmentvo);
               // log.info("取部门数据结束");
            }
            conn.close();
            stmt.close();
            rs.close();
        } catch (SQLException ex) {
            ex.getMessage();
        }
        return list;
    }

request.setAttribute(Constants.DEPARTMENTS_KEY,DEPARTMENTS);//request到下一个页面
            return mapping.findForward(Constants_url.RETURN_LINK3_SUCCESS);//给sturts mapping传一个值

public static final String RETURN_LINK3_SUCCESS="link3_success";
    

<forward name="link3_success" path="/link3.jsp">

<table cellpadding="0" cellspacing="5"  width="100%" >
  <tr>
    <td width="14%"><bean:message key="lable.dept.row.id"/></td>
    <td width="14%"><bean:message key="lable.dept.row.name"/></td>
    <td width="14%"><bean:message key="lable.dept.row.leader"/></td>
    <td width="14%"><bean:message key="lable.dept.row.add.emp"/></td>
    <td width="14%"><bean:message key="lable.dept.row.delete.emp"/></td>
  </tr>
  <tr>
    <td width="100%" colspan="5">
    <page:pager dz="5">
    <%int i=1; %>
    <logic:iterate id="departments" name="DEPARTMENTS" type="companypj.DepartmentVO">
    <table border="1" cellpadding="0" cellspacing="1" style="border-collapse: collapse"  width="100%" >
      <page:item nr="<%=i++%>">
      <tr>
        <td width="14%"><bean:write name="departments" property="id"/></td>
        <td width="14%"><bean:write name="departments" property="name"/></td>
        <td width="14%"><bean:write name="departments" property="leader"/></td>
        <td width="14%"><html:link page="/link3_add.do">
          <bean:message key="lable.dept.add.emp"/>
          </html:link></td>
        <td width="14%">
        <bean:define id="dep_id" name="departments" property="id">
        </bean:define>

          <html:link page="/link3_delete.do" paramId="dep_id" paramName="dep_id">
           <bean:message key="lable.dept.delete.emp"/>
          </html:link>
        </td>
      </tr>
      </page:item>
    </table>
    
    <br>
    
    </logic:iterate>
    </page:pager>
    </td>
  </tr>
</table>
<center>
<p>
<page:bt/>

<html:link page="/link3_add.do">
       <bean:message key="lable.dept.add.emp"/>
       </html:link>

<action path="/link3_add" parameter="link3_add" type="companypj.Link3Action" validate="false">

if(type.equals("link3_add"))
        {
            log.info("link3_temp..");
            EmployeeBean empbean=new EmployeeBean(ds);
            Collection EMPSTEMP=empbean.getTempEmps(); //这里就看到了取得TEMP员工的方法
            request.setAttribute(Constants.EMPS_TEMP_KEY,EMPSTEMP);
            return mapping.findForward(Constants_url.RETURN_LINK3_ADD_SUCCESS);
        }

public Collection getTempEmps() { //获得所有无部门的员工
        return this.getEmployeesHelper(Constants_sql.EMP_TEMP_ALL_SQL);
    }

public static final String EMP_TEMP_ALL_SQL="select * from employee where department='无部门' order by id desc";

private Collection getEmployeesHelper(String sql) {
        Collection list = new ArrayList();
        try {
            Connection conn = ds.getConnection();
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            while (rs.next()) {
                EmployeeVO employeeVO = new EmployeeVO();
                log.info("取人员信息开始");
                employeeVO.setId(rs.getInt("id"));
                employeeVO.setName(rs.getString("name"));
                employeeVO.setSex(rs.getString("sex"));
                employeeVO.setAge(rs.getInt("age"));
                employeeVO.setSalary(rs.getString("salary"));
                employeeVO.setDepartment(rs.getString("department"));
                employeeVO.setMarriage(rs.getString("marriage"));
                employeeVO.setAddress(rs.getString("address"));
                employeeVO.setPhone(rs.getString("phone"));
                employeeVO.setResume(rs.getString("resume"));
                list.add(employeeVO);
                log.info("取人员信息结束");
            }
            conn.close();
            stmt.close();
            rs.close();
        } catch (SQLException ex) {
        }
        return list;
    }

<bean:define id="dep_id" name="departments" property="id">
        </bean:define>
          <html:link page="/link3_delete.do" paramId="dep_id" paramName="dep_id">
           <bean:message key="lable.dept.delete.emp"/>

if(type.equals("link3_delete"))
        {
            log.info("delete ready..");
            EmployeeBean empbean=new EmployeeBean(ds);
            Collection DEPTEMPS=empbean.getDepartemtDemployees(request.getParameter("dep_id"));
            request.getSession().setAttribute("DEP_ID",request.getParameter("dep_id"));
            //保存部门ID号，以便删除之后可以返回页
            request.setAttribute(Constants.DEPT_EMPS_KEY,DEPTEMPS);
            return mapping.findForward(Constants_url.RETURN_LINK3_Delete_READY);
        }

public Collection getDepartemtDemployees(String dep_id) { //指定部门中的员工
        log.info("该部门是：" + dep_id);
        String sql_dep =
                "select * from employee where department=(select name from department where id=" +
                dep_id + ")";
        log.info(sql_dep);
        return this.getEmployeesHelper(sql_dep);
    }

public static final String DEPT_EMPS_KEY="DEPTEMPS";

<logic:iterate id="dept_emps" name="DEPTEMPS">
    <page:item nr="<%=i++%>">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%">
      <tr>
        <td width="33%"><bean:write name="dept_emps" property="id"/>��</td>
        <td width="33%"><bean:write name="dept_emps" property="name"/></td>
        <td width="34%">
          <bean:define id="ID" name="dept_emps" property="id"/>
          <html:link page="/link3_deleted.do" paramId="id" paramName="ID">
          <bean:message key="lable.delete.emp.this"/>
          </html:link>
        </td>
      </tr>

    </table>
    <br>
    </page:item>
    </logic:iterate>

if(type.equals("link3_deleted"))
        {
            EmployeeBean empbean=new EmployeeBean(ds);
            empbean.deleteEmployee(request.getParameter("id"));//删除某个员工
            Collection DEPTEMPS=empbean.getDepartemtDemployees(String.valueOf(request.getSession().getAttribute("DEP_ID")));//再取部门人员
            log.info("转发回页面");
            request.setAttribute(Constants.DEPT_EMPS_KEY,DEPTEMPS);
            return mapping.findForward(Constants_url.RETURN_LINK3_DeleteD_SUCCESS);
        }
        return null;
    }

public void deleteEmployee(String id) {
        try {
            log.info("1");
            Connection conn = ds.getConnection();
            Statement stmt = conn.createStatement();
            String sql_update = "update employee set department='无部门' where id=" +
                                id + "";
            log.info(sql_update);
            stmt.executeUpdate(sql_update);
            log.info("2");
            conn.close();
            stmt.close();
        } catch (SQLException ex) {
        }

<definition name="layout-definition" path="/layout.jsp">
<put name="sidebar" value="sidebar.jsp"></put>
<put name="header" value="header.jsp"></put>
<put name="content"></put>
<put name="footer" value="footer.jsp"></put>
</definition>

<definition extends="layout-definition" name="index-definition">
<put name="content" value="indexContent.jsp"></put>
</definition>

<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@ taglib uri="/WEB-INF/struts-tiles.tld" prefix="tiles" %>
<tiles:insert definition="index-definition">
</tiles:insert>

<html:link page="/link1.do"><font color="#000000" style="text-decoration: none"><bean:message key="link.add.emp"/></font></html:link>

<action path="/link1" parameter="link1" type="companypj.AddEmployeeAction" validate="false">
<forward name="link1_success" path="/link1.jsp">
</forward>

public class AddEmployeeAction extends Action {
    public ActionForward execute(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) {
         DynaValidatorForm empDynForm=(DynaValidatorForm)form;
         Log log=LogFactory.getLog("A");
         String type=mapping.getParameter();
         DataSource ds=getDataSource(request);
         if(type.equals("link1"))
         {
             log.info("return_link1..");
             DepartmentBean departmentbean=new DepartmentBean(ds);
             Collection onlydep=departmentbean.getOnlyDepartments();//这里转入部门类，取出部门集合
             request.getSession().setAttribute(Constants.ONLYDEPARTMENTS_KEY,onlydep);//集合保存，并传入下一页面
             return mapping.findForward(Constants_url.RETURN_LINK1_SUCCESS);
         }
         if(type.equals("link_addemp"))
         {
            EmployeeBean empbean=new EmployeeBean(ds);
            //String address=empDynForm.get("address").toString();
            empbean.addEmployee(empDynForm);
            return mapping.findForward(Constants_url.RETURN_ADD_EMP_READY);
         }
         return null;
    }
}

    public Collection getOnlyDepartments()     //只找出所有部门的集合,这个方法多此一举，都是动态数据即时更新的，所有没必要用它，当写着玩了～
    {
        Collection list=new ArrayList();
        Collection departments = this.getDepartments();//跳转
        Iterator i = departments.iterator();
        while(i.hasNext()) {
          DepartmentVO Onlydepartments=(DepartmentVO) i.next();
          log.info("Onlydep:"+Onlydepartments.getName());
          Onlydepartments.setName(Onlydepartments.getName()); //筛选后重新放入
          list.add(Onlydepartments);
        }
        return list;
    }

public Collection getDepartments()
    {
        log.info("提交所有部门数据集合");
        return this.getDepartmentsHelper(Constants_sql.DEPARTMENT_ALL_SQL);
    }

private Collection getDepartmentsHelper(String sql) //遍历集合 帮助方法
    {
        Collection list=new ArrayList();
        try {
            Connection conn=ds.getConnection();
            Statement stmt=conn.createStatement();
            ResultSet rs=stmt.executeQuery(sql);
            while(rs.next())
            {
                DepartmentVO departmentvo=new DepartmentVO();
                log.info("取部门数据开始");
                departmentvo.setId(rs.getInt("id"));
                departmentvo.setName(rs.getString("name"));
                departmentvo.setDescription(rs.getString("description"));
                log.info(rs.getString("description"));
                departmentvo.setLeader(rs.getString("leader"));
                departmentvo.setPhone(rs.getString("phone"));
                departmentvo.setAddress(rs.getString("address"));
                departmentvo.setStarttime(rs.getString("starttime"));
                departmentvo.setInfo(rs.getString("info"));
                list.add(departmentvo);
                log.info("取部门数据结束");
            }
            conn.close();
            stmt.close();
            rs.close();
        } catch (SQLException ex) {
            ex.getMessage();
        }
        return list;
    }

Onlydepartments.setName(Onlydepartments.getName()); //筛选后重新放入

request.getSession().setAttribute(Constants.ONLYDEPARTMENTS_KEY,onlydep);//集合保存，并传入下一页面

<forward name="link1_success" path="/link1.jsp">

<definition extends="layout-definition" name="link1-definition">
<put name="content" value="return/CreateEmployee.jsp"></put>
</definition>

<html:select property="department">
              <logic:iterate id="onlydep" name="ONLYDEPARTMENTS" type="companypj.DepartmentVO" scope="session">
                <option value="<bean:write name="onlydep" property="name"/>">
                  <bean:write name="onlydep" property="name"/>
                </option>
              </logic:iterate>
            </html:select>

<html:form action="/link_addemp.do" method="POST">

<action input="/link1.jsp" name="EmpForm" path="/link_addemp" parameter="link_addemp"
scope="request" type="companypj.AddEmployeeAction" validate="true" >

<formset>
<form name="EmpForm">
<field property="name" depends="required">
<arg0 key="label.emp.name"/>
</field>
<field property="age" depends="required">
<arg0 key="label.emp.age"/>
</field>
<field property="salary" depends="required">
<arg0 key="label.emp.salary"/>
</field>
</form>
</formset>

if(type.equals("link_addemp"))
         {
            EmployeeBean empbean=new EmployeeBean(ds);
            //String address=empDynForm.get("address").toString();
            empbean.addEmployee(empDynForm);
            return mapping.findForward(Constants_url.RETURN_ADD_EMP_READY);
         }

public void addEmployee(DynaValidatorForm empDynForm) {
        EmployeeVO employeeVO = this.NynaIntoEmp(empDynForm);
        String strSQL="{call demo_empadd(?,?,?,?,?,?,?,?,?)}";//存储过程
        this.executeEmpHelper(employeeVO, strSQL);
    }

Create PROCEDURE demo_empadd
@inparam1 varchar(10),@inparam2 varchar(20),@inparam3 int,
@inparam4 varchar(10),@inparam5 varchar(20),@inparam6 varchar(10),
@inparam7 varchar(20),
@inparam8 varchar(10),@inparam9 varchar(40)
AS insert into employee(name,sex,age,salary,department,marriage,address,phone,resume)values
(@inparam1,@inparam2,@inparam3,@inparam4,@inparam5,@inparam6,@inparam7,@inparam8,@inparam9)
GO

private void executeEmpHelper(EmployeeVO employeeVO, String sql) { //帮助方法
        try {
            Connection conn = ds.getConnection();
            java.sql.CallableStatement pstm=conn.prepareCall(sql);
            //PreparedStatement pstm = conn.prepareStatement(sql);
            log.info("雇员信息开始加入");
            pstm.setString(1, employeeVO.getName());
            pstm.setString(2, employeeVO.getSex());
            pstm.setInt(3, employeeVO.getAge());
            pstm.setString(4, employeeVO.getSalary());
            pstm.setString(5, employeeVO.getDepartment());
            pstm.setString(6, employeeVO.getMarriage());
            pstm.setString(7, employeeVO.getAddress());
            pstm.setString(8, employeeVO.getPhone());
           // log.info("1");
            pstm.setString(9, employeeVO.getResume());
           // log.info("2");
            pstm.executeUpdate();
            log.info("雇员信息加入结束");
        } catch (SQLException ex) {
        }
    }

<forward name="link_addemp_ready" path="/link1_add_success.jsp">