Hi,
I am j madhu sudana rao working as a analyst programmer computer based learning sdn bhd in malaysia.Now i am Netbeans 5.0 version and also database mysql5.0 and i am using jar file mysql-connector-java-3.1.12.
I take two Jtextfields and Jbutton.
when click button i want display the records from mysql database,but i got following error
java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.sql.DriverManager;
import java.net.*;
import java.sql.SQLException;
private void btn_displayActionPerformed(java.awt.event.ActionEv ent evt) {
// TODO add your handling code here:
try {
System.out.println("ok");
Class.forName("com.mysql.jdbc.Driver").newInstance ();
System.out.println("ok");
String url = "jdbc:mysql://localhost:3306/asset";
Connection conn = DriverManager.getConnection(url,"root","123456");
Statement stmt = conn.createStatement();
ResultSet rs;
rs = stmt.executeQuery("SELECT username,password FROM user");
// while ( rs.next() )
// {
//String lastName = rs.getString("Lname");
// System.out.println(lastName);
rs.next();
txt_username.setText(rs.getString("username"));
txt_password.setText(rs.getString("password"));
// }
conn.close();
}
catch (Exception e)
{
System.err.println("Got an exception! ");
System.err.println(e.getMessage());
}
}
Please help me as early as possible
Tq
J madhu