public boolean insertFamilyDetails(String personnelID, FamilyDetails fd) {
   boolean check = true;
   PreparedStatement ps;
   if (dbc.connect()) {
     try {
       String sqlQuery = "INSERT INTO " + FAMILY + " VALUES(?,?,?,?,?,?,?)";
       ps = dbc.getConnection().prepareStatement(sqlQuery);
       ps.setString(1, personnelID);
       ps.setShort(2, fd.getRelationID());
       ps.setNString(3, fd.getPerName());
       if (fd.getPerBirth() == null) {
         ps.setNull(4, java.sql.Types.DATE);
       } else {
         ps.setDate(4, fd.getPerBirth());
       }
       ps.setNString(5, fd.getPerJob());
       ps.setNString(6, fd.getPerAdd());
       ps.setString(7, fd.getPerPhone());
       if (ps.executeUpdate() < 1) {
         check = false;
       }
     } catch (SQLException ex) {
       Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
     }
   }
   return check;
 }
Ejemplo n.º 2
0
  /**
   * Add recruitment request to permanent store.
   *
   * @param toAdd request to be added
   * @return id of added request or -1 if unsuccessful
   */
  public int addRecruitmentRequest(RecruitmentRequestBean toAdd) {
    String insertStatement =
        "insert into recruitmentrequests (requestdep, requestdate, jobtitle, contracttype, yearsofexperience, jobdescription, status) values (?,?,?,?,?,?,?);";

    try {
      PreparedStatement statement =
          connection.prepareStatement(insertStatement, Statement.RETURN_GENERATED_KEYS);
      statement.setNString(1, toAdd.getRequestDepartment());
      statement.setDate(2, new java.sql.Date(toAdd.getRequestDate().getTime()));
      statement.setNString(3, toAdd.getJobTitle());
      statement.setNString(4, toAdd.getContractType());
      statement.setInt(5, toAdd.getYearsOfExperience());
      statement.setNString(6, toAdd.getJobDescription());
      statement.setNString(7, "active");

      statement.executeUpdate();

      ResultSet rs = statement.getGeneratedKeys();
      if (rs.first()) {
        return rs.getInt(1);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return -1;
  }
  public boolean insertHealthStatus(String personnelID, HealthStatus hs) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery = "INSERT INTO " + HEALTH_STATUS + " VALUES(?,?,?,?,?,?,?,?,?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);
        ps.setString(1, personnelID);
        if (hs.getHealDate() == null) {
          ps.setNull(2, java.sql.Types.DATE);
        } else {
          ps.setDate(2, hs.getHealDate());
        }

        ps.setNString(3, hs.getHospital());
        ps.setShort(4, hs.getHeight());
        ps.setShort(5, hs.getWeight());
        ps.setString(6, hs.getSight());
        ps.setShort(7, hs.getBloodID());
        ps.setShort(8, hs.getHealthStatusID());
        ps.setNString(9, hs.getNote());
        if (ps.executeUpdate() < 1) {
          check = false;
        }
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }
    return check;
  }
  public boolean insertCompanyDetails(CompanyDetails com) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery = "INSERT INTO " + COMPANY_INFO + " VALUES(?,?,?,?,?,?,?,?,?,?,?,?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);
        ps.setNString(1, com.getTenCtyVN());
        ps.setString(2, com.getTenCtyEN());
        ps.setString(3, com.getTenVietTat());
        ps.setNString(4, com.getTenGiamDoc());
        ps.setString(5, com.getSoDienThoai());
        ps.setString(6, com.getSoFax());
        ps.setString(7, com.getSoTaiKhoan());
        ps.setNString(8, com.getDiaChiVN());
        ps.setNString(9, com.getDiaChiEN());
        ps.setString(10, com.getMaSoThue());
        if (com.getNgayDangKy() == null) {
          ps.setNull(11, java.sql.Types.DATE);
        } else {
          ps.setDate(11, com.getNgayDangKy());
        }

        ps.setBytes(12, com.getLogo());

        if (ps.executeUpdate() < 1) {
          check = false;
        }
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }
    return check;
  }
  public boolean insertDocumentDetails(String personnelID, DocumentsDetails doc) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery = "INSERT INTO " + DOC_INFO + " VALUES(?,?,?,?,?,?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);
        ps.setString(1, personnelID);
        ps.setNString(2, doc.getName());
        if (doc.getSaveDate() == null) {
          ps.setNull(3, java.sql.Types.DATE);
        } else {
          ps.setDate(3, doc.getSaveDate());
        }
        ps.setBytes(4, doc.getFile());
        ps.setString(5, doc.getExtension());
        ps.setShort(6, doc.getKindID());

        if (ps.executeUpdate() < 1) {
          check = false;
        }
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }
    return check;
  }
  public boolean updateContractList(Contract con) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery = "INSERT INTO " + getCONTRACT_CB() + " VALUES(?,?,?,?,?,?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);

        ps.setNString(1, con.getName());
        ps.setShort(2, con.getMonth());
        if (con.isBHXH()) {
          ps.setBoolean(3, con.isBHXH());
          ps.setFloat(4, con.getPercent());
        } else {
          ps.setBoolean(3, con.isBHXH());
          ps.setNull(4, java.sql.Types.FLOAT);
        }
        ps.setBytes(5, con.getTemplate());
        ps.setString(6, con.getExtension());

        if (ps.executeUpdate() < 1) {
          check = false;
        }
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }
    return check;
  }
  public boolean insertSkillInfo(String personnelID, Skill sk) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery = "INSERT INTO " + SKILL_INFO + " VALUES(?,?,?,?,?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);
        ps.setString(1, personnelID);
        ps.setShort(2, sk.getNameID());
        ps.setShort(3, sk.getClassificationID());
        ps.setNString(4, sk.getNote());
        if (sk.getEffectiveDate() == null) {
          ps.setNull(5, java.sql.Types.DATE);
        } else {
          ps.setDate(5, sk.getEffectiveDate());
        }

        if (ps.executeUpdate() < 1) {
          check = false;
        }
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }
    return check;
  }
 public void setNString(int idx, String string) throws SQLException {
   try {
     addMementoEntry("setNString", new Class[] {String.class}, idx, string);
     wrapped.setNString(idx, string);
   } catch (SQLException e) {
     throw new UcanaccessSQLException(e);
   }
 }
 public void setNString(int parameterIndex, String value) throws SQLException {
   String methodCall = "setNString(" + parameterIndex + ", " + value + ")";
   argTraceSet(parameterIndex, "(String)", value);
   try {
     realPreparedStatement.setNString(parameterIndex, value);
   } catch (SQLException s) {
     reportException(methodCall, s);
     throw s;
   }
   reportReturn(methodCall);
 }
