Beispiel #1
0
  public Podes getPodesForm() {
    Podes baru = new Podes();

    baru.setNKD(getNKD());
    baru.setPengentry(DataStatic.getNimPengentry());
    baru.setB1R5(kuesionerPodes.getListBlok1().get(4).getText());
    baru.setB1R6(kuesionerPodes.getListBlok1().get(5).getText());
    baru.setB1R7(kuesionerPodes.getListBlok1().get(6).getText());
    baru.setB2R2(kuesionerPodes.getListBlok2().get(1).getText());
    baru.setB2R3(kuesionerPodes.getListBlok2().get(2).getText());
    baru.setB2R7(kuesionerPodes.getListBlok2().get(5).getText());
    baru.setB3R1A(kuesionerPodes.getListBlok3().get(0).getInt());
    baru.setB3R1B(kuesionerPodes.getListBlok3().get(1).getInt());
    baru.setB3R1C(kuesionerPodes.getListBlok3().get(2).getInt());
    baru.setB3R1D(kuesionerPodes.getListBlok3().get(3).getInt());
    baru.setB3R1E(kuesionerPodes.getListBlok3().get(4).getInt());
    baru.setB3R1F(kuesionerPodes.getListBlok3().get(5).getInt());
    baru.setB3R1G(kuesionerPodes.getListBlok3().get(6).getInt());
    baru.setB3R2A1(kuesionerPodes.getListBlok3().get(7).getInt());
    baru.setB3R2A2(kuesionerPodes.getListBlok3().get(8).getInt());
    baru.setB3R2B1(kuesionerPodes.getListBlok3().get(9).getInt());
    baru.setB3R2B2(kuesionerPodes.getListBlok3().get(10).getInt());
    baru.setB3R2C1(kuesionerPodes.getListBlok3().get(11).getInt());
    baru.setB3R2C2(kuesionerPodes.getListBlok3().get(12).getInt());
    baru.setB3R2D1(kuesionerPodes.getListBlok3().get(13).getInt());
    baru.setB3R2D2(kuesionerPodes.getListBlok3().get(14).getInt());
    baru.setB3R2E1(kuesionerPodes.getListBlok3().get(15).getInt());
    baru.setB3R2E2(kuesionerPodes.getListBlok3().get(16).getInt());
    baru.setB3R2F1(kuesionerPodes.getListBlok3().get(17).getInt());
    baru.setB3R2F2(kuesionerPodes.getListBlok3().get(18).getInt());
    baru.setB3R2G1(kuesionerPodes.getListBlok3().get(19).getInt());
    baru.setB3R2G2(kuesionerPodes.getListBlok3().get(20).getInt());

    baru.setB3R3A1(kuesionerPodes.getListBlok3().get(21).getNol());
    baru.setB3R3A2(kuesionerPodes.getListBlok3().get(22).getNol());
    baru.setB3R3A3(kuesionerPodes.getListBlok3().get(23).getNol());
    baru.setB3R3A4(kuesionerPodes.getListBlok3().get(24).getNol());
    baru.setB3R3B1(kuesionerPodes.getListBlok3().get(25).getNol());
    baru.setB3R3B2(kuesionerPodes.getListBlok3().get(26).getNol());
    baru.setB3R3B3(kuesionerPodes.getListBlok3().get(27).getNol());
    baru.setB3R3B4(kuesionerPodes.getListBlok3().get(28).getNol());
    baru.setB3R3C1(kuesionerPodes.getListBlok3().get(29).getNol());
    baru.setB3R3C2(kuesionerPodes.getListBlok3().get(30).getNol());
    baru.setB3R3C3(kuesionerPodes.getListBlok3().get(31).getNol());
    baru.setB3R3C4(kuesionerPodes.getListBlok3().get(32).getNol());
    baru.setB3R3D1(kuesionerPodes.getListBlok3().get(33).getNol());
    baru.setB3R3D2(kuesionerPodes.getListBlok3().get(34).getNol());
    baru.setB3R3D3(kuesionerPodes.getListBlok3().get(35).getNol());
    baru.setB3R3D4(kuesionerPodes.getListBlok3().get(36).getNol());
    baru.setB3R3E1(kuesionerPodes.getListBlok3().get(37).getNol());
    baru.setB3R3E2(kuesionerPodes.getListBlok3().get(38).getNol());
    baru.setB3R3E3(kuesionerPodes.getListBlok3().get(39).getNol());
    baru.setB3R3E4(kuesionerPodes.getListBlok3().get(40).getNol());
    baru.setB3R3F1(kuesionerPodes.getListBlok3().get(41).getNol());
    baru.setB3R3F2(kuesionerPodes.getListBlok3().get(42).getNol());
    baru.setB3R3F3(kuesionerPodes.getListBlok3().get(43).getNol());
    baru.setB3R3F4(kuesionerPodes.getListBlok3().get(44).getNol());
    baru.setB3R3G1(kuesionerPodes.getListBlok3().get(45).getNol());
    baru.setB3R3G2(kuesionerPodes.getListBlok3().get(46).getNol());
    baru.setB3R3G3(kuesionerPodes.getListBlok3().get(47).getNol());
    baru.setB3R3G4(kuesionerPodes.getListBlok3().get(48).getNol());
    baru.setB3R4A(kuesionerPodes.getListBlok3().get(49).getInt());
    baru.setB3R4AAlasan(kuesionerPodes.getListBlok3().get(55).getInt());
    baru.setB3R4B(kuesionerPodes.getListBlok3().get(50).getInt());
    baru.setB3R4BAlasan(kuesionerPodes.getListBlok3().get(56).getInt());
    baru.setB3R4C(kuesionerPodes.getListBlok3().get(51).getInt());
    baru.setB3R4D1(kuesionerPodes.getListBlok3().get(52).getInt());
    baru.setB3R4D2(kuesionerPodes.getListBlok3().get(53).getInt());
    baru.setB3R4DLain(kuesionerPodes.getListBlok3().get(54).getInt());
    return baru;
  }
