Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.applet.*;
- import java.awt.*;
- import java.awt.event.*;
- import java.sql.*;
- public class AbfrageDB extends Applet implements MouseListener,ActionListener
- {
- //Datenbankvariablen
- Connection dbVerbindung=null;
- Statement sqlStatement=null;
- ResultSet resultSet=null;
- ResultSetMetaData rsmd = null;
- ResultSet resultSet2=null;
- // graph. Objekte globalisieren
- Image lahnverlauf;
- TextField tf1;
- TextField tf2;
- Button b1;
- TextArea ta1;
- String sqlString="",strkanukl,strkanugr,strpreis,geskost,anzkl,anzgr,gesanz;
- double dbkanukl,dbkanugr,kostkl,kostgr,dbanzkl,dbanzgr,kostges,dbkanu,anzges;
- Label lbort,lbstart,lbziel,lbanzkanus,lbklkanus,lbgrkanus,lbdaten,lbvnme,lbnnme,lbstrnr,lbplzort,lbmail;
- TextField tfpreis, tfklein,tfgross,tfnnme,tfvnme,tfstr,tfnr,tfplz,tfort,tfmail;
- Button preis,buchen,korrekt;
- //Initialisierung
- public void init()
- {
- //Layout
- this.setLayout(null);
- //Bilder
- lahnverlauf = getImage (getDocumentBase (), "Lahnverlauf.GIF");
- //Labels
- lbort=new Label("Bitte geben sie Start- und Zielort an:");
- lbort.setLocation(350,5);
- lbort.setSize(350,15);
- this.add(lbort);
- lbstart=new Label("Start");
- lbstart.setLocation(350,30);
- lbstart.setSize(50,15);
- this.add(lbstart);
- lbziel=new Label("Ziel");
- lbziel.setLocation(500,30);
- lbziel.setSize(50,15);
- this.add(lbziel);
- lbanzkanus=new Label("Wieviele Kanus werden benötigt?");
- lbanzkanus.setLocation(350,150);
- lbanzkanus.setSize(350,15);
- this.add(lbanzkanus);
- lbklkanus=new Label("Kleine Kanus:");
- lbklkanus.setLocation(350,175);
- lbklkanus.setSize(100,15);
- this.add(lbklkanus);
- lbgrkanus=new Label("Große Kanus:");
- lbgrkanus.setLocation(350,200);
- lbgrkanus.setSize(100,15);
- this.add(lbgrkanus);
- lbdaten=new Label("Bitte persönliche Daten angeben:");
- lbdaten.setLocation(10,250);
- lbdaten.setSize(250,20);
- this.add(lbdaten);
- lbvnme=new Label("Vorname:");
- lbvnme.setLocation(10,280);
- lbvnme.setSize(60,20);
- this.add(lbvnme);
- lbnnme=new Label("Nachname:");
- lbnnme.setLocation(10,305);
- lbnnme.setSize(70,20);
- this.add(lbnnme);
- lbstrnr=new Label("Straße / Hausnr.:");
- lbstrnr.setLocation(10,330);
- lbstrnr.setSize(100,20);
- this.add(lbstrnr);
- lbplzort=new Label("Plz. / Ort:");
- lbplzort.setLocation(10,355);
- lbplzort.setSize(70,20);
- this.add(lbplzort);
- lbmail=new Label("eMail:");
- lbmail.setLocation(10,380);
- lbmail.setSize(50,20);
- this.add(lbmail);
- //Textfelder
- tfklein=new TextField();
- tfklein.setLocation(450,175);
- tfklein.setSize(30,20);
- tfklein.setText("0");
- this.add(tfklein);
- tfgross=new TextField();
- tfgross.setLocation(450,200);
- tfgross.setSize(30,20);
- tfgross.setText("0");
- this.add(tfgross);
- tfvnme=new TextField();
- tfvnme.setLocation(130,280);
- tfvnme.setSize(150,20);
- this.add(tfvnme);
- tfnnme=new TextField();
- tfnnme.setLocation(130,305);
- tfnnme.setSize(150,20);
- this.add(tfnnme);
- tfstr=new TextField();
- tfstr.setLocation(130,330);
- tfstr.setSize(100,20);
- this.add(tfstr);
- tfnr=new TextField();
- tfnr.setLocation(235,330);
- tfnr.setSize(45,20);
- this.add(tfnr);
- tfplz=new TextField();
- tfplz.setLocation(130,355);
- tfplz.setSize(45,20);
- this.add(tfplz);
- tfort=new TextField();
- tfort.setLocation(180,355);
- tfort.setSize(100,20);
- this.add(tfort);
- tfmail=new TextField();
- tfmail.setLocation(130,380);
- tfmail.setSize(150,20);
- this.add(tfmail);
- //Textausgabe
- tfpreis=new TextField();
- tfpreis.setLocation(455,230);
- tfpreis.setSize(100,30);
- this.add(tfpreis);
- //Buttons
- preis=new Button("Preis kalkulieren");
- preis.setLocation(350,230);
- preis.setSize(100,30);
- preis.addActionListener(this);
- this.add(preis);
- buchen=new Button("Kanus buchen");
- buchen.setLocation(350,280);
- buchen.setSize(100,30);
- buchen.addActionListener(this);
- this.add(buchen);
- //Dropdowns
- Choice c1=new Choice();
- c1.add("Wetzlar");
- c1.add("Weilburg");
- c1.add("Arfurt");
- c1.add("Limburg");
- c1.setLocation(350,50);
- c1.setSize(100,50);
- this.add(c1);
- Choice c2=new Choice();
- c2.add("Wetzlar ");
- c2.add("Weilburg ");
- c2.add("Arfurt ");
- c2.add("Limburg ");
- c2.setLocation(500,50);
- c2.setSize(100,50);
- this.add(c2);
- // Datenbanktreiber laden
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- System.out.println("Treiber erfolgreich geladen...");
- }//try
- catch(ClassNotFoundException e)
- {
- System.out.println("Fehler beim Laden des Treibers "+e);
- System.exit(0);//Abbruch des Programm
- }// catch(ClassNotFoundException e)
- // Datenbankverbindung herstellen
- try
- {
- dbVerbindung = DriverManager.getConnection("jdbc:mysql://localhost/kanuverleih","root","");
- System.out.println("Verbindung erfolgreich...");
- }//try
- catch(SQLException e)
- {
- System.out.println("DB-Verbindung Fehler: "+e);
- System.exit(0);
- }// catch(SQLException e)
- }//Init() Ende
- // Paint - Methode
- public void paint (Graphics g)
- {
- g.drawImage(lahnverlauf,0,0,this);
- g.setColor( Color.black );
- g.drawLine(350,20,550,20);
- g.drawLine(350,165,535,165);
- g.drawLine(10,270,200,270);
- g.drawRect(0,0,799,599);
- }
- // Mouse Listener
- public void mousePressed(MouseEvent evt){ }
- public void mouseEntered(MouseEvent evt) { }
- public void mouseExited(MouseEvent evt) { }
- public void mouseClicked(MouseEvent evt) { }
- public void mouseReleased(MouseEvent evt) { }
- // Methode, die auf Ereignisse (z.B. Button betaetigen reagiert)
- public void actionPerformed(ActionEvent e)
- {
- String command = e.getActionCommand();
- if(command.equals("Preis kalkulieren"))
- {
- sqlString="SELECT Kosten FROM preis";
- // Anwenden der SQL Abfrage + Berechnung der Eingaben
- try
- {
- sqlStatement = dbVerbindung.createStatement();
- System.out.println("SQL-Statement erzeugt...");
- resultSet = sqlStatement.executeQuery(sqlString);
- // nächste Datensatz holen bis Tabellenende erreicht
- while (resultSet.next())
- {
- dbkanu=resultSet.getDouble(1);
- anzkl=tfklein.getText();
- anzgr=tfgross.getText();
- dbanzkl=Double.parseDouble(anzkl);
- dbanzgr=Double.parseDouble(anzgr);
- anzges=dbanzkl+dbanzgr;
- kostges=anzges*dbkanu;
- geskost=Double.toString(kostges);
- }
- tfpreis.setText(geskost+" Euro");
- // Tabelle schliessen
- resultSet.close();
- System.out.println("resultSet-Objekt zerstoert...");
- sqlStatement.close();
- System.out.println("sqlStatementobjekt zerstoert");
- dbVerbindung.close();
- System.out.println("Verbindung geschlossen...");
- }//try
- catch(SQLException ex)
- {
- System.out.println("Fehler beim DB-Zugriff!"+ex);
- System.exit(0);
- }// catch(SQLException ex)
- }//if Ende
- if(command.equals("Kanus buchen"));
- {
- try
- {
- sqlStatement = dbVerbindung.createStatement();
- sqlStatement.executeUpdate("INSERT into kunden (Vorname) VALUES('test')");
- }
- catch (SQLException s)
- {
- System.out.println("SQL statement is not executed!");
- System.exit(0);
- }
- }
- }// actionPerformed() Ende
- }// Class Ende
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement