Time I18N

最新推荐文章于 2024-08-15 14:47:41 发布

iteye_7399

最新推荐文章于 2024-08-15 14:47:41 发布

阅读量98

点赞数

分类专栏： java 文章标签： java 工作

java 专栏收录该内容

137 篇文章 0 订阅

订阅专栏

time i18n ：时间国际化

1. class diagram <img src="http://dl.iteye.com/upload/attachment/481139/6533ebc2-8c73-36ae-b019-527b7b2ab499.jpg" alt=""> calendar.settime(date date);
calendar.gettime();
 返回一个表示此 <code>calendar</code> 时间值（从历元至现在的毫秒偏移量）的 <code>date</code> 对象。
 历元格林威治标准时间1970年1月1日的 00:00:00.000 

2. 实例
通常有两种方式实现time i18n
1）在时间存取的时候统一转化为某一时区的值 type1
2）在时间存取的时候增加一timezone列 type2

connectionfactory.java
================================================================
package com.siyuan.time.i18n;
import java.sql.connection; import java.sql.drivermanager; import java.sql.sqlexception;
public class connectionfactory { public static string driver_class_name = "com.mysql.jdbc.driver"; public static string user_name = "root"; public static string password = "123456"; public static string url = "jdbc:mysql://localhost:3306/year2"; public static connection getconnection() throws classnotfoundexception, sqlexception { class.forname(driver_class_name); return drivermanager.getconnection(url, user_name, password); } }
================================================================
timei18ndao.java
================================================================
package com.siyuan.time.i18n;
import java.sql.connection; import java.sql.preparedstatement; import java.sql.resultset; import java.sql.sqlexception; import java.sql.statement; import java.sql.timestamp;
public class timei18ndao { public static final string sql_save = "insert into timei18n(time, timezone) values(?, ?)"; public static final string sql_get = "select time, timezone from timei18n where id = ?"; public static void save(timestamp time, string timezone) { connection conn = null; preparedstatement pstat = null; try { conn = connectionfactory.getconnection(); conn.setautocommit(false); pstat = conn.preparestatement(sql_save); pstat.settimestamp(1, time); pstat.setstring(2, timezone); pstat.executeupdate(); conn.commit(); } catch (classnotfoundexception e) { e.printstacktrace(); if (conn != null) { try { conn.rollback(); } catch (sqlexception e1) { e1.printstacktrace(); } } } catch (sqlexception e) { if (conn != null) { try { conn.rollback(); } catch (sqlexception e1) { e1.printstacktrace(); } } e.printstacktrace(); } finally { close(null, pstat, conn); } } public static object[] get(int id) { object[] result = new object[2]; connection conn = null; preparedstatement pstat = null; resultset rs = null; try { conn = connectionfactory.getconnection(); pstat = conn.preparestatement(sql_get); pstat.setint(1, id); rs = pstat.executequery(); if (rs.next()) { result[0] = rs.gettimestamp(1); result[1] = rs.getstring(2); } } catch (classnotfoundexception e) { e.printstacktrace(); if (conn != null) { try { conn.rollback(); } catch (sqlexception e1) { e1.printstacktrace(); } } } catch (sqlexception e) { if (conn != null) { try { conn.rollback(); } catch (sqlexception e1) { e1.printstacktrace(); } } e.printstacktrace(); } finally { close(rs, pstat, conn); } return result; } public static void close(resultset rs, statement stat, connection conn) { if (rs != null) { try { rs.close(); } catch (sqlexception e) { e.printstacktrace(); } } if (stat != null) { try { stat.close(); } catch (sqlexception e) { e.printstacktrace(); } } if (conn != null) { try { conn.close(); } catch (sqlexception e) { e.printstacktrace(); } } } }
================================================================
servertimezone.java
================================================================
package com.siyuan.time.i18n;
import java.util.timezone;
public class servertimezone { private static final timezone servertz = timezone.gettimezone("gmt+02:00"); public static timezone getservertimezone() { return servertz; } }
================================================================
timei18ntest.java
================================================================
package com.siyuan.time.i18n;
import java.sql.timestamp; import java.text.dateformat; import java.text.parseexception; import java.text.simpledateformat; import java.util.calendar; import java.util.date; import java.util.gregoriancalendar; import java.util.timezone;
public class timei18ntest { public static void settime(calendar calendar, int year, int month, int day, int hour, int minute) { calendar.set(calendar.year, year); calendar.set(calendar.month, month); calendar.set(calendar.day_of_month, day); calendar.set(calendar.hour_of_day, hour); calendar.set(calendar.minute, minute); } /** * @param args * @throws parseexception */ public static void main(string[] args) throws parseexception { string input = "01/05/2011 13:30"; dateformat datefmt = new simpledateformat("dd/mm/yyyy hh:mm"); date inputdate = datefmt.parse(input); /* * type 1 */ //save timezone servertz = servertimezone.getservertimezone(); calendar local = gregoriancalendar.getinstance(); system.out.println(local.gettimeinmillis()); local.settime(inputdate); system.out.println(local.gettimeinmillis()); local.settimezone(servertz); system.out.println(local.gettimeinmillis()); calendar save = gregoriancalendar.getinstance(); settime(save, local.get(calendar.year), local.get(calendar.month), local.get(calendar.day_of_month), local.get(calendar.hour_of_day), local.get(calendar.minute)); timei18ndao.save(new timestamp(save.gettime().gettime()), servertz.getid()); //get // object[] result = timei18ndao.get(4); // calendar get = gregoriancalendar.getinstance(); // get.settime((date)result[0]); // calendar view = gregoriancalendar.getinstance(); // view.settimezone(servertz); // settime(view, // get.get(calendar.year), // get.get(calendar.month), // get.get(calendar.day_of_month), // get.get(calendar.hour_of_day), // get.get(calendar.minute)); // // system.out.println(datefmt.format(view.gettime())); /* * type 2 */ // timezone local1tz = timezone.gettimezone("gmt+08:00"); // calendar local1 = gregoriancalendar.getinstance(); // local1.settime(inputdate); // timei18ndao.save(new timestamp(local1.gettime().gettime()), local1tz.getid()); // // timezone local2tz = timezone.gettimezone("gmt+02:00"); // object[] result = timei18ndao.get(4); // calendar get = gregoriancalendar.getinstance(); // get.settime((date) result[0]); // // calendar local1 = gregoriancalendar.getinstance(); // local1.settimezone(timezone.gettimezone((string) result[1])); // settime(local1, // get.get(calendar.year), // get.get(calendar.month), // get.get(calendar.day_of_month), // get.get(calendar.hour_of_day), // get.get(calendar.minute)); // // calendar local2 = gregoriancalendar.getinstance(); // local2.settimezone(local2tz); // local1.settimezone(local2tz); // settime(local2, // local1.get(calendar.year), // local1.get(calendar.month), // local1.get(calendar.day_of_month), // local1.get(calendar.hour_of_day), // local1.get(calendar.minute)); // datefmt.settimezone(local2tz); // system.out.println(datefmt.format(local2.gettime())); }
}

3.测试及结果
此实例需分次运行，比较复杂
type 1
================================
第一次：
1305336107484 1304227800000 1304227800000
<img src="http://dl.iteye.com/upload/attachment/481143/86a8f40f-94e6-34a1-964c-87fdda8cf11d.jpg" alt="">
第二次：
01/05/2011 13:30
================================
type 2
================================
第一次
<img src="http://dl.iteye.com/upload/attachment/481145/959128f2-c402-392a-9572-1086762967de.jpg" alt="">
第二次
01/05/2011 13:30

iteye_7399

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Time I18N

time i18n ：时间国际化 1. class diagram calendar.settime(date date); calendar.gettime(); 返回一个表示此 calendar 时间值（从历元至现在的毫秒偏移量）的 date 对象。历元格林威治标准时间1970年1月1日的 00:00:00.000 2. 实例通常有两种方式实现time i18n...
复制链接

扫一扫

专栏目录