Ejemplo n.º 10
0
  @POST
  @Path("/products")
  @Consumes(MediaType.APPLICATION_JSON)
  @Produces(MediaType.TEXT_PLAIN)
  public String postProduct(String str) throws SQLException {
    JsonParser parser = Json.createParser(new StringReader(str));
    Map<String, String> productMap = new LinkedHashMap<String, String>();
    String key = "";
    String val = "";

    while (parser.hasNext()) {
      JsonParser.Event event = parser.next();
      switch (event) {
        case KEY_NAME:
          key = parser.getString();
          break;
        case VALUE_STRING:
          val = parser.getString();
          productMap.put(key, val);
          break;
        case VALUE_NUMBER:
          val = parser.getString();
          productMap.put(key, val);
          break;
        default:
          break;
      }
    }
    if (conn == null) {
      return "Not connected";
    } else {
      String query = "INSERT INTO products (name,decription,quantity) VALUES (?,?,?)";
      PreparedStatement pstmt = conn.prepareStatement(query);
      pstmt.setNString(1, productMap.get("product_id"));
      pstmt.setNString(2, productMap.get("name"));
      pstmt.setNString(3, productMap.get("description"));
      pstmt.setNString(4, productMap.get("quantity"));
      return "row has been inserted into the database";
    }
  }
