215 lines
7.4 KiB
Java
215 lines
7.4 KiB
Java
package edu.hsog.db;
|
|
|
|
import javax.swing.*;
|
|
import java.awt.event.ActionEvent;
|
|
import java.awt.event.ActionListener;
|
|
import java.util.ArrayList;
|
|
import java.util.Random;
|
|
|
|
public class GUI {
|
|
public GUI() {
|
|
|
|
slider1.setMinimum(1);
|
|
slider1.setMaximum(5);
|
|
slider1.setMajorTickSpacing(1);
|
|
slider1.setPaintTicks(true);
|
|
slider1.setPaintLabels(true);
|
|
slider1.setValue(3);
|
|
|
|
|
|
exitButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
System.exit(0);
|
|
}
|
|
});
|
|
initConPoolButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
Globals.initConnectionPool();
|
|
conLabel.setText("verbunden");
|
|
}
|
|
});
|
|
countButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
int c = DBQueries.count();
|
|
countJLabel.setText("Count: " + c);
|
|
}
|
|
});
|
|
loginButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
String user = userTextField.getText();
|
|
String passwd = passwdTextField.getText();
|
|
boolean loggedIn = DBQueries.login(user, passwd);
|
|
if (loggedIn) {
|
|
conLabel.setText("logged in");
|
|
|
|
Globals.currentmail = user;
|
|
} else {
|
|
Globals.currentmail = null;
|
|
|
|
conLabel.setText("not logged in");
|
|
}
|
|
}
|
|
});
|
|
loadImageButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
imageLabel.setIcon(Converter.mergeIcons(DBQueries.showAll()));
|
|
|
|
|
|
}
|
|
});
|
|
getImageByZahlGadgetsAscButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
String eingabe = userTextField.getText();
|
|
ImageIcon i = DBQueries.getImage(Integer.parseInt(eingabe));
|
|
imageLabel.setIcon(i);
|
|
}
|
|
});
|
|
getImageByUrlGadgetsURLButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
String urlEingabe = userTextField.getText().trim();
|
|
ImageIcon i = DBQueries.getImageByUrl(urlEingabe);
|
|
imageLabel.setIcon(i);
|
|
}
|
|
});
|
|
getImageByDescGadgetsDescButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
String descEingabe = userTextField.getText().trim();
|
|
ImageIcon i = DBQueries.getImageByDesc(descEingabe);
|
|
imageLabel.setIcon(i);
|
|
}
|
|
});
|
|
|
|
insertImageByURLEmailButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
Random random = new Random();
|
|
int randomNumber = random.nextInt(1000);
|
|
String gadgetUrl = Integer.toString(randomNumber);
|
|
String eingabe = "abc@web.de";
|
|
DBQueries.insertImageUrlEmail(gadgetUrl,eingabe);
|
|
|
|
}
|
|
});
|
|
updateBildLikeKeywordsButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
String eingabe = "%"+userTextField.getText()+"%";
|
|
DBQueries.updateItemLikeKeywords(eingabe);
|
|
}
|
|
});
|
|
iconListEmailButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
ArrayList<Icon>ergebnis = DBQueries.iconListEmail(userTextField.getText());
|
|
imageLabel.setIcon(Converter.mergeIcons(ergebnis));
|
|
|
|
}
|
|
});
|
|
searchGadgetsByUrlButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
|
|
int ergebnis = DBQueries.searchGadgetsUrlIndex(userTextField.getText());
|
|
imageLabel.setText(" :"+ ergebnis);
|
|
}
|
|
});
|
|
zeilenSpaltenButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
int row = Integer.parseInt(userTextField.getText());
|
|
int col = Integer.parseInt((passwdTextField.getText()));
|
|
String ergebnis = DBQueries.zeilenSpalten(row,col);
|
|
imageLabel.setText(ergebnis);
|
|
}
|
|
});
|
|
emailPasswordButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
DTO ergebnis = DBQueries.emailPassword(userTextField.getText());
|
|
|
|
String s1 = ergebnis.email;
|
|
String s2 = ergebnis.password;
|
|
|
|
passwdTextField.setText(s1 +" #" +s2);
|
|
|
|
}
|
|
});
|
|
sumGefallenByURLButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
String eingabe = userTextField.getText();
|
|
passwdTextField.setText(String.valueOf(DBQueries.sumGefallenUrl(eingabe)));
|
|
}
|
|
});
|
|
ersteKommentarButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
String eingabe = userTextField.getText();
|
|
imageLabel.setText(DBQueries.firstKommentar(eingabe));
|
|
}
|
|
});
|
|
getBestRatedGadgetsButton.addActionListener(new ActionListener() {
|
|
@Override
|
|
public void actionPerformed(ActionEvent e) {
|
|
|
|
String eingabe = userTextField.getText();
|
|
passwdTextField.setText(DBQueries.Kommentar(eingabe));
|
|
System.out.println(DBQueries.Kommentar(eingabe));
|
|
}
|
|
});
|
|
|
|
}
|
|
|
|
public JPanel getMasterPanel() {
|
|
return masterPanel;
|
|
}
|
|
|
|
private JPanel masterPanel;
|
|
private JButton exitButton;
|
|
private JButton initConPoolButton;
|
|
private JButton countButton;
|
|
private JLabel conLabel;
|
|
private JLabel countJLabel;
|
|
private JTextField userTextField;
|
|
private JTextField passwdTextField;
|
|
private JButton loginButton;
|
|
private JButton registerButton;
|
|
private JLabel imageLabel;
|
|
private JButton loadImageButton;
|
|
private JSlider slider1;
|
|
private JButton getImageByZahlGadgetsAscButton;
|
|
private JButton getImageByUrlGadgetsURLButton;
|
|
private JButton getImageByDescGadgetsDescButton;
|
|
private JButton insertImageByURLEmailButton;
|
|
private JButton updateBildLikeKeywordsButton;
|
|
private JButton iconListEmailButton;
|
|
private JButton searchGadgetsByUrlButton;
|
|
private JButton zeilenSpaltenButton;
|
|
private JButton emailPasswordButton;
|
|
private JButton sumGefallenByURLButton;
|
|
private JButton ersteKommentarButton;
|
|
private JButton getBestRatedGadgetsButton;
|
|
private JButton addCommentSliderButton;
|
|
private JButton bildButton;
|
|
|
|
|
|
}
|