Set Time by using the Prepared Statement
In this section you will learn about setting the time in database table by using the PreparedStatement interface of java.sql package. Suppose you want to insert the actual time in a table, here you will provide a setTime method for setting the time. See below for an example with code that insert the time in JDBC table.
Description of program:
This example helps us for setting the time in database table (child) by using the PreparedStatement interface. First of all we need to establish the connection with MySQL database through the help of JDBC deriver. After establishing the connection, we will insert our query in the prepareStatement method that returns the PreparedStatement object. With the help of this object we insert all data with time. Here, we will only insert the child name and born time by using the setString and setTime methods. Finally you will get all data that are added in the database table (child) and it will show "row(s) affected" otherwise it will display a message "SQL statement is not executed!".
Description of code:
setTime(int index, Time t);
Above method takes integer type value and time type value. This method sets
the arguments to java.sql.Time value that is converted into SQL
TIME value.
Here is the code program:
import java.sql.*;
|
Database Table: child
ch_name | b_time |
Santosh | 12:08:36 |
vinod | 02:01:00 |
Output of program:
C:\vinod\jdbc\jdbc\PreparedStatement>javac SetTime.java C:\vinod\jdbc\jdbc\PreparedStatement>java SetTime Prepared Statement Set Time example! 1 row(s) affectec) |
After executing the program:
Database Table: child
ch_name | b_time |
Santosh | 12:08:36 |
vinod | 02:01:00 |
Deepak | 09:45:57 |