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;
}
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;
}
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;
}