I've managed to load the String for color out of the database.. like this
String sql = "SELECT * FROM flowchart WHERE ProcesID = " + ProcesID;
System.out.println(sql);
ResultSet resultset = statement.executeQuery(sql);
while (resultset.next()){
String tmpColor = resultset.getString("color");
color = new Color(Integer.parseInt(removeChar(tmpColor, '#'), 16));
}
which I found somewhere on the internet..
now I want to save stuff to the database.. which needs a varchar(10)
how do I get the correct value?