Code:
/*
* Application.java
*
* Created on 19. Februar 2004, 14:19
*/
package pulververwaltung5;
/**
*
* @author userfritz
* @version
*/
import java.awt.*;
import java.sql.*;
import javax.swing.*;
public class Application extends javax.swing.JFrame {
// Diese Eintraege werden zum Verbindungsaufbau zur Datenbank benoetigt.
static String hostname = "localhost";
static String port = "3306";
static String dbname = "pulververwaltung";
static String user = "root";
static String password = "";
/** Creates new form Application */
public Application() {
initComponents ();
setSize(1200,800);
setVisible(true);
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the FormEditor.
*/
private void initComponents() {
menuBar = new javax.swing.JMenuBar();
fileMenu = new javax.swing.JMenu();
nPulver = new javax.swing.JMenuItem();
sPulver = new javax.swing.JMenuItem();
exitMenuItem = new javax.swing.JMenuItem();
helpMenu = new javax.swing.JMenu();
contentsMenuItem = new javax.swing.JMenuItem();
aboutMenuItem = new javax.swing.JMenuItem();
fileMenu.setText("File");
nPulver.setText("Neues Pulver erfassen");
nPulver.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
nPulverActionPerformed(evt);
}
}
);
fileMenu.add(nPulver);
sPulver.setText("Pulver suchen");
sPulver.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
sPulverActionPerformed(evt);
}
}
);
fileMenu.add(sPulver);
exitMenuItem.setText("Exit");
exitMenuItem.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
exitMenuItemActionPerformed(evt);
}
}
);
fileMenu.add(exitMenuItem);
menuBar.add(fileMenu);
helpMenu.setText("Help");
contentsMenuItem.setText("Contents");
helpMenu.add(contentsMenuItem);
aboutMenuItem.setText("About");
helpMenu.add(aboutMenuItem);
menuBar.add(helpMenu);
getContentPane().setLayout(null);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowClosing(java.awt.event.WindowEvent evt) {
exitForm(evt);
}
}
);
setJMenuBar(menuBar);
}
private void sPulverActionPerformed(java.awt.event.ActionEvent evt) {
// Add your handling code here:
suchePulverPanel suchePulverPanel = new suchePulverPanel();
setContentPane(suchePulverPanel);
//Nur für die aktualisierung des Frames
setSize(1200,801);
setSize(1200,800);
}
private void nPulverActionPerformed(java.awt.event.ActionEvent evt) {
// Add your handling code here:
JPanel neuesPulver = new JPanel();
setContentPane(neuesPulver);
//Nur für die aktualisierung des Frames
setSize(1200,801);
setSize(1200,800);
}
private void exitMenuItemActionPerformed (java.awt.event.ActionEvent evt) {
System.exit (0);
}
/** Exit the Application */
private void exitForm(java.awt.event.WindowEvent evt) {
System.exit (0);
}
/**
* @param args the command line arguments
*/
public static void main (String args[]) {
new Application ().show ();
}
// Variables declaration - do not modify
private javax.swing.JMenuBar menuBar;
private javax.swing.JMenu fileMenu;
private javax.swing.JMenuItem nPulver;
private javax.swing.JMenuItem sPulver;
private javax.swing.JMenuItem exitMenuItem;
private javax.swing.JMenu helpMenu;
private javax.swing.JMenuItem contentsMenuItem;
private javax.swing.JMenuItem aboutMenuItem;
// End of variables declaration
}
Code:
/*
* JPanel.java
*
* Created on 19. Februar 2004, 14:22
*/
package pulververwaltung5;
/**
*
* @author userfritz
* @version
*/
import java.awt.*;
import java.sql.*;
import javax.swing.*;
public class JPanel extends javax.swing.JPanel {
/** Creates new form JPanel */
public JPanel() {
initComponents();
Drop DropDown = new Drop();
DropDown.DropDown();
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the FormEditor.
*/
private void initComponents() {
jMenuItem1 = new javax.swing.JMenuItem();
jMenuItem2 = new javax.swing.JMenuItem();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jLabel6 = new javax.swing.JLabel();
jTextField2 = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
jTextField3 = new javax.swing.JTextField();
jLabel8 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
jLabel10 = new javax.swing.JLabel();
jLabel11 = new javax.swing.JLabel();
jTextField4 = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jComboBox1 = new javax.swing.JComboBox();
jComboBox2 = new javax.swing.JComboBox();
jComboBox3 = new javax.swing.JComboBox();
jComboBox4 = new javax.swing.JComboBox();
jComboBox5 = new javax.swing.JComboBox();
jComboBox6 = new javax.swing.JComboBox();
jComboBox7 = new javax.swing.JComboBox();
jMenuItem1.setText("Neues Pulver erfassen");
jMenuItem2.setText("Neues Pulver erfassen");
setLayout(null);
jLabel1.setText("Hersteller");
add(jLabel1);
jLabel1.setLocation(70, 90);
jLabel1.setSize(jLabel1.getPreferredSize());
jLabel2.setText("Qualit\u00e4t");
add(jLabel2);
jLabel2.setLocation(70, 130);
jLabel2.setSize(jLabel2.getPreferredSize());
jLabel3.setText("Glanzgrad");
add(jLabel3);
jLabel3.setLocation(70, 170);
jLabel3.setSize(jLabel3.getPreferredSize());
jLabel4.setText("Oberfl\u00e4che");
add(jLabel4);
jLabel4.setLocation(70, 210);
jLabel4.setSize(jLabel4.getPreferredSize());
jLabel5.setText("Menge");
add(jLabel5);
jLabel5.setLocation(70, 250);
jLabel5.setSize(jLabel5.getPreferredSize());
add(jTextField1);
jTextField1.setBounds(170, 240, 210, 30);
jLabel6.setText("Beschrieb");
add(jLabel6);
jLabel6.setLocation(70, 290);
jLabel6.setSize(jLabel6.getPreferredSize());
add(jTextField2);
jTextField2.setBounds(170, 280, 210, 30);
jLabel7.setText("Preis");
add(jLabel7);
jLabel7.setLocation(70, 330);
jLabel7.setSize(jLabel7.getPreferredSize());
add(jTextField3);
jTextField3.setBounds(170, 320, 210, 30);
jLabel8.setText("Farbsystem");
add(jLabel8);
jLabel8.setLocation(70, 370);
jLabel8.setSize(jLabel8.getPreferredSize());
jLabel9.setText("Farbcode");
add(jLabel9);
jLabel9.setLocation(70, 410);
jLabel9.setSize(jLabel9.getPreferredSize());
jLabel10.setText("Ver\u00f6ffentlichen");
add(jLabel10);
jLabel10.setLocation(70, 450);
jLabel10.setSize(jLabel10.getPreferredSize());
jLabel11.setText("ArtikelNr");
add(jLabel11);
jLabel11.setLocation(70, 490);
jLabel11.setSize(jLabel11.getPreferredSize());
add(jTextField4);
jTextField4.setBounds(170, 480, 210, 30);
jButton1.setText("Speichern");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
}
);
add(jButton1);
jButton1.setLocation(170, 540);
jButton1.setSize(jButton1.getPreferredSize());
add(jComboBox1);
jComboBox1.setBounds(170, 80, 210, 30);
add(jComboBox2);
jComboBox2.setBounds(170, 120, 210, 30);
add(jComboBox3);
jComboBox3.setBounds(170, 160, 210, 30);
add(jComboBox4);
jComboBox4.setBounds(170, 200, 210, 30);
add(jComboBox5);
jComboBox5.setBounds(170, 360, 210, 30);
add(jComboBox6);
jComboBox6.setBounds(170, 400, 210, 30);
add(jComboBox7);
jComboBox7.setBounds(170, 440, 210, 30);
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// Add your handling code here:
//Variablen auf Standardwerte setzen
int SavLagerort = 0;
String SavMenge = "";
String SavBeschrieb = "";
int FarbID = 0;
int SavVeröffentlichen = 0;
String SavPreis = "";
String SavArtikelNr = "";
int SavHersteller = 0;
String SavQualität = "";
String SavGlanzgrad = "";
String SavOberfläche = "";
//Holt die Daten von den Objekten der GUI und speichert sie in der Datenbank
SavQualität = jComboBox2.getSelectedItem().toString();
SavGlanzgrad = jComboBox3.getSelectedItem().toString();
SavOberfläche = jComboBox4.getSelectedItem().toString();
int SavFarbsystem = (jComboBox5.getSelectedIndex() + 1);
int SavFarbcode = (jComboBox6.getSelectedIndex() + 1);
SavHersteller = (jComboBox1.getSelectedIndex() + 1);
SavMenge = jTextField1.getText();
SavBeschrieb = jTextField2.getText();
SavPreis = jTextField3.getText();
SavVeröffentlichen = jComboBox7.getSelectedIndex();
SavArtikelNr = jTextField4.getText();
//Datenbankverbindung aufbauen
Connection conn = null;
try {
//Datenbanktreiber laden
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch (Exception e) {
System.err.println("Unable to load driver.");
e.printStackTrace();
}
try {
//Datenbankverbindung aufbauen
String url = "jdbc:mysql://"+Application.hostname+":"+Application.port+"/"+Application.dbname;
conn = DriverManager.getConnection(url, Application.user, Application.password);
Statement stmt=conn.createStatement();
//FarbID wird aus der Datenbank abgefragt
ResultSet rs = stmt.executeQuery("SELECT FarbcodeID,FarbsystemID,FarbID FROM farbid WHERE FarbcodeID = " + SavFarbcode + " AND FarbsystemID = " + SavFarbsystem);
while(rs.next()){
//Gibt mehrere freie Lagerplätze zurück
FarbID = rs.getInt("FarbID");
}
//Datenbankverbindung beenden, Statement beenden, ResultSet beenden
rs.close();
stmt.close();
conn.close();
}
catch (SQLException sqle) {
System.out.println("SQLException: " + sqle.getMessage());
System.out.println("SQLState: " + sqle.getSQLState());
System.out.println("VendorError: " + sqle.getErrorCode());
sqle.printStackTrace();
}
//Berechnet einen freien Lagerplatz--------------------------------------------
try {
//Datenbankverbindung aufbauen
String url = "jdbc:mysql://"+Application.hostname+":"+Application.port+"/"+Application.dbname;
conn = DriverManager.getConnection(url, Application.user, Application.password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM lagerorte WHERE Besetzt='0'");
while(rs.next()){
SavLagerort = rs.getInt("LagerortID");
}
//Datenbankverbindung beenden, Statement beenden, ResultSet beenden
rs.close();
stmt.close();
conn.close();
}
catch (SQLException sqle) {
System.out.println("SQLException: " + sqle.getMessage());
System.out.println("SQLState: " + sqle.getSQLState());
System.out.println("VendorError: " + sqle.getErrorCode());
sqle.printStackTrace();
}
//Neues Pulver in die Datenbank speichern
try {
//Datenbankverbindung aufbauen
String url = "jdbc:mysql://"+Application.hostname+":"+Application.port+"/"+Application.dbname;
conn = DriverManager.getConnection(url, Application.user, Application.password);
Statement stmt=conn.createStatement();
String sql = "INSERT INTO pulver (LagerortID,Menge,Beschrieb,FarbID,Veröffentlichen,Preis,ArtikelNr,HerstellerID,Qualität,Glanzgrad,Oberfläche) VALUES "
+ "(" +
"'" + SavLagerort + "'"
+ "," + "'" + SavMenge + "'"
+ "," + "'" + SavBeschrieb + "'"
+ "," + "'" + FarbID + "'"
+ "," + "'" + SavVeröffentlichen + "'"
+ "," + "'" + SavPreis + "'"
+ "," + "'" + SavArtikelNr + "'"
+ "," + "'" + SavHersteller + "'"
+ "," + "'" + SavQualität + "'"
+ "," + "'" + SavGlanzgrad + "'"
+ "," + "'" + SavOberfläche + "'"
+ ")";
System.out.println(sql);
stmt.executeUpdate(sql);
//Datenbankverbindung beenden, Statement beenden, ResultSet beenden
stmt.close();
conn.close();
}
catch (SQLException sqle) {
System.out.println("SQLException: " + sqle.getMessage());
System.out.println("SQLState: " + sqle.getSQLState());
System.out.println("VendorError: " + sqle.getErrorCode());
sqle.printStackTrace();
}
}
//Herstellerliste in das Dropdown Menü einfügen----------------------------------
class Drop {
public void DropDown() {
Connection conn = null;
//Datenbankverbindung aufbauen
try {
//Datenbanktreiber laden
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch (Exception e) {
System.err.println("Unable to load driver.");
e.printStackTrace();
}
try {
//Datenbankverbindung aufbauen
String url = "jdbc:mysql://"+Application.hostname+":"+Application.port+"/"+Application.dbname;
conn = DriverManager.getConnection(url, Application.user, Application.password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM hersteller");
while(rs.next()){
jComboBox1.addItem(rs.getString("hersteller"));
}
//Datenbankverbindung beenden, Statement beenden, ResultSet beenden
rs.close();
stmt.close();
conn.close();
}
catch (SQLException sqle) {
System.out.println("SQLException: " + sqle.getMessage());
System.out.println("SQLState: " + sqle.getSQLState());
System.out.println("VendorError: " + sqle.getErrorCode());
sqle.printStackTrace();
}
//DropDownMenu für Qualität Glanzgrad und Oberfläche machen----------------------------------
//Qualität
jComboBox2.addItem("aussen");
jComboBox2.addItem("innen");
//Glanzgrad
jComboBox3.addItem("matt");
jComboBox3.addItem("seidenglanz");
//Oberfläche
jComboBox4.addItem("glatt");
//DropDown Menu für Farbsystemliste----------------------------------------------------
try {
//Datenbankverbindung aufbauen
String url = "jdbc:mysql://"+Application.hostname+":"+Application.port+"/"+Application.dbname;
conn = DriverManager.getConnection(url, Application.user, Application.password);
//Herstellerliste in das Dropdown Menü einfügen
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM farbsystem");
while(rs.next()){
jComboBox5.addItem(rs.getString("Farbsystem"));
}
//Datenbankverbindung beenden, Statement beenden, ResultSet beenden
rs.close();
stmt.close();
conn.close();
}
catch (SQLException sqle) {
System.out.println("SQLException: " + sqle.getMessage());
System.out.println("SQLState: " + sqle.getSQLState());
System.out.println("VendorError: " + sqle.getErrorCode());
sqle.printStackTrace();
}
//Farbcodeliste hinzufügen-----------------------------------------------------------------
try {
//Datenbankverbindung aufbauen
String url = "jdbc:mysql://"+Application.hostname+":"+Application.port+"/"+Application.dbname;
conn = DriverManager.getConnection(url, Application.user, Application.password);
//Herstellerliste in das Dropdown Menü einfügen
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM farbcode");
while(rs.next()){
jComboBox6.addItem(rs.getString("Farbcode"));
}
//Datenbankverbindung beenden, Statement beenden, ResultSet beenden
rs.close();
stmt.close();
conn.close();
}
catch (SQLException sqle) {
System.out.println("SQLException: " + sqle.getMessage());
System.out.println("SQLState: " + sqle.getSQLState());
System.out.println("VendorError: " + sqle.getErrorCode());
sqle.printStackTrace();
}
//DropDown Menü Veröffentlichen
jComboBox7.addItem("Nein");
jComboBox7.addItem("Ja");
}
}
// Variables declaration - do not modify
private javax.swing.JMenuItem jMenuItem1;
private javax.swing.JMenuItem jMenuItem2;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JTextField jTextField1;
private javax.swing.JLabel jLabel6;
private javax.swing.JTextField jTextField2;
private javax.swing.JLabel jLabel7;
private javax.swing.JTextField jTextField3;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JTextField jTextField4;
private javax.swing.JButton jButton1;
private javax.swing.JComboBox jComboBox1;
private javax.swing.JComboBox jComboBox2;
private javax.swing.JComboBox jComboBox3;
private javax.swing.JComboBox jComboBox4;
private javax.swing.JComboBox jComboBox5;
private javax.swing.JComboBox jComboBox6;
private javax.swing.JComboBox jComboBox7;
// End of variables declaration
}
Code:
/*
* suchePulverPanel.java
*
* Created on 20. Februar 2004, 14:26
*/
package pulververwaltung5;
/**
*
* @author userfritz
* @version
*/
public class suchePulverPanel extends javax.swing.JPanel {
/** Creates new form suchePulverPanel */
public suchePulverPanel() {
initComponents();
//JPanel.Drop DropDown = new JPanel.Drop();
//DropDown.DropDown();
Code:
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the FormEditor.
*/
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jComboBox1 = new javax.swing.JComboBox();
jLabel2 = new javax.swing.JLabel();
jComboBox2 = new javax.swing.JComboBox();
jLabel3 = new javax.swing.JLabel();
jComboBox3 = new javax.swing.JComboBox();
jComboBox4 = new javax.swing.JComboBox();
jTextField1 = new javax.swing.JTextField();
jTextField2 = new javax.swing.JTextField();
jTextField3 = new javax.swing.JTextField();
jComboBox5 = new javax.swing.JComboBox();
jComboBox6 = new javax.swing.JComboBox();
jComboBox7 = new javax.swing.JComboBox();
jTextField4 = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
jLabel8 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
jLabel10 = new javax.swing.JLabel();
jLabel11 = new javax.swing.JLabel();
setLayout(null);
jLabel1.setText("Hersteller");
add(jLabel1);
jLabel1.setLocation(70, 90);
jLabel1.setSize(jLabel1.getPreferredSize());
add(jComboBox1);
jComboBox1.setBounds(170, 80, 210, 30);
jLabel2.setText("Qualit\u00e4t");
add(jLabel2);
jLabel2.setLocation(70, 130);
jLabel2.setSize(jLabel2.getPreferredSize());
add(jComboBox2);
jComboBox2.setBounds(170, 120, 210, 30);
jLabel3.setText("Glanzgrad");
add(jLabel3);
jLabel3.setLocation(70, 170);
jLabel3.setSize(jLabel3.getPreferredSize());
add(jComboBox3);
jComboBox3.setBounds(170, 160, 210, 30);
add(jComboBox4);
jComboBox4.setBounds(170, 200, 210, 30);
add(jTextField1);
jTextField1.setBounds(170, 240, 210, 30);
add(jTextField2);
jTextField2.setBounds(170, 280, 210, 30);
add(jTextField3);
jTextField3.setBounds(170, 320, 210, 30);
add(jComboBox5);
jComboBox5.setBounds(170, 360, 210, 30);
add(jComboBox6);
jComboBox6.setBounds(170, 400, 210, 30);
add(jComboBox7);
jComboBox7.setBounds(170, 440, 210, 30);
add(jTextField4);
jTextField4.setBounds(170, 480, 210, 30);
jButton1.setText("Suchen");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
}
);
add(jButton1);
jButton1.setLocation(170, 540);
jButton1.setSize(jButton1.getPreferredSize());
jLabel4.setText("ArtikelNr");
add(jLabel4);
jLabel4.setLocation(70, 490);
jLabel4.setSize(jLabel4.getPreferredSize());
jLabel5.setText("Ver\u00f6ffentlichen");
add(jLabel5);
jLabel5.setLocation(70, 450);
jLabel5.setSize(jLabel5.getPreferredSize());
jLabel6.setText("Farbcode");
add(jLabel6);
jLabel6.setLocation(70, 410);
jLabel6.setSize(jLabel6.getPreferredSize());
jLabel7.setText("Farbsystem");
add(jLabel7);
jLabel7.setLocation(70, 370);
jLabel7.setSize(jLabel7.getPreferredSize());
jLabel8.setText("Preis");
add(jLabel8);
jLabel8.setLocation(70, 330);
jLabel8.setSize(jLabel8.getPreferredSize());
jLabel9.setText("Beschrieb");
add(jLabel9);
jLabel9.setLocation(70, 290);
jLabel9.setSize(jLabel9.getPreferredSize());
jLabel10.setText("Menge");
add(jLabel10);
jLabel10.setLocation(70, 250);
jLabel10.setSize(jLabel10.getPreferredSize());
jLabel11.setText("Oberfl\u00e4che");
add(jLabel11);
jLabel11.setLocation(70, 210);
jLabel11.setSize(jLabel11.getPreferredSize());
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// Add your handling code here:
}
// Variables declaration - do not modify
private javax.swing.JLabel jLabel1;
private javax.swing.JComboBox jComboBox1;
private javax.swing.JLabel jLabel2;
private javax.swing.JComboBox jComboBox2;
private javax.swing.JLabel jLabel3;
private javax.swing.JComboBox jComboBox3;
private javax.swing.JComboBox jComboBox4;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField2;
private javax.swing.JTextField jTextField3;
private javax.swing.JComboBox jComboBox5;
private javax.swing.JComboBox jComboBox6;
private javax.swing.JComboBox jComboBox7;
private javax.swing.JTextField jTextField4;
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
// End of variables declaration
}
Gruss Hans