How To Convert Java.Util.Date To Java.Sql.Date - Jdbc Example - Hallo sahabat BEST LEARNING JAVA, Pada Artikel yang anda baca kali ini dengan judul How To Convert Java.Util.Date To Java.Sql.Date - Jdbc Example, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan Artikel core java, Artikel date and time tutorial, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.

Judul : How To Convert Java.Util.Date To Java.Sql.Date - Jdbc Example
link : How To Convert Java.Util.Date To Java.Sql.Date - Jdbc Example

How To Convert Java.Util.Date To Java.Sql.Date - Jdbc Example

You oftentimes need to convert java.util.Date to java.sql.Date if y'all are storing dates inward database e.g. SQL SERVER or MySQL. Since JDBC has their ain information types for appointment as well as fourth dimension e.g. java.sql.Date, java.sql.Time as well as java.sql.TimeStamp to tally amongst database date, fourth dimension as well as date-time types, y'all cannot overstep a java.util.Date directly. All methods which are suppose to shop dates e.g. setDate(paramName, paramValue) expects java.sql.Date, as well as then it becomes essential to know how to convert java.util.Date to java.sql.Date inward JDBC. You would live on surprised to know that java.sql.Date is a subclass of java.util.Date as well as all it does is suppress or take away time-related fields from java.util.Date.


It is besides a skillful instance of a shape which violates Liskov exchange principle, because fifty-fifty though java.sql.Date extends java.util.Date, y'all cannot overstep around it to the method which await java.util.Date because all time-related methods e.g. getHour(), getMinute() as well as getSeconds() method throws java.util.NotSupportedException. 

I actually promise that JDBC driver could practice the translation depending upon the information type of columns as well as Java developer could only overstep the java.util.Date e.g. convert it to java.sql.Date if the column inward the tabular array is of type DATE, java.sql.Time if the type of column is TIME as well as java.sql.Timestamp if the information type of column is DATETIME.

Converting java.util.Date to java.sql.Date - Example

Unfortunately, in that place is no method similar toSQLDate() inward java.util.Date shape to facilitate conversion betwixt util appointment as well as SQL appointment but y'all tin plough over the axe purpose getTime() method to extract long millisecond value from java.util.Date as well as practice a novel java.sql.Date based on that value every bit shown below:

Date at nowadays = new Date(); java.sql.Date sqlDate = new java.sql.Date(now.getTime());

This is the easiest as well as correct means to convert a java.util.Date to java.sql.Date inward Java. To acquire to a greater extent than nigh JDBC as well as how to write Java application which connects to the database, delight come across Core Java, Volume II--Advanced Features (10th Edition), ane of the best books to acquire advanced features of Java programming language.

Things to remember

1) java.sql.Date mapped to DATE datatype on JDBC i.e. Type.Date, which corresponds to appointment equivalent inward DB side. In SQLSERVER till 2008 it maps to DATETIME as well as afterwards maps to DATE information type.

2) java.sql.Date extends java.util.Date but voilates Liskov Substituion Principle.

3) You tin plough over the axe convert betwixt java.util.Date as well as java.sql.Date past times using getTime() method.

4) Here is mapping betwixt MySQL appointment as well as fourth dimension types as well as Java appointment types:

That's all nigh how to convert java.util.Date to java.sql.Date inward Java as well as JDBC. It's ane of the most useful tips patch working inward JDBC. You tin plough over the axe fifty-fifty practice a shape similar JdbcUtil to host all appointment as well as time-related conversion methods e.g. toSQLDate(), toSQLTime() etc.

Further Learning
Complete Java Masterclass
tutorial)

How practice y'all calculate the departure betwixt ii dates inward Java? (solution)

How to convert a String to Date inward Java? (example)

How to acquire a day, calendar month as well as twelvemonth from a Date inward Java? (solution)

How to convert XMLGregorianCalendar to Date inward Java? (solution)

How to acquire the current appointment amongst Timezone inward Java? (example)

3 ways to compare ii dates inward Java? (program)

How to add together days, months as well as years from a Date inward Java? (solution)

The departure betwixt java.sql.Time, java.sql.Timestamp as well as java.util.Date inward Java? (answer)

How to increment the appointment inward Java? (solution)

How to convert local fourth dimension to GMT inward Java? (answer)

How to convert Date to String inward Java? (answer)

Why should y'all non purpose SimpleDateFormat inward Java? (answer)

Demikianlah Artikel How To Convert Java.Util.Date To Java.Sql.Date - Jdbc Example

Sekianlah artikel How To Convert Java.Util.Date To Java.Sql.Date - Jdbc Example kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.

Anda sekarang membaca artikel How To Convert Java.Util.Date To Java.Sql.Date - Jdbc Example dengan alamat link https://bestlearningjava.blogspot.com/2019/04/how-to-convert-javautildate-to.html

Bagikan Artikel ini