ufmobiledao.java

国内很牛的软件公司花费两年半开发的用EJB3开发的代码,采用STRUTS和EJB3,目前系统进行第二版.所以拿出来共享

package com.ufmobile.common.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.Types;
import java.util.Date;

import javax.persistence.EntityManager;

import com.ufmobile.common.UFMobileUUID;
import com.ufmobile.platform.log.RunTimeLogger;

/*
 * @author maoshifu
 * @date   2006/12/4
 * @function �ṩdao�Ļ���
 * 
 */
public abstract class UFMobileDAO {

	private EntityManager manager;

	public UFMobileDAO(EntityManager manager) {
		this.manager = manager;
	}

	public UFMobileDAO() {

	}

	public EntityManager getManager() {

		return manager;
	}

	public void setManager(EntityManager manager) {
		this.manager = manager;
	}

	protected synchronized String getUUID() {

		return UFMobileUUID.randomUUID().toString();
	}

	protected synchronized String getUUID(String sName) {

		return UFMobileUUID.fromString(sName).toString();
	}

	/**
	 * <p>
	 * <p>
	 * 作者：qbh <br>
	 * 日期：2007-1-11
	 * 
	 * @param con
	 * @param stmt
	 */
	protected void close(Connection con, PreparedStatement stmt) {
		try {
			if (stmt != null) {
				stmt.close();
			}
			if (con != null) {
				con.close();
			}
		} catch (Exception e) {
			RunTimeLogger.error(this, "无法关闭连接", e);
		}
	}

	protected void setLong(PreparedStatement stmt, int index, Long value) throws SQLException {
		if (value == null) {
			stmt.setNull(index, Types.NUMERIC);
		} else {
			stmt.setLong(index, value);
		}
	}

	protected void setInt(PreparedStatement stmt, int index, Integer value) throws SQLException {
		if (value == null) {
			stmt.setNull(index, Types.NUMERIC);
		} else {
			stmt.setInt(index, value);
		}
	}

	protected void setShort(PreparedStatement stmt, int index, Short value) throws SQLException {
		if (value == null) {
			stmt.setNull(index, Types.NUMERIC);
		} else {
			stmt.setShort(index, value);
		}
	}

	protected void setDouble(PreparedStatement stmt, int index, Double value) throws SQLException {
		if (value == null) {
			stmt.setNull(index, Types.NUMERIC);
		} else {
			stmt.setDouble(index, value);
		}
	}

	protected void setString(PreparedStatement stmt, int index, String value) throws SQLException {
		if (value == null) {
			stmt.setNull(index, Types.VARCHAR);
		} else {
			stmt.setString(index, value);
		}
	}

	protected void setTimestamp(PreparedStatement stmt, int index, Date value) throws SQLException {
		if (value == null) {
			stmt.setNull(index, Types.TIMESTAMP);
		} else {
			stmt.setTimestamp(index, new Timestamp(value.getTime()));
		}
	}

}