JTable Filled From Database
Oct 9, 2014
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...
View Replies
ADVERTISEMENT
May 21, 2014
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?
class TablePanel extends JPanel {
private Connection con;
private JTable table;
TablePanel() {
try {
[code].....
View Replies
View Related
Apr 12, 2014
How to insert multiple rows into a database from a jtable and also retrive the same details from database and show it in a jtable.
View Replies
View Related
Feb 10, 2015
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.
View Replies
View Related
Sep 26, 2014
Why this code is not working/my JTable won't updated after i click the button
import java.awt.Component;
import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
[code]....
View Replies
View Related
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.
Here is the code for my current class.
package ManGUI;
import Database.DatabaseOperations;
import javax.swing.*;
import javax.swing.border.BevelBorder;
import javax.swing.table.DefaultTableModel;
import javax.xml.crypto.Data;
[Code] .....
View Replies
View Related
Jul 16, 2014
The Table Model
package presentation;
import java.util.List;
import javax.swing.table.AbstractTableModel;
import javax.swing.*;
import javax.swing.table.*;
import java.awt.*;
import business.*;
public class BgTableModel extends AbstractTableModel
[code]....
View Replies
View Related
Jul 16, 2014
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)
[Code] .....
View Replies
View Related
Feb 7, 2014
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.
public void insertar(JTable tabla, int rowt, int colt) throws ParseException{
String documento=null, cve_clie=null, fechaE=null, fechaR=null, check=null;
char d=' ',dd=' ',m=' ',mm=' ',y1=' ',y2=' ',y3=' ',y4=' ';
String chck = null;
try{
conexion = connMysql.mysql();
String squery="insert into consefact3 values (?,?,?,?,?)";
PreparedStatement pst = conexion.prepareStatement(squery);
[Code]...
View Replies
View Related
Oct 17, 2014
Do I want to make something like this:
*****
*.....*
*.....*
*.....*
*****
I am stuck, I have made a code that creates this and don't know how to complete it.
*****
* *
* *
* *
*****
Code:
class Main {
public static void main( String args[] ) {
System.out.print("#Enter number of stars :");
int stars = BIO.getInt();
[Code] ....
View Replies
View Related
Oct 31, 2014
I have a Char stack: ArrayStack<Character> stek=new ArrayStack<>();
The stack is filled with numbers and characters (only '+' and '*' ), but I need to make calculations, so I need the INT values of the numbers i pop from the stack. So each time I need to make a calculation, I have to pop two numbers, convert them into INT ,then add/multiply them, and put them back into the stack again, but as CHAR (because the stack is not accepting them to be added as INT)
int a= Character.getNumericValue(stek.pop()); //stack no1
int b= Character.getNumericValue(rezultat.pop()); //stack no2
int tmp=a*b;
char tmp2 = (char) tmp;
stek.push(tmp2);
View Replies
View Related
Feb 15, 2015
I was inquiring about selecting random numbers from a Fibonacci array, the original post for which is here: Exiting a 'for' Loop Early. I have managed to achieve this with the following code:
System.out.println("Random numbers from the Fibonacci array");
for(int i = 0; i < limit; i++) //Limit is an 'int' of 15 & is set as the length of the Fib. array. I'm calling it for the Random array, too!!
{
Random dice = new Random();
int randomIndex = dice.nextInt(array.length); //The Fib. array was simply called 'array'!!
if (array[randomIndex] < 100)
{
System.out.print(array[randomIndex]+ " ");
}
}
When the code prints I get a random set of numbers which occur in the Fibonacci sequence preceding it. However, the actual length of this Random array also changes each time, and never more than the limit of 15 specified in the 'for' loop. What I want to try and do is print the Random array with a specific length each time. I've tried changing the conditional statement of the 'for' loop in different ways to set the Random array's length, but had no luck.
View Replies
View Related
Nov 16, 2014
I'm a complete beginner in Java programming and I'm interested to learn more about its concepts.
Recently, I've been given an exercise which instructs me to display two versions of a picture. The picture to be displayed is provided in the form of a data file of 40,000 digits that are arranged in rows (although there is no marker between rows) and it starts from the top of the picture. So the first digit represents the top left corner of the picture and the last is the bottom right.
Basically, what the exercise wants me to construct a program that plots a dot in one of two colours for each digit. If the digit is in the range 0 to 3 the output should be one colour and for digits in the range 4 to 9 the dot should be in the other colour.
I understand I have to use arrays and also loops to perform this. I'm familiar with the fillEllipse, drawEllipse, drawRectangle and fillRectangle but this exercise is nothing I've attempted before.
View Replies
View Related
Apr 13, 2014
Write a program that shows a square frame filled with 100 buttons labeled 1 to 100. Nothing needs to happen when you press any of the buttons. I keep getting errors i am a beginner.
import java.awt.Frame;
import javax.swing.JButton;
import javax.swing.JPanel;
class TestFrame extends Frame {
[Code] ...
View Replies
View Related
May 26, 2014
I need to compare two jtable and set the value from one jtabel to the other jtable.
jtable one consist of:
Unit ID Unit Name Access
ABC, Inc ABC Incorporate (checkbox) value = uncheck
CDE, Inc CDE Incorporate (Checkbox) value = uncheck
jtable two consist of:
Unit ID Access
ABC, Inc ABC Incorporate (checkbox) value = checked
CDE, Inc CDE Incorporate (Checkbox) value = checked
if comparing jtable one an jtable two has the same Unit ID then colum Access from jtable two value is set to jtable one become check based on jtable two.I did the code but did not work:
for (i = 0, jTable1.getrowcount(), i++) {
for (j = 0, jTable1.getrowcount(), j++) {
if (jTable1.getvalueAt(i,0) == jTable2.getvalueat(j,0)) {
jTable1.setvalueat(true,i,2)
}
}
}
above code i try did not make any changes.
View Replies
View Related
Jun 5, 2014
i must get minimum value of 4th row in jTable and place it in textfield, but i can't do this
View Replies
View Related
Jan 9, 2014
how can i sort a Jtable, If i have in a certain column Strings and Integers, but I don't want to sort like string.example:
ID |
----------
1
11
2
213
22
MOSTR
MOSTIR
i dont want this to happen when i sort this column, I'm using table.setAutoCreateRowSorter(true);
View Replies
View Related
Aug 12, 2014
How to get value from jTable? I use mouse click event for my jtable and then, i want to set value to datechooser. Usually my behaviour for get value from jTable to Textfield, i'm using this method.
txtNamaKlien.setText(String.valueOf(jTable1.getValueAt(jTable1.getSelectedRow(), 1)));
And then value from jTable success fill to textfield.
My problem value from jTable not success fill to jdatechooser, i'm using this method
Date tanggal = (Date) jTable1.getValueAt(jTable1.getSelectedRow(), 2);
jDateChooser1.setDate(tanggal);
And I get an error
java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Date
I'm using database mySQL
When inserting data, i use this method
java.text.SimpleDateFormat fmt = new java.text.SimpleDateFormat("yyyy-MM-dd");
String formattedDate1 = fmt.format(jDateChooser1.getDate());
View Replies
View Related
Jul 13, 2014
I have created a JTable which does not display. When I run the program I can see that a line appears around the edge of the panel indicating the JScrollPane is added to MyJPanel, however, the table is missing. This is the table
public class MyJTable extends JTable {
private Object[][] data;
private Object[] columns;
private MyTableModel model = new MyTableModel(data, columns);
public MyJTable(Object[] columns, ArrayList<Data> data) {
this.columns = columns;
for(Data d:data){
[code] ....
View Replies
View Related
Jan 17, 2015
I'm trying to implement a spreadsheet-like table using JTable and this is the basic structure.
String[] colnames={"A","B","C","D","E"};
String[][]data=new String[28][5];
sheet = new JTable(data,colnames);
//sheet.setBounds(10, 36, 527, 214);
JPanel tablepane=new JPanel();
tablepane.add(new JScrollPane(sheet));
tablepane.setSize(800, 400);
In a spreadsheet, alphabetical letters are column names and numbers represent rows. I have named the columns and I need to name the rows in the same way. Or if I am to set the first column in every row as row headers, how can I make then non-editable by the user? In addition to that, how can I make the table appear bigger? There's a lot of space but the table appears to be small.
View Replies
View Related
Dec 6, 2014
I have created Jtable which stores images and Strings, I can SAVE the content to external file, however whenever I will try to load it back (below code) to JTable, it throws me an error. One field in the JTable uses renderer for images, and the code throws everything back as a String ) how can I transform one 'word' (e.g. /usr/etc/test.jpg) in a text file to ImageIcon which will be handeled by the renderer? Should I read the file 'word' by 'word' store it as array and load it into column?
private void check() {
String path = "Tab.csv";
File source = new File(path);
if (source.exists()) {
DefaultTableModel mdl = (DefaultTableModel) Tab.getModel();
String line;
BufferedReader reader;
[code]....
View Replies
View Related
Nov 9, 2008
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.
View Replies
View Related
Apr 18, 2014
Can I use Jlist instead of Jtable for showing database table data (select * from employee) in my code?
View Replies
View Related
Mar 26, 2015
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"
What am i missing?
View Replies
View Related
Nov 17, 2014
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();
[code]....
View Replies
View Related
Nov 18, 2014
I have a panel which has set to cardLayout and at the bottom, I have the buttons, based on the button clicked I will change my cards further and back. My second card has Jtable which allows the user to edit a particular cell. Now my problem is for the first time, when the data is inserted into the table, the particular column's cell is getting editable and allowing user to edit the cell and take the value what user gives. But when I come from 3rd card to the 2nd card, I have to show the previous created table or again from my 1st card if I move to the second card (in the same opened application), the cell's in the jtable is getting editable but not allowing the user to enter the text to the cell?? why is this problem coming?? I tried repainting that table when I move from 3rd card to 2nd card, and when coming from 1st to 2nd card the jtable rows are removed and new rows are inserted. But still the same problem arrives?? why is it working correctly in the first time and not able to in the second time??
View Replies
View Related
