Пример #1
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;
 }
Пример #2
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;
  }
Пример #3
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;
  }