Home / Questions / 10661
Accepted
Oundroni
Asked: 2020-05-23 01:39:11 +0800 CST 2020-05-23 01:39:11 +0800 CST

Store a Java Date value in MySQL

  • 772

I am trying to store in a MySQL record a value java.util.Datethat contains a date and a time together. I have tried with this:

java.util.Date d = new java.util.Date();  
plantilla = new SimpleDateFormat("dd/MM/yyyy H:mm");
String tiempo = plantilla.format(d);

And then record the value in MySQL tiempobut it doesn't work. I don't know if I have to use the java.sql.Date. In any case, I'm lost.

Can I write directly to the raw a value java.util.Datein MySQL defining the field with another type other than DATETIMEor is it not recommended?

java

4 Answers

  1. Can I directly raw write a java.util.Date value in MySQL by defining the field with another type than DATETIME or is it not recommended?

    JDBC does not support the registration of direct instances of java.util.Date. Instead, you have three classes in the package java.sqlthat extend from java.util.Dateso you can perform the operation:

    • java.sql.Date. This type only stores the date. Time information is lost. Equivalent to type sql DATE.
    • java.sql.Time. This type only stores the time. Date information is lost. Equivalent to the sql type `TIME.
    • java.sql.Timestamp. This type stores both date and time. Equivalent to type sql DATETIMEand TIMESTAMP, depending on the database engine support.

    For your case, I recommend creating an instance of Timestampfrom your object java.util.Datelike so:

    java.util.Date miObjetoJavaUtilDate = ...
Timestamp timestamp = new Timestamp(miObjetoJavaUtilDate.getTime());
PreparedStatement pstmt = ...
//...
pstmt.setTimestamp(1, timestamp);

    And to get an object java.util.Datefrom Timestamp:

    PreparedStatement pstmt = ...
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
    Date miFechaYHora = new Date(rs.getTimestamp(1).getTime());
}

    You can create and get instances of the other classes java.sql.Dateand java.sql.Timesimilarly.

    • 4
  2. Best Answer

    You can do it, if your field in the database is a date, you have to convert from java.util.Date to java.sql.Date

    java.sql.Date date2 = new java.sql.Date(d.getTime());

    So you can use a preparedStatement and use date2 for the insert

    • 1

  3. 1.- The first step in your database is to check that the field where the date is going to go is in format dateor datetimethat it is the one that allows you to save the dates.

    2.- You must make a conversion within the program. This is to assign the value:

    try {
     String formato = comboFormato.getSelectedItem().toString();
     //Formato
     Date date = SelectorFecha.getDate();
     SimpleDateFormat sdf = new SimpleDateFormat(formato);
     txtFechaSeleccionada.setText(sdf.format(date));
} catch(NullPointerException ex) {
     JOptionPane.showMessageDialog(this, "¡Al menos selecciona una fecha válida!", "¡Error!", JOptionPane.INFORMATION_MESSAGE);
}

    3.- Then you must separate the fields to compose the date:

    int año = SelectorFecha.getCalendar().get(Calendar.YEAR);
int mes = SelectorFecha.getCalendar().get(Calendar.MONTH) + 1;
int dia = SelectorFecha.getCalendar().get(Calendar.DAY_OF_MONTH);
txtDía.setText("" + dia);
txtMes.setText("" + mes);
txtAño.setText("" + año);

    4.- At the end, you concatenate these values ​​and give the result to your type variabledate

    Annex: http://blog.rolandopalermo.com/2009/12/capturando-fechas-de-un-jdatechooser.html

    • 0 
  4. public class Cliente {
    private String CODIGO_CLIENTE;  
    private int ESTATUS_CLIENTE ; 
    private String RUC;
    private String NOMBRE ; 
    private String DIRECCION ; 
    private String CIUDAD  ;
    private Date FECHA_INGRESO ;
    private int TIPO_CLIENTE ; 
    private  float LIMITE_CREDITO ; 
    private String CORREO_ELECTRONICO ; 
    private String TELEFONO ;

    public Cliente(){
        CODIGO_CLIENTE="";  
        ESTATUS_CLIENTE =0; 
        RUC="";
        NOMBRE="" ; 
        DIRECCION="" ; 
        CIUDAD ="" ; 

        FECHA_INGRESO=;quiero inicializarlo y no me sale no se is puedas ayudarme

        TIPO_CLIENTE = 0; 
        LIMITE_CREDITO =0; 
        CORREO_ELECTRONICO="" ; 
        TELEFONO ="";
    • 0