Swing/AWT/SWT :: Add / Edit And Delete JTable With Database
Apr 2, 2015
I currently have all the code working to fill my database and to display it, although I would like to have it displaying in a JPanel but I cannot figure it out so a JFrame will do. Add, Edit and Delete button for the JTable so I can add rows to the table and database, edit existing rows and delete rows also.
I have been developing what I intent to be a base class for several forms that will allow the user for adding / editing / deleteing records. These records could be customers, products, suppliers etc.
I have designed a basic form that has an add, edit and delete button. For the add button, I would want to clear all the values in all of the controls (textboxes, combox etc) in preperation for adding a new record.
My question is this. Is this something I should do in the base class OR should it be handled in the classes that will extend from the base class? Perhaps if the controls were datalinked to the data they will clear themselves (I haven't got that far yet so I dont know). I thought maybe I could write code in the base class that could loop through all of the controls and call this from the extended classes.
I want to add a Refresh button to my frame to refresh the data from the database, but I'm not sure how to refresh the data in the jtable. The constructor below initially creates the table and displays the data. Should my button destroy/create the JPanel all over, or is there a single method within the TableModel that will redisplay the data?
As shown in the SS I show the data of the batch from the db.Now I want to edit the data of the jtable using the default Double editors and also show the data using a Date renderer in dd/MM/yyyy format.The problem is when the data is loaded from the db,I am not knowing how to implement and set the editors to double and date.I am new in java.The code of the above is shown as follows.
Java Code: /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package Billing; import java.awt.Component; import java.sql.Connection; import java.sql.Date; import java.sql.PreparedStatement; import java.sql.ResultSet;
How to do this editing the last 3 letters of a string that i retrieve from database.. I have a string "111-222-333-000" here's the sample what i want to happen was to edit the last 3 letters of the string ,,
i insert into database "111-222-333-000" then i retrieve it for editing but what i want to happen is when i retrieve it what i can only edit was the last 3 strings only
I can insert data in database, delete aslo using JSP. But facing problem while updating the information saved in database as m using MySQL 2008. I want to see the bring saved in database with particular username into the updateinfo.jsp form.
My programms is working perfectly except for one little detail that annoys me. I have a JTable with a button on the first column that allows to delete this row from the table. Its working well except when I try to delete the last row of the table, the button stay there and then the table freeze and i can't delete any rows because i receive a "Out of bound Exception" . But, when I use the command table.getRowCount());
Before and after the removal of the line, the table "knows" that a line was removed but as i said, the button stay there. The screenshots in thumbnails show the situation before and after clicking the button next to the "Year" cell.
It's good to add that i'm adding rows in the table from a button outside the table.
Heres my code:
Main.java
static String [] title = {"X","Nom","SRM","Rend.","%","Kg",}; static Object[][] contenu; static DefaultTableModel model1 = new DefaultTableModel(contenu, title); static JTable tableauGrains = new JTable(model1); tableauGrains.getColumn("X").setCellRenderer(new ButtonRenderer()); tableauGrains.getColumn("X").setCellEditor(new ButtonEditor(new JCheckBox())); ButtonRenderer.java
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub String delete = ("DELETE FROM anagrafica WHERE Nome = ? And Cognome = ?"); ConnectionManager cm = new ConnectionManager(); String Nome = request.getParameter("nome"); String Cognome = request.getParameter("cognome");
[code]....
and this is my JSP.The problem is easy, when I click on the grid for deleting the record two things happen, or the record is deleted only on JSP but not in my Database or Nothing happens even on my JSP, it is because I don't know how to get values from my jsp and send them to replace the ? in my delete query I tried even to give a name to the <tr> which contains Name and Last name but obviously i guess it works only for input type ex. Textbox.
Im building a program that tracks overtime for employees. Basically there will be a list of employees. Number will be dynamic as different departments will have different amounts of employees.A user could pick the department from a JCombobox. E.g Quality Control. A Jtable will be populated with the employees from Quality Control.
The problem is this.
The way it will work is the list will be in a specific order. Whoever is at the top of the list will be asked if they want to do overtime. Then they will be moved to the back of the queue. If they do the work or not doesnt matter.How would i go about planning a system like this? Specifically creating a dynamic list that people can be moved up and down and stored persistently. URL...
I'm doing an application which needs a JTable with data from an existing database. I need the table to periodically (I plan to use a Timer) reflect the changes made to the DB (inserting new rows, deleting or updating existing rows) without making the dirty approach of clearing the whole JTable and refilling it again, which is not nice. I need to just add/modify/delete the needed rows, not the whole table.
I've tried everything but in vain..I want to save the data from the table into the database, I can easily connect to the database. All I want is how to get the values from the table. I've tried this method to get the values but its not working because of the contructor error in the BgTableModel class.
Tried Method public void writeBgEdu() { int last=gtm.getRowCount(); System.out.println(last); for( int i=0;i<last;i++) { if(((String) gtm.getValueAt(i,0))!=null)
i have a problem, im trying to get some values from a jtable (tabla) and insert them in a mysql database, so i scan the table for some values to know which of the rows i must insert ("s" or "n").
I'm able to insert few rows, but when the last row with "s" or "n" is inserted it launch me a NullPointerException and I dont know why.
My JTable has a row, row number 0, which I always want to be at the top.I tried the following two approaches, both without success:
1- Use a custom table cell renderer for the header, and create a header of two rows. the second row is my JTextField.
Problem: I cannot get the JTextField to function properly. (I've seen examples with a checkbox in the header, but that one just reacts to a click somewhere on the header, my textfield must be editable).
2- Use the first row of the table. This works quite nice. However, I must prevent row 0 to be re-ordered when sorting the table.
I was thinking to add a prefix (either something like "___" or "zzz" depending on current sorting mode), but I do not know which methods to adjust for this exaclty.
Another approach would be to have N textfields above the JTable in some layout (or two JTable's on top of each other).
However, Then I would need to react to the re-ordering and re-sizing of all columns as well, which does not seem easy to me.
I have encountered a very tricky spot in a project that i am working on. I must have a JTable to programmatically select the very last row in an AbstractTableModel. I have tried every thing but nothing works so far.
The problem is is that the JTable only scrolls down to the second last table row in the model? What am i missing?
//Show the very last row in a tablemodel object using the method updateTableRows //after an "insert action event" occurred public void updateViewMode(String name, java.util.List<NetworkSwitch> list, boolean flag) { CableTableModel model = cableTable.getCableModel();
[code]....
What happens is that the only row that gets selected is the second last row of the total rows iny AbstractTableModel object, "CableTableModel"
I am preparing a small solution. Below is how the functionality works.
1. Login Screen 2. Successful Login will take to a MDI Form 3. Click the menu, a JInternalFrame will open in the JDestopPane. 4. JInternalFrame has a JTable. 5. JInternalFrame has a JButton available for adding new data. 6. When JButton is clicked, a new JInternalFrame is popped up with some JTextField and JButton to save the data. 7. After saving the data (after insert query), a JDialog is opened to upload Logo (update query for BLOB), There are two buttons in the JDialog, one is for uploading the image, another one is uploading it later. 8. The logo is displayed in the JDialog and if the JButton, for upload is pressed, update the database and reload the JTable in the JInternalFrame is called.
My challenge is in point 8. The function is called properly, but the table is not getting refreshed.
JButton in JDialog for uploading the Logo private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: JOptionPane.showMessageDialog(this, "Image Uploaded Successfully"); companyConfig cc = new companyConfig(); //cc.reloadTable(); cc.updateTable(); this.dispose();
I've been creating a jTable where I can add / edit /delete new entries. Now i have 2 Questions :
1) My column 0 is filled with the row-number. I created a variable and with each "add" it adds +1 to the variable. That works, but as soon as i delete 1 row there is a gap ( 1..2..4..5..).
My question: Is there another way then mine to handle this?
2) The table is/should be working as some kind of database. The user is able to add Information (height, width,...). Now I want to sum the entries of 1 column (length,...). But as they´re objects I didn´t find a way.
My question: How can I sum the entries of 1 column of a table?
I am trying to get the data entered in a JTextField into a JTable but not clear on how. The LeftPanel is where the button is located and the RightPanel is where the JTable is. I want the actionPerformed to update the row of the JTable but I can't figure out how. There is another class that controls the GUI but did not think it was necessary to include. Also, I am aware that I am getting an error at the addRow line, can't seem to alleviate it.
public class LeftPanel extends JPanel {
private static final long serialVersionUID = -2311952438693382407L; private RightPanel rPanel; public LeftPanel(){ Dimension size = getPreferredSize(); size.width = 250; setPreferredSize(size);
I have a JTable with the model " Names " , " Quantity " and " Unit " .
I'm coding a program where you get the ingredients names.
So i need to get the whole row of one column and String it all up together,because i need to store it in mySql and i have already set it all as String.
how i can do this ?
My code are as follows :
JTable Code:
DefaultTableModel model = (DefaultTableModel)table.getModel(); if(!txtQty.getText().trim().equals("")){ model.addRow(new Object[]{ingCB.getSelectedItem().toString(),txtQty.getText(),unitCB.getSelectedItem().toString()}); }else{ JOptionPane.showMessageDialog(null,"*Quantity field left blank"); }
Getting the values and for storing :
for(int i = 1; i<= i ; i++){ ingredients = table.getName(); }
This is for loop is wrong and it does not work because i have a constructor to take in Ingredients but because it is inside the loop, it cannot take it in.
