如何在JDK 1.7上将GMT datetime SQL数据类型转换为JAVA EST timestamp

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT gmt_datetime_column FROM your_table");

SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
dateFormat.setTimeZone(TimeZone.getTimeZone("GMT"));
Date gmtDatetime = dateFormat.parse(rs.getString("gmt_datetime_column"));

Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("EST"));
cal.setTime(gmtDatetime);

Timestamp estTimestamp = new Timestamp(cal.getTimeInMillis());