How to insert date values to database using java swings

[Narendra kodli]

Hello,

can any buddy tell me how to insert date values from a calender to data base by using java swings

[Maneesh Godbole]

To start with, SwingIsAProperNoun !
Secondly, swing is a front end technology framework. It has nothing which will let you interact with the DB directly. You will need to write JDBC code to do that.

[Rob Camick]

Check out JDBC Database Access for the basics of usingSQL with Java.

[Narendra kodli]

Thank you for the reply. Ya i know how to link database but my problem is to create a form with cambobox, pressing on which a calender should be displayed and after selecting date month year it should be set to textfield so that i can insert it into the database. is their any code to do that

[Maneesh Godbole]

Narendra kodli wrote:Thank you for the reply. Ya i know how to link database but my problem is to create a form with cambobox, pressing on which a calender should be displayed and after selecting date month year it should be set to textfield so that i can insert it into the database. is their any code to do that

No. You will have to code it yourself.
All these components will provide you with appropriate getterXXX methods which you can use to retrieve user selected/input values. Once you have these values you can put them in your DB.
For a nice calendar component, check out JCalendar

[Narendra kodli]

Ok... Now i am able to get date values and my new task is to calculate to date from from date. That is if i give todays date it should calculate and display next year date. I am using spinnerdatemodel and jspinner. How to do that

[Michael Dunn]

> That is if i give todays date it should calculate and display next year date. I am using spinnerdatemodel and jspinner. How to do that

post the code you've tried.

[Narendra kodli]

Here is my code


import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
import java.text.*;
import java.util.*;
import javax.swing.text.*;
import javax.swing.event.*;
public class calender extends JFrame {


public calender(){

final JFormattedTextField t1=new JFormattedTextField();
final JFormattedTextField t2=new JFormattedTextField();


SpinnerDateModel model = new SpinnerDateModel(new Date(), null, null,
Calendar.DAY_OF_YEAR);

final JSpinner spinner = new JSpinner(model);
spinner.setPreferredSize(new Dimension(120, spinner.getPreferredSize().height));
JSpinner.DateEditor editor = new JSpinner.DateEditor(spinner, "MMM dd yyyy");
editor.getTextField().setHorizontalAlignment(JTextField.CENTER);

final SpinnerDateModel model1 = new SpinnerDateModel(new Date(), null, null,
Calendar.DAY_OF_YEAR);
final JSpinner spinner1 = new JSpinner(model1);
spinner1.setPreferredSize(new Dimension(120, spinner1.getPreferredSize().height));
JSpinner.DateEditor editor1 = new JSpinner.DateEditor(spinner1, "MMM dd yyyy");
editor1.getTextField().setHorizontalAlignment(JTextField.CENTER);

spinner1.setEditor(editor1);
spinner.setEditor(editor);

spinner.addChangeListener(new ChangeListener()
{

public void stateChanged(ChangeEvent e)
{
t1.setValue(spinner.getValue());

}
});

spinner1.addChangeListener(new ChangeListener()
{

public void stateChanged(ChangeEvent e1)
{

t2.setValue(spinner1.getValue());
}
});


final JFrame frame=new JFrame("Date Entry");
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);


JPanel panel=new JPanel();
panel.setLayout(null);

panel.setBackground(Color.cyan);
frame.add(panel);

final JButton ok =new JButton("OK");
final JButton close =new JButton("Close");

ok.addActionListener(new ActionListener()
{

public void actionPerformed(ActionEvent ae){
if (ae.getSource()==ok) {


}
}});

close.addActionListener(new ActionListener()
{

public void actionPerformed(ActionEvent ae){
if (ae.getSource()==close) {

frame.setVisible(false);
}
}});

Label l1=new Label("Period Selection:");
Label l2=new Label("From Date:");
Label l3=new Label("To Date:");
Choice comb1=new Choice();
Choice comb2=new Choice();


panel.add(spinner);
panel.add(spinner1);
panel.add(l1);
panel.add(l2);
panel.add(l3);

panel.add(ok);
panel.add(close);

panel.add(comb1);
// panel.add(comb2);

panel.add(t1);
panel.add(t2);

comb1.add("MONTHLY");
comb1.add("QUARTERLY");
comb1.add("HALFYEARLY");
comb1.add("YEARLY");

comb1.setBounds(150, 55, 100, 30);
l1.setBounds(50, 50, 100, 30);

spinner.setBounds(150, 100, 100, 30);
spinner1.setBounds(150, 150, 100, 30);

l2.setBounds(81, 100, 100, 30);
l3.setBounds(95, 150, 100, 30);
//t1.setBounds(50, 200, 100, 30);
//t2.setBounds(200, 200, 100, 30);
ok.setBounds(150, 200, 80, 30);
close.setBounds(250, 200, 80, 30);
//frame.setLayout(new FlowLayout());
frame.setSize(400,300);
frame.setLocation(350,150);
frame.setVisible(true);
}


public static void main(String[] args) {
calender c=new calender();
}
}

[Michael Dunn]

whay are you mixing awt's Label and Choice with Swing components?
why set preferred sizes, then a null layout with setBounds()?

I'd suggest you fix the GUI part before attempting to add functionality to it.

[Narendra kodli]

Ok... But the problem is with next date calculation. Can you give any solution for that.

[Darryl Burke]

Michael Dunn wrote:I'd suggest you fix the GUI part before attempting to add functionality to it.

[Narendra kodli]

I don't know why you guys stick d with gui... any ways as you said i have replaced JLables and Choice with JCombobox. now can you tell me how to find next date from given date??

[Michael Dunn]

if I'm reading the code right, spinner1's value is to be set by a combination of spinner's date + the combobox time period.

if so:
1) create a method to set spinner1's date via java.util.Calendar class (let's call it 'cal')
set cal's time to that of spinner
create an int[] representing the periods in months 1,3,6,12 (monthly, quarterly etc)
add to cal (Calendar.MONTH field), int[comb1.getSelectedIndex()], which will add 1,3,6 or 12 months to cal.
now set spinner1's value to cal.
2) add listeners to spinner (not spinner1) and to comb1, so that whenever spinner or comb1 change,
the change will reset spinner1's value

[Aromal ayyappan]

By overriding the getNextValue() method , I think you can achieve the incremening the year by one.

SpinnerDateModel model = new SpinnerDateModel(new Date(), null, null, Calendar.YEAR){

public Object getNextValue() {

Calendar cal = Calendar.getInstance();
cal.setTime((Date)getValue());
cal.add(Calendar.YEAR,1);
//cal.add(getCalendarField(), 1);
Date next = cal.getTime();
return next;
}
};

[Narendra kodli]

By above method i am able to change only day or only month or only year for only one time. But i want all three fields to be changed based on spinner change listener for each change made.

[Darryl Burke]

Narendra, please UseOneThreadPerQuestion and BeForthrightWhenCrossPostingToOtherSites.