資料結構
網路
RDBMS
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化學
生物
數學
英語
經濟學
心理學
社會學
服飾研究
法學研究java.sql.Date toString() 方法示例?
java.sql.Date 類的 toString() 方法將當前 Date 物件的時間的 JDBC 轉義格式作為 String 變數返回。
即使用此方法，你可以將 Date 物件轉換為 String。
//Retrieving the Date object
Date dateObj = rs.getDate("DispatchDate");
//Converting the Date object to String format
String date = dateObj.toString();示例
使用 CREATE 語句在 MySQL 資料庫中建立名稱為 dispatches 的表，如下所示 −
CREATE TABLE dispatches( ProductName VARCHAR(255), CustomerName VARCHAR(255), DispatchDate date, DeliveryTime time, Price INT, Location VARCHAR(255));
現在，我們將使用 INSERT 語句在 dispatches 表中插入 5 條記錄 −
insert into dispatches values('Key-Board', 'Raja', DATE('2019-09-01'), TIME('11:00:00'), 7000, 'Hyderabad');
insert into dispatches values('Earphones', 'Roja', DATE('2019-05-01'), TIME('11:00:00'), 2000, 'Vishakhapatnam');
insert into dispatches values('Mouse', 'Puja', DATE('2019-03-01'), TIME('10:59:59'), 3000, 'Vijayawada');
insert into dispatches values('Mobile', 'Vanaja', DATE('2019-03-01'), TIME('10:10:52'), 9000, 'Chennai');
insert into dispatches values('Headset', 'Jalaja', DATE('2019-04-06'), TIME('11:08:59'), 6000, 'Goa');以下 JDBC 程式建立與資料庫的連線並檢索 dispatches 表的內容。
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Date_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 table
String query = "select * from dispatches";
//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"));
Date dateObj = rs.getDate("DispatchDate");
//Converting the Date object to String format
String date = dateObj.toString();
System.out.println("Date Of Dispatch in String format: "+date);
System.out.println("Delivery time: "+rs.getTime("DeliveryTime"));
System.out.println("Location: "+rs.getString("Location"));
System.out.println();
}
}
}此處，在此程式中，在檢索列值時，我們使用 Date 類的 toString() 方法將 DispatchDate 值從 Date 物件轉換為字串格式並顯示它。
輸出
Connection established...... Product Name: Key-Board Customer Name: Raja Dispatch Date: 2019-09-01 Delivery time in String format: 11:00:00 Location: Hyderabad Product Name: Earphones Customer Name: Roja Dispatch Date: 2019-05-01 Delivery time in String format: 11:00:00 Location: Vishakhapatnam Product Name: Mouse Customer Name: Puja Dispatch Date: 2019-03-01 Delivery time in String format: 10:59:59 Location: Vijayawada Product Name: Mobile Customer Name: Vanaja Dispatch Date: 2019-03-01 Delivery time in String format: 10:10:52 Location: Chennai Product Name: Headset Customer Name: Jalaja Dispatch Date: 2019-04-06 Delivery time in String format: 11:08:59 Location: Goa
更新於： 2019-7-30
5 千+ 瀏覽量
廣告