有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

从mysql数据库导入的jtable中缺少java(日期)列

除了jtable中的my date列之外,所有的运行都是正确的,没有填充数据库mysql中的数据。有错吗

public final class ClientiFrame extends javax.swing.JFrame {    

    public ClientiFrame() {
        initComponents();
        Show_Clienti_In_JTable();
    }

    //mysql java connectivity
    public Connection getConnection()
    {
       Connection con;

       try {
           con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sys", "student5", "student5");
           return con;
       } 
      catch (SQLException e) {
           return null;
       }
    }

    //creating arrayList(the problem might be here)
    public ArrayList<Client> getClientiList()
    {
       ArrayList<Client> clientiList = new ArrayList<>();
       Connection connection = getConnection();

       String query = "SELECT * FROM  clienti ";
       Statement st;
       ResultSet rs;

       try {
           st = connection.createStatement();
           rs = st.executeQuery(query);
           Client client;
           while(rs.next())
           {
               client = new Client(rs.getInt("id"),rs.getString("nume"),rs.getString("prenume"),rs.getInt("suma"),rs.getDate("data"));
               clientiList.add(client);
           }
       } catch (SQLException e) {
       }
       return clientiList;
    }

    //displaying in jtable(not good)(the problem might be here)
    public void Show_Clienti_In_JTable()
    {
       ArrayList<Client> list = getClientiList();
       DefaultTableModel model = (DefaultTableModel)jTable_Display_Clienti.getModel();
       Object[] row = new Object[5];
       for(int i = 0; i < list.size(); i++)
       {
           row[0]=list.get(i).getId();
           row[1]=list.get(i).getNume();
           row[2]=list.get(i).getPrenume();
           row[3]=list.get(i).getSuma();
           row[4]=list.get(i).getData();
           model.addRow(row);
       }
     }

这是我的客户课

public class Client {

    private final int id;
    private final String nume;
    private final String prenume;
    private final int suma;
    private final Date data;

    public Client(int Id, String Nume, String Prenume, int Suma, Date Data)
    {
        this.id = Id;
        this.nume = Nume;
        this.prenume = Prenume;
        this.suma = Suma;
        this.data = Data;
    }

    public int getCodcli()
    {
        return id;
    }

    public String getNume()
    {
        return nume;
    }

    public String getPrenume()
    {
        return prenume;
    }

    public int getSuma()
    {
        return suma;
    }
    public Date getData()
    {
        return data;
    }
}

我的jtable有日期列 我的mysql表也提供了所需的一切 我对其他变量(id nume等)的处理方法与我对其他变量的处理方法相同,当我试图简单地用int或string变量替换日期时,它起了作用,但我需要日期。。如果你搞不懂,至少有人能给我发一个教程(如何将日期数据从mysql导入jtable java。我在youtube上找不到任何东西)


共 (0) 个答案