Test Riverlayout :: sample

JAVA gebonden afkortingen

---

ORM JSP JSF MVC J2EE J2SE POJO	Object-Relational mapping JavaServer Pages JavaServer Faces Model-view-controller Java 2 Platform Enterprise Edition Java 2 Platform, Standard Edition Plain Old Java Object
JTA EJB API AOP JDBC	Java Transaction API Enterprise JavaBeans Application programming interface Aspect-oriented programming Java Database Connectivity
SQL HQL JDO DAO	Structured Query Language Hibernate Query Language Java Data Objects Data Access Object
iBATIS	is a persistence framework which enables mapping SQL queries to POJOs
Apache Struts	is an open-source web application framework for developing Java EE web applications.
WebWork	is a Java-based web application framework developed by OpenSymphony.
Tapestry	is an open-source framework for creating dynamic, robust, highly scalable web applications in Java.
TopLink	is an object-relational mapping package for Java developers.
Hibernate	is an object-relational mapping (ORM) library for the Java language, providing a framework for mapping an object-oriented domain model to a traditional relational database.
Spring	Spring is a layered Java/J2EE application framework, based on code published in Expert One-on-One J2EE Design and Development by Rod Johnson (Wrox, 2002).

---

Java Persistence with Hibernate 
            Schermbreed weergeven : klik voorlaatste ikoon van toolbalk

---

Macro voor excel om een lijst woorden in één keer te vervangen in een tekst.

---

De code voor Visual Basic macro "Vervang"

De lijst woorden die men wenst te vervangen bevindt zich in dit voorbeeld in de kolom C4 tot C13.De wisselwoorden in de kolom daarnaast [Offset(0, 1)].

Sub Vervang()

'author piet :: pwProTech

For Each c In Worksheets(1).Range("C4:C13")
Sheets("Blad2").Cells.Replace What:=c.Value, Replacement:=c.Offset(0, 1).Value, LookAt:=xlPart _
, SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
Next c

End Sub

De inhoud van excel Blad1
Range C4 tot C13 :
Hier plaats je de woorden die je wil vervangen en de veervangtekst

Vb.:Blad1:

Op dit blad kan je ook de knop [VERVANG] (die de macro "Vervang" start) aanbrengen.:

A	B	C	D	...
1
2
3		Te vervangen:	met:
4		Event	DB_action
5		event	db_action
...		...	...

De inhoud van excel Blad2

Op Blad2 plaats je de tekst die bewerkt moet worden.

Je plakt best de hele tekst in één enkele cel zodat je hem weer gemakelijk kan copiëren
Hoe : dubbele klik in de cel die je verkiest en plakken

Noot: Je kan ook een knop voorzien om de woorden op "Blad1" te verwijderen met de macro "Reset"

Code:

Sub Reset()

  'author piet :: pwProTech

  For Each c In Worksheets(1).Range("C4:C13")
     c.Value = ""
     c.Offset(0, 1).Value = ""
  Next c

End Sub

 

Project :: Kantoren :: Items

Minimumindeling van het algemeen rekeningstelsel MAR Databesetabel voor MySQL

 

Eclipse :: Java :: Items

