从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) 个答案