departmentbo.java

企业级的即时通软件。。java语言写的 这是服务端部份。

package edu.sccp.chat.bo;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Vector;

import javax.swing.JOptionPane;

import edu.sccp.chat.dao.ConnData;


public class DepartmentBO {

	public static ResultSet rs;
	public static PreparedStatement stat;
	public static int insertdept(String id,String name,String chief,String adress,String tel,String remark){
		//插入部门信息
    	String sql="insert into t_dept values('"+id+"','"+name+"','"+chief+"','"+adress+"','"+tel+"','"+remark+"')";
    	int i=0;
    	try {
        	stat=ConnData.conn().prepareStatement(sql);
        	i=stat.executeUpdate();//如果I返回1则添加成功，返回0则不成功
			stat.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				DepartmentBO.stat.close();
				ConnData.co.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return i;
    }
	
	public static String[] depthead(String id){//返回部门信息
		String [] str=new String[6];
		try {
			rs=ConnData.conn().createStatement().executeQuery("select * from t_dept where f_deptNo='"+id+"'");
			if(rs.next()){
				str[0]=rs.getString(1);
				str[1]=rs.getString(2);
				str[2]=rs.getString(3);
				str[3]=rs.getString(4);
				str[4]=rs.getString(5);
				str[5]=rs.getString(6);
				}else
				{
					str[0]="F";
				}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				DepartmentBO.rs.close();
				ConnData.co.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return str;
		
	}
	public static Vector deptInfo(String name){//返回部门信息
		Vector str=new Vector();
		try {
			rs=ConnData.conn().createStatement().executeQuery("select * from t_dept where f_name='"+name+"'");
			rs.next();
				str.addElement(rs.getString(1).trim());
				str.addElement(rs.getString(2).trim());
				str.addElement(rs.getString(3).trim());
				str.addElement(rs.getString(4).trim());
				str.addElement(rs.getString(5).trim());
				str.addElement(rs.getString(6).trim());
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				DepartmentBO.rs.close();
				ConnData.co.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return str;
		
	} 
	
//	删除部门信息的方法
    public static  boolean alldeletata(String id){
        boolean flag=false;
        String sql="delete  from t_dept where f_deptNo='"+id+"'";
    	try {
		int i=	ConnData.conn().createStatement().executeUpdate(sql);
		if(i==0){
			flag=false;
			
		}else{
			flag=true;
		}
		} catch (SQLException e) {
			e.printStackTrace();
			
		  }finally{
				try {
					ConnData.co.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
	 
    	return flag;
    	
    }
//  修改公司和部门公告方法
    public static boolean alterMessageData(String table,String text,String name){
    	boolean flag=false;
    	if(table.equals("t_dept")){
    	String sql="update "+table+" set f_deptMessage='"+text+"' where f_name='"+name+"'";
    	try {
		int i =	ConnData.conn().createStatement().executeUpdate(sql);
			if(i==0){
				flag=false;	
			}else{
				flag=true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				ConnData.co.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
    }
    	else{
    		String sql="update "+table+" set f_companyMessage='"+text+"'";
        	try {
    			int i=ConnData.conn().createStatement().executeUpdate(sql);
    			if(i==0){
    				flag=false;	
    			}else{
    				flag=true;
    			}
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    	finally{
			try {
				ConnData.co.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
    	return flag;
    }
		return flag;
    	
    }
    public static Vector selectdept()//获取部门名称
	 {
		 ResultSet rs = null;
		 Vector vector=new Vector();
		 try {
			 stat=ConnData.conn().prepareStatement("select * from t_dept");
			rs=stat.executeQuery();
			while(rs.next())
			{
				vector.add(rs.getString(2).trim());
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				DepartmentBO.stat.close();
				if(rs!=null)rs.close();
				ConnData.co.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return vector;
	 }
    
    //查看部门信息
    
    public static String[] deptinfo(String id){
		String [] str=new String[6];
		try {
			rs=ConnData.conn().createStatement().executeQuery("select * from t_dept where f_deptNo='"+id+"'");
			if(rs.next()){
				str[0]=rs.getString(1);
				str[1]=rs.getString(2);
				str[2]=rs.getString(3);
				str[3]=rs.getString(4);
				str[4]=rs.getString(5);
				str[5]=rs.getString(6);
				}else
				{
					str[0]="F";
				}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				DepartmentBO.rs.close();
				ConnData.co.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return str;
		
	}
    
//  修改部门信息
	public static int upd(String id,String name,String chief,String adress,String tel,String remark){//插入部门信息
    	String sql="update t_dept set f_name='"+name+"',f_chief='"+chief+"',f_adress='"+adress+"',f_tel='"+tel+"',f_deptmessage='"+remark+"' where f_deptNo='"+id+"'";
    	int i=0;
    	try {
        	PreparedStatement stat=ConnData.conn().prepareStatement(sql);
        	i=stat.executeUpdate();//如果I返回1则添加成功，返回0则不成功
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null){
					DepartmentBO.rs.close();
					}if(ConnData.co!=null){
					ConnData.co.close();}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return i;
    }
	
	//反返回公司公告
	public static String selectCompany()
	{
		String str="";
		String sql="select f_companyMessage from t_boss";
		try {
			rs=ConnData.conn().createStatement().executeQuery(sql);
			rs.next();
			str=rs.getString(1);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				DepartmentBO.rs.close();
				ConnData.co.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return str;
	}
	public static String selectdeptgonggao(String dept)//查看部门公告
	{
		String str = null;
		String sql="select f_deptMessage from t_dept where f_name='"+dept+"'";
		try {
			rs=ConnData.conn().createStatement().executeQuery(sql);
			rs.next();
			str=rs.getString(1);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				DepartmentBO.rs.close();
				ConnData.co.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return str;
	}
}