Beispiel #2
0
  public Podes getPodes(String NKS) throws SQLException {
    Podes b = null;
    PreparedStatement ps = null;
    set = null;
    try {
      ps = connection.prepareStatement(getData);
      ps.setString(1, NKS);
      set = ps.executeQuery();
      if (set.next()) {
        b = new Podes();
        b.setNKD(set.getString(1));
        b.setB1R5(set.getString(2));
        b.setB1R6(set.getString(3));
        b.setB1R7(set.getString(4));
        b.setB2R2(set.getString(5));
        b.setB2R3(set.getString(6));
        b.setB2R7(set.getString(7));
        b.setB3R1A(isNull(8));

        b.setB3R1B(isNull(9));
        b.setB3R1C(isNull(10));
        b.setB3R1D(isNull(11));
        b.setB3R1E(isNull(12));
        b.setB3R1F(isNull(13));
        b.setB3R1G(isNull(14));
        b.setB3R2A1(isNull(15));
        b.setB3R2A2(isNull(16));
        b.setB3R2B1(isNull(17));
        b.setB3R2B2(isNull(18));
        b.setB3R2C1(isNull(19));
        b.setB3R2C2(isNull(20));
        b.setB3R2D1(isNull(21));
        b.setB3R2D2(isNull(22));
        b.setB3R2E1(isNull(23));
        b.setB3R2E2(isNull(24));
        b.setB3R2F1(isNull(25));
        b.setB3R2F2(isNull(26));
        b.setB3R2G1(isNull(27));
        b.setB3R2G2(isNull(28));
        b.setB3R3A1(isNull(29));
        b.setB3R3A2(isNull(30));
        b.setB3R3A3(isNull(31));
        b.setB3R3A4(isNull(32));
        b.setB3R3B1(isNull(33));
        b.setB3R3B2(isNull(34));
        b.setB3R3B3(isNull(35));
        b.setB3R3B4(isNull(36));
        b.setB3R3C1(isNull(37));
        b.setB3R3C2(isNull(38));
        b.setB3R3C3(isNull(39));
        b.setB3R3C4(isNull(40));
        b.setB3R3D1(isNull(41));
        b.setB3R3D2(isNull(42));
        b.setB3R3D3(isNull(43));
        b.setB3R3D4(isNull(44));
        b.setB3R3E1(isNull(45));
        b.setB3R3E2(isNull(46));
        b.setB3R3E3(isNull(47));
        b.setB3R3E4(isNull(48));
        b.setB3R3F1(isNull(49));
        b.setB3R3F2(isNull(50));
        b.setB3R3F3(isNull(51));
        b.setB3R3F4(isNull(52));
        b.setB3R3G1(isNull(53));
        b.setB3R3G2(isNull(54));
        b.setB3R3G3(isNull(55));
        b.setB3R3G4(isNull(56));
        b.setB3R4A(isNull(57));
        b.setB3R4AAlasan(isNull(58));
        b.setB3R4B(isNull(59));
        b.setB3R4BAlasan(isNull(60));
        b.setB3R4C(isNull(61));
        b.setB3R4D1(isNull(62));
        b.setB3R4D2(isNull(63));
        b.setB3R4DLain(isNull(64));
      }
    } finally {
      if (ps != null) {
        ps.close();
      }
    }
    return b;
  }