Eclipse - Mysql - MS sql-server Een database Mysql - Project starten met eclipse Test mysql-connectie :: java Java :: eclipse :: Check of een internal frame is aangemaakt Java :: eclipse :: JTable addRow Java :: eclipse :: tabel leegmaken [clear JTable] Java :: eclipse :: omzetting nr string Java :: eclipse :: arrays Java :: eclipse :: voorbeeld internalframe mysql , menu, klantenformulier
Java :: eclipse :: Aanmaken van het object klant [classe]
Java :: eclipse :: Voorbeeld HQL [sample HQL FRom (class name)
Java :: eclipse :: Voorbeeld DAO [sample DAO (klant,user database mysql)
Java :: eclipse :: In voorbeeld DAO KlantDao.java en UserDao.java vervangen door 1 enkel bestand : dbDao.java

Elipse :: java »» Project DAO :: voorbeeld (sample user , klant : database mysql).

---

Structuur :

[-]prjdao (project)
|      |
|     [-]config (map)
|      |     klant.hbm.xml
|      |     user.hbm.xml
|      |
|     [-]src (package)
|      |     main.java
|      |     Klant.java
|      |     User.java
|      |     KlantDao.java
|      |     UserDao.java
|      |     HibernateFactory.java
|      |     ConstructDao.java
|      |     DataAccessError.java
|     [+] JRE System Library
|     [+] xerces-2.6.2.jar
|     [+] ant-antlr-1.6.3.jar
|     [+] antlr-2.7.5H3.jar
|     [+] asm.jar
|     [+] asm-attrs.jar
|     [+] cglib-2.1.jar
|     [+] commons-collections-2.1.1.jar
|     [+] commons-logging-1.0.4.jar
|     [+] dom4j-1.6.jar
|     [+] ehache-1.1.jar
|     [+] hibernate3.jar
|     [+] hsqldb.jar
|     [+] jta.jar
|     [+] log4j-1.2.9.jar
|     [+] mysql-connector-java-3.1.6-bin.jar
|
hibernate.cfg.xml
log4j.properties
 

---

1.--- begin main.java ------

package src;

import java.util.Date;

public class Main {

    public static void main(String[] args) {

    Date now = new Date ();

    /*
    * User toevoegen aan de database
    */
    System.out.println("user toegevoegd voor");
    UserDao userDao = new UserDao();
    User user = new User();
    userDao.create(user);
    user.setNaam("De Gavere");
    user.setWachtwoord("gaverzicht");
    user.setAansluiting(now);
    userDao.update(user);
    System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>user toegevoegd");
    userDao.findAll();

    /*
    * Klant toevoegen aan de database
    */
    KlantDao klantDao = new KlantDao();
    Klant klant = new Klant();
    klantDao.create(klant);
    klant.setVoornaam("Kere-gerom");
    klant.setAchternaam("Reuzegom");
    klant.setStraat("Lange Wapperstraat");
    klant.setHuisnr("12");
    klant.setPostnr("8640");
    klant.setGemeente("Papoptvier");
    klantDao.update(klant);
    System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>klant toegevoegd");
    klantDao.findAll();


    System.out.println("Einde main");

    }
}

--- einde Main java ------ top
 

---

2.--- begin Klant.java ------

package src;

public class Klant {//implements Serializable {

private Long id;
private String voonaam;
private String achternaam;
private String straat;
private String huisnr;
private String postnr;
private String gemeente;


public Long getId() {return id;}
public void setId(Long id) {this.id = id;}

public String getVoornaam() {return voonaam;}
public void setVoornaam(String voonaam) {this.voonaam = voonaam;}

public String getAchternaam() {return achternaam;}
public void setAchternaam(String achternaam) {this.achternaam = achternaam;}

public String getStraat() {return straat;}
public void setStraat(String straat) {this.straat = straat;}

public String getHuisnr() {return huisnr;}
public void setHuisnr(String huisnr) {this.huisnr = huisnr;}

public String getPostnr() {return postnr;}
public void setPostnr(String postnr) {this.postnr = postnr;}

public String getGemeente() {return gemeente;}
public void setGemeente(String gemeente) {this.gemeente = gemeente;}

}


--- einde Klant.java ------  top
 

---

3.--- begin User.java ------

package src;

import java.util.Date;


public class User {
private Long id;
private int werkniveau;
private String naam;
private String wachtwoord;
private Date aansluiting;



public Long getId() {return id;}
public void setId(Long id) {this.id = id;}

public String getNaam() {return naam;}
public void setNaam(String naam) {System.out.println("in klant :naam");this.naam = naam;}

public String getWachtwoord() {return wachtwoord;}
public void setWachtwoord(String wachtwoord) {this.wachtwoord = wachtwoord;}

public Date getAansluiting() {return aansluiting;}
public void setAansluiting(Date aansluiting) {this.aansluiting = aansluiting;}

public int getwerkniveau() {return werkniveau;}
public void setwerkniveau(int werkniveau) {this.werkniveau = werkniveau;}

}

--- einde User.java ------ top
 

---

4.--- begin HibernateFactory.java ------

package src;

import org.hibernate.*;
import org.hibernate.cfg.Configuration;
import org.apache.commons.logging.*;



public class HibernateFactory {
private static SessionFactory sessionFactory;
private static Log log = LogFactory.getLog(HibernateFactory.class);

    /*
    * Maakt een nieuwe Singleton SessionFactory aan
    */
    public static SessionFactory buildSessionFactory() throws HibernateException {
    System.out.println("sessionfact build");
    if (sessionFactory != null) {
    closeFactory();
    }
    return configureSessionFactory();
    }

    /*
    * Maakt een nieuwe Singleton SessionFactory aan indien nodig.
    */
    public static SessionFactory buildIfNeeded() throws DataAccessError{

    if (sessionFactory != null) {
    return sessionFactory;
    }
        try {
            return configureSessionFactory();
    } catch (HibernateException err) {
        throw new DataAccessError("build if needed mislukt >> "+err);
    }
}

public static SessionFactory getSessionFactory() {
return sessionFactory;
}

public static Session openSession() throws HibernateException {
buildIfNeeded();
return sessionFactory.openSession();
}

public static void closeFactory() {
    if (sessionFactory != null) {
        try {
            sessionFactory.close();
        } catch (HibernateException ignored) {
            log.error("SessionFactory kon niet afgesloten worden", ignored);
        }
    }
}

public static void close(Session session) {
    if (session != null) {
        try {
        session.close();
        } catch (HibernateException ignored) {
        log.error("Session kon niet afgesloten worden", ignored);
        }
    }
}

public static void rollback(Transaction trans) {
    try {
        if (trans != null) {
        trans.rollback();
        System.out.println("Terugschroeven");
        }
    } catch (HibernateException ignored) {
        log.error("Transaction-terugschroeven (rollback) is mislukt", ignored);
    }
}

/*
* Configuratie SessionFactory
*/
private static SessionFactory configureSessionFactory() throws HibernateException {
    Configuration configuration = new Configuration();
    configuration.configure();
    sessionFactory = configuration.buildSessionFactory();
    return sessionFactory;
    }
}

--- einde HibernateFactory.java ------ top
 

---

5.--- begin ConstructDao.java -----

package src;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.Query;
import java.util.List;

public abstract class ConstructDao {
private Session session;
private Transaction trans;

public ConstructDao() {
System.out.println("maak indien nodig");
HibernateFactory.buildIfNeeded();
}

protected void saveOrUpdate(Object obj) {
    try {
        System.out.println("saveOrUpdate");
        openSessionTrans();
        session.saveOrUpdate(obj);
        trans.commit();
    } catch (HibernateException err) {
        handleException(err);
    } finally {
        HibernateFactory.rollback(trans);
        HibernateFactory.close(session);
    }
}

protected void delete(Object object) {
    try {
        openSessionTrans();
        session.delete(object);
        trans.commit();
    } catch (HibernateException err) {
        handleException(err);
    } finally {
        HibernateFactory.close(session);
    }
}

protected Object find(Class clazz, Long id) {
Object object = null;
    try {
        openSessionTrans();
        object = session.load(clazz, id);
        trans.commit();
    } catch (HibernateException err) {
        handleException(err);
    } finally {
        HibernateFactory.close(session);
    }
    return object;
}

protected List findAll(Class clazz) {
List objects = null;
    try {
        openSessionTrans();
        Query query = session.createQuery("from " + clazz.getName());
        objects = query.list();
        trans.commit();
    } catch (HibernateException err) {
        handleException(err);
    } finally {
        HibernateFactory.close(session);
    }
    return objects;
}

protected void handleException(HibernateException err) throws DataAccessError {
    HibernateFactory.rollback(trans);
    throw new DataAccessError(err);
}

protected void openSessionTrans() throws HibernateException {
    System.out.println("openSessionTrans");
    session = HibernateFactory.openSession();
    trans = session.beginTransaction();
    }
}



--- einde ConstructDao.java ------ top
 

---

6.--- begin KlantDao.java ------

package src;

import java.util.List;


public class KlantDao extends ConstructDao {

public KlantDao() {
super();
}

/*
* Nieuwe Klant toevoegen aan database.
*/
public void create(Klant klant) throws DataAccessError {
super.saveOrUpdate(klant);
}


/*
* Een Klant verwijderen van de database.
*/
public void delete(Klant klant) throws DataAccessError {
super.delete(klant);
}

/*
* Een Klant vinden met de primary key.
*/
public Klant find(Long id) throws DataAccessError {
System.out.print("klant update");
return (Klant) super.find(Klant.class, id);
}

/*
* Klant toevoegen aan - of wijzigen in de database.
*/
public void update(Klant klant) throws DataAccessError {
System.out.print("klant update");
super.saveOrUpdate(klant);
}

/**
* Zoek alle klanten in de database.
*/
public List findAll() throws DataAccessError{
return super.findAll(Klant.class);
}

}
--- einde klantDao.java ------ top
 

---

7.--- begin UserDao.java ------

package src;

import java.util.List;

public class UserDao extends ConstructDao {
public UserDao() {
super();
}

/*
* Een User toevoegen aan - wijzigen in de database.
*/
public void create(User user) throws DataAccessError {
super.saveOrUpdate(user);
}


/*
* Een User verwijderen uit de database.
*/
public void delete(User user) throws DataAccessError {
super.delete(user);
}

/**
* Find an Event by its primary key.
* @param id
* @return
*/
public User find(Long id) throws DataAccessError {

return (User) super.find(User.class, id);
}

/*
* User toevoegen aan - of wijzigen in de database.
*/
public void update(User user) throws DataAccessError {
System.out.println(">>>>> user update");
super.saveOrUpdate(user);
}

/*
* Haal alle users op uit de database.
*/
public List findAll() throws DataAccessError{
return super.findAll(User.class);
}

}

--- einde UserDao.java ------ top
 

---

8.--- begin DataAccesError.java ------
package src;

/*
* Exceptions opgeworpen door de Data Access Layer.
*/
public class DataAccessError extends RuntimeException {
public DataAccessError() {
}

public DataAccessError(String message) {
super(message);
}

public DataAccessError(Throwable cause) {
super(cause);
}

public DataAccessError(String message, Throwable cause) {
super(message, cause);
}
}


--- einde DataAccesError.java ------ top
 

---

map config

    klant.hbm.xml
    user.hbm.xml



1.--- begin klant.hbm.xml ------

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping >
    <class name="src.Klant" table="klanten">
        <id name="id" column="id" type="long">
        <generator class="increment"/>
        </id>
        <property name="voornaam" type="string"/>
        <property name="achternaam" type="string"/>
        <property name="straat" type="string"/>
        <property name="huisnr" type="string"/>
        <property name="postnr" type="string"/>
        <property name="gemeente" type="string"/>
    </class>
</hibernate-mapping>

--- einde klant.hbm.xml ------ top
 

---

2.--- begin user.hbm.xml ------

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping >
    <class name="src.User" table="users">
        <id name="id" column="id" type="long">
        <generator class="increment"/>
        </id>
        <property name="naam" type="string"/>
        <property name="wachtwoord" type="string"/>
        <property name="aansluiting" type="date"/>
        <property name="werkniveau" type="integer"/>
    </class>
</hibernate-mapping>

--- einde user.hbm.xml ------ top
 

---

project prjdao
    hibernate.cfg.xml
    log4j.properties


1.--- begin hibernate.cfg.xml ------

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
    <session-factory>
        <!-- Database connection settings -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost/mysqltest</property>
        <property name="connection.username">db-usernaam</property>
        <property name="connection.password">uwpaswoord</property>

        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.HSQLDialect</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

        <mapping resource="config/User.hbm.xml"/>
        <mapping resource="config/Klant.hbm.xml"/>
    </session-factory>
</hibernate-configuration>


--- einde hibernate.cfg.xml ------ top
 

---

2.--- begin log4j.properties ------

log4j.rootLogger=DEBUG, A1
log4j.appender.A1=
org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=
org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=
%-4r [%t] %-5p %c %x - %m%n

--- einde log4j.properties ------ top
 

---

Tables mysql database "mysqltest"

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 17 Aug 2007 om 17:40
-- Server versie: 5.0.24
-- PHP Versie: 5.0.3
--
-- Database: `mysqltest`
--

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `klanten`
--

CREATE TABLE `klanten` (
  `id` bigint(20) NOT NULL auto_increment,
  `voornaam` varchar(30) default NULL,
  `achternaam` varchar(15) default NULL,
  `straat` varchar(30) default NULL,
  `huisnr` varchar(10) default NULL,
  `postnr` varchar(4) default NULL,
  `gemeente` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

--
-- Gegevens worden uitgevoerd voor tabel `klanten`
--

INSERT INTO `klanten` VALUES (1, 'Reuzegom', 'Kere-gerom', 'Smallestraat', '12', '8640', 'Tzalbeteren');
INSERT INTO `klanten` VALUES (2, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Tzalbeteren');
INSERT INTO `klanten` VALUES (3, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Tzalbeteren');
INSERT INTO `klanten` VALUES (4, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Tzalbeteren');
INSERT INTO `klanten` VALUES (5, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Tzalbeteren');
INSERT INTO `klanten` VALUES (6, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (7, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (8, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (9, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (10, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (11, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (12, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (13, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (14, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (15, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (16, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (17, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (18, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (19, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (20, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (21, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (22, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (23, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (24, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (25, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (26, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (27, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (28, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (29, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (30, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (31, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (32, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (33, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (34, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
INSERT INTO `klanten` VALUES (35, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 17 Aug 2007 om 17:41
-- Server versie: 5.0.24
-- PHP Versie: 5.0.3
--
-- Database: `mysqltest`
--

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `users`
--

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL auto_increment,
  `naam` varchar(30) default NULL,
  `wachtwoord` varchar(10) default NULL,
  `aansluiting` date default NULL,
  `werkniveau` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Gegevens worden uitgevoerd voor tabel `users`
--

INSERT INTO `users` VALUES (1, 'dillems', 'blabla', '2007-07-29', 1);
INSERT INTO `users` VALUES (2, 'De Vlucht', 'Wachtwoord', '2007-08-08', 0);
INSERT INTO `users` VALUES (3, 'De Vlucht', 'Wachtwoord', '2007-08-08', 0);
INSERT INTO `users` VALUES (4, 'De Gavere', 'gaverzicht', '2007-08-08', 0);
INSERT INTO `users` VALUES (5, 'De Gavere', 'gaverzicht', '2007-08-08', 0);
INSERT INTO `users` VALUES (6, 'De Gavere', 'gaverzicht', '2007-08-09', 0);
INSERT INTO `users` VALUES (7, 'De Gavere', 'gaverzicht', '2007-08-09', 0);
INSERT INTO `users` VALUES (8, 'De Gavere', 'gaverzicht', '2007-08-09', 0);
INSERT INTO `users` VALUES (9, 'De Gavere', 'gaverzicht', '2007-08-09', 0);
INSERT INTO `users` VALUES (10, NULL, NULL, NULL, 0);
INSERT INTO `users` VALUES (11, 'De Gavere', 'gaverzicht', '2007-08-17', 0);
INSERT INTO `users` VALUES (12, 'De Gavere', 'gaverzicht', '2007-08-17', 0);

Resultaat prjdao

Vervangen van KlantDao.java en UserDao.java door 1 enkel bestand : dbDao.java

1.Nieuwe code voor Main.java

2.Code voor dbDao [Nieuwe code voor User-KlantDao]

» Naar  Menu

---

 

1.Nieuwe code voor Main.java

--- begin Main.java ------

package src;

import java.util.Date;

public class Main {

    public static void main(String[] args) {


    Date now = new Date ();

    /*
    * User toevoegen aan de database
    */
    User user = new User();
    user.setNaam("De Koster");
    user.setWachtwoord("kost");
    user.setAansluiting(now);

    dbDao dbuser = new dbDao();
    dbuser.update(user);
    System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>user toegevoegd");
    dbuser.findAll(User.class);

    /*
    * Klant toevoegen aan de database
    */
    Klant klant = new Klant();
    klant.setAchternaam("De Client");
    klant.setVoornaam("Andre");
    klant.setStraat("Klantenstraat");
    klant.setHuisnr("15");
    klant.setPostnr("4578");
    klant.setGemeente("Winkelen");


    dbDao dbklant = new dbDao();
    dbklant.update(klant);
    System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>klant toegevoegd");
    dbklant.findAll(Klant.class);


    System.out.println("Einde main");

}

}
 

--- einde Main.java ------

---

 

2.Vervangen van de 2 codebestanden userDao.java en KlantDao.java door dbDao.java te gebruiken voor klant and user

--- begin dbDao.java ------

package src;

import java.util.List;

public class dbDao extends ConstructDao {
public dbDao() {
super();
}

    /*
    * Een Oject toevoegen aan - wijzigen in de database.
    */
    public void create(Object obj) throws DataAccessError {
        super.saveOrUpdate(obj);
    }


    /*
    * Een Oject  verwijderen uit de database.
    */
    public void delete(Object obj) throws DataAccessError {
        super.delete(obj);
    }

    /**
    * Zoeken met primary key.
    * @param id
    * @return
    */
    public Object find(Long id) throws DataAccessError {
        return (Object) super.find(Object.class, id);
    }

    /*
    * Oject  toevoegen aan - of wijzigen in de database.
    */
    public void update(Object obj) throws DataAccessError {
        super.saveOrUpdate(obj);
    }

    /*
    * Haal Oject op uit de database.
    */
    public List findAll() throws DataAccessError{
        return super.findAll(Object.class);
    }
}

--- einde dbDao.java ------

 

Eclipse :: java :: Aanmaken van Object Klant  [Class]

Eclips project

- src

  + AdminKlanten.java

  +OpzoekenKlant.java

  +VoorraadBeheer.java

  +Klant.java

---

Aanmaken van het object klant

Code :: Klant.java :

package src;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Klant {

private String id,voornaam,achternaam,straat,huisnr,postnr,gemeente;


public Klant( ResultSet rs) {
try {
id = String.valueOf(rs.getInt("id"));
achternaam = rs.getString("achternaam");
voornaam = rs.getString("voornaam");
straat = rs.getString("straat");
huisnr = rs.getString("huisnr");
postnr = rs.getString("postnr");
gemeente = rs.getString("gemeente");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

public String getID() {
return id;
}
public String getAchternaam() {
return achternaam;
}
public String getVoornaam() {
return voornaam;
}
public String getStraat() {
return straat;
}
public String getHuisnr() {
return huisnr;
}
public String getPostnr() {
return postnr;
}
public String getGemeente() {
return gemeente;
}


public void setID(String id) {
this.id = id;
}
public void setAchternaam(String achternaam) {
this.achternaam = achternaam;
}
public void setVoornaam(String voornaam) {
this.voornaam = voornaam;
}
public void setStraat(String straat) {
this.straat = straat;
}
public void setHuisnr(String huisnr) {
this.huisnr = huisnr;
}
public void setPostnr(String postnr) {
this.postnr = postnr;
}
public void setGemeente(String gemeente) {
this.gemeente = gemeente;
}
}

 

Aan te passen in de code : AdminKlanten.java :

 

knopZoek.addActionListener(
    new ActionListener() {
        public void actionPerformed(ActionEvent e) {
            int y = myModel.getRowCount();
            for(int a = 0; a < y; a++)
            {
            myModel.removeRow(0);
            }
            klanten.clear();

            System.out.println(comboBox.getSelectedItem());
            try
            {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "passwoord");
            Statement statement = conn.createStatement();
            ResultSet rs = statement.executeQuery("SELECT * FROM klanten WHERE "+comboBox.getSelectedItem()+" = '"+rs01.getText()+"' LIMIT 0 , 1000");
            int x;x=0;
            while (rs.next()) {

            record[x][0]=String.valueOf(rs.getInt("id"));
            record[x][1]=Klant.chternaam");
            record[x][2]=rs.getString("voornaam");
            record[x][3]=rs.getString("straat");
            record[x][4]=rs.getString("huisnr");
            record[x][5]=rs.getString("postnr");
            record[x][6]=rs.getString("gemeente");

vervangen door :

            Klant klant = new Klant(rs);
            klanten.add(klant);
            record[x][0]=klant.getID();
            record[x][1]=klant.getAchternaam();
            record[x][2]=klant.getVoornaam();
            record[x][3]=klant.getStraat();
            record[x][4]=klant.getHuisnr();
            record[x][5]=klant.getPostnr();
            record[x][6]=klant.getGemeente();

            myModel.addRow(record[x]);
            x++;
            }
            conn.close();
            }
            catch (Exception ex)
            {
            ex.getStackTrace();
            }
            }
    }
);


panel.add(jScrollPane);
getContentPane().add(panel);

Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
setSize(new Dimension(800, 600));
setLocation((screenSize.width-800)/2,(screenSize.height-600)/2);
}

Elipse : java : MySQL query, menubar , internal frame, form klanten ,DefaultTableModel

MySQL - tabel :

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 15 Jul 2007 om 11:24
-- Server versie: 5.0.24
-- PHP Versie: 5.0.3
--
-- Database: `voorraad`
--

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `klanten`
--

DROP TABLE IF EXISTS `klanten`;
CREATE TABLE `klanten` (
`id` int(11) NOT NULL auto_increment,
`geslacht` char(1) NOT NULL,
`achternaam` varchar(30) NOT NULL,
`voornaam` varchar(30) NOT NULL,
`straat` varchar(50) NOT NULL,
`huisnr` char(10) NOT NULL,
`postnr` char(4) NOT NULL,
`gemeente` varchar(30) NOT NULL,
`telefoon` varchar(12) NOT NULL,
`GSM` varchar(20) NOT NULL,
`fax` varchar(12) NOT NULL,
`email` varchar(50) NOT NULL,
`korting` int(2) NOT NULL,
`nieuws` char(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Gegevens worden uitgevoerd voor tabel `klanten`
--

INSERT INTO `klanten` VALUES (1, 'm', 'de gieter', 'jefke', 'mollestraat ', '362', '8640', 'vleteren', '057400017', '', '057400017', 'degieter@gegoten.com', 0, 'n');
INSERT INTO `klanten` VALUES (2, 'm', 'de wachter', 'jozef', 'diepestraat', '31', '8641', 'izenberge', '057425218', 'geen', '057555223', 'dewachter@wachteenbeke.be', 2, 'j');
INSERT INTO `klanten` VALUES (3, 'm', 'de gieter', 'jaak', 'mollestraat ', '362', '8640', 'vleteren', '057425217', '448 155515', '057555222', 'bler@blobbers.com', 5, 'n');
INSERT INTO `klanten` VALUES (4, 'm', 'maresco', 'stefaan', 'diepebeekstraat ', '36', '8640', 'vleteren', '057425217', '448 145915', '057555222', 'maresco@blobbers.com', 5, 'n');
INSERT INTO `klanten` VALUES (7, 'v', 'smolders', 'jenny', 'vennestraat', '62', '4525', 'izenberge', '0245678925', 'geen', 'geen', 'jenny@column.com', 0, 'j');
INSERT INTO `klanten` VALUES (8, 'v', 'van santen', 'mary', 'wipstraat', '47', '2010', 'vleteren', '0358946545', 'geen', 'geen', 'mary@strijders.com', 0, 'n');
 

---

 

Eclips project

- src

  + AdminKlanten.java

  +OpzoekenKlant.java

  +VoorraadBeheer.java

 

1.Code :: AdminKlanten.java

package src;


import java.awt.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import javax.swing.BoxLayout;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
import javax.swing.table.DefaultTableModel;
import java.awt.event.*;

import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;



public class AdminKlanten extends JInternalFrame
{

final String[] columnNames = {"id","Familienaam","Voornaam","Straat","Nr","Postnr","Gemeente"};
Object[][] record = new Object[1000][7];
java.util.List<Klant> klanten = new ArrayList<Klant> ();

final DefaultTableModel myModel = new DefaultTableModel(record,columnNames )
{
public Class getColumnClass(int c)
{
return getValueAt(0, c).getClass();
}
};



JTable table = new JTable(myModel);

JButton knp_nieuw = new JButton("Nieuw");
JButton knp_toevoegen = new JButton("Toevoegen");
JButton knp_wijzigen = new JButton("wijzigen");
JButton knp_delete = new JButton("Verwijderen");


JLabel lab01 = new JLabel("Klantnummer");
JLabel lab02 = new JLabel("Geslacht");
JLabel lab03 = new JLabel("Achternaam");
JLabel lab04 = new JLabel("Voornaam");
JLabel lab05 = new JLabel("Straat");
JLabel lab06 = new JLabel("Huisnr");
JLabel lab07 = new JLabel("Postnummer");
JLabel lab08 = new JLabel("Gemeente");
JLabel lab09 = new JLabel("Telefoon");
JLabel lab10 = new JLabel("GSM");
JLabel lab11 = new JLabel("Fax");
JLabel lab12 = new JLabel("E-post");
JLabel lab13 = new JLabel("Korting %");
JLabel lab14 = new JLabel("Niewsbrief");

JTextField rs01 = new JTextField("auto");//klnt_id :: disable!
JTextField rs02 = new JTextField("");//klnt_geslacht
JTextField rs03 = new JTextField("");//klnt_voornaam
JTextField rs04 = new JTextField("");//klnt_achternaam
JTextField rs05 = new JTextField("");//klnt_straat
JTextField rs06 = new JTextField("");//klnt_huisnr
JTextField rs07 = new JTextField("");//klnt_postnr
JTextField rs08 = new JTextField("");//klnt_gemeente
JTextField rs09 = new JTextField("");//klnt_telefoon
JTextField rs10 = new JTextField("");//klnt_gsm
JTextField rs11 = new JTextField("");//klnt_fax
JTextField rs12 = new JTextField("");//klnt_email
JTextField rs13 = new JTextField("");//klnt_korting
JTextField rs14 = new JTextField("");//klnt_nieuws


public AdminKlanten()
{

super("Klanten",true,true,true,true);
try {
} catch (Exception exception) {
exception.printStackTrace();
}
knp_nieuw.addActionListener(new KnpnieHandler());knp_nieuw.setBounds(550, 190, 140, 20);add(knp_nieuw);
knp_toevoegen.addActionListener(new KnptoeHandler());knp_toevoegen.setBounds(550, 220, 140, 20);add(knp_toevoegen);
knp_wijzigen.addActionListener(new KnpwijHandler());knp_wijzigen.setBounds(550, 250, 140, 20);add(knp_wijzigen);
knp_delete.addActionListener(new KnpdelHandler());knp_delete.setBounds(550, 280, 140, 20);add(knp_delete);

add(lab01);lab01.setForeground(Color.black);lab01.setBounds(190, 20, 150, 20);lab01.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab02);lab02.setForeground(Color.black);lab02.setBounds(190, 40, 150, 20);lab02.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab03);lab03.setForeground(Color.black);lab03.setBounds(190, 60, 150, 20);lab03.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab04);lab04.setForeground(Color.black);lab04.setBounds(190, 80, 150, 20);lab04.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab05);lab05.setForeground(Color.black);lab05.setBounds(190, 100, 150, 20);lab05.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab06);lab06.setForeground(Color.black);lab06.setBounds(190, 120, 150, 20);lab06.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab07);lab07.setForeground(Color.black);lab07.setBounds(190, 140, 150, 20);lab07.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab08);lab08.setForeground(Color.black);lab08.setBounds(190, 160, 150, 20);lab08.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab09);lab09.setForeground(Color.black);lab09.setBounds(190, 180, 150, 20);lab09.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab10);lab10.setForeground(Color.black);lab10.setBounds(190, 200, 150, 20);lab10.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab11);lab11.setForeground(Color.black);lab11.setBounds(190, 220, 150, 20);lab11.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab12);lab12.setForeground(Color.black);lab12.setBounds(190, 240, 150, 20);lab12.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab13);lab13.setForeground(Color.black);lab13.setBounds(190, 260, 150, 20);lab13.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab14);lab14.setForeground(Color.black);lab14.setBounds(190, 280, 150, 20);lab14.setHorizontalAlignment(SwingConstants.RIGHT);

add(rs01);rs01.setBounds(350, 20, 150, 20);
add(rs02);rs02.setBounds(350, 40, 150, 20);
add(rs03);rs03.setBounds(350, 60, 150, 20);
add(rs04);rs04.setBounds(350, 80, 150, 20);
add(rs05);rs05.setBounds(350, 100, 150, 20);
add(rs06);rs06.setBounds(350, 120, 150, 20);
add(rs07);rs07.setBounds(350, 140, 150, 20);
add(rs08);rs08.setBounds(350, 160, 150, 20);
add(rs09);rs09.setBounds(350, 180, 150, 20);
add(rs10);rs10.setBounds(350, 200, 150, 20);
add(rs11);rs11.setBounds(350, 220, 150, 20);
add(rs12);rs12.setBounds(350, 240, 150, 20);
add(rs13);rs13.setBounds(350, 260, 150, 20);
add(rs14);rs14.setBounds(350, 280, 150, 20);

JPanel panel = new JPanel();
panel.setLayout(new BoxLayout(panel, BoxLayout.Y_AXIS));

vulTabel();

table.setSurrendersFocusOnKeystroke(true);
table.putClientProperty("terminateEditOnFocusLost", Boolean.TRUE);

class pwLeesToets extends KeyAdapter{
public void keyReleased(KeyEvent e)
{
int key = e.getKeyCode();
if (( key == 13)||(key == 10))
{
int r = table.getSelectedRow();
rs03.setText(table.getValueAt(r,1).toString());//achternaam
rs04.setText(table.getValueAt(r,2).toString());//voornaam
rs05.setText(table.getValueAt(r,3).toString());//straat table edit
rs06.setText(table.getValueAt(r,4).toString());//huisnr table edit
rs07.setText(table.getValueAt(r,5).toString());//postnr table edit
rs08.setText(table.getValueAt(r,6).toString());//gemeente table edit
//table.nextFocus();
}
}
}

table.addKeyListener(new pwLeesToets());

table.addMouseListener( new MouseAdapter()
{
public void mousePressed(MouseEvent e)
{
int r = table.rowAtPoint(e.getPoint());
String s = table.getValueAt(r,0).toString();
int i01 = Integer.parseInt(s);// bij delete veranderen listitem n recorditem!

actieTabelselectie(i01);
}
});


JScrollPane jScrollPane = new JScrollPane();
jScrollPane.setViewportView(table);

Font font01 = new Font("Arial", Font.BOLD, 12);
Font font02 = new Font("Arial", Font.BOLD, 18);
//Font font03 = new Font("Arial", Font.BOLD, 14);

JLabel lab01 = new JLabel("Criteria");
JLabel lab02 = new JLabel("Zoekitem");
JLabel lab03 = new JLabel("Administratie Klanten");

add(lab01);lab01.setFont(font02);lab01.setForeground(Color.GRAY);lab01.setBounds(-20, 360, 100, 20);lab01.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab02);lab02.setFont(font02);lab02.setForeground(Color.GRAY);lab02.setBounds(190, 360, 150, 20);lab02.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab03);lab03.setFont(font02);lab03.setForeground(Color.darkGray);lab03.setBounds(-45, 15, 250, 30);lab03.setHorizontalAlignment(SwingConstants.RIGHT);

final JTextField rs01 = new JTextField("");//zoek item
add(rs01);rs01.setBounds(350, 360, 150, 20);rs01.setFont(font01);

JButton knopZoek = new JButton("Zoek");
knopZoek.setBounds(550, 360, 140, 20);
knopZoek.setFont(font01);
add(knopZoek);

final JComboBox comboBox = new JComboBox();
comboBox.setName("JComboBox");
comboBox.setBounds(90,360,150,20);
comboBox.setPreferredSize(new java.awt.Dimension(100,22));
comboBox.addItem("");
comboBox.addItem("Id");
comboBox.addItem("achternaam");
comboBox.addItem("Voornaam");
comboBox.addItem("Straat");
comboBox.addItem("Huisnummer");
comboBox.addItem("Postnummer");
comboBox.addItem("Gemeente");
comboBox.setFont(font01);
add(comboBox);


for(int x = 0 ; x < 26 ; x++)
{
panel.add(new JLabel(" "));
}

knopZoek.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
int y = myModel.getRowCount();
for(int a = 0; a < y; a++)
{
myModel.removeRow(0);
}

System.out.println(comboBox.getSelectedItem());
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "passwoord");
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM klanten WHERE "+comboBox.getSelectedItem()+" = '"+rs01.getText()+"' LIMIT 0 , 1000");
int x;x=0;
while (rs.next()) {

record[x][0]=String.valueOf(rs.getInt("id"));
record[x][1]=rs.getString("achternaam");
record[x][2]=rs.getString("voornaam");
record[x][3]=rs.getString("straat");
record[x][4]=rs.getString("huisnr");
record[x][5]=rs.getString("postnr");
record[x][6]=rs.getString("gemeente");
myModel.addRow(record[x]);
x++;
}
conn.close();
}
catch (Exception ex)
{
ex.getStackTrace();
}
}
}
);


panel.add(jScrollPane);
getContentPane().add(panel);

Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
setSize(new Dimension(800, 600));
setLocation((screenSize.width-800)/2,(screenSize.height-600)/2);
}



public void actieTabelselectie(int selectie){
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "passwoord");
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM klanten WHERE id="+(selectie));
while (rs.next()) {
rs01.setText(rs.getString("id"));//omzetten naar string
rs02.setText(rs.getString("geslacht"));
rs03.setText(rs.getString("achternaam"));
rs04.setText(rs.getString("voornaam"));
rs05.setText(rs.getString("straat"));
rs06.setText(rs.getString("huisnr"));
rs07.setText(rs.getString("postnr"));
rs08.setText(rs.getString("gemeente"));
rs09.setText(rs.getString("telefoon"));
rs10.setText(rs.getString("GSM"));
rs11.setText(rs.getString("fax"));
rs10.setText(rs.getString("email"));
rs13.setText(rs.getString("korting"));
rs14.setText(rs.getString("nieuws"));
rs01.disable();
}
conn.close();
}
catch (Exception ex)
{
ex.getStackTrace();
}
}

@SuppressWarnings("test")
public void vulTabel(){

int y = myModel.getRowCount();
for(int a = 0; a < y; a++)
{
myModel.removeRow(0);
}
try
{
System.out.println("start");
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "passwoord");
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM `klanten`LIMIT 0 , 1000");
int x;x=0;
while (rs.next()) {
record[x][0]=String.valueOf(rs.getInt("id"));
record[x][1]=rs.getString("achternaam");
record[x][2]=rs.getString("voornaam");
record[x][3]=rs.getString("straat");
record[x][4]=rs.getString("huisnr");
record[x][5]=rs.getString("postnr");
record[x][6]=rs.getString("gemeente");
myModel.addRow(record[x]);
x++;
}
conn.close();
}
catch (Exception ex)
{
ex.getStackTrace();
}
}

public void nieuwKlantenForm(){

rs01.setText("Auto");
rs02.setText("");
rs03.setText("");
rs04.setText("");
rs05.setText("");
rs06.setText("");
rs07.setText("");
rs08.setText("");
rs09.setText("");
rs10.setText("");
rs11.setText("");
rs10.setText("");
rs13.setText("");
rs14.setText("");
rs01.disable();

}


class KnpnieHandler implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
try
{
nieuwKlantenForm();
}
catch (Exception ex)
{
ex.getStackTrace();
}
System.out.println("nieuw");
knp_delete.setEnabled( false );
knp_wijzigen.setEnabled( false );
}
}

class KnptoeHandler implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "passwoord");
Statement statement = conn.createStatement();
String s = rs13.getText();
int i13;
if (s == "") {i13 = 0;} else {i13 = Integer.parseInt(s);}
statement.executeUpdate("INSERT INTO klanten ( id , geslacht , achternaam , voornaam , straat , huisnr , postnr , gemeente , telefoon , GSM , fax , email , korting , nieuws ) VALUES (0, '"+rs02.getText()+"', '"+rs03.getText()+"', '"+rs04.getText()+"', '"+rs05.getText()+"', '"+rs06.getText()+"', '"+rs07.getText()+"', '"+rs08.getText()+"', '"+rs09.getText()+"', '"+rs10.getText()+"', '"+rs11.getText()+"', '"+rs12.getText()+"', "+i13+", '"+rs14.getText()+"')");
conn.close();
}
catch (Exception ex)
{
ex.getStackTrace();
System.out.println(ex);
}
System.out.println("INSERT"+rs13.getText());
vulTabel();
knp_delete.setEnabled(true);
knp_wijzigen.setEnabled(true);
}
}


class KnpwijHandler implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "passwoord");
Statement statement = conn.createStatement();
String s = rs01.getText();
int i01 = Integer.parseInt(s);
System.out.println(i01);
System.out.println(rs02.getText());
statement.executeUpdate("UPDATE klanten SET geslacht = '"+rs02.getText()+"',achternaam = '"+rs03.getText()+"',voornaam = '"+rs04.getText()+"',straat = '"+rs05.getText()+"',huisnr = '"+rs06.getText()+"',postnr = '"+rs07.getText()+"',gemeente = '"+rs08.getText()+"',telefoon = '"+rs09.getText()+"',GSM = '"+rs10.getText()+"',fax = '"+rs11.getText()+"',email = '"+rs12.getText()+"',korting = '"+rs13.getText()+"',nieuws = '"+rs14.getText()+"' WHERE id = "+ i01 +" LIMIT 1");
conn.close();
}
catch (Exception ex)
{
ex.getStackTrace();
}
System.out.println("vullen");
vulTabel();
}
}

class KnpdelHandler implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "passwoord");
Statement statement = conn.createStatement();
String s = rs01.getText();
int i01 = Integer.parseInt(s);
statement.executeUpdate("DELETE FROM klanten WHERE id = "+i01);
System.out.println(i01);
conn.close();
}
catch (Exception ex)
{
ex.getStackTrace();
}
System.out.println("delete");
vulTabel();
nieuwKlantenForm();
}
}

public static void main(String args[])
{
new AdminKlanten().setVisible(true);
}

}
 

 

2.Code OpzoekenKlant.java

package src;

import javax.swing.*;
import java.awt.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.BoxLayout;
import javax.swing.JComboBox;
import javax.swing.JDesktopPane;
import javax.swing.JFrame;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
import javax.swing.table.DefaultTableModel;
import javax.swing.event.*;

import java.awt.event.*;
//import org.eclipse.swt.SWT;
//import org.eclipse.swt.widgets.Listener;

public class OpzoekenKlant extends JInternalFrame
{

public OpzoekenKlant()
{

super("Klant Opzoeken",true,true,true,true);
try {
//setDefaultCloseOperation(EXIT_ON_CLOSE);
//jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}

JPanel panel = new JPanel();
panel.setLayout(new BoxLayout(panel, BoxLayout.Y_AXIS));
final String[] columnNames = {"id","Familienaam","Voornaam","Straat","Nr","Postnr","Gemeente"};
final Object[][] record= new Object[1000][7];

try
{
System.out.println("start");
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "passwoord");
Statement statement = conn.createStatement();
//ResultSet rs = statement.executeQuery("SELECT 'id','achternaam','voornaam','straat`,'huisnr','postnr' FROM 'klanten' WHERE 'gemeente' = 'vleteren' LIMIT 0 , 30");
ResultSet rs = statement.executeQuery("SELECT * FROM `klanten`LIMIT 0 , 30");
int x;x=0;
while (rs.next()) {
record[x][0]=String.valueOf(rs.getInt("id"));
record[x][1]=rs.getString("achternaam");
record[x][2]=rs.getString("voornaam");
record[x][3]=rs.getString("straat");
record[x][4]=rs.getString("huisnr");
record[x][5]=rs.getString("postnr");
record[x][6]=rs.getString("gemeente");
x++;
}
conn.close();

}
catch (Exception ex)
{
ex.getStackTrace();
}

final DefaultTableModel myModel = new DefaultTableModel(record,columnNames )
{

//Gezien er geen foutenroutine voorzien is in dit voorbeeld zal de code hier vastlopen

//indien er geen database "voorraad" en tabel "klanten" bestaat

public Class getColumnClass(int c)
{
return getValueAt(0, c).getClass();
}
};
final JTable table = new JTable(myModel);
table.setSurrendersFocusOnKeystroke(true);
table.putClientProperty("terminateEditOnFocusLost", Boolean.TRUE);
JScrollPane jScrollPane = new JScrollPane();
jScrollPane.setViewportView(table);


Font font01 = new Font("Arial", Font.BOLD, 18);
Font font02 = new Font("Arial", Font.BOLD, 24);

JLabel lab01 = new JLabel("Criteria");
JLabel lab02 = new JLabel("Zoekitem");
JLabel lab03 = new JLabel("Info Klant opzoeken");

add(lab01);lab01.setFont(font01);lab01.setForeground(Color.blue);lab01.setBounds(18, 60, 100, 20);lab01.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab02);lab02.setFont(font01);lab02.setForeground(Color.blue);lab02.setBounds(200, 60, 150, 20);lab02.setHorizontalAlignment(SwingConstants.RIGHT);
add(lab03);lab03.setFont(font02);lab03.setForeground(Color.darkGray);lab03.setBounds(36, 20, 250, 30);lab03.setHorizontalAlignment(SwingConstants.RIGHT);

final JTextField rs01 = new JTextField("");//zoek item

add(rs01);rs01.setBounds(270, 85, 150, 22);rs01.setFont(font01);

JButton knopZoek = new JButton("Zoek");

knopZoek.setBounds(440, 62, 80, 44);
knopZoek.setFont(font01);
add(knopZoek);

final JComboBox comboBox = new JComboBox();
comboBox.setName("JComboBox");
comboBox.setBounds(55,85,150,22);
comboBox.setPreferredSize(new java.awt.Dimension(100,22));
comboBox.addItem("");
comboBox.addItem("Id");
comboBox.addItem("achternaam");
comboBox.addItem("Voornaam");
comboBox.addItem("Straat");
comboBox.addItem("Huisnummer");
comboBox.addItem("Postnummer");
comboBox.addItem("Gemeente");
comboBox.setFont(font01);
add(comboBox);

for(int x = 0 ; x < 10 ; x++)
{
panel.add(new JLabel(" "));
}

knopZoek.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
int y = myModel.getRowCount();
for(int a = 0; a < y; a++)
{
myModel.removeRow(0);
}
String[] achter; achter = new String[7];
System.out.println(comboBox.getSelectedItem());
try
{
System.out.println("start");
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "password");
Statement statement = conn.createStatement();
//ResultSet rs = statement.executeQuery("SELECT 'id','achternaam','voornaam','straat`,'huisnr','postnr' FROM 'klanten' WHERE 'gemeente' = 'vleteren' LIMIT 0 , 30");
ResultSet rs = statement.executeQuery("SELECT * FROM klanten WHERE "+comboBox.getSelectedItem()+" = '"+rs01.getText()+"' LIMIT 0 , 1000");
int x;x=0;
while (rs.next()) {
record[x][0]=String.valueOf(rs.getInt("id"));
record[x][1]=rs.getString("achternaam");
record[x][2]=rs.getString("voornaam");
record[x][3]=rs.getString("straat");
record[x][4]=rs.getString("huisnr");
record[x][5]=rs.getString("postnr");
record[x][6]=rs.getString("gemeente");
myModel.addRow(record[x]);
x++;
}
conn.close();
}
catch (Exception ex)
{
ex.getStackTrace();
}
}
}
);

