commondao.java

来自「公司自己开发的工作流引擎」· Java 代码 · 共 48 行

package cn.com.iaspec.workflow.privilege.dao;

import java.sql.*;
import java.text.*;
import java.util.Date;
import org.apache.log4j.*;
import cn.com.iaspec.workflow.db.*;

public class CommonDAO{
  private static Logger logger=Logger.getLogger(CommonDAO.class);
  public CommonDAO(){
  }

  /**
   * 查询
   * @param func LaFuncInfo
   * @throws SQLException
   * @return List
   */
  public Date getCurrentDBDate()
      throws Exception{
    Connection conn=null;
    Statement stm=null;
    java.util.Date resultDate=null;
    try{
      conn=WorkflowDBConnectionManager.getInstance().getConnection();
      stm=conn.createStatement();
      String sql=" select distinct to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') "+
          " as dbserverdate  from dual ";
      logger.info("......query sql:"+sql);
      ResultSet rs=stm.executeQuery(sql);

      if(rs.next()){
        String sDate=rs.getString("dbserverdate");
        SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        resultDate=sdf.parse(sDate);
        return resultDate;
      }
      return resultDate;
    }
    finally{
      WorkflowDBConnectionManager.getInstance().close(stm,false);
      WorkflowDBConnectionManager.getInstance().close(conn);
    }
  }

}