package dal;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Department
{
	//增加部門信息
	public static boolean add(String name,String remark)
	{
		boolean b=true;
		PreparedStatement ps=null;
		try
		{
			String sql="insert into Department(D_name,D_remark) values(?,?)";
			ps=SQLHelper.getConn().prepareStatement(sql);
			ps.setString(1,name);
			ps.setString(2,remark);
			b=SQLHelper.executeUpdate(ps);
		}
		catch(SQLException e)
		{
			System.out.println (e);
		}
		return b;
	}
	
	//刪除部門信息
	public static boolean delete(int id)
	{
		boolean b=true;
		PreparedStatement ps=null;
		try
		{
			String sql="delete from Department where D_id=?";
			ps=SQLHelper.getConn().prepareStatement(sql);
			ps.setInt(1,id);
			b=SQLHelper.executeUpdate(ps);
		}
		catch(SQLException e)
		{
			System.out.println (e);
		}
		finally
		{
			SQLHelper.coloseConn();
		}
		return b;
	}
	
	//更新部門信息
	public static boolean update(int id,String name,String remark)
	{
		boolean b=true;
		PreparedStatement ps=null;
		try
		{
			String sql="update Department set D_name=?,D_remark=? where D_id=?";
			ps=SQLHelper.getConn().prepareStatement(sql);
			ps.setString(1,name);
			ps.setString(2,remark);
			ps.setInt(3,id);
			b=SQLHelper.executeUpdate(ps);
		}
		catch(SQLException e)
		{
			System.out.println (e);
		}
		finally
		{
			SQLHelper.coloseConn();
		}
		return b;
	}
	
	//查詢部門信息
	public static ResultSet list(String strWhere)
	{
		PreparedStatement ps=null;
		ResultSet rs=null;
		try
		{
			String sql="select * from Department ";
			if(strWhere!="")
			{
				sql+=strWhere;
			}
			
			ps=SQLHelper.getConn().prepareStatement(sql);
			rs=SQLHelper.executeQuery(ps);
		}
		catch(SQLException e)
		{
			System.out.println (e);
		}
		return rs;
	}
}