panel.add(jScrollPane);
getContentPane().add(panel);

Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
setSize(new Dimension(800, 600));
setLocation((screenSize.width-800)/2,(screenSize.height-600)/2);

}


public void knopZoekActie(String val, Object crit, DefaultTableModel dtm){


Object[][] record= new Object[1000][7];


try
{
System.out.println("start");
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/voorraad", "user", "password");
Statement statement = conn.createStatement();
//ResultSet rs = statement.executeQuery("SELECT 'id','achternaam','voornaam','straat`,'huisnr','postnr' FROM 'klanten' WHERE 'gemeente' = 'vleteren' LIMIT 0 , 30");
ResultSet rs = statement.executeQuery("SELECT * FROM `klanten`LIMIT 0 , 30");
int x;x=0;int y;y=0;
while (rs.next()) {
record[x][0]=String.valueOf(rs.getInt("id"));
record[x][1]=rs.getString("achternaam");
record[x][2]=rs.getString("voornaam");
record[x][3]=rs.getString("straat");
record[x][4]=rs.getString("huisnr");
record[x][5]=rs.getString("postnr");
record[x][6]=rs.getString("gemeente");
x++;
}
conn.close();
for (y=0;y<x;y++){dtm.addRow(record);}
}
catch (Exception ex)
{
ex.getStackTrace();
}


}

