如何在 JDBC 中將日期值轉換為字串?
java.sql.Date 類的 toString() 方法返回日期物件的轉義格式:yyyy-mm-dd。透過此方法,你可以將日期物件轉換為字串。
Date date = rs.getDate("Dispatch_Date"); date.toString());
假設我們有一個名為 dispatch_data 的表,共有 3 條記錄,如下所示
+--------------+------------------+---------------+----------------+ | Product_Name | Name_Of_Customer | Dispatch_Date | Location | +--------------+------------------+---------------+----------------+ | KeyBoard | Amith | 1981-12-05 | Hyderabad | | Ear phones | Sumith | 1981-04-22 | Vishakhapatnam | | Mouse | Sudha | 1988-11-05 | Vijayawada | +--------------+------------------+---------------+----------------+
下面的 JDBC 程式將與資料庫建立連線,檢索 dispatch_data 表的內容,然後使用 toString() 方法將日期物件轉換為字串值,最後顯示錶的內容和日期值(已被轉換為字串格式)。
import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class DateToString { public static void main(String args[])throws Exception { //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(); //Creating Statement object stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select * from dispatch_data"); //Retrieving values while(rs.next()) { System.out.println("Product Name: "+rs.getString("Product_Name")); System.out.println("Name Of The Customer: "+rs.getString("Name_Of_Customer")); //Retrieving the date Date date = rs.getDate("Dispatch_Date"); //Converting Date object to String System.out.println("Date: "+date.toString()); System.out.println(); } } }
輸出
Connection established...... Product Name: KeyBoard Name Of The Customer: Amith Date: 1981-12-05 Product Name: Ear phones Name Of The Customer: Sumith Date: 1981-04-22 Product Name: Mouse Name Of The Customer: Sudha Date: 1988-11-05
廣告