java Having trouble inserting data to mysql db through java

[Shammikit]

i want to insert some data to a table in my mysql db.firstly i got a null pointer exception error and after changing  rs= st.executeQuery(query); to rs= st.executeUpdate(query); i get no errors but no values are being sent to the db.i have correctly setup the db drivers and connection and i have checked my insert statement.all these look correct.please help me 

[Shammikit]

2 minutes ago, Lacrimas said:

Giving us some code would be useful.

try{ 
String query = "INSERT INTO table1(Emp_no,Date,salary) VALUES ('"+empid+"','"+localDate+"','"+w_amount+"')";
       ps.executeUpdate(query);
}

catch(Exception e)
{
System.out.print(e);
}  

the variables have been declared above the try statement

 

[Shammikit]

9 minutes ago, Lacrimas said:

String query = "INSERT INTO table1(Emp_no,Date,salary) VALUES ('"+empid+"','"+localDate+"','"+w_amount+"')";

should be

String query = "INSERT INTO table1 (Emp_no, Date, salary)" + "VALUES ('"+empid+"','"+localDate+"','"+w_amount+"')";

 

i get this now

 

Error: java.lang.NumberFormatException: For input string: ""

[AnotherMax]

String query = "INSERT INTO table1(Emp_no,Date,salary) VALUES (?, ?, ?)";

PreparedStatement pStatement;
try {
  // getConnection() is DriverManager.getConnection(); I have things set up in seperate classes
  pStatement = getConnection().prepareStatement(query);

  pStatement.setInt(1, empid);
  // you should be able to do setDate() if thats how your DB is set up
  pStatement.setString(2, localDate);
  pStatement.setInt(3, w_amount);

  pStatement.executeUpdate();
} catch (SQLException ex) {
  Logger.getLogger(DBInterface.class.getName()).log(Level.SEVERE, null, ex);
}

I've done this before. This is what I did.