GET DATE in JDBC

This example shows how to retrieve date from existing table of MySql database. Date functions can be used in the SELECT statement or in the WHERE clause of a Query.

GET DATE in JDBC

GET DATE in JDBC

  

This example shows how to retrieve date from existing table of MySql database. Date functions can be used in the SELECT statement or in the WHERE clause of a Query. Various date functions of Date are-

ADDDATE()
This function is used for add date to any other date.

ADDTIME()
This function is used for add time.

CURDATE(), CURRENTDATE(), CURRENTDATE
These three are synonyms, are used for display the current date.

CURRENTTIME(), CURRENTTIME, CURTIME()
These are same used for current time.

DATE_ADD()
This is used for adding two dates.

DATEDIFF()
This is used for subtraction of two dates.

DAY(), DAYOFMONTH()
It shows the day of month from 1 to 31.

DAYNAME()
It shows the name of the weekday.

DAYOFWEEK()
It returns the index of weekdays.

DAYOFYEAR()
It returns the day of year from 1 to 366.

LASTDAY()
It returns the last day of the month.

LOCALTIME(),LOCALTIMESTAMP(),NOW()
It returns the current date and time.

MONTH()
It returns the month from the date has gone.

MONTHNAME()
It returns the name of the month.

SECOND()
It returns the seconds from 0 to 59.

STR_TO_DATE()
It converts a string to a date.

SYSDATE()
It returns the time of execution the function.

TIMEDIFF()
It returns the diffrence of time.

WEEK()
It returns the week number.

WEEKDAY()
It returns the weekday index.

WEEKOFYEAR()
It returns the week of year from 1 to 53.

YEAR()
It returns the year.

YEARWEEK()
It returns the year and week.

GetDate.java

import java.sql.*;
import java.io.*;
public class GetDate {
  public static void main(String a[])
  {
 Connection con = null;
 String url = "jdbc:mysql://lacalhost:3306/";
 String dbName = "vineej";
 String driver = "com.mysql.jdbc.Driver";
 String userName = "vineej";
 String password = "no";
 try {
  Class.forName(driver).newInstance();
  con = DriverManager.getConnection
  (url+dbName,userName,password);
  Statement st = con.createStatement();
  ResultSet rs= st.executeQuery("select Dates 
  from Student where Name ='Ravi'");
  while(rs.next()) {
  String data = rs.getString(1);
  System.out.println(data);
  }
  System.out.println("Results");
  st.close();
  }
  catch( Exception e ) {
  System.out.println(e.getMessage());
  e.printStackTrace();
  }
 }
}


Description of the Program
This program is concern with retrieve the date from existing table in the database. Student is the of a table and ravi is the name of a student. Dates is the field in table from where we can retrieve the date.When the query successfully executed it will shows "Results".

Description of code

1.First in the program we import the java.sql and java.io packages then define the GetDate class.

import java.sql.*;
import java.io.*;

2.Create a connection with MySql database

con = DriverManager.getConnection(url+dbName,userName,password);

3.Create statement and then execute query with the SELECT statement.

Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select Dates from Student where Name ='Ravi");

4.Finally got the result by the getString() method.

while( rs.next() ) {
String data = rs.getString(1);
System.out.println( data ); 
}

5. After all connection should be closed.

con.close();

6. printStackTrace() method
The method is used to show error messages. If the connection is not connected then it throws the exception and print the message.

Download Source Code:

Tutorials

  1. First Step towards JDBC
  2. Accessing the Database from Servlet
  3. Accessing Databases Using Java and JDBC
  4. First Step towards JDBC!
  5. First Step towards JDBC!
  6. Accessing Database from servlets through JDBC!
  7. JDBC, JDBC Tutorial, JDBC Tutorials
  8. What is JDBC?
  9. Product Components of JDBC
  10. Understanding the JDBC Architecture
  11. JDBC Driver and Its Types
  12. JDBC Versions
  13. Features of JDBC 3.0 API
  14. Features of JDBC 4.0
  15. Difference between JDBC 3.0 & JDBC 4.0
  16. Relational Database Concepts
  17. Understanding Common SQL statements
  18. Important JDBC Concepts
  19. Introduction to java.sql package
  20. Driver Manager Class
  21. Understanding Data Source
  22. Understanding Connection Object
  23. Mapping MySQL Data Types in Java
  24. Connecting to a MySQL Database in Java
  25. Creating a Database in MySQL
  26. Creating a Database Table
  27. Creating a MySQL Database Table to store Java Types
  28. Description of Database Table
  29. Deleting a Table from Database
  30. Retrieving Tables from a Database
  31. Inserting values in MySQL database table
  32. Retrieving All Rows from a Database Table
  33. Adding a New Column Name in Database Table
  34. Change Column Name of a Table
  35. Make Unique Column in Database Table
  36. Remove Unique Column in Database Table
  37. Arrange a Column of Database Table
  38. Arrange a Column of Database Table
  39. Sum of Column in a Database Table
  40. Deleting All Rows from a Database Table