Convert String to Date format, to insert it into MySQL

Question

Good afternoon,

I'm trying to get a String from a JTextField. Then convert it to Date for afterwards sending that into a MYSQL statement.

        String nom = jTextField_Name.getText().toUpperCase();
        int temp = Integer.parseInt(jTextField_Temp.getText());
        String d = jTextField_Date.getText();
        System.out.println("Inputs taken");

        SimpleDateFormat format = new SimpleDateFormat("yyyy/MM/dd");
        Date parsed = (Date) format.parse(d);
        java.sql.Date sql = new java.sql.Date(parsed.getTime());
        System.out.println("Converted to proper Date for MYSQL");

        int retorn = db.insertTemperatura(nom, sql, temp);
        if (retorn == 1){
            jTextArea_Result.setText("S'ha inserit "+nom+" amb la seva temperatura correctament!");
        } else{
            jTextArea_Result.setText("-----Hi ha hagut un ERROR a l'hora d'inserir "+nom+" amb la seva temperatura.\nIntenta-ho de nou sisplau.");
        }
        } catch (ParseException ex) {
            Logger.getLogger(GUI.class.getName()).log(Level.SEVERE, null, ex);
        }

The thing is, that i'm not doing the conversion right, i've tried diferent ways and I always came up with that error:

run:
Llegides entrades
Exception in thread "AWT-EventQueue-0" java.lang.ClassCastException: java.util.Date cannot be cast to java.sql.Date

I've used other types of format but I don't know what I'm doing wrong.

Thanks in advance!

The method I call for that insertion into the DDBB is:

 public int insertTemperatura(String nom, Date data, int temperatura){
    try {
        Statement s = c.createStatement();
        String query = "INSERT INTO TaulaTemp VALUES ('"+nom+"',"+temperatura+","+data+")";

        int numRows = s.executeUpdate(query);
        if (numRows > 0){
            return 1;
        }
        return 0;
    } catch (SQLException ex) {
        Logger.getLogger(DDBB.class.getName()).log(Level.SEVERE, null, ex);
        return -1;
    }
}

You can pass directly a java.util.Date to mySQL... is not necesary Parse it to java.sql.Date — Dazak
– Dazak, Commented Mar 3, 2017 at 16:24
Possible duplicate of How to convert java.util.Date to java.sql.Date? — f1sh
– f1sh, Commented Mar 3, 2017 at 16:24
You can't simply cast a java.util.Date to a java.sql.Date... — f1sh
– f1sh, Commented Mar 3, 2017 at 16:25
You have not shown the important code, i.e. the definition of insertTemperatura. Please edit you post and include that code. — Jim Garrison
– Jim Garrison, Commented Mar 3, 2017 at 16:39
Do not build your SQL like that, use a PreparedStatement with placeholders instead. Your code is wide open to SQL-Injection attacks. — Jim Garrison
– Jim Garrison, Commented Mar 3, 2017 at 16:39

Dazak · Accepted Answer · 2017-03-03 16:47:35Z

1

You can pass directly a java.util.Date to mySQL... is not necessary Cast it to java.sql.Date

Just delete this line:

java.sql.Date sql = new java.sql.Date(parsed.getTime());

and pass in this line the variable casted

int retorn = db.insertTemperatura(nom, parsed, temp);

UPDATE:

You should use a preparedStatement clause instead of put all your query in a String, like this:

String query = "INSERT INTO TaulaTemp VALUES (?,?,?)";

PreparedStatement preparedStatement = dbConnection.prepareStatement(query);
preparedStatement.setString(1, nom);
preparedStatement.setDate(2, data);
preparedStatement.setInt(3, temperatura);
// execute insert SQL stetement
preparedStatement .executeUpdate();

Remember to use PreparedStatement add the necesary import statement:

import java.sql.PreparedStatement;

edited Mar 3, 2017 at 16:47

answered Mar 3, 2017 at 16:27

Dazak

1,0533 gold badges9 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

neoSmith Over a year ago

Hello Dazak, thanks for the answer. I've just tried and it keeps me saying the same. Can it be an error from the input type I get from my method insertTemperatura? I've just updated the question with it's code, maybe it's there where I should change it :S

Dazak Over a year ago

As @JimGarrison said... use a PreparedStatement... I update my answer so you can see it

neoSmith Over a year ago

Now I've changed the code with the prepared statement but the error seems to be in the same part. As I've put system.out.prints, it seems that it's not passing the line: Date parsed = (Date) format.parse(d);

Collectives™ on Stack Overflow

Convert String to Date format, to insert it into MySQL

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related