Ejemplo n.º 11
0
  /**
   * Add event request to persistent store
   *
   * @param toAdd event to add
   * @return id of added event, or -1 if unsuccessful
   */
  public int addEventRequest(EventRequestBean toAdd) {
    String insertStatement =
        "insert into eventrequests "
            + "(clientid, type, name, fromdate, todate, budget,"
            + " status, details_photo_video, details_music,"
            + " details_poster, details_decoration, details_network,"
            + " details_food_beverages, details_waiter, feedback_budget)"
            + " values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
    try {
      PreparedStatement statement =
          connection.prepareStatement(insertStatement, Statement.RETURN_GENERATED_KEYS);
      statement.setInt(1, toAdd.getClientId());
      statement.setNString(2, toAdd.getType());
      statement.setNString(3, toAdd.getName());
      statement.setDate(4, new java.sql.Date(toAdd.getFrom().getTime()));
      statement.setDate(5, new java.sql.Date(toAdd.getTo().getTime()));
      statement.setNString(6, toAdd.getBudget());
      statement.setNString(7, toAdd.getStatus());
      Map<String, String> preferences = toAdd.getPreferences();
      statement.setNString(8, preferences.get("details_photo_video"));
      statement.setNString(9, preferences.get("details_music"));
      statement.setNString(10, preferences.get("details_poster"));
      statement.setNString(11, preferences.get("details_decoration"));
      statement.setNString(12, preferences.get("details_network"));
      statement.setNString(13, preferences.get("details_food_beverages"));
      statement.setNString(14, preferences.get("details_waiter"));
      statement.setNString(15, preferences.get("feedback_budget"));

      statement.executeUpdate();
      ResultSet rs = statement.getGeneratedKeys();
      if (!rs.next()) {
        return -1;
      }
      return (int) rs.getLong(1);

    } catch (SQLException e) {
      e.printStackTrace();
    }
    return -1;
  }
Ejemplo n.º 12
0
  /**
   * PUT method for updating or creating an instance of ProductResource
   *
   * @param content representation for the resource
   * @return an HTTP response with content of the updated or created resource.
   */
  @PUT
  @Path("{id}")
  @Consumes(MediaType.APPLICATION_JSON)
  public String putProduct(@PathParam("id") int id, String str) throws SQLException {
    JsonParser parser = Json.createParser(new StringReader(str));
    Map<String, String> productMap = new LinkedHashMap<String, String>();
    String key = "";
    String val = "";

    while (parser.hasNext()) {
      JsonParser.Event event = parser.next();
      switch (event) {
        case KEY_NAME:
          key = parser.getString();
          break;
        case VALUE_STRING:
          val = parser.getString();
          productMap.put(key, val);
          break;
        case VALUE_NUMBER:
          val = parser.getString();
          productMap.put(key, val);
          break;
        default:
          break;
      }
    }
    if (conn == null) {
      return "Not connected";
    } else {
      String query =
          "UPDATE products SET  name = ?, SET decription = ?, SET quantity = ? WHERE id = ? ";
      PreparedStatement pstmt = conn.prepareStatement(query);
      pstmt.setInt(4, id);
      pstmt.setNString(1, productMap.get("name"));
      pstmt.setNString(2, productMap.get("description"));
      pstmt.setNString(3, productMap.get("quantity"));
      return "row has been updated into the database";
    }
  }
