todeptaddcreateadd.java

实现银行系统中某个部门的计算机设备管理、公共信息管理、权限用户管理、系统设置等,为系统的安全正常运行提供保障

package com.isoftstone.banktearm1.to;
/*
 * 07作成部门及机构
 */
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.isoftstone.banktearm1.dao.DeptDao;
import com.isoftstone.banktearm1.db.DB;

public class ToDeptAddCreateAdd extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public ToDeptAddCreateAdd() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		DB db=new DB();
		DeptDao dd=new DeptDao();
		String url="";
		try{
			String depname=(String)request.getAttribute("depname");
			String unitid=(String)request.getAttribute("unitid");
			Connection con=db.getConnection();
			Statement stmt=con.createStatement();
			String sql="select * from dep";
			ResultSet rs=stmt.executeQuery(sql);
			boolean b=false;
			while(rs.next()){
				String name=rs.getString("DepartmentName");
				String DepartmentUnit=rs.getString("DepartmentUnit");
				if((name.equals(depname) && DepartmentUnit.equals("unitid")) || depname.equals(""))
					b=true;
			}
			if(b)
				url="JspDeptAddCreateError.jsp";
			else{
				String str="科技部";
				String id1="";
				int departmentType=0;
				request.setAttribute("depname", depname);
				request.setAttribute("unitid", unitid);
				int id=dd.getMax("ID")+1;
				if(id<10)
					id1="0"+id;
				int departmentId=Integer.parseInt(unitid+id1);
				String departmentName=depname;
				String departmentUnit=unitid;
				if(!str.equals(departmentName))
					departmentType=1;
				dd.insertDep(id, departmentId, departmentName, departmentUnit, departmentType);
				url="JspDeptAddCreate.jsp";
			}
			db.closs(stmt,con);
		}catch(Exception e){
			e.printStackTrace();
		}
	    request.getRequestDispatcher(url).forward(request,response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		this.doGet(request, response);
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}