problem in adding java date in MySQL? [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed last year.

Improve this question

here is the code

String DateOfBirth[]=strDOB.split("/");
Date dateOfBirth = new Date();
dateOfBirth.setYear(Integer.parseInt(DateOfBirth[2].trim()));
dateOfBirth.setMonth(Integer.parseInt(DateOfBirth[1].trim()));
dateOfBirth.setDate(Integer.parseInt(DateOfBirth[0].trim()));
 java.text.SimpleDateFormat DateFormat = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
strDOB = DateFormat.format(dateOfBirth);
 DBProcess.QueryExecuter("INSERT INTO patients(patient_id,first_name,last_name,middle_name,birth_dt) VALUES (\""+Double.parseDouble(strPatientID.trim())+"\",\""+strFirstname+"\",\""+strLastname+"\",\""+strMiddlename+"\",\""+strDOB +"\");");

and ... what exactly is the problem? A description of the error (and the expected behaviour) would be quite helpful. — Andreas Dolk
– Andreas Dolk, Commented Aug 23, 2010 at 9:18
Grab the value of that constant string INSERT INTO .... and execute it directly in MySQL client. It will fail. Then make it work in that client and apply the changes to your java code. — Miserable Variable
– Miserable Variable, Commented Aug 23, 2010 at 9:23

duffymo · Accepted Answer · 2010-08-23 09:27:12Z

1

Oh, my.

See if this is better:

private static final String INSERT_SQL = "insert into patients(patient_id, first_name, last_name, middle_name, birth_dt) values(?, ?, ?, ?, ?)";

DateFormat inputFormatter = new SimpleDateFormat("dd/MM/yy");
Date dob = inputFormatter.parse(strDOB);
PreparedStatement ps = connection.prepareStatement(INSERT_SQL);
// bind your values here.
int numRowsAffected = ps.executeUpdate();

I can't understand why you'd write that code to parse a date string when DateFormat was born to do it. And I certainly hope that your birth_dt column is of type Date in your database. Anything else is utterly foolish.

answered Aug 23, 2010 at 9:27

duffymo

310k46 gold badges376 silver badges570 bronze badges

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

Comments

Benoit Courtine · Accepted Answer · 2010-08-23 09:27:11Z

0

In your code, do you use java.util.Date or java.sql.Date ?

The best way to insert a Java date in MySQL (or other DB) is to use the PreparedStatement, and the java.sql.Date class :

java.sql.Date theDate = new Date(longTime);
PreparedStatement stmt = conn.prepareStatement("INSERT INTO table(id,date) VALUES (?,?)");
stmt.setInt(1, 123);
stmt.setDate(2, theDate);
stmt.execute();

edited Aug 23, 2010 at 9:27

answered Aug 23, 2010 at 9:20

Benoit Courtine

7,09433 silver badges42 bronze badges

Collectives™ on Stack Overflow

problem in adding java date in MySQL? [closed]

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related