Package aflac.utils

Examples of aflac.utils.ConnectionManager


  }

  public void fetchRequestList() throws SQLException {
    logger.debug("RequestSummaryList: Fetching...");
    if (null == cn)
      cn = (new ConnectionManager()).getConnection();

    listStmt = cn
        .prepareStatement("SELECT ir_type,ir_num,ir_start_date,nickName,left(ir_desc,50),ir_priority,ir_status,ir_team FROM ir_status_report");

    ResultSet rs = listStmt.executeQuery();
View Full Code Here


  Connection cn;
  PreparedStatement addStmt, modStmt, delStmt, viewStmt;
  final Logger logger=Logger.getLogger(RequestSummary.class.getName());

  public RequestSummary() {
    cn = (new ConnectionManager()).getConnection();
  }
View Full Code Here

  }

  public void fetchRequestCommentList() throws SQLException {
    logger.debug("RequestComment: Fetching...");
    if (null == cn)
      cn = (new ConnectionManager()).getConnection();
    commentStmt = cn
        .prepareStatement("SELECT ir_comment_date,ir_comment_txt FROM ir_comments WHERE ir_num=?");

    commentStmt.setString(1, reqNum);
View Full Code Here

    logger.debug("RequestComment: reqNum: " + reqNum);
    logger.debug("RequestComment: CommentDate: " + CommentDate);

    try {
      if (null == cn)
        cn = (new ConnectionManager()).getConnection();
      commentStmt = cn
          .prepareStatement("SELECT ir_comment_txt FROM ir_comments WHERE ir_num=? AND ir_comment_date=?");

      commentStmt.setString(1, reqNum);
      commentStmt.setString(2, FormDate2MysqlDate(CommentDate));
View Full Code Here

    logger.debug("RequestComment Bean: Add: called...");
    try {

      if (null == cn)
        cn = (new ConnectionManager()).getConnection();

      addStmt = cn
          .prepareStatement("INSERT INTO ir_comments(ir_num,ir_comment_date,ir_comment_txt) VALUES(?,?,?)");

      addStmt.setString(1, reqNum);
View Full Code Here

  public int update() {

    logger.debug("RequestComment Bean: Update: called...");

    if (null == cn) {
      cn = (new ConnectionManager()).getConnection();
    }

    try {
      updateStmt = cn
          .prepareStatement("UPDATE ir_comments set ir_comment_txt=? WHERE ir_num=? and ir_comment_date=?");
View Full Code Here

    try {
      // create Excel file
      wb = new HSSFWorkbook();
      CreationHelper createHelper = wb.getCreationHelper();

      cn = (new ConnectionManager()).getConnection();
      listStmt = cn
          .prepareStatement("SELECT ir_type,ir_num,ir_start_date,nickName,ir_desc,ir_priority,ir_status FROM ir_status_report WHERE ir_team=?");

      listStmt.setString(1, team);
View Full Code Here

TOP

Related Classes of aflac.utils.ConnectionManager

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.