hi i am doing a login page for my project it suppose to connect to a database.however when i compile the
java codes severals errors appear...
i have been having problems for a few weeks, hope tat someone can advise me on this project. thanks!!
//Java core packages
import java.awt.*;
import java.awt.event.*;
// Java extension packages
import javax.swing.*;
public class TestingLogin extends JFrame
{
private JTextField nameField;
private JPasswordField passwordField;
private JButton loginButton, exitButton;
private JLabel label1;
//******************************************************
String dialogmessage;
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc
dbc:try";
String dialogf = "LOGIN FAILED";
String output = " ";
int dialogtype = JOptionPane.PLAIN_MESSAGE;
//**********************************************************
public TestingLogin()
{
super( "TestingLoginPage" );
Container container = getContentPane();
container.setLayout( new FlowLayout() );
Icon nyp = new ImageIcon( "nyp.gif" );
label1 = new JLabel("Student Feedback System", nyp,SwingConstants.LEFT );
// construct textfield with default sizing
nameField = new JTextField( 10 );
container.add( nameField );
// construct textfield with default text
passwordField = new JPasswordField( 10 );
container.add( passwordField );
// register event handlers
TextFieldHandler handler = new TextFieldHandler();
nameField.addActionListener( handler );
passwordField.addActionListener( handler );
// create login button
loginButton = new JButton( "Login" );
container.add( loginButton );
// create exit button
exitButton = new JButton( "Exit" );
container.add( exitButton );
// create an instance of inner class ButtonHandler
loginButton.addActionListener( handler );
exitButton.addActionListener( handler );
setSize( 350, 100 );
setVisible( true );
}
// execute application
public static void main( String args[] )
{
TestingLogin application = new TestingLogin();
application.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE );
}
// private inner class for event handling
private class TextFieldHandler implements ActionListener
{
// process text field events
public void actionPerformed( ActionEvent event )
{
String string = "";
// user pressed Enter in JTextField nameField
if ( event.getSource() == nameField )
string = "nameField: " + event.getActionCommand();
// user pressed Enter in JTextField passwordField
else if ( event.getSource() == passwordField )
{
JPasswordField pwd =
( JPasswordField ) event.getSource();
string = "passwordField: " + new String( passwordField.getPassword() );
}
}
}
//**********************************************************************
public void accessDB()
{
try
{
String var1 = nameField.getText();
var1 = var1.trim();
String var2 = passwordField.getText();
var2 = var2.trim();
sql = "SELECT STAFFID, PASSWORD FROM Staff WHERE STAFFID='"+var1+"' AND PASSWORD='"+var2+"'";
Class.forName(driver);
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
boolean hasResults = statement.execute(sql);
if(hasResults)
{
ResultSet result = statement.getResultSet(); // get result from query
if(result!=null)
{
displayResults(result);
}
connection.close();
}
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null, "Failed to load JDBC/ODBC driver","Message",JOptionPane.INFORMATION_MESSAGE);
}
}
public void displayResults(ResultSet r) throws SQLException
{
ResultSetMetaData rmeta = r.getMetaData();
int foundrec = 0;
int numColumns=rmeta.getColumnCount();
while(r.next())
{
String param4 = r.getString(4).trim();
if (param4.equals("Accounts"))
{
output += "\nTesting";
JOptionPane.showMessageDialog(null, output);
}
}
if(foundrec==0)//field=0
{
dialogmessage = "Please Re-Login";
dialogtype = JOptionPane.INFORMATION_MESSAGE;
JOptionPane.showMessageDialog((Component) null, dialogmessage, dialogf, dialogtype);
nameField.setText(" ");
passwordField.setText(" ");
}
}
//***********************************************************************
// inner class for button event handling
private class ButtonHandler implements ActionListener
{
// handle button event
public void actionPerformed( ActionEvent event )
{
JOptionPane.showMessageDialog( null,"You pressed: " + event.getActionCommand() );
}
}
}
this is the compilation results
C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java:132: cannot resolve symbol
symbol : class ResultSet
location: class TestingLogin
public void displayResults(ResultSet r) throws SQLException
^
C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java:132: cannot resolve symbol
symbol : class SQLException
location: class TestingLogin
public void displayResults(ResultSet r) throws SQLException
^
C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java:108: cannot resolve symbol
symbol : variable sql
location: class TestingLogin
sql = "SELECT STAFFID, PASSWORD FROM Staff WHERE STAFFID='"+var1+"' AND PASSWORD='"+var2+"'";
^
C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java:110: cannot resolve symbol
symbol : class Connection
location: class TestingLogin
Connection connection=DriverManager.getConnection(url);
^
C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java:110: cannot resolve symbol
symbol : variable DriverManager
location: class TestingLogin
Connection connection=DriverManager.getConnection(url);
^
C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java:111: cannot resolve symbol
symbol : class Statement
location: class TestingLogin
Statement statement = connection.createStatement();
^
C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java:112: cannot resolve symbol
symbol : variable sql
location: class TestingLogin
boolean hasResults = statement.execute(sql);
^
C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java:115: cannot resolve symbol
symbol : class ResultSet
location: class TestingLogin
ResultSet result = statement.getResultSet(); // get result from query
^
C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java:134: cannot resolve symbol
symbol : class ResultSetMetaData
location: class TestingLogin
ResultSetMetaData rmeta = r.getMetaData();
^
Note: C:\Documents and Settings\013119R\StudentFeedbackSystem\studentfdbk\TestingLogin.java uses or overrides a deprecated API.
Note: Recompile with -deprecation for details.
9 errors
Tool completed with exit code 1
[email protected] 
And, since most questions I get are actually of interest to everyone, I prefer to answer them where everyone can see the answer.
