Display Records From MySQL Database using JTable in Java

Question

I want to connect a JTable to a ResultSet from a MySQL database so I can view the data    I am looking for some links or code snippets describing this task  I m using the Netbeans IDE

User · Answer

this is the easy way to do that you just need to download the jar file  rs2xml jar  add it to your project and do that    1- creat a connection 2- statment and resultset 3- creat a jtable 4- give the result set to DbUtils resultSetToTableModel rs  as define in this methode you well get your jtable so easy   public void afficherAll String tableName           String sql  select   from   tableName          try               stmt con createStatement                rs stmt executeQuery sql               tbContTable setModel DbUtils resultSetToTableModel rs              catch  SQLException e                   TODO Auto-generated catch block              JOptionPane showMessageDialog null  e

User · Answer

If you need to work a lot with database in your code and you know the structure of your table  I suggest you do it as follow    First of all you can define a class which will help you to make objects capable of keeping your table rows data  For example in my project I created a class named Document java to keep data of a single document from my database and I made an array list of these objects to keep data of my table which is gain by a query   package financialdocuments   import java lang    import java util HashMap              author Administrator     public class Document     private int document number    private boolean document type   private boolean document status    private StringBuilder document date   private StringBuilder document statement   private int document code number   private int document employee number   private int document client number   private String document employee name   private String document client name   private long document amount   private long document payment amount    HashMap lt Integer Activity gt  document activity hashmap    public Document int dn boolean dt boolean ds String dd String dst int dcon int den int dcln long da String dena String dcna        document date   new StringBuilder dd       document date setLength 10       document date setCharAt 4            document date setCharAt 7            document statement   new StringBuilder dst       document statement setLength 50       document number   dn       document type   dt      document status   ds      document code number   dcon      document employee number   den      document client number   dcln      document amount   da      document employee name   dena      document client name   dcna       document payment amount   0       document activity hashmap   new HashMap lt  gt         public Document int dn boolean dt boolean ds  long dpa        document number   dn       document type   dt      document status   ds       document payment amount   dpa       document activity hashmap   new HashMap lt  gt            Print document information  public void printDocumentInformation         System out println  Document Number     document number        System out println  Document Date     document date        System out println  Document Type     document type        System out println  Document Status     document status        System out println  Document Statement     document statement        System out println  Document Code Number     document code number        System out println  Document Client Number     document client number        System out println  Document Employee Number     document employee number        System out println  Document Amount     document amount        System out println  Document Payment Amount     document payment amount        System out println  Document Employee Name     document employee name        System out println  Document Client Name     document client name             Second of all  you can define a class to handle your database needs  For example I defined a class named DataBase java which handles my connections to the database and my needed queries  And I instantiated an objected of it in my main class    package financialdocuments   import java sql Connection  import java sql DriverManager  import java sql ResultSet  import java sql SQLException  import java sql Statement  import java util ArrayList  import java util HashMap  import java util logging Level  import java util logging Logger              author Administrator     public class DataBase                Defining parameters and strings that are going to be used           Connection connect      Tables which their datas are extracted at the beginning  HashMap lt Integer String gt  code table  HashMap lt Integer String gt  activity table  HashMap lt Integer String gt  client table  HashMap lt Integer String gt  employee table      Resultset Returned by queries  private ResultSet result      Strings needed to set connection String url    jdbc mysql   localhost 3306 financial documents useUnicode yes amp characterEncoding UTF-8   String dbName    financial documents   String driver    com mysql jdbc Driver   String userName    root    String password        public DataBase         code table   new HashMap lt  gt         activity table   new HashMap lt  gt         client table   new HashMap lt  gt         employee table   new HashMap lt  gt         Initialize               Set variables and objects for this class      private void Initialize         System out println  Loading driver            try           Class forName driver           System out println  Driver loaded            catch  ClassNotFoundException e             throw new IllegalStateException  Cannot find the driver in the classpath    e               System out println  Connecting database        try  Connection connect   DriverManager getConnection url userName password                 System out println  Database connected                   Get tables  information              selectCodeTableQueryArray connect                 System out println  HshMap Print                   printCodeTableQueryArray                 selectActivityTableQueryArray connect                 System out println  HshMap Print                   printActivityTableQueryArray                  selectClientTableQueryArray connect                 System out println  HshMap Print                   printClientTableQueryArray                 selectEmployeeTableQueryArray connect                 System out println  HshMap Print                   printEmployeeTableQueryArray                 connect close         catch  SQLException e             throw new IllegalStateException  Cannot connect the database    e                     Write Queries      param s     return      public boolean insertQuery String s        boolean ret   false      System out println  Loading driver            try           Class forName driver           System out println  Driver loaded            catch  ClassNotFoundException e             throw new IllegalStateException  Cannot find the driver in the classpath    e               System out println  Connecting database        try  Connection connect   DriverManager getConnection url userName password                 System out println  Database connected                   Set tables  information              try                   Statement st   connect createStatement                    int val   st executeUpdate s                   if val  1                        System out print  Successfully inserted value                        ret   true                                    else                       System out print  Unsuccessful insertion                        ret   false                                    st close                  catch  SQLException ex                    Logger getLogger DataBase class getName    log Level SEVERE  null  ex                             connect close         catch  SQLException e             throw new IllegalStateException  Cannot connect the database    e              return ret            Query needed to get code table s data     param c     return      private void selectCodeTableQueryArray Connection c        try           Statement st   c createStatement            ResultSet res   st executeQuery  SELECT   FROM  code             while  res next                      int id   res getInt  code number                    String msg   res getString  code statement                    code table put id  msg                         st close          catch  SQLException ex            Logger getLogger DataBase class getName    log Level SEVERE  null  ex            private void printCodeTableQueryArray         for  HashMap Entry lt Integer  String gt  entry   code table entrySet             System out println  Key       entry getKey       Value       entry getValue                     Query needed to get activity table s data     param c     return      private void selectActivityTableQueryArray Connection c        try           Statement st   c createStatement            ResultSet res   st executeQuery  SELECT   FROM  activity             while  res next                      int id   res getInt  activity number                    String msg   res getString  activity statement                    activity table put id  msg                         st close          catch  SQLException ex            Logger getLogger DataBase class getName    log Level SEVERE  null  ex            private void printActivityTableQueryArray         for  HashMap Entry lt Integer  String gt  entry   activity table entrySet             System out println  Key       entry getKey       Value       entry getValue                     Query needed to get client table s data     param c     return      private void selectClientTableQueryArray Connection c        try           Statement st   c createStatement            ResultSet res   st executeQuery  SELECT   FROM  client             while  res next                      int id   res getInt  client number                    String msg   res getString  client full name                    client table put id  msg                         st close          catch  SQLException ex            Logger getLogger DataBase class getName    log Level SEVERE  null  ex            private void printClientTableQueryArray         for  HashMap Entry lt Integer  String gt  entry   client table entrySet             System out println  Key       entry getKey       Value       entry getValue                     Query needed to get activity table s data     param c     return      private void selectEmployeeTableQueryArray Connection c        try           Statement st   c createStatement            ResultSet res   st executeQuery  SELECT   FROM  employee             while  res next                      int id   res getInt  employee number                    String msg   res getString  employee full name                    employee table put id  msg                         st close          catch  SQLException ex            Logger getLogger DataBase class getName    log Level SEVERE  null  ex            private void printEmployeeTableQueryArray         for  HashMap Entry lt Integer  String gt  entry   employee table entrySet             System out println  Key       entry getKey       Value       entry getValue                  I hope this could be a little help

