AWT-EventQueue-0 java.lang.NullPointerException

[susan]

Hi, Can some one please help me, i have create a form in netbeans,my backend database choice is mysql, i am having problem inserting and dispalying data from the database.

this is the method i call when a submit button is clicked

Code:

public void InsertData()
{
Connection conn = null;
//getData();
// PreparedStatement stmt = null;

//String initials ;

initials = jTextField1.getText();
name = jTextField2.getText();
surname = jTextField10.getText();
race = jTextField6.getText();
// email = jTextField6.getText();
company = jTextField3.getText();
//String type=(String)jList1.getSelectedItem();

//physical_add = jTextArea1.getText();
// postal_add = jTextArea2.getText();

System.out.println(initials);
System.out.println(name);
System.out.println(surname);
System.out.println(race);
System.out.println(company);

String insertStr ="";
String sql;
// String sql2;
String Statement;
String select;

//Statement stmt = conn.createStatement();


try{

sql= "insert into bus (initals, name, surname, comapany_name) values("+quotate(initials)+","+quotate(name)+","+quotate(surname)+","+quotate(company)+")";

int done=stmt.executeUpdate(sql);

System.out.println("shows");
stmt.close();
conn.close();

//stmt.executeUpdate ( "INSERT INTO client( initials ) VALUES ( "+quotate(initials)+" ) " );




jTextField8.setText("1 row inserted");

getContentPane().removeAll();
initComponents();

}

catch(Exception e){
jTextField8.setText("Error occurred in inserting data");
e.printStackTrace(System.err);
}

//String type =(String)jList1.getSelectedItem();
}

i get the fulling

• java.lang.NullPointerException

then i have my second method

which dispalys data

Code:

private ResultSet getResultFromClient() {

ResultSet rs=null;

try{
rs=stmt.executeQuery("Select * from client");
System.out.println("name "+ rs.getString(1));

}
catch(SQLException e){}

return rs;

}

i get the following

• Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException

Thanks

[Lakhsika Rajakaruna]

Hi Susan
What is the java, netbeans versions you are using?

[lakshika]

I think the version of Netbeans does not matter as long as you are using the right platform. I'm getting the same error when compiling an earlier code that works well in java 1.5 but gives
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException

in jdk1.6 .
does any one have a solution for this?