Beispiel #3
0
 public List<Podes> selectAllPodes() throws SQLException {
   List<Podes> list = new ArrayList<Podes>();
   Podes b;
   Statement st = null;
   st = (Statement) connection.createStatement();
   set = st.executeQuery(selectAll);
   while (set.next()) {
     b = new Podes();
     b.setNKD(set.getString(1));
     b.setB1R5(set.getString(6));
     b.setB2R2(set.getString(9));
     b.setB2R3(set.getString(10));
     b.setB2R7(set.getString(12));
     b.setB3R1A(isNull(13));
     b.setB3R1B(isNull(14));
     b.setB3R1C(isNull(15));
     b.setB3R1D(isNull(16));
     b.setB3R1E(isNull(17));
     b.setB3R1F(isNull(18));
     b.setB3R1G(isNull(19));
     b.setB3R2A1(isNull(20));
     b.setB3R2A2(isNull(21));
     b.setB3R2B1(isNull(22));
     b.setB3R2B2(isNull(23));
     b.setB3R2C1(isNull(24));
     b.setB3R2C2(isNull(25));
     b.setB3R2D1(isNull(26));
     b.setB3R2D2(isNull(27));
     b.setB3R2E1(isNull(28));
     b.setB3R2E2(isNull(29));
     b.setB3R2F1(isNull(30));
     b.setB3R2F2(isNull(31));
     b.setB3R2G1(isNull(32));
     b.setB3R2G2(isNull(33));
     b.setB3R3A1(isNull(34));
     b.setB3R3A2(isNull(35));
     b.setB3R3A3(isNull(36));
     b.setB3R3A4(isNull(37));
     b.setB3R3B1(isNull(38));
     b.setB3R3B2(isNull(39));
     b.setB3R3B3(isNull(40));
     b.setB3R3B4(isNull(41));
     b.setB3R3C1(isNull(42));
     b.setB3R3C2(isNull(43));
     b.setB3R3C3(isNull(44));
     b.setB3R3C4(isNull(45));
     b.setB3R3D1(isNull(46));
     b.setB3R3D2(isNull(47));
     b.setB3R3D3(isNull(48));
     b.setB3R3D4(isNull(49));
     b.setB3R3E1(isNull(50));
     b.setB3R3E2(isNull(51));
     b.setB3R3E3(isNull(52));
     b.setB3R3E4(isNull(53));
     b.setB3R3F1(isNull(54));
     b.setB3R3F2(isNull(55));
     b.setB3R3F3(isNull(56));
     b.setB3R3F4(isNull(57));
     b.setB3R3G1(isNull(58));
     b.setB3R3G2(isNull(59));
     b.setB3R3G3(isNull(60));
     b.setB3R3G4(isNull(61));
     b.setB3R4A(isNull(62));
     b.setB3R4B(isNull(63));
     b.setB3R4C(isNull(64));
     b.setB3R4D1(isNull(65));
     b.setB3R4D2(isNull(66));
     b.setB3R4DLain(isNull(67));
     list.add(b);
   }
   return list;
 }
