数据结构
网络
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://127.0.0.1/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 千+ 浏览量
广告