Calling a button to perform add function into database. Please help with the code.

[Yuta Lolap]

I have created a button on my Dashboard.java file as follows and i have a added a actionlistener to it and written the fuction in the a different class. What is want is when i click on the button add i want the items to be added in to the database.
Am i calling the add button e.getsource()the right way or is it wrong?
------------------------------------------------
Dashboard.java partial code

add =new JButton("Add");
	add(add);
	add.addActionListener(new myhandler(this));

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

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;





public class myhandler implements ActionListener {

	
	public Dashboard d;
	public myhandler(Dashboard d)
	{
		this.d=d;
		
	}
	
	
	@Override
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub

		String item=d.item.getText();
		String itemcode = d.itemCode.getText();
		String itemprice = d.itemPrice.getText();
		
		String itemquan = d.itemQuan.getText();
		
		if(e.getSource() == d.add)
		{
			PreparedStatement  ptmt= null;
			
			try {
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection conn = DriverManager.getConnection("jdbc:odbc:XE","system","tiger");
				System.out.println("Connection Successfull");
				System.out.println(conn);
				String q = "insert into items(item, itemcode,itemprice,itemquan) values (?,?,?,?)";
				ptmt = conn.prepareStatement(q);
				
				ptmt.setString(1, item);
				ptmt.setString(2, itemcode);
				
				ptmt.setString(3, itemprice);
				ptmt.setString(4, itemquan);
				
				ptmt.executeUpdate();
				//Statement stmt = conn.createStatement();
				
					
		
			
				/*while(rec.next())
				{
					System.out.println(rec.getString(1));
					System.out.println(rec.getString(2));
					System.out.println(rec.getInt(3));
					System.out.println(rec.getInt(4));
				}*/
			} catch (ClassNotFoundException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
				System.out.println(e);
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
				System.out.println(e);
			}
			
	       			
		}
		
	}

	
}

[Christophe Verré]

Please UseCodeTags (<- click this link) the next time you want to post some code.
I have added them for you this time.

[Christophe Verré]

Am i calling the add button e.getsource()the right way or is it wrong?

Yes, this is one way to do it.

[Campbell Ritchie]

I don’t like any action listeners with getSource in. But you have bigger problems than that, if you are not adding in the database.
I think you are going about the whole exercise the wrong way. Start by working out what to do in the database. Then work out a query, and get it working from the command line with a Java application. Once you have got that working, you can put the GUI on top of that. I think you will find your application quicker and easier to build like that.

[Yuta Lolap]

thanks i got it solved!