getContenetData = con.createStatement();
			PreparedStatement updateStatment = con.prepareStatement("UPDATE Counter SET CounterName = '2'");
			updateStatment.executeUpdate();

 package  de.Calypso.tools;

 import  java.sql.Connection;
 import  java.sql.DriverManager;
 import  java.sql.PreparedStatement;
 import  java.sql.ResultSet;
 import  java.sql.SQLException;
 import  java.sql.Statement;


 public   class  DBprovider {
	 private   final   int  DBART =  1 ;
	 private   static  DBprovider DBlinc;
	 private  Connection con;
	
 private  DBprovider()  throws  SQLException {
		 switch  (DBART) {			//Ich fersuche jetzt DB konnektion für 3 DB- Vareanten zu realisiren
		 case   1 :						//Wareant "Access"
			 try  {
				//Initialisirung von DB Dreiver
				 Class .forName("sun.jdbc.odbc.JdbcOdbcDriver");
				//DB Location
				String database = "jdbc:odbc:Driver=Microsoft Access Driver (*.mdb);DBQ=DB/Calypso.mdb;";
				con = DriverManager.getConnection(database);
			}  catch  (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				System.out.println("DB error: " + e.getMessage());
				e.printStackTrace();
			}
			 break ;
		 case   2 :					//Wareant "MySQL".Speter
			 break ;
		 case   3 :					//Wareant "HSQLDB".Speter
			 break ;
		}
	}

	 public   static  DBprovider getInstance()  throws  SQLException {
		 if  (DBlinc ==  null ) {
			DBlinc =  new  DBprovider();
		}
		 return  DBlinc;
	}

	 public  Connection getConnection() {
		 return  con;
	}

		 public  String reservNextCounter(String CounterName) {
		Statement getCountertData;
		 try  {
			getCountertData = con.createStatement();
			String getCounterSQL = "select * from Counter where CounterName = '"
					+ CounterName + "'";
			ResultSet rs = getCountertData.executeQuery(getCounterSQL);
			 if  (rs.next()) {
				 int  intCounter = rs.getInt("Counter") +  1 ;
				 int  year = rs.getInt("Year");
				 int  size = rs.getInt("Size");
				//
				String counterNr = Integer.toString(intCounter);
				 while  (counterNr.length() < size) {
					counterNr = "0" + counterNr;
				}
				String counterYear = Integer.toString(year);
				 if  (counterYear.length() ==  1 ) {
					counterYear = "0" + counterYear;
				}
				String counter = counterYear + "-" + counterNr;
				 return  counter;
			}  else  {
				System.out.println("Ungultige Counter name");
			}

		}  catch  (SQLException e) {
			e.printStackTrace();
		}
		 return  "X";
	}

	 public   void  conformCounter(String CounterName) {
		 try  {
			Statement updateStatment = con.createStatement();
			updateStatment.executeUpdate("UPDATE Counter SET Counter = 3");
		}  catch  (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

dBlinc = DBprovider.getInstance();
			System.out.println(dBlinc.reservNextCounter("test"));
			dBlinc.conformCounter("test");
			System.out.println(dBlinc.reservNextCounter("test"));
			dBlinc.conformCounter("test");
			System.out.println(dBlinc.reservNextCounter("test"));
			dBlinc.conformCounter("test");
			System.out.println(dBlinc.reservNextCounter("test"));
			dBlinc.conformCounter("test");
			System.out.println(dBlinc.reservNextCounter("test"));
			dBlinc.conformCounter("test");
			System.out.println(dBlinc.reservNextCounter("test"));
			dBlinc.conformCounter("test");

 05 - 0002 
 05 - 0003 
 05 - 0004 
 05 - 0005 
 05 - 0006