User · Answer

Below is a class which will accomplish the very basics of what you want to do when reading data from a MySQL database into a JTable in Java   import java awt    import java sql    import java util    import javax swing    import javax swing table     public class TableFromMySqlDatabase extends JFrame       public TableFromMySqlDatabase                 ArrayList columnNames   new ArrayList            ArrayList data   new ArrayList                 Connect to an MySQL Database  run query  get result set         String url    jdbc mysql   localhost 3306 yourdb           String userid    root           String password    sesame           String sql    SELECT   FROM animals               Java SE 7 has try-with-resources            This will ensure that the sql objects are closed when the program             is finished with them         try  Connection connection   DriverManager getConnection  url  userid  password                Statement stmt   connection createStatement                ResultSet rs   stmt executeQuery  sql                          ResultSetMetaData md   rs getMetaData                int columns   md getColumnCount                     Get column names             for  int i   1  i  lt   columns  i                                  columnNames add  md getColumnName i                                    Get row data             while  rs next                                  ArrayList row   new ArrayList columns                    for  int i   1  i  lt   columns  i                                          row add  rs getObject i                                        data add  row                                    catch  SQLException e                        System out println  e getMessage                            Create Vectors and copy over elements from ArrayLists to them            Vector is deprecated but I am using them in this example to keep             things simple - the best practice would be to create a custom defined            class which inherits from the AbstractTableModel class         Vector columnNamesVector   new Vector            Vector dataVector   new Vector             for  int i   0  i  lt  data size    i                          ArrayList subArray    ArrayList data get i               Vector subVector   new Vector                for  int j   0  j  lt  subArray size    j                                  subVector add subArray get j                              dataVector add subVector                      for  int i   0  i  lt  columnNames size    i                 columnNamesVector add columnNames get i                 Create table with database data             JTable table   new JTable dataVector  columnNamesVector                        public Class getColumnClass int column                                for  int row   0  row  lt  getRowCount    row                                          Object o   getValueAt row  column                        if  o    null                                                return o getClass                                                             return Object class                                    JScrollPane scrollPane   new JScrollPane  table            getContentPane   add  scrollPane             JPanel buttonPanel   new JPanel            getContentPane   add  buttonPanel  BorderLayout SOUTH               public static void main String   args                TableFromMySqlDatabase frame   new TableFromMySqlDatabase            frame setDefaultCloseOperation  EXIT ON CLOSE            frame pack            frame setVisible true             In the NetBeans IDE which you are using - you will need to add the MySQL JDBC Driver in Project Properties as I display here     Otherwise the code will throw an SQLException stating that the driver cannot be found   Now in my example  yourdb is the name of the database and animals is the name of the table that I am performing a query against   Here is what will be output     Parting note    You stated that you were a novice and needed some help understanding some of the basic classes and concepts of Java  I will list a few here  but remember you can always browse the docs on Oracle s site    ArrayList  Vector Try-with-resources statement

[java] Display Records From MySQL Database using JTable in Java

Examples related to java

Examples related to mysql

Examples related to netbeans

Examples related to jdbc