Beispiel #4
0
 public void updatePodes() throws SQLException {
   pst = null;
   Podes Podes = getPodesForm();
   try {
     pst = connection.prepareStatement(update);
     pst.setString(1, Podes.getB1R5());
     pst.setString(2, Podes.getB2R2());
     pst.setString(3, Podes.getB2R3());
     pst.setString(4, Podes.getB2R7());
     cek(5, Podes.getB3R1A());
     cek(6, Podes.getB3R1B());
     cek(7, Podes.getB3R1C());
     cek(8, Podes.getB3R1D());
     cek(9, Podes.getB3R1E());
     cek(10, Podes.getB3R1F());
     cek(11, Podes.getB3R1G());
     cek(12, Podes.getB3R2A1());
     cek(13, Podes.getB3R2A2());
     cek(14, Podes.getB3R2B1());
     cek(15, Podes.getB3R2B2());
     cek(16, Podes.getB3R2C1());
     cek(17, Podes.getB3R2C2());
     cek(18, Podes.getB3R2D1());
     cek(19, Podes.getB3R2D2());
     cek(20, Podes.getB3R2E1());
     cek(21, Podes.getB3R2E2());
     cek(22, Podes.getB3R2F1());
     cek(23, Podes.getB3R2F2());
     cek(24, Podes.getB3R2G1());
     cek(25, Podes.getB3R2G2());
     cek(26, Podes.getB3R3A1());
     cek(27, Podes.getB3R3A2());
     cek(28, Podes.getB3R3A3());
     cek(29, Podes.getB3R3A4());
     cek(30, Podes.getB3R3B1());
     cek(31, Podes.getB3R3B2());
     cek(32, Podes.getB3R3B3());
     cek(33, Podes.getB3R3B4());
     cek(34, Podes.getB3R3C1());
     cek(35, Podes.getB3R3C2());
     cek(36, Podes.getB3R3C3());
     cek(37, Podes.getB3R3C4());
     cek(38, Podes.getB3R3D1());
     cek(39, Podes.getB3R3D2());
     cek(40, Podes.getB3R3D3());
     cek(41, Podes.getB3R3D4());
     cek(42, Podes.getB3R3E1());
     cek(43, Podes.getB3R3E2());
     cek(44, Podes.getB3R3E3());
     cek(45, Podes.getB3R3E4());
     cek(46, Podes.getB3R3F1());
     cek(47, Podes.getB3R3F2());
     cek(48, Podes.getB3R3F3());
     cek(49, Podes.getB3R3F4());
     cek(50, Podes.getB3R3G1());
     cek(51, Podes.getB3R3G2());
     cek(52, Podes.getB3R3G3());
     cek(53, Podes.getB3R3G4());
     cek(54, Podes.getB3R4A());
     cek(55, Podes.getB3R4AAlasan());
     cek(56, Podes.getB3R4B());
     cek(57, Podes.getB3R4BAlasan());
     cek(58, Podes.getB3R4C());
     cek(59, Podes.getB3R4D1());
     cek(60, Podes.getB3R4D2());
     cek(61, Podes.getB3R4DLain());
     pst.setString(62, Podes.getB1R6());
     pst.setString(63, Podes.getB1R7());
     pst.setString(64, Podes.getNKD());
     pst.executeUpdate();
   } finally {
     if (pst != null) {
       pst.close();
     }
   }
 }