Code:
public void connect() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc:odbc:RclElectionsDB","",""); String sql1 = "SELECT SUM ([Total number of votes]) AS SumVotes FROM Votes;"; String sql2 = "SELECT RclNames FROM Votes WHERE [Total number of votes]=(SELECT MAX([Total number of votes]) FROM Votes);"; String sql3 = "SELECT RclNames FROM Votes WHERE [Total number of votes]=(SELECT MIN([Total number of votes]) FROM Votes)"; String sql4 = "SELECT COUNT * AS Number FROM Registration;"; Statement stmt = conn.createStatement(); ResultSet rs1 = stmt.executeQuery(sql1); ResultSet rs2 = stmt.executeQuery(sql2); ResultSet rs3= stmt.executeQuery(sql3); ResultSet rs4 = stmt.executeQuery(sql4); while(rs1.next()) { this.jTextField1.setText(rs1.getString("SumVotes")); } while(rs2.next()) { this.jTextField2.setText(rs2.getString("RclNames")); } while(rs3.next()) { this.jTextField3.setText(rs3.getString("RclNames")); } while(rs4.next()) { this.jTextField4.setText(rs4.getString("RclNames")); } conn.close(); } catch(Exception e) { JOptionPane.showMessageDialog(null, e.getMessage()); } }