duandang6111 2015-12-11 01:58
浏览 478
已采纳

android mysql在textview中显示日期/时间

i am trying to display current date/time in a textview, i have managed to display the date but do not know how to display the time, the format of the date/time must be '2015-12-10 01:52:23' as it will be stored in a database field TIMESTAMP. Heres what i have as of yet (Prints date '2015-12-10' only)

        displayDate = (TextView) findViewById(R.id.DATE);

    final Calendar cal = Calendar.getInstance();
    yy = cal.get(Calendar.YEAR);
    mm = cal.get(Calendar.MONTH);
    dd = cal.get(Calendar.DAY_OF_MONTH);

    // set current date into textview
    displayDate.setText(new StringBuilder()
            // Month is 0 based, just add 1
            .append(yy).append(" ").append("-").append(mm + 1).append("-")
            .append(dd));

It is then passed onto this: final String datetime = displayDate.getText().toString().trim();

which is added into the database:

            @Override
        protected String doInBackground(Void... v) {
            HashMap<String,String> params = new HashMap<>();
            params.put(Config.KEY_EMP_ID, TextUserID);
            params.put(Config.KEY_LAT,lat);
            params.put(Config.KEY_LON,lon);

Config is a java file which has the keys and JSON tags to query the database using php:

//Keys that will be used to send the request to php scripts
public static final String KEY_EMP_ID = "UserID";
public static final String KEY_LAT = "Latitude";
public static final String KEY_LON = "Longitude";
public static final String KEY_TIMEINSERTED = "TimeInserted";
  • 写回答

2条回答 默认 最新

  • doutan5798 2015-12-11 02:28
    关注

    I don't have the ability to test this at the moment, but you might want to consider using SimpleDateFormat.

    Calendar calendar = Calendar.getInstance();
    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    displayDate.setText(dateFormat.format(calendar.getTime()));
    

    You should also consider using a locale as well.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作