Updating jtable data
To keep it simple — but also show several different data types — I've created the following My SQL database table: create table users ( id int unsigned auto_increment not null, first_name varchar(32) not null, last_name varchar(32) not null, date_created timestamp default now(), is_admin boolean, num_points int, primary key (id) ); -- insert some sample records insert into users (first_name, last_name) values ('Fred', 'Flinstone'); insert into users (first_name, last_name) values ('Barney', 'Rubble'); A few of these fields are a little contrived, but I wanted to show several different data types in one table, so this is what I came up with.In particular, the field "num_points" is a little unusual.I made it up so I could show an int data type in this table, and I was thinking of those websites where points are awarded for giving correct answers.
For the Simple Book Table Model to work, an Array List object must be returned from a Simple Book List object. Also, the convert2Data() method has been removed because it won't be needed with the custom table model. Line 13 has the constructor name changed to match the class name.Here is the file "Simple Book Table Model.java": These are the absolute minimum necessary methods to display data in the JTable. Line 19 constructs the table model by passing the Simple Book List object to the Simple Book Custom Table constructor.New versions of the Joomla Platform API provide additional functionality which extends the database layer further, and includes features such as connectors to a greater variety of database servers and the query chaining to improve readability of connection code and simplify SQL coding.Joomla can use different kinds of SQL database systems and run in a variety of environments with different table-prefixes.