JTable setCellRenderer格式化文本字段的日期? [英] JTable setCellRenderer to format a text field to date?

问题描述

我有一个SQLite数据库，其日期存储为VARCHAR(yyyy-mm-dd)，例如'2013-01-25'. 我的查询从表中检索记录并将其显示为已存储.我需要在我的JTable中将VARCHAR数据显示为"2013年1月25日星期五".我怀疑对包含VARCHAR的列使用 setCellRenderer 是可行的方法.此外，我认为这将分为两个步骤:首先，将VARCHAR转换为日期值，然后根据需要格式化日期.如果我从JTable抓取VARCHAR值并将其显示在JTextField中，则可以按照以下方式进行操作:

I have a SQLite database with a date stored as VARCHAR (yyyy-mm-dd), for example '2013-01-25'. My query retrieves the records from the table and displays it as stored. I need to display the VARCHAR data in my JTable as 'Friday January 25, 2013'. I suspect using setCellRenderer for the column containing the VARCHAR is the way to go. Further, I think it will be a two step process: first, converting the VARCHAR to a date value then formatting the date as desired. I can do so as follows if I grab the VARCHAR value from the JTable and display it in a JTextField:

MyDate = new SimpleDateFormat("yyyy-MM-dd").parse(rs.getString("My_Date"));

然后根据需要对其进行格式化

and then formatting it as desired

MyDateStr = new SimpleDateFormat("EEEE MMMM d, yyyy").format(MyDate);

一切都很好.但是，我需要JTable列中的格式化显示.我从没使用过setCellRenderer，因此可以使用一些入门帮助.

That's all well and good; however, I need the formatted display in the JTable column. I've never used setCellRenderer, so I could use some help getting started.

推荐答案

由Rob Camick发表有关

Post by Rob Camick about Table Format Renderers may solve your problem.

更新:

我尝试了一个使用 mKorbel的示例(因为我也很想在JTable中查看DateFormat，到目前为止我还没有做过) 代码.我给定的格式为input是"2013-01-25".

I tried an example (as I am also curious to look DateFormat in JTable which I have not done so far) using mKorbel code. The format which I have given as input is "2013-01-25".

import java.awt.Dimension;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Locale;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableCellRenderer;

public class JTableDateFormat {
public static void main(String[] args) {
    Object[][] data = {
                       {"Amar", "2013-01-25"},
                       {"Sammy", "2013-01-25"} 
                      };
    Object[] columnNames = {"Name", "Date"};
    JTable table = new JTable(data, columnNames);
    table.getColumnModel().getColumn(1).setCellRenderer(new DateRenderer());
    JFrame frame = new JFrame();
    frame.add(new JScrollPane(table));
    frame.setSize(new Dimension(400, 100));
    frame.setVisible(true);
}
}


class DateRenderer extends DefaultTableCellRenderer {

private static final long serialVersionUID = 1L;
private Date dateValue;
private SimpleDateFormat sdfNewValue = new SimpleDateFormat("EE MMM dd hh:mm:ss z yyyy");
private String valueToString = "";

@Override
public void setValue(Object value) {
    if ((value != null)) {
        String stringFormat = value.toString();
        try {
            dateValue = new SimpleDateFormat("yyyy-mm-dd", Locale.ENGLISH).parse(stringFormat);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        valueToString = sdfNewValue.format(dateValue);
        value = valueToString;
    }
    super.setValue(value);
}
}

这篇关于JTable setCellRenderer格式化文本字段的日期?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！