netbeans

Original Posted By velianoviyanti►didatabase tanggal tipenya date. tapi coding ini kalo dirun keluarnya "tabel salah". kalo tanggal tipenya ane ganti varchar, tabelnya bisa muncul. jadi codingnya apa yang diganti kak kalo tipenya tetap mau date.

private void table(){
    
        DefaultTableModel tb=new DefaultTableModel();
        tb.addColumn("KODE KATEGORI");
        tb.addColumn("KATEGORI");
        tb.addColumn("TANGGAL");
        
        try{
            int i=1;
            Statement stat=(Statement)conek.GetConnection().createStatement();
            res=stat.executeQuery("select*from input");
            while(res.next())
            {
                tb.addRow(new Object[]{
                    (""+i++),
                    res.getString(1),
                    res.getString(2),
                    res.getString(3) 
                });
                table.setModel(tb);
            }
        }
        catch(Exception e){
            JOptionPane.showMessageDialog(null,"tabel salah");
        }
        
    }

while(res.next()){

  tb.addRow(new Object[]{

    res.getString(1),

    res.getString(2),

    res.getDate(3),

  });

}

table.setModel(tb);

Original Posted By 762786153►
coba getDate()

while(res.next()){

  tb.addRow(new Object[]{

    res.getString(1),

    res.getString(2),

    res.getDate(3),

  });

}

table.setModel(tb);

Original Posted By velianoviyanti►

tabel salah kak. tipenya udah diganti date, codingnya juga udah diganti getDate

Statement stat=(Statement)conek.GetConnection().createStatement();

res=stat.executeQuery("select*from input");

try{

      Connection con = DriverManager.getConnection("jdbc:mysql://localhost/NAMADB","NAMAUSER","USERPASSWD");      

      Statement stat = con.createStatement();

      ResultSet res = stat.executeQuery("select * from input");

      while(res.next()){..............

Original Posted By 762786153►

kemungkinan disini salahnya

Statement stat=(Statement)conek.GetConnection().createStatement();

res=stat.executeQuery("select*from input");

karena ane gk tau conek itu object apa.
dibagian itu harusnya semacam gini

try{

      Connection con = DriverManager.getConnection("jdbc:mysql://localhost/NAMADB","NAMAUSER","USERPASSWD");      

      Statement stat = con.createStatement();

      ResultSet res = stat.executeQuery("select * from input");

      while(res.next()){..............

Original Posted By velianoviyanti►

ga ada masalah disitunya kok kak. conek itu nama java class yang aku buat. databasenya connect kalo tanggal didatabase typenya diganti varchar, terus getDatenya diganti jadi getString

}catch(Exception e){

   e.printStackTrace();

}

Original Posted By 762786153►
coba

}catch(Exception e){

   e.printStackTrace();

}

kirim output stacktrace kesini.

Original Posted By velianoviyanti►java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

Original Posted By velianoviyanti►

java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ResultSetRow.getDateFast(ResultSetRow.java:141)
at com.mysql.jdbc.ByteArrayRow.getDateFast(ByteArrayRow.java:238)
at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2211)
at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2173)
at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2238)
at input.table(input.java:53)
at input.<init>(input.java:34)
at input$6.run(input.java:304)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:312)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:745)
at java.awt.EventQueue.access$300(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:706)
at java.awt.EventQueue$3.run(EventQueue.java:704)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:715)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

res = stat.executeQuery("select kode,kategori,case when tanggal='0000-00-00' then null else tanggal end from input");

Original Posted By 762786153►
'0000-00-00' gk bisa diconvert ke java.sql.Date jadi ubah querynya misal gini

res = stat.executeQuery("select kode,kategori,case when tanggal='0000-00-00' then null else tanggal end from input");