Ejemplo n.º 13
0
  /**
   * Add client record to persistent store.
   *
   * @param toAdd client to add
   * @return id of added client, or -1 if an error occurred
   */
  public int addClient(ClientBean toAdd) {
    String insertStatement =
        "insert into clients (firstname, lastname, email, phonenumber) values (?,?,?,?);";
    try {
      PreparedStatement statement =
          connection.prepareStatement(insertStatement, Statement.RETURN_GENERATED_KEYS);
      statement.setNString(1, toAdd.getFirstName());
      statement.setNString(2, toAdd.getLastName());
      statement.setNString(3, toAdd.getEmail());
      statement.setNString(4, toAdd.getPhone());

      statement.executeUpdate();

      ResultSet generatedKeys = statement.getGeneratedKeys();
      if (generatedKeys.first()) {
        return generatedKeys.getInt(1);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return -1;
  }
Ejemplo n.º 14
0
  public void insertNewData(CommonDataBean bean) throws Exception {
    Connection conn = null;
    PreparedStatement pstmt = null;

    try {
      // prepare sql script
      StringBuffer sql = new StringBuffer();
      sql.append(
              "insert into digital_converage (serialno, id, lang_id, title, subtitle, description, author, linkA, ")
          .append(
              " linkB, linkC, imgPathA, imgPathB, imgPathC, breadcrumbA, breadcrumbB, breadcrumbC, ")
          .append(
              " filePathA, filePathB, filePathC, createDate, top, enabled, isDelete, displayOrder, content_short, content_long ) ")
          .append(" values (?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,now(), ?,?,?,1,?,?) ");

      conn = DriverManager.getConnection("proxool.digital");
      pstmt = conn.prepareStatement(sql.toString());
      pstmt.setNull(1, java.sql.Types.INTEGER);
      pstmt.setInt(2, bean.getId());
      pstmt.setInt(3, bean.getLang_id());
      pstmt.setNString(4, bean.getTitle());
      pstmt.setString(5, bean.getSubtitle());
      pstmt.setString(6, bean.getDescription());
      pstmt.setString(7, bean.getAuthor());
      pstmt.setString(8, bean.getLinkA());
      pstmt.setString(9, bean.getLinkB());
      pstmt.setString(10, bean.getLinkC());
      pstmt.setString(11, bean.getImageApath());
      pstmt.setString(12, bean.getImageBpath());
      pstmt.setString(13, bean.getImageCpath());
      pstmt.setInt(14, bean.getBreadcrumbA());
      pstmt.setInt(15, bean.getBreadcrumbB());
      pstmt.setInt(16, bean.getBreadcrumbC());
      pstmt.setString(17, bean.getFileApath());
      pstmt.setString(18, bean.getFileBpath());
      pstmt.setString(19, bean.getFileCpath());
      // pstmt.setNull(20, java.sql.Types.DATE);//default is now()
      pstmt.setBoolean(20, bean.getTop() == 1 ? true : false);
      pstmt.setBoolean(21, bean.getEnabled() == 1 ? true : false);
      pstmt.setBoolean(22, false);
      pstmt.setString(23, bean.getContent_short());
      pstmt.setString(24, bean.getContent_long());

      pstmt.execute();
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      pstmt.close();
      conn.close();
    }
  }
Ejemplo n.º 15
0
  public boolean addEventFeedback(int eventId, String budgetFeedback) {
    String updateStatement = "update eventrequests set feedback_budget=? where id=?;";
    try {
      PreparedStatement statement = connection.prepareStatement(updateStatement);
      statement.setNString(1, budgetFeedback);
      statement.setInt(2, eventId);

      statement.executeUpdate();
      return true;
    } catch (SQLException e) {
      e.printStackTrace();
    }

    return false;
  }
  public boolean insertExperience(String personnelID, Experience exp) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery = "INSERT INTO " + EXPERIENCE_INFO + " VALUES(?,?,?,?,?,?,?,?,?,?,?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);
        ps.setString(1, personnelID);
        ps.setNString(2, exp.getCompName());
        ps.setNString(3, exp.getPos());
        ps.setNString(4, exp.getJob());
        if (exp.getStartDate() == null) {
          ps.setNull(5, java.sql.Types.DATE);
        } else {
          ps.setDate(5, exp.getStartDate());
        }
        if (exp.getEndDate() == null) {
          ps.setNull(6, java.sql.Types.DATE);
        } else {
          ps.setDate(6, exp.getEndDate());
        }
        ps.setNString(7, exp.getReason());
        ps.setNString(8, exp.getReferName());
        ps.setString(9, exp.getReferPhone());
        ps.setString(10, exp.getReferEmail());
        ps.setNString(11, exp.getReferPos());

        if (ps.executeUpdate() < 1) {
          check = false;
        }
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }
    return check;
  }
