Hey new to JDBC SQL DERBY and Java so I don't know why but my Jtable only shows the columns.
Here are my codes for my LeaderboardDAO class.
public class LeaderboardDAO extends Dao {
private static final Logger LOG = LogManager.getLogger(PlayerDAO.class);
public static final String TABLE_NAME = "leaderboard";
private static LeaderboardDAO leaderboardDao;
private LeaderboardDAO() {
super(TABLE_NAME);
}
public static LeaderboardDAO getLeaderboardDao() {
if (leaderboardDao == null) {
leaderboardDao = new LeaderboardDAO();
}
return leaderboardDao;
}
@Override
public void create() throws SQLException {
LOG.debug("Creating database table " + TABLE_NAME);
final String createStatement = "create table leaderboard(wins INTEGER(10), losses INTEGER(10), game_name VARCHAR(64), gamer_tag VARCHAR(64), platform VARCHAR(64))";
super.create(createStatement);
LOG.info("Executed statement: " + createStatement);
}
/**
* Inserts singular persona into database
*
* @param player
* @throws SQLException
*/
public void addLeaderboardItem(final Leaderboard item) throws SQLException {
final String addStatement = String.format("insert into %s values('%d', '%d', '%s', '%s', '%s')", TABLE_NAME, item.getWins(), item.getLosses(), item.getGameName(),
item.getGamerTag(), item.getPlatform());
super.add(addStatement);
}
/**
* Retrieves a list of all leaderboard rows in the database
*
* @return List<Leaderboard> rows
* @throws SQLException
* @throws Exception
*/
public List<Leaderboard> getLeaderboardRows(final String order, final boolean desc) throws SQLException, Exception {
Connection connection;
Statement statement = null;
final List<Leaderboard> leaderboardRows = new ArrayList<Leaderboard>();
String sqlString;
try {
if (order == null) {
sqlString = String.format("SELECT * FROM " + TABLE_NAME);
} else {
if (order.equals("byGame")) {
if (MainFrame.filterGamertag.equals("")) {
sqlString = String.format("SELECT * FROM " + TABLE_NAME + " ORDER BY game_name");
} else {
sqlString = String.format("SELECT * FROM " + TABLE_NAME + " WHERE gamer_tag = '" + MainFrame.filterGamertag + "' ORDER BY game_name");
}
} else {
if (MainFrame.filterGamertag.equals("")) {
sqlString = String.format("SELECT * FROM " + TABLE_NAME + " ORDER BY (wins||losses)");
} else {
sqlString = String.format("SELECT * FROM " + TABLE_NAME + " WHERE gamer_tag= '" + MainFrame.filterGamertag + "' ORDER BY (wins||losses)");
}
}
if (desc) {
sqlString += " DESC";
}
}
connection = database.connect();
statement = connection.createStatement();
final ResultSet resultSet = statement.executeQuery(sqlString);
while (resultSet.next()) {
leaderboardRows.add(new Leaderboard(resultSet.getInt("wins"), resultSet.getInt("losses"), resultSet.getString("game_name"), resultSet.getString("gamer_tag"),
resultSet.getString("platform")));
}
} finally {
close(statement);
}
return leaderboardRows;
}
}Here is my other code for LeaderboardDialog class
@SuppressWarnings("serial")
public class LeaderboardDialog extends JDialog {
private static LeaderboardDAO dao;
private final JPanel contentPanel = new JPanel();
private final JTable table;
private final int numberOfColumns = 4;
private static final Logger LOG = LogManager.getLogger(LeaderboardDialog.class);
/**
* Launch the application.
*/
public static void main(final String[] args) {
try {
Database.getDatabaseInstance();
dao = LeaderboardDAO.getLeaderboardDao();
final List<Leaderboard> rows = dao.getLeaderboardRows("byGame", false);
final LeaderboardDialog dialog = new LeaderboardDialog(rows);
dialog.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE);
dialog.setVisible(true);
} catch (final Exception e) {
e.printStackTrace();
}
}
/**
* Create the dialog.
*/
public LeaderboardDialog(final List<Leaderboard> rows) {
LOG.info("Creating leaderboard dialog.");
Database.getDatabaseInstance();
dao = LeaderboardDAO.getLeaderboardDao();
this.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE);
this.setVisible(true);
this.setBounds(100, 100, 400, 400);
this.setLayout(new FlowLayout());
final String[] columnNames = { "Wins:Losses", "Game Name", "Gamer Tag", "Platform" };
final String[][] data = new String[rows.size()][numberOfColumns];
for (int i = 0; i < rows.size(); i++) {
data[i] = new String[numberOfColumns];
for (int j = 0; j < numberOfColumns; j++) {
data[i][0] = rows.get(i).getWins() + ":" + rows.get(i).getLosses();
data[i][1] = rows.get(i).getGameName();
data[i][2] = rows.get(i).getGamerTag();
data[i][3] = rows.get(i).getPlatform();
}
}
table = new JTable(data, columnNames);
contentPanel.add(new JScrollPane(table));
this.add(contentPanel);
this.pack();
}
}what it is doing is just showing the columns only, have been trying to figure it out but have had no luck have also looked around in forums no luck as well.
Any help would be greatly appreciated because I've been stuck on it for the past few days maybe I am missing something or overlooked something.
If more code is need please let me know thank you.
Thanks in advance.
