public static void f3(String Host, String SID) {
int d1 = 0;
int d2 = 0;
int anrX1 = 0;
int anrX2 = 0;
int anrX3 = 0;
int anrFix = 0;
String Aus = "";
final JFrame f = new JFrame("ID");
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
f.setLayout(null);
f.setSize(380,150);
java.awt.Dimension mD = java.awt.Toolkit.getDefaultToolkit()
.getScreenSize();
java.awt.Dimension fD = f.getSize();
f.setLocation((int) ((mD.getWidth() - fD.getWidth()) / 2), (int) ((mD
.getHeight() - fD.getHeight()) / 2));
JLabel l1 = new JLabel(Host + "@" + SID);
l1.setForeground(Color.BLUE);
l1.setBounds(80, 3, 175, 15);
f.add(l1);
JLabel l2 = new JLabel("JAHR");
l2.setForeground(Color.BLUE);
l2.setBounds(10, 30, 75, 15);
f.add(l2);
JLabel l3 = new JLabel("MANDANT");
l3.setForeground(Color.BLUE);
l3.setBounds(130, 30, 75, 15);
f.add(l3);
JLabel l4 = new JLabel("ANWENDER");
l4.setForeground(Color.BLUE);
l4.setBounds(250, 30, 75, 15);
f.add(l4);
SelectOut[] E = new SelectOut[0];
E = Conn.Connection(Host, SID);
SelectOut[] Ezwi = new SelectOut[E.length];
for (int i = 0; i < E.length; i++) {
Ezwi[i] = new SelectOut(E[i].jahr, E[i].hhj_id, E[i].ANW_ANW_ID,
E[i].MAN_MAN_NR, E[i].ANW_NR);
}
final SelectOut[] Efix = Ezwi;
// System.out.println(E);
// System.out.println(Efix);
final JButton Change = new JButton("Change");
f.getContentPane().add(Change);
Change.setPreferredSize(new java.awt.Dimension(65, 35));
f.add(Change);
Change.setBounds(2, 1, 80, 20);
final JButton Search = new JButton("Search");
f.getContentPane().add(Search);
Search.setPreferredSize(new java.awt.Dimension(65, 35));
f.add(Search);
Search.setBounds(10, 100, 350, 20);
int zaehler1 = E.length; // Länge vom Array als Zähler
int d = 0;
for (anrX1 = 0; anrX1 < E.length; anrX1++) {
if (E[anrX1].jahr == 0) {
continue;
} else {
anrX3 = E[anrX1].jahr;
d = 0;
// }
for (anrX2 = 0; anrX2 < E.length; anrX2++) {
if (d == 1 && anrX3 == E[anrX2].jahr) {
E[anrX2].jahr = 0;
} else if (anrX3 == E[anrX2].jahr) {
d = 1;
}
}
}
}
boolean vertauscht = false;
do {
vertauscht = false;
for (int i = 0; i == zaehler1 - 1; i++) {
if (E[i].jahr > E[i + 1].jahr) {
int temp = 0;
temp = E[i].jahr;
E[i].jahr = E[i + 1].jahr;
E[i + 1].jahr = temp;
vertauscht = true;
} // end if
}
zaehler1 = zaehler1 - 1;
} while (vertauscht == true);
zaehler1 = 0;
for (int i = 0; i < E.length; i++) {
if (E[i].jahr != 0) {
zaehler1 = zaehler1 + 1;
}
}
String[] s1 = new String[zaehler1];
zaehler1 = 0;
for (int i = 0; i < E.length; i++) {
if (E[i].jahr != 0) {
s1[zaehler1] = E[i].jahr + "";
zaehler1++;
}
}
zaehler1 = E.length; // Länge vom Array als Zähler
d = 0;
for (anrX1 = 0; anrX1 < E.length; anrX1++) {
if (E[anrX1].MAN_MAN_NR == 0) {
continue;
} else {
anrX3 = E[anrX1].MAN_MAN_NR;
d = 0;
// }
for (anrX2 = 0; anrX2 < E.length; anrX2++) {
if (d == 1 && anrX3 == E[anrX2].MAN_MAN_NR) {
E[anrX2].MAN_MAN_NR = 0;
} else if (anrX3 == E[anrX2].MAN_MAN_NR) {
d = 1;
}
}
}
}
vertauscht = false;
do {
vertauscht = false;
for (int i = 0; i == zaehler1 - 1; i++) {
if (E[i].MAN_MAN_NR > E[i + 1].MAN_MAN_NR) {
int temp = 0;
temp = E[i].MAN_MAN_NR;
E[i].MAN_MAN_NR = E[i + 1].MAN_MAN_NR;
E[i + 1].MAN_MAN_NR = temp;
vertauscht = true;
} // end if
}
zaehler1 = zaehler1 - 1;
} while (vertauscht == true);
zaehler1 = 0;
for (int i = 0; i < E.length; i++) {
if (E[i].MAN_MAN_NR != 0) {
zaehler1 = zaehler1 + 1;
}
}
String[] s2 = new String[zaehler1];
zaehler1 = 0;
for (int i = 0; i < E.length; i++) {
if (E[i].MAN_MAN_NR != 0) {
s2[zaehler1] = E[i].MAN_MAN_NR + "";
zaehler1++;
}
}
zaehler1 = E.length; // Länge vom Array als Zähler
d = 0;
for (anrX1 = 0; anrX1 < E.length; anrX1++) {
if (E[anrX1].ANW_NR == -1) {
continue;
} else {
anrX3 = E[anrX1].ANW_NR;
d = 0;
// }
for (anrX2 = 0; anrX2 < E.length; anrX2++) {
if (d == 1 && anrX3 == E[anrX2].ANW_NR) {
E[anrX2].ANW_NR = -1;
} else if (anrX3 == E[anrX2].ANW_NR) {
d = 1;
}
}
}
}
vertauscht = false;
do {
vertauscht = false;
for (int i = 0; i == zaehler1 - 1; i++) {
if (E[i].ANW_NR > E[i + 1].ANW_NR) {
int temp = 0;
temp = E[i].ANW_NR;
E[i].ANW_NR = E[i + 1].ANW_NR;
E[i + 1].ANW_NR = temp;
vertauscht = true;
} // end if
}
zaehler1 = zaehler1 - 1;
} while (vertauscht == true);
zaehler1 = 0;
for (int i = 0; i < E.length; i++) {
if (E[i].ANW_NR != -1) {
zaehler1 = zaehler1 + 1;
}
}
String[] s3 = new String[zaehler1];
zaehler1 = 0;
for (int i = 0; i < E.length; i++) {
if (E[i].ANW_NR != -1) {
s3[zaehler1] = E[i].ANW_NR + "";
zaehler1++;
}
}
final String[] s1fix = s1;
final String[] s2fix = s2;
final String[] s3fix = s3;
final JComboBox Jahr = new JComboBox(s1);
Jahr.setSelectedIndex(0);
Jahr.setBounds(10, 45, 110, 20);
Jahr.setForeground(Color.BLACK);
f.add(Jahr);
final JComboBox Man = new JComboBox(s2);
Man.setSelectedIndex(0);
Man.setBounds(130, 45, 110, 20);
Man.setForeground(Color.BLACK);
f.add(Man);
final JComboBox Anw = new JComboBox(s3);
Anw.setSelectedIndex(0);
Anw.setBounds(250, 45, 110, 20);
Anw.setForeground(Color.BLACK);
f.add(Anw);
ActionListener a1 = new ActionListener() {
public void actionPerformed(ActionEvent e) {
los();
f.setVisible(false);
}
};
Change.addActionListener(a1);
ActionListener a2 = new ActionListener() {
public void actionPerformed(ActionEvent e) {
JLabel le1 = new JLabel();
le1.setForeground(Color.RED);
le1.setBounds(10, 75, 75, 15);
f.add(le1);
JLabel le2 = new JLabel();
le2.setForeground(Color.RED);
le2.setBounds(130, 75, 75, 15);
f.add(le2);
JLabel le3 = new JLabel();
le3.setForeground(Color.RED);
le3.setBounds(250, 75, 75, 15);
f.add(le3);
String jw = s1fix[Jahr.getSelectedIndex()];
String mw = s2fix[Man.getSelectedIndex()];
String aw = s3fix[Anw.getSelectedIndex()];
int indexoutput = -1;
for (int i = 0; i < Efix.length; i++) {
// System.out.println(Efix[1].jahr+ "");
// System.out.println(Efix[i].MAN_MAN_NR+"");
// System.out.println(Efix[i].ANW_ANW_ID+"");
if ((jw.equals(Efix[i].jahr + ""))
& (mw.equals(Efix[i].MAN_MAN_NR + ""))
& aw.equals(Efix[i].ANW_NR + "")) {
indexoutput = i;
}
}
if (indexoutput != -1) {
le1.setText("hhj_id: " + Efix[indexoutput].hhj_id + "");
le2.setText("Man_NR: " + Efix[indexoutput].MAN_MAN_NR + "");
le3.setText("Anw_ID: " + Efix[indexoutput].ANW_ANW_ID + "");
} else {
le1.setText("Fehler: Datensatz nicht vorhanden!");
}
}
};
Search.addActionListener(a2);
f.setVisible(true);
}
}