Ejemplo n.º 17
0
  public void addUser(String username, String password, String position) {
    String hash = Util.SHA256(password);
    String prepared = "insert into users (username, password, position) values (?,?,?);";
    PreparedStatement statement = null;
    try {
      statement = connection.prepareStatement(prepared);
      statement.setNString(1, username);
      statement.setString(2, hash);
      statement.setString(3, position);
      statement.executeUpdate();

      Log.i("Added user " + username + " : " + position);
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
  public boolean updateListTable(String value, String listName) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery = "INSERT INTO " + listName + " VALUES(?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);

        ps.setNString(1, value);

        if (ps.executeUpdate() < 1) {
          check = false;
        }
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }
    return check;
  }
  public boolean updateOfficeList(Office o) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery = "INSERT INTO " + getOFFICE_CB() + " VALUES(?,?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);

        ps.setNString(1, o.getOfficeName());
        ps.setString(2, o.getOfficeNum());

        if (ps.executeUpdate() < 1) {
          check = false;
        }
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }
    return check;
  }
  public boolean insertEducationInfo(String personnelID, Education edu) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery = "INSERT INTO " + EDUCATION + " VALUES(?,?,?,?,?,?,?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);
        ps.setString(1, personnelID);
        ps.setShort(2, edu.getKindID());
        ps.setShort(3, edu.getGraduationID());
        ps.setNString(4, edu.getCourseName());
        ps.setNString(5, edu.getSchoolName());
        ps.setShort(6, edu.getFromYear());
        ps.setShort(7, edu.getToYear());

        if (ps.executeUpdate() < 1) {
          check = false;
        }
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }
    return check;
  }
Ejemplo n.º 21
0
 @Override
 public void setNString(int parameterIndex, String x) throws SQLException {
   stmt.setNString(parameterIndex, x);
   logValue(parameterIndex, x == null ? null : '\'' + x.replace("'", "''") + '\'');
 }
  public boolean updatePersonnelDetails(PersonnelDetails pd) {
    boolean check = false;
    PreparedStatement ps = null;
    if (dbc.connect()) {
      try {
        String sqlQuery =
            "update "
                + PERSONNEL_INFO
                + " set "
                + "HoDem = ? ,"
                + "Ten = ?   ,"
                + "	Nickname = ?,\n"
                + "	MaTrangThai = ?,\n"
                + "	MaLoaiNV = ?,\n"
                + "	MaLoaiHopDong = ?,\n"
                + "	MaChucVu = ?,\n"
                + "	MaPhongBan = ?,\n"
                + "	NgayVao = ?,\n"
                + "	NgayBatDau = ?,\n"
                + "	GioiTinh = ?,\n"
                + "	SDT = ?,\n"
                + "	EmailCty = ?,\n"
                + "	NgayKTthuViec = ?,\n"
                + "	HinhAnh = ?,\n"
                + "	NgaySinh = ?,\n"
                + "	NguyenQuan = ?,\n"
                + "	ThuongTru = ?,\n"
                + "	MaDanToc = ?,\n"
                + "	MaTonGiao = ?,\n"
                + "	MaQuocGia = ?,\n"
                + "	EmailRieng = ?,\n"
                + "	KetHon = ?,\n"
                + "	TrinhDoVH = ?,\n"
                + "	DiaChi = ?,\n"
                + "	SoCMT = ?,\n"
                + "	NgayCap = ?,\n"
                + "	MaTinh = ?,\n"
                + "	SoTK = ?,\n"
                + "	MaNH = ?,\n"
                + "	NoiCap = ?,\n"
                + "	MaSoThue = ?\n"
                + "where MaNV = ?";
        ps = dbc.getConnection().prepareStatement(sqlQuery);
        ps.setNString(1, pd.getlName());
        ps.setNString(2, pd.getfName());
        ps.setNString(3, pd.getNickName());
        ps.setShort(4, pd.getStatusID());
        ps.setShort(5, pd.getKindID());
        ps.setShort(6, pd.getContractID());
        ps.setShort(7, pd.getPosID());
        ps.setShort(8, pd.getOfficeID());

        if (pd.getEnterDate() == null) {
          ps.setNull(9, java.sql.Types.DATE);
        } else {
          ps.setDate(9, pd.getEnterDate());
        }

        if (pd.getStartDate() == null) {
          ps.setNull(10, java.sql.Types.DATE);
        } else {
          ps.setDate(10, pd.getStartDate());
        }

        ps.setBoolean(11, pd.isSex());
        ps.setString(12, pd.getPhoneNum());
        ps.setString(13, pd.getCompEmail());

        if (pd.getEndTraining() == null) {
          ps.setNull(14, java.sql.Types.DATE);
        } else {
          ps.setDate(14, pd.getEndTraining());
        }

        ps.setBytes(15, pd.getPic());

        if (pd.getBirth() == null) {
          ps.setNull(16, java.sql.Types.DATE);
        } else {
          ps.setDate(16, pd.getBirth());
        }
        ps.setNString(17, pd.getPlaceOB());
        ps.setNString(18, pd.getRecentAdd());
        ps.setShort(19, pd.getFolkID());
        ps.setShort(20, pd.getReligionID());
        ps.setShort(21, pd.getNationID());
        ps.setString(22, pd.getPersonalEmail());
        ps.setBoolean(23, pd.isMariage());
        ps.setString(24, pd.getEducation());
        ps.setNString(25, pd.getAdd());
        ps.setString(26, pd.getIDNum());

        if (pd.getIDDay() == null) {
          ps.setNull(27, java.sql.Types.DATE);
        } else {
          ps.setDate(27, pd.getIDDay());
        }
        ps.setShort(28, pd.getRegionID());
        ps.setString(29, pd.getBankCode());
        ps.setShort(30, pd.getBankID());
        ps.setNString(31, pd.getIDPlace());
        ps.setString(32, pd.getTaxCode());
        ps.setString(33, pd.getPersonnelID());

        if (ps.executeUpdate() > 0) {
          check = true;
        }
        dbc.close(ps);
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      } finally {
        dbc.close(ps);
      }
    }

    return check;
  }
