logo
down
shadow

INSERT row does not update JTable in GUI


INSERT row does not update JTable in GUI

By : Phartumax
Date : November 22 2020, 11:17 AM
Hope this helps
"I cannot get my JTable to update with a new row unless I restart the program."
code :
public static void addGenre(Integer a, String b){
    ...
    rowsAdded = stmt.executeUpdate(query);
    if (rowsAdded > 0) {
        DefaultTableModel model = (DefaultTableModel)tab1.getModel();
        model.addRow( new Object[] { a, b });
    }
}
 catch(Exception ex) {
     ex.printStackTrace();
 }


Share : facebook icon twitter icon
Joomla 1.5 - JTable queries always doing UPDATE instead of INSERT

Joomla 1.5 - JTable queries always doing UPDATE instead of INSERT


By : Nuno Feliciano
Date : March 29 2020, 07:55 AM
this will help The following code is straight from the docs and should insert a row into the "test" table.
code :
function store( $updateNulls=false )
{
    // You set user_id so this branch is executed
    if( $this->$k)
    {
        $ret = $this->_db->updateObject( $this->_tbl, $this, $this->_tbl_key, $updateNulls );
    }
    // ...
How to insert, update and delete items from JTable that is loaded from (SQLite) Database

How to insert, update and delete items from JTable that is loaded from (SQLite) Database


By : gtigan
Date : March 29 2020, 07:55 AM
wish of those help I am still unclear about your requirements, but lets start answering as much as i have got to:
Every JTable object uses a table model object to manage the actual table data. A table model object must implement the TableModel interface. However the DefaultTableModel it self is enough to work with table data interaction. Check out it's java doc for more details.
code :
model.addTableModelListener(new TableModelListener() {

     @Override
     public void tableChanged(TableModelEvent e) {
          int rowFirstIndex = e.getFirstRow();
          int rowLastIndex = e.getLastRow();

          DefaultTableModel model = (DefaultTableModel) e.getSource();
           if(e.getType()==TableModelEvent.UPDATE)
            {
                int updatedColIndex = e.getColumn();
                String updateColmn = table.getColumnName(updatedColIndex);
                String updatedValue = (String) model.getValueAt(rowFirstIndex, updatedColIndex);
                System.out.println("column: "+updateColmn+" value: "+updatedValue);
                updateDB(updateColmn, updatedValue);
            }

            else if(e.getType()==TableModelEvent.INSERT)
            {
             for(int i= rowFirstIndex; i <= rowLastIndex ; i++)  
              {   
                  Vector rowData = (Vector) model.getDataVector().get(i);

                  Map<String, String>dataMap = new HashMap<>();

                  for(int j=0; j < rowData.size() ; j++)
                    dataMap.put(table.getColumnName(j), (String) rowData.get(j));

                  InsertToDB(dataMap); // now it contains columndName corresponding to row value

              }
          }
         }
     });
Insert,Update,Delete rows of jtable having mysql data

Insert,Update,Delete rows of jtable having mysql data


By : Jamil Regra
Date : March 29 2020, 07:55 AM
wish helps you Yes, you can. I'm not very good in swing but you can do this. Will be lot of work, implementing lot of listeners, changing and reloading table model, repainting the table after data change... very hard. But when you say " to remove the value and insert another in the case of update, or remove the entire row if the delete, or insert a new row" I understand that this wont be done by "clicking a cell". You should implement more controls over the row to know if you want to delete it or insert one above/below and all the operations you want. Hope this helps you, since you just asked if you can do that. Dont you think will be much easier on cell clik to open a new frame over the table and edit the row?
Update JTable after delete or insert

Update JTable after delete or insert


By : Skills
Date : March 29 2020, 07:55 AM
wish help you to fix your issue I did not use a direct row index because that may change if the user sorted the data by any one of the columns. I felt that since employeeID was unique that it would be better to match on that:
code :
//remove row in the ResultSet
	public void removeRow(String empID)
	{
		int rsRow = 0;
		try
		{
			//set cursor to beginning of data set (before first row)
			if(!resultSet.isBeforeFirst())
				resultSet.beforeFirst();
			
			//iterate through resultSet to find matching record with
			//correct employee ID. once found delete row
			while(resultSet.next())
			{
				if(resultSet.getString("EmployeeNo") == empID)
				{
					rsRow = resultSet.getRow();
					
					resultSet.deleteRow();
					System.out.println("User: " + empID + " was deleted from row: " + rsRow);
					break;
				}
			}
			
			resultSet.last();
			numRowCount = resultSet.getRow();
			
			fireTableRowsDeleted(rsRow, rsRow);

//			resultSet.absolute(rsRow);
//			resultSet.deleteRow();
		}
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
	
How to trigger Jtable update after delete or insert in DB?

How to trigger Jtable update after delete or insert in DB?


By : user2105034
Date : March 29 2020, 07:55 AM
it helps some times Let's take a look at what's happening:
When you call tabela() you query the database and create a new DefaultTableModel in model1. During construction in LekariD() you create a new instance of JTable and provide it with model1. On change you update the database and call tabela() again. This creates a new DefaultTableModel in model1. Your table still holds the previous DefaultTableModel and queries it whenever you require some data to be drawn.
code :
table.setModel(model1);
Related Posts Related Posts :
  • Support multi-language
  • Why does Hibernate @OneToOne execute multiple select queries instead of one?
  • How to modify the height and width of a LinearLayout programmatically for a customAlertDialog?
  • Java getting every second element from array list and using it as value for hash map
  • Jmap error "More than one non-option argument"
  • Thread.uncaughtExceptionHandler does not catch DataFormatException, FileAlreadyExistsException and NoSuchFileException
  • After navigating to each link in the webpage,how to get list of all forms with method =post using selenium java
  • Launch a specific Spring Boot service from a codebase containing several
  • How do I cast a Java Object into a List of integers?
  • The method andProperty(String) from the type QueryBuilder is deprecated - Javers
  • I don't understand the difference in output between System.out.println((char)b) and System.out.write((char)b)
  • How to support multiple source level targets in an annotation processor
  • Is there a way to save the obtained output from a a process object's getOutPutStream() method into a file
  • How to use item touch helper with heterogeneous view types?
  • Tap button again to confirm action
  • Getting wrong characters from Clob field in Oracle using java jdbc
  • Run multiple call in parallel go generate object using Futures
  • Unparseable date Exception java date pattern
  • Stored procedures call (namedparameterjdbctemplate)
  • com.google.firebase.database.DatabaseException: Failed to convert a value of type java.lang.String to long
  • Java - Scanner .next() doesn't read string that contains a space
  • Set a timer for the visibility of a button
  • Unirest gives NoSuchMethodError when using asString method
  • Abstract Controller in Spring
  • Map an instance containing a list to a flatMap (using stream)
  • JPanel is added onto other Jpanel on togglebutton Click
  • Mysterious " The color components or name must be specified " error in JavaFX ListView
  • How to set up blocking asynchronous request/response in project reactor?
  • How can i achieve the same functionality with Java 8 using streams
  • How to verify a password without sending it unencrypted to a server
  • While fetching all links,Ignore logout link from the loop and continue navigation in selenium java
  • Issues using spring boot with MySQL database
  • Method unmodifiablelist() cannot be applied to given type
  • Does using the fragments lower down the load on main activity
  • Cannot read resource as stream when running jar
  • JPA criteria produce a query with just a one question point
  • Upload data to the Azure ADLS Gen2 from on-premise using Python or Java
  • Netty server send a byte[] encoded by Protobuf, but C# client Socket.Receive keeps being 0
  • How to add string at the bottom of a ScrollView
  • Using the instantiated collection type for Jackson deserialization instead of initializing a new one?
  • Firebase Realtime Database Update Data - Android Java
  • Move to main thread after another thread go to sleep
  • use of lambda and streams on nested object
  • OneDrive authentication using ADAL4J
  • How to get lines starting with some word from file and if no match get lines starting with another word
  • Is there alternative for Java's ' byte[] decodeFile = Base64.getMimeDecoder().decode(fileBase64); ' in Python?
  • filter minimum value from custom java array list
  • PowerMock static method mocking isn't taken into account for each @InjectMocks invocation
  • Spring Boot LazyInitializationException inside Transaction
  • Getting field name as string for already defined class. Is that possible?
  • List the largest possible cuboids inside a 16x16x16 matrix
  • Reading Int value of bytes from inputStream
  • How to fix text change listener error when I implement it?
  • How to send XML file to ActiveMQ?
  • @PropertyId annotation "is disallowed for this location"
  • Single Ignite node does not stop TCP discovery
  • While loop stop condition missing
  • How to register a listener on a OID / Managed Object using SNMP4J to act on set or get requests the agent receives?
  • maven issue with profiles
  • How to properly implement a sensor with SensorManager in a thread?
  • shadow
    Privacy Policy - Terms - Contact Us © festivalmusicasacra.org