資料結構
網路
關係型資料庫管理系統
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化學
生物
數學
英語
經濟學
心理學
社會研究
時尚研究
法律研究Java sql.Timestamp toString() 方法示例說明
java.sql.Timestamp 類中 toString() 方法以 String 變數形式返回當前 Timestamp 物件的時間戳形式為 JDBC 轉義格式。
即使用此方法，可以將 Timestamp 物件轉換為 String。
//Retrieving the Time object
Timestamp timestampObj = rs.getTimestamp("DispatchTimeStamp");
//Converting the Time object to String format
String time_stamp = timestampObj.toString();示例
讓我們使用如下所示的 CREATE 語句，在 MySQL 資料庫中使用名稱為 dispatches_data 的表
CREATE TABLE dispatches_data( ProductName VARCHAR(255), CustomerName VARCHAR(255), DispatchTimeStamp timestamp, Price INT, Location VARCHAR(255));
現在，我們將使用 INSERT 語句在 dispatches_data 表中插入 5 條記錄
insert into dispatches_data values('Key-Board', 'Raja', TIMESTAMP('2019-05-04', '15:02:45'), 7000, 'Hyderabad');
insert into dispatches_data values('Earphones', 'Roja', TIMESTAMP('2019-06-26', '14:13:12'), 2000, 'Vishakhapatnam');
insert into dispatches_data values('Mouse', 'Puja', TIMESTAMP('2019-12-07', '07:50:37'), 3000, 'Vijayawada');
insert into dispatches_data values('Mobile', 'Vanaja' , TIMESTAMP ('2018-03-21', '16:00:45'), 9000, 'Chennai');
insert into dispatches_data values('Headset', 'Jalaja' , TIMESTAMP('2018-12-30', '10:49:27'), 6000, 'Goa');以下 JDBC 程式與資料庫連線，並檢索 dispatches_data 表的內容。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
public class Timestamp_toString {
public static void main(String args[]) throws SQLException {
//Registering the Driver
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//Getting the connection
String mysqlUrl = "jdbc:mysql:///mydatabase";
Connection con = DriverManager.getConnection(mysqlUrl, "root", "password");
System.out.println("Connection established......");
//Creating a Statement object
Statement stmt = con.createStatement();
//Query to retrieve the contents of the dispatches_data table
String query = "select * from dispatches_data";
//Executing the query
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
System.out.println("Product Name: " + rs.getString("ProductName"));
System.out.println("Customer Name: " + rs.getString("CustomerName"));
Timestamp timeStampObj = rs.getTimestamp("DispatchTimeStamp");
//Converting the Time object to String format
String timeStamp = timeStampObj.toString();
System.out.println("Dispatch time stamp in String format: " + timeStamp);
System.out.println("Location: " + rs.getString("Location"));
System.out.println();
}
}
}在此程式中，在檢索列值時，我們使用 Timestamp 類的 toString() 方法將 DeliveryTime 值從 Timestamp 物件轉換為字串格式，並試圖顯示它。
輸出
Connection established...... Product Name: Key-Board Customer Name: Raja Dispatch time stamp in String format: 2019-05-04 15:02:45.0 Location: Hyderabad Product Name: Earphones Customer Name: Roja Dispatch time stamp in String format: 2019-06-26 14:13:12.0 Location: Vishakhapatnam Product Name: Mouse Customer Name: Puja Dispatch time stamp in String format: 2019-12-07 07:50:37.0 Location: Vijayawada Product Name: Mobile Customer Name: Vanaja Dispatch time stamp in String format: 2018-03-21 16:00:45.0 Location: Chennai Product Name: Headset Customer Name: Jalaja Dispatch time stamp in String format: 2018-12-30 10:49:27.0 Location: Goa
更新於：2019 年 7 月 30 日
5K+ 瀏覽
廣告