JSpinner value from Database.
-
I have this code which saves the value into database from JSpinner
SpinnerListModel monthModel = new SpinnerListModel();
String[] monthStrings = {"1Month","3Month","6Month","1Year"}; //get month names
monthModel = new SpinnerListModel(monthStrings);
JSpinner spinner = new JSpinner(monthModel);
statement.setString(28,(String)monthModel.getValue().toString().toUpperCase());But how to get that value back for Editing? I tried
spinner.setText((String)monthModel.getValue(),29);
But it says
The method setText(String, int) is undefined for the type JSpinner
How do I get the values from Database?again to JSpinner.
-
I have this code which saves the value into database from JSpinner
SpinnerListModel monthModel = new SpinnerListModel();
String[] monthStrings = {"1Month","3Month","6Month","1Year"}; //get month names
monthModel = new SpinnerListModel(monthStrings);
JSpinner spinner = new JSpinner(monthModel);
statement.setString(28,(String)monthModel.getValue().toString().toUpperCase());But how to get that value back for Editing? I tried
spinner.setText((String)monthModel.getValue(),29);
But it says
The method setText(String, int) is undefined for the type JSpinner
How do I get the values from Database?again to JSpinner.
You should have a database layer. It should NOT have any gui code in it. It provides a public API that allows an external caller to interact with the layer. The layer interacts with the database. That public API would have a method/class that would represent "save interval" and "get interval" where the 'interval' values represent '1 month', '3 Months', '6 months' (and note that I am NOT saying to store "1 month" as a value.) The 'save' method uses a database insert or perhaps update statement. And the 'get' uses a database query statement. You code that and test it. After you do that THEN your gui code, specifically the JSpinner uses the two methods.