public static void main(String args[])
{
new OpzoekenKlant().setVisible(true);
}
}

 

3.Code VoorraadBeheer.java

package src;


import javax.swing.JDesktopPane;
import javax.swing.JMenu;
import javax.swing.JMenuItem;
import javax.swing.JMenuBar;
import javax.swing.JFrame;
import javax.swing.KeyStroke;
import java.awt.event.*;
import java.awt.*;


public class VoorraadBeheer extends JFrame
                               implements ActionListener {

    JDesktopPane desktop;

    public VoorraadBeheer() {
        super("Voorraadbeheer");

        //50 pixels van rand scherm

        int inset = 50;
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        setBounds(inset, inset,
                  screenSize.width  - inset*2,
                  screenSize.height - inset*2);


        desktop = new JDesktopPane(); //a specialized layered pane
        setContentPane(desktop);
        setJMenuBar(createMenuBar());
        desktop.setDragMode(JDesktopPane.OUTLINE_DRAG_MODE);
    }

    protected JMenuBar createMenuBar() {
        JMenuBar menuBar = new JMenuBar();

        JMenu menu = new JMenu("Administratie");
        menu.setMnemonic(KeyEvent.VK_A);
        menuBar.add(menu);

        JMenuItem menuItem01 = new JMenuItem("Producten");
        menuItem01.setMnemonic(KeyEvent.VK_P);
        menuItem01.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_P, ActionEvent.ALT_MASK));
        menuItem01.setActionCommand("adminpro");
        menuItem01.addActionListener(this);
        menu.add(menuItem01);

        JMenuItem menuItem02 = new JMenuItem("Klanten");
        menuItem02.setMnemonic(KeyEvent.VK_K);
        menuItem02.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_K, ActionEvent.ALT_MASK));
        menuItem02.setActionCommand("adminkla");
        menuItem02.addActionListener(this);
        menu.add(menuItem02);    
        
        JMenuItem menuItem03 = new JMenuItem("Leveranciers");
        menuItem03.setMnemonic(KeyEvent.VK_L);
        menuItem03.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_L, ActionEvent.ALT_MASK));
        menuItem03.setActionCommand("adminlev");
        menuItem03.addActionListener(this);
        menu.add(menuItem03);
        
        JMenuItem menuItem04 = new JMenuItem("Klant opzoeken");
        menuItem04.setMnemonic(KeyEvent.VK_A);
        menuItem04.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_A, ActionEvent.ALT_MASK));
        menuItem04.setActionCommand("adminzoek");
        menuItem04.addActionListener(this);
        menu.add(menuItem04);
        
        JMenuItem menuItem05 = new JMenuItem("Printbeheer");
        menuItem05.setMnemonic(KeyEvent.VK_P);
        menuItem05.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_P, ActionEvent.ALT_MASK));
        menuItem05.setActionCommand("adminprint");
        menuItem05.addActionListener(this);
        menu.add(menuItem05);            
        
        
        JMenu menu10 = new JMenu("Voorraad");
        menu.setMnemonic(KeyEvent.VK_V);
        menuBar.add(menu10);

        JMenuItem menuItem11 = new JMenuItem("Producten IN");
        menuItem11.setMnemonic(KeyEvent.VK_I);
        menuItem11.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_I, ActionEvent.ALT_MASK));
        menuItem11.setActionCommand("Prodin");
        menuItem11.addActionListener(this);
        menu10.add(menuItem11);

        JMenuItem menuItem12 = new JMenuItem("Producten UIT");
        menuItem12.setMnemonic(KeyEvent.VK_U);
        menuItem12.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_U, ActionEvent.ALT_MASK));
        menuItem12.setActionCommand("produit");
        menuItem12.addActionListener(this);
        menu10.add(menuItem12);    
        
        JMenu menu20 = new JMenu("Fakturatie");
        menu.setMnemonic(KeyEvent.VK_F);
        menuBar.add(menu20);

        JMenuItem menuItem21 = new JMenuItem("Kostprijs");
        menuItem21.setMnemonic(KeyEvent.VK_K);
        menuItem21.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_K, ActionEvent.ALT_MASK));
        menuItem21.setActionCommand("kost");
        menuItem21.addActionListener(this);
        menu20.add(menuItem21);

        JMenuItem menuItem22 = new JMenuItem("Rekening");
        menuItem22.setMnemonic(KeyEvent.VK_R);
        menuItem22.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_R, ActionEvent.ALT_MASK));
        menuItem22.setActionCommand("rek");
        menuItem22.addActionListener(this);
        menu20.add(menuItem22);    
        
        JMenu menu50 = new JMenu("Systeem");
        menu.setMnemonic(KeyEvent.VK_S);
        menuBar.add(menu50);
        
        JMenuItem menuItem51 = new JMenuItem("Quit");
        menuItem51.setMnemonic(KeyEvent.VK_Q);
        menuItem51.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_Q, ActionEvent.ALT_MASK));
        menuItem51.setActionCommand("quit");
        menuItem51.addActionListener(this);
        menu50.add(menuItem51);

        return menuBar;
    }


    public void actionPerformed(ActionEvent e) {
        if ("adminpro".equals(e.getActionCommand())) { //new
            maakProductAdmin();
        } else if ("adminkla".equals(e.getActionCommand())) {
            maakKlantenAdmin();
        } else if ("adminlev".equals(e.getActionCommand())) {
            maakLeveranciersAdmin();    
        } else if ("adminzoek".equals(e.getActionCommand())) {
            maakKlantOpzoeken();
        } else { //quit
            quit();
        }
    }



    protected void maakProductAdmin() {
        //AdminProducten frame01 = new AdminProducten();
        //    frame01.setVisible(true); //necessary as of 1.3
        //    desktop.add(frame01);                
        //    try {
        //        frame01.setSelected(true);
        //        } catch (java.beans.PropertyVetoException e) {}    
    }
    
    protected void maakKlantenAdmin() {
        AdminKlanten frame02 = new AdminKlanten();
        frame02.setVisible(true);
        desktop.add(frame02);
        try {
            frame02.setSelected(true);
        } catch (java.beans.PropertyVetoException e) {}
    }    
    
    protected void maakLeveranciersAdmin() {
        //AdminLeveranciers frame03 = new AdminLeveranciers();
        //frame03.setVisible(true);
        //desktop.add(frame03);
        //try {
        //    frame03.setSelected(true);
        //} catch (java.beans.PropertyVetoException e) {}
    }        

    protected void maakKlantOpzoeken() {
        OpzoekenKlant frame04 = new OpzoekenKlant();
        frame04.setVisible(true);
        desktop.add(frame04);
        try {
            frame04.setSelected(true);
        } catch (java.beans.PropertyVetoException e) {}
    }       
    
    
    //Beêindig toepessing.
    protected void quit() {
        System.exit(0);
    }

    /**
     * Maak hoofdraam
     */
    private static void createAndShowGUI() {

        JFrame.setDefaultLookAndFeelDecorated(true);
        VoorraadBeheer frame = new VoorraadBeheer();
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setVisible(true);
    }
    


    public static void main(String[] args) {

        javax.swing.SwingUtilities.invokeLater(new Runnable() {
            public void run() {
                createAndShowGUI();
            }
        });
    }
}

---

Run VoorraadBeheer.java  als java application

dit project is slechts een basis voorbeeld gezien het de uiteindelijke bedoeling is om met hibernate 3 te werken.

De volgende stap in dit voolbeeld die we volgen is : het object klant maken

Ook is het aan te raden om in een definitief project met meer duidelijke benamingen te weken

bvb ipv lab01 » labelKlantID te gebruiken enz...

zie : Aanmaken object klant : Klant;java