cardgroupado.java

辅助办公系统,具有发布公告、站内邮箱、日程安排、日志查看等功能

package com.x3408.card;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import com.x3408.database.CNProvider;

public class CardGroupADO {
	public static boolean cardGroupInsert(CardGroupInfo cardGroupInfo) {
		Connection conn = null;
		PreparedStatement pstat = null;
		if (!cardGroupInfo.isValid()) {
			return false;
		}
		conn = CNProvider.getConnection();
		if (conn == null) {
			return false;
		}
		try {
			pstat = conn
					.prepareStatement("insert cardGroup(cardGroup,cardID,employeeID)values(?,?)");
			pstat.setString(1, cardGroupInfo.getCardGroup());
			pstat.setInt(2, cardGroupInfo.getCardID());
			pstat.executeUpdate();
			return true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			CNProvider.release(pstat, conn);
		}
		return false;
	}

	public static boolean cardGroupInfoDelete(String cardGroup,String pCardID) {
		Connection conn = null;
		PreparedStatement pstat = null;
		int cardID;
		if (cardGroup==null||"".equals(cardGroup.trim())||pCardID==null||"".equals(pCardID.trim())) {
			return false;
		}
		try{
			cardID=Integer.parseInt(pCardID);
		}catch(NumberFormatException e){
			e.printStackTrace();
			return false;
		}
		conn = CNProvider.getConnection();
		if (conn == null) {
			return false;
		}
		try {
			pstat = conn
					.prepareStatement("delete from cardGroup where cardGroup=? and cardID=?");
			pstat.setString(1, cardGroup.trim());
			pstat.setInt(2, cardID);
			pstat.executeUpdate();
			return true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			CNProvider.release(pstat, conn);
		}
		return true;
	}

	public static Vector cardGroupQuery(String employeeID) {
		Connection conn = null;
		PreparedStatement pstat = null;
		ResultSet rs = null;
		Vector<String> cardGroup;
		if (employeeID == null || "".equals(employeeID.trim())) {
			return null;
		}
		conn = CNProvider.getConnection();
		if(conn==null){
			return null;
		}
		try {
			pstat = conn.prepareStatement("select cardGroupOwner.cardGroup,count(cardGroup.cardID) as count from cardGroup right join cardGroupOwner " +
							"on cardGroup.employeeID=cardGroupOwner.employeeID and cardGroup.cardGroup=cardGroupOwner.cardGroup where cardGroupOwner.employeeID=? group by cardGroupOwner.cardGroup");
			pstat.setString(1, employeeID.trim());
			rs = pstat.executeQuery();
			cardGroup = new Vector<String>();
			while(rs.next()){
				cardGroup.addElement(rs.getString("count"));
				cardGroup.addElement(rs.getString("cardGroup"));
			}
			return cardGroup;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			CNProvider.release(rs, pstat, conn);
		}
		return null;
	}

	public static CardGroupInfo cardGroupInfoQuery(String cardGroup) {
		Connection conn = null;
		PreparedStatement pstat = null;
		ResultSet rs = null;
		CardGroupInfo cardGroupInfo = null;
		if (cardGroup == null || "".equals(cardGroup.trim())) {
			return null;
		}
		conn = CNProvider.getConnection();
		if (conn == null) {
			return null;
		}
		try {
			pstat = conn
					.prepareStatement("select * from cardGroup where cardGroup=?");
			pstat.setString(1, cardGroup.trim());
			rs = pstat.executeQuery();
			if (rs.next()) {
				cardGroupInfo = new CardGroupInfo(rs.getString("cardGroup"), rs
						.getString("cardInfo"), rs.getString("employeeID"));
			}
			return cardGroupInfo;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
}