Thread: SQL Query

I have Paradox database
for connecting to db i use this class

package sqlClasses;
 
import java.sql.*;
 
public class Paradox {
 
    public static Connection createConnection() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
            Connection conn = DriverManager.getConnection("jdbc:odbc:Odds-Database", "user", "pass");
            return conn;
        } catch (Exception e) {
            System.out.println(e);
            System.exit(0);
            return null;
        }
    }
}

i want to fill table with data from database, and i use this method:

public void roundTable() {
        TableModles tm = new TableModles();
        tm.roundTable();
        try {
            Connection con = Paradox.createConnection();
            Statement s = con.createStatement();
            s.executeQuery("SELECT Kolo, Od_datuma, Do_datuma FROM Kola");
            ResultSet rset = s.getResultSet();
            if (rset != null) {
                tables.CreateTables.roundTable((DefaultTableModel) oddsmaker.OddsMakerView.roundTable.getModel(), rset);
                con.close();
            }
        } catch (Exception e) {
            System.out.println(e);
        }
    }

Its working fine but in the table where I put the columns "Od_datuma" and "Do_datuma" i need to fill table only with date , but with this code is filled with date and time.
Db column is type DATE, how to edit the query to get only the DATE from db?

in your executeQuery method you're selecting 3 columns from the table when u only need 1... change the statement to select whichever column holds the date information (im guessing "Od_datuma") and it should work

I need values from 3 columns from the table, "Kolo", "Od_datuma" and "Do_datuma", in the table columns Od_datuma and Do_datuma hold datetime values, I only need DATE values from this two columns

I have read on microsoft site that Paradox Data type can't be converted with operation cast or convert, so im looking for another solution

Originally Posted by copeg

Then use option b. Perform the query, use the getDate function of ResultSet(presuming the driver supports this operation), and use the returned Date object as needed.

ok, and how to fill JTable with that results, i need Kolo, Od_datuma, Do_datuma in one table row

Originally Posted by copeg

What did you try? Where are you stuck?

Im trying to get data from Paradox Database (table with columns Kolo, Od_datuma, Do_datuma) and i like to fill JTable with this values
for ex. one row of JTable to contain data from one row of Paradox Table , with my code i do this but in JTable columns Od_datuma and Do_datuma are filling values with date and time, I like to fill this columns only with date I don't need time in this JTable

public void roundTable() {
        TableModles tm = new TableModles();
        tm.roundTable();
        try {
            Connection con = Paradox.createConnection();
            Statement s = con.createStatement();
            s.executeQuery("SELECT Kolo, Od_datuma, Do_datuma FROM Kola");
            ResultSet rset = s.getResultSet();
            if (rset != null) {
                tables.CreateTables.roundTable((DefaultTableModel) oddsmaker.OddsMakerView.roundTable.getModel(), rset);
                con.close();
            }
        } catch (Exception e) {
            System.out.println(e);
        }
    }

TableModels is a class where I have Different Models of tables witch i use in my code, in this method i use Table Model with 3 columns and i fill table created with that table model with result set from query