Ejemplo n.º 23
0
  private void testClob(int length) throws Exception {
    Random r = new Random(length);
    char[] data = new char[length];

    // Unicode problem:
    // The UCS code values 0xd800-0xdfff (UTF-16 surrogates)
    // as well as 0xfffe and 0xffff (UCS non-characters)
    // should not appear in conforming UTF-8 streams.
    // (String.getBytes("UTF-8") only returns 1 byte for 0xd800-0xdfff)
    for (int i = 0; i < length; i++) {
      char c;
      do {
        c = (char) r.nextInt();
      } while (c >= 0xd800 && c <= 0xdfff);
      data[i] = c;
    }
    Clob c = conn.createClob();
    Writer out = c.setCharacterStream(1);
    out.write(data, 0, data.length);
    out.close();
    stat.execute("delete from test");
    PreparedStatement prep = conn.prepareStatement("insert into test values(?, ?)");

    prep.setInt(1, 1);
    prep.setClob(2, c);
    prep.execute();

    c = conn.createClob();
    c.setString(1, new String(data));
    prep.setInt(1, 2);
    prep.setClob(2, c);
    prep.execute();

    prep.setInt(1, 3);
    prep.setCharacterStream(2, new StringReader(new String(data)));
    prep.execute();

    prep.setInt(1, 4);
    prep.setCharacterStream(2, new StringReader(new String(data)), -1);
    prep.execute();

    NClob nc;
    nc = conn.createNClob();
    nc.setString(1, new String(data));
    prep.setInt(1, 5);
    prep.setNClob(2, nc);
    prep.execute();

    prep.setInt(1, 5);
    prep.setNClob(2, new StringReader(new String(data)));
    prep.execute();

    prep.setInt(1, 6);
    prep.setNClob(2, new StringReader(new String(data)), -1);
    prep.execute();

    prep.setInt(1, 7);
    prep.setNString(2, new String(data));
    prep.execute();

    ResultSet rs;
    rs = stat.executeQuery("select * from test");
    rs.next();
    Clob c2 = rs.getClob(2);
    assertEquals(length, c2.length());
    String s = c.getSubString(1, length);
    String s2 = c2.getSubString(1, length);
    while (rs.next()) {
      c2 = rs.getClob(2);
      assertEquals(length, c2.length());
      s2 = c2.getSubString(1, length);
      assertEquals(s, s2);
    }
  }
 public void setNString(int parameterIndex, String value) throws SQLException {
   delegate.setNString(parameterIndex, value);
 }
  //    public static void main(String[] args) {
  //        PersonnelDAO p = new PersonnelDAO();
  //        p.getPersonnelDetails("NV0001");
  ////////
  ////        String a = p.getPersonnelInfo("TenPhongBan", "tblPhongBan", "MaPhongBan", (short) 1);
  ////        System.out.println(a);
  //////        ArrayList h = p.getList("MaMQH", "tblGiaDinh");
  //////        for (int i = 0; i < h.size(); i++) {
  //////            System.out.println(h.get(i));
  //////        }
  //////////        p.getFamilyDetails("NV0001");
  //////////        p.getHealthStatus("NV0001");
  //////////        p.getEducation("NV0001");
  //////////        p.getSkill("NV0001");
  //////////        p.getExperience("NV0001");
  //////////        p.getDocumentsDetails("NV0001");
  //////////        p.getRowPersonnelListTable();
  ////////        ArrayList<PersonnelBasic> a = p.getRowPersonnelListTable();
  ////////        for (int i = 0; i < a.size(); i++) {
  ////////            System.out.println(a.get(i).getName());
  ////////            System.out.println(a.get(i).getBirth());
  ////////            System.out.println(a.get(i).getOffice());
  //        }
  //    }
  public boolean insertPersonnelDetails(PersonnelDetails pd) {
    boolean check = true;
    PreparedStatement ps;
    if (dbc.connect()) {
      try {
        String sqlQuery =
            "INSERT INTO "
                + PERSONNEL_INFO
                + " VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        ps = dbc.getConnection().prepareStatement(sqlQuery);
        ps.setString(1, pd.getPersonnelID());
        ps.setNString(2, pd.getlName());
        ps.setNString(3, pd.getfName());
        ps.setNString(4, pd.getNickName());
        ps.setShort(5, pd.getStatusID());
        ps.setShort(6, pd.getKindID());
        ps.setShort(7, pd.getContractID());
        ps.setShort(8, pd.getPosID());
        ps.setShort(9, pd.getOfficeID());

        if (pd.getEnterDate() == null) {
          ps.setNull(10, java.sql.Types.DATE);
        } else {
          ps.setDate(10, pd.getEnterDate());
        }

        if (pd.getStartDate() == null) {
          ps.setNull(11, java.sql.Types.DATE);
        } else {
          ps.setDate(11, pd.getStartDate());
        }

        ps.setBoolean(12, pd.isSex());
        ps.setString(13, pd.getPhoneNum());
        ps.setString(14, pd.getCompEmail());

        if (pd.getEndTraining() == null) {
          ps.setNull(15, java.sql.Types.DATE);
        } else {
          ps.setDate(15, pd.getEndTraining());
        }
        ps.setBytes(16, pd.getPic());

        if (pd.getBirth() == null) {
          ps.setNull(17, java.sql.Types.DATE);
        } else {
          ps.setDate(17, pd.getBirth());
        }
        ps.setNString(18, pd.getPlaceOB());
        ps.setNString(19, pd.getRecentAdd());
        ps.setShort(20, pd.getFolkID());
        ps.setShort(21, pd.getReligionID());
        ps.setShort(22, pd.getNationID());
        ps.setString(23, pd.getPersonalEmail());
        ps.setBoolean(24, pd.isMariage());
        ps.setString(25, pd.getEducation());
        ps.setNString(26, pd.getAdd());
        ps.setString(27, pd.getIDNum());

        if (pd.getIDDay() == null) {
          ps.setNull(28, java.sql.Types.DATE);
        } else {
          ps.setDate(28, pd.getIDDay());
        }
        ps.setShort(29, pd.getRegionID());
        ps.setString(30, pd.getBankCode());
        ps.setShort(31, pd.getBankID());
        ps.setNString(32, pd.getIDPlace());
        ps.setString(33, pd.getTaxCode());

        if (ps.executeUpdate() < 1) {
          check = false;
        }
        dbc.close(ps);
      } catch (SQLException ex) {
        Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
      }
    }

    return check;
  }