Skip to Main Content

New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JDBC insert statement problem

807598Sep 16 2006 — edited Mar 20 2007
i have the following code. please help me out.
import java.io.*;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement ;
import java.util.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;

public class BookIssue extends JFrame
{
	JComboBox cbBooks;
	JLabel lblIssue;
	String selectedBook;
	JButton btnIssue;

	public BookIssue(String title)
	{
		super(title);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		 lblIssue = new JLabel("Select books from combo box",JLabel.CENTER);
		 	
		 btnIssue = new JButton("Issue");

		cbBooks = new JComboBox(new Object[] {"RaghuRamkrishnan","J2CR","Netwrok Security"});    
		Container cp=getContentPane();
		setLayout(new FlowLayout());
		cp.add(lblIssue);
		cp.add(cbBooks);
		cp.add(btnIssue);
		selectedBook =(String) (cbBooks.getSelectedItem());
		btnIssue.addActionListener(new IssueListerner());


		setSize(300,300);
		setVisible(true);
		 
		
	}// constructor end

	class IssueListerner implements ActionListener 
	{
		Connection conn;
		Statement stmt;
	   
			public void actionPerformed(ActionEvent ae)
			 {
				 try
				 {
					 if(btnIssue==ae.getSource())
					{
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
						conn = DriverManager.getConnection("jdbc:odbc:JemNat","","");
						stmt=conn.createStatement();
						stmt.executeUpdate("Insert into StudentIssueDetails(BookName) values(selectedBook)");
						
			
					}///End outer if
					stmt.close();
					conn.close();
				 } //end try
				 catch(SQLException exc)
				{
					exc.printStackTrace();
				}
				catch(Exception exc)
				{
					exc.printStackTrace();
				}
			 }   /// end function
		
     }

	 public static void main(String[] args)
	{
		new BookIssue("Book Issue");
	}

	
} ///end class
	
getting the following list of errors::
---------- java ----------
RaghuRamkrishnan
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
at BookIssue$IssueListerner.actionPerformed(BookIssue.java:59)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2007
Added on Sep 16 2006
4 comments
459 views