Thread: Program not reading my Database

I'm trying to make my program read from a database. I've used the following code given by my online course to read from a database:

import java.sql.*;
 
public class Database
{
	private Connection conn = null;
	ResultSet rs;
	public Database()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection(
			   "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=PAT3");
			System.out.println("Connection successful");
		}
		catch(Exception e)
		{
			System.out.println("Failed to get connection");
			e.printStackTrace();
		}
	}

Now, in my program, I'm trying to make a button do work:

private void btnOKActionPerformed(java.awt.event.ActionEvent evt) {                                      
        // TODO add your handling code here:
        inputProductID.setText(PAT3.updateTbl("INSERT INTO TransactionDetails(CustomerID, ProductID, UnitPrice, Quantity)"
                +Integer.parseInt(lblCustomerID.getText())+
                "','"+Integer.parseInt(inputProductID.getText())+
                "','"+Integer.parseInt(lblUnitPrice.getText())+
                "','"+Integer.parseInt(inputQuantity.getText())+"';"));
        setVisible(false);
        JOptionPane.showMessageDialog(null,"Transaction has successfully been completed");
    }

In line 3, PAT3 is being underlined by my JDE (Netbeans) and the program is not running whenever I click this button.

I am having similar problems with data-retrievement throughout my program. I have entered the stuff into the ODBC here: itQuestion1.jpg and also put it into the file DSN after the first it didn't work in the user DSN.

Can anyone tell me what I'm doing wrong?

For problems like this, it is always best to show us the error message that your compiler gives you. I can guarantee you that NetBeans is giving you more than just a word being underlined. It looks to me though that you're trying to use PAT3 as a variable, but that it has not been declared as a variable anywhere. Also, does your program have an updateTbl method declared anywhere?

In this particular example, it is just PAT3 that is being underlined. The Error messages are:

Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: Uncompilable source code
at makeTransaction.btnOKActionPerformed(makeTransacti on.java:132)
at makeTransaction.access$000(makeTransaction.java:20 )
at makeTransaction$1.actionPerformed(makeTransaction. java:60)
at javax.swing.AbstractButton.fireActionPerformed(Abs tractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultB uttonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseRe leased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.jav a:6505)
at javax.swing.JComponent.processMouseEvent(JComponen t.java:3321)
at java.awt.Component.processEvent(Component.java:627 0)
at java.awt.Container.processEvent(Container.java:222 9)
at java.awt.Component.dispatchEventImpl(Component.jav a:4861)
at java.awt.Container.dispatchEventImpl(Container.jav a:2287)
at java.awt.Component.dispatchEvent(Component.java:46 87)
at java.awt.LightweightDispatcher.retargetMouseEvent( Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(C ontainer.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Conta iner.java:4422)
at java.awt.Container.dispatchEventImpl(Container.jav a:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719 )
at java.awt.Component.dispatchEvent(Component.java:46 87)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.j ava:723)
at java.awt.EventQueue.access$200(EventQueue.java:103 )
at java.awt.EventQueue$3.run(EventQueue.java:682)
at java.awt.EventQueue$3.run(EventQueue.java:680)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:696)
at java.awt.EventQueue$4.run(EventQueue.java:694)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 693)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:244)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:147)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:139)
at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:97)

I assumed PAT3 was declared and made accessable by the first batch of code?

I don't have an updateTbl method declared anywhere, which makes it weird that it isn't underlined. I assumed it was a method within java.sql.* seeing as it wasn't flagged as an error.

Originally Posted by EagerBrad

In this particular example, it is just PAT3 that is being underlined. The Error messages are:

The message above just tells us that you're trying to run uncompilable code. Don't do this, but instead just give us the error that the compiler gives you. With Eclipse you can see this by hovering your mouse over the code marked in error, and I'll bet that NetBeans is similar.

I assumed PAT3 was declared and made accessable by the first batch of code?

No. This:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(
			   "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=PAT3");

Creates a Connection object that is hopefully connected to your PAT3 database. No where is there a variable declared with the name PAT. The only variable initialized here is the conn variable. Consider going through the Oracle Java JDBC tutorial for the necessary details on what to do.

I don't have an updateTbl method declared anywhere, which makes it weird that it isn't underlined. I assumed it was a method within java.sql.* seeing as it wasn't flagged as an error.

The Java API and the tutorials will tell you what methods are available. You will want to refer to them often as otherwise you risk making up methods that don't exist, and that never works.

Originally Posted by curmudgeon

The message above just tells us that you're trying to run uncompilable code. Don't do this, but instead just give us the error that the compiler gives you. With Eclipse you can see this by hovering your mouse over the code marked in error, and I'll bet that NetBeans is similar.

Ah, that message is:

"cannot find symbol
symbol: variable PAT3
location: class makeTransaction"

No. This:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(
			   "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=PAT3");

Creates a Connection object that is hopefully connected to your PAT3 database. No where is there a variable declared with the name PAT. The only variable initialized here is the conn variable. Consider going through the Oracle Java JDBC tutorial for the necessary details on what to do.

Why would I be making a variable though? All I want to do is connect to the database, which is what this does.

The Java API and the tutorials will tell you what methods are available. You will want to refer to them often as otherwise you risk making up methods that don't exist, and that never works.

Yeah I know, but according to netbeans there is nothing wrong with that method, which is confusing me.