用Java实现h2中MySQL的TIME()函数

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Time;

public class H2TimeFunction {
    public static void main(String[] args) {
        // 连接数据库
        try (Connection conn = DriverManager.getConnection("jdbc:h2:~/test", "sa", "")) {
            Statement stmt = conn.createStatement();
            
            // 创建测试表
            stmt.executeUpdate("CREATE TABLE test (id INT PRIMARY KEY, timeValue TIME)");
            
            // 插入测试数据
            stmt.executeUpdate("INSERT INTO test VALUES (1, '10:30:45')");
            stmt.executeUpdate("INSERT INTO test VALUES (2, '15:20:10')");
            
            // 查询并使用Java实现的TIME()函数
            ResultSet rs = stmt.executeQuery("SELECT id, TIME(timeValue) AS time FROM test");
            while (rs.next()) {
                int id = rs.getInt("id");
                Time time = rs.getTime("time");
                System.out.println("id: " + id + ", time: " + time);
            }
            
            // 删除测试表
            stmt.executeUpdate("DROP TABLE test");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}