Swing/AWT/SWT :: How To Select Items Of JList2 From MYSQL To Show In Jtable
Jan 31, 2015
There is a Jlist(Jlist1) which is populated with the columnNames from MYSQL. Then There is another empty Jlist (Jlist2) which the user can add items from Jlist1. At this stage I want to know how I can select items of JList2 from MYSQL to show in Jtable. Because the columnnames(items) of Jlist2 is less than the Jlist1. Like Spss that when you select variables from available list then you can add some of variable to selected list and do analysis.
View Replies
ADVERTISEMENT
Jan 31, 2014
i want to make adding into mysql database and then when i click adds, jtable show those data automatically. but it seem to get error at display part, it shows " Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: Uncompilable source code - illegal start of expression" and jtable do not show the added data but in mysql, data is properly kept.
private void jtPropertyChange(java.beans.PropertyChangeEvent evt) {
DefaultTableModel model = (DefaultTableModel) jt.getModel();
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url, user, password);
String sql = "SELECT * FROM `companya`";
[Code].....
the adding part seems to be fine
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
Aug 3, 2014
I am designing a advanced search option in a java project with sqlite in NetBeans. there are 5 different JTextfields and 5 columns, I want to populate JTable with corresponding matching criteria. If a JTextfield is empty then it should select all items of that column.
query i was using is:
String val1=txt_billing2.getText(); //five input fields
String val2=txt_station2.getText();
String val3=txt_invoice2.getText();
String val4=txt_amonth2.getText();
String val5=txt_umonth2.getText();
[code]....
but when i leave a JTextfield empty it shows no data in JTable. only method i know is to use if else conditions but that generates 5!= 120 conditions!!!
View Replies
View Related
Dec 5, 2014
I want to show the number of rows that is available in the table from my MySQL table. The thing is, im doing a music system database thingy and i want to show how much songs there is in the database in my GUI ie through a jTextField.
View Replies
View Related
Jun 11, 2014
I have a jtable. the fields are like Product_code,Product_name,Qty,Rate in my java program.. now i want to do is when i press a first letter in my jtable under Product_name like "P" it will display the reminding Product_name which will have the starting letter of "P" like pen, pencil, peper like this i want to populate in my jtable.
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
Jul 12, 2014
I've 2 tables in my MySql DB,Employees and Assets & I want to pick 2 columns Employees and one column from Assets,then how would I display them into a JTable??
View Replies
View Related
Feb 27, 2014
I'm trying to display the data from database in a jtable by following the jtable demo example in Java Tutorials Sample Code; but, I couldn't output the data to the jtable. The following code is what I've done so far.
import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;
public class Patient { static String szJdbcURL = "jdbc:oracle:thin:@129.78.110.188:1521:MyDB";
static String szUser = "...";
static String szPasswd = "...";
static String szModelName = "...";
[Code] .....
View Replies
View Related
Jan 18, 2015
This is an old project that I had working probably 2 years ago. Since I reopened it the only thing I have changed is the database location. This is a very basic project I did to dip my toes in to Java. I'm going to add it to my portfolio but just to clarify I am not a Java developer so this is mainly there to show that I am not completely blind when it comes to Java.
//Import libraries
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.GridLayout;
import java.awt.event.KeyEvent;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.sql.Connection;
import java.sql.DriverManager;
[Code]...
Errors when I click the button that launches the JFrame:
Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: 6 >= 6
at java.util.Vector.elementAt(Unknown Source)
at javax.swing.table.DefaultTableModel.getValueAt(Unknown Source)
at javax.swing.JTable.getValueAt(Unknown Source)
at javax.swing.JTable.prepareRenderer(Unknown Source)
at javax.swing.plaf.basic.BasicTableUI.paintCell(Unknown Source)
[Code]...
It will launch the window but it will be blank. If I resize the window it will show me the headers. If I click below the headers were the data should be, it will show me the data.
Since it has been so long the only thing I can think of is some of the code has become antiquated. As I said, this was working originally. I just fired it up again to take some screenshots for my portfolio.
View Replies
View Related
Jan 5, 2015
I stored an image into MySQL database using swings and hibernate but I am struggling to retrieve that image from MySQL database and display same image in the jTable cell and same as on jLabel whatever I retrieve from the database using swings and hibernate .
View Replies
View Related
Oct 24, 2014
I have problem with manually (through my java code) selecting items in a JTree. I did Google the problem and found solutions here :
[URL]
This code worked for me only partially. Once I tried selecting deeper nested nodes, I ran into problems. Since my production code is very cluttered I built an example and reproduced my exact problem in it.
DummyView.java
package de.fortis.tcws.client.controller;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
[code].....
The important method is 'manualSelect(String[])'.
It streps through the tree by comparing user objects and finds the target node. Then it calls 'navigateToNode()' which uses the solution discussed in the links above.
This method behaves incosistently:
If you call it with an empty array it will correctly select the root node. The righthand pane shows the text of the selected node. = correct
If you call it with target node 1 it will correctly select node 1. The righthand pane shows the text of the selected node. = correct
If you call it with target node 1.1 it will select node 1.1 but for some reason it is not displayed as marked (no background). The righthand pane shows the text of the selected node. = only partly correct
If you call it with target node A it will run into an exception. Debugging reveals that the selection occurs correclty at first. You can also observe the righthand pane showing that 'A' was selected. But afterwards another TreeselectionEvent is occuring that has a NewLeadSelectionPath of null. I do not know where this second SelectionEvent is triggered from.
This code is run with Java 1.6.0_39 which is also what I will have to use in production.
View Replies
View Related
Aug 7, 2014
Is it possible to switch images (on jlabel)on combobox item select. I
If (combobox.selecteditem = value)
{
SetIcon (resource) // I'm using the default auto generated code used by eclipse when we set an icon for a jlabel in the gui
}
View Replies
View Related
Mar 3, 2014
When I add to a JScrollPane (I'm adding to a JPanel then putting that in the scroll pane) it displays as many items in one row as possible. How can I make it so that it only displays one per row?
View Replies
View Related
Mar 16, 2014
How do you make it so that you can select 2 buttons in a radio button group? for example: If I have 7 radio buttons, and I want to be able to select 2 of the 7 instead of 1.
View Replies
View Related
Oct 8, 2014
If I have a comboBox full of id's - is it possible that when I choose said id (click it) it will then transfer over into my textField where I can use that as a prefix for my filename ...
(The file can be created just by having a name in the text field it doesn't need to already exists) ...
View Replies
View Related
Nov 12, 2014
I have a program where I have to open a file and then run a piece of code to do something with it. However since there are different files I want to run different pieces of code depending on the file. I have a JFileChooser setup and it works but I would like to have a something like an if else depending on the file extension.
View Replies
View Related
Mar 10, 2014
I've got another project for a course and am stuck. I've debugged and tried to figure out where it is breaking, but I just can't find it. I've used this connection code block as well as the contstructors before, but this just won't work. I've got a tab that should send all of the information to a MySql database upon the click of 'Add Employee'. I've given my connection string, the addEmployee(); code, and if needed I can include the subclass code. I've got a superclass 'Employee' and a subclass 'Salaried' that uses four attributes from 'Employee'.
private void btnAddActionPerformed(java.awt.event.ActionEvent evt) {
addEmployee();
}
public void addEmployee() {
int socialSecurity = 0;
boolean error = false;
[code]....
View Replies
View Related
Nov 11, 2014
I need to take the value of what's typed in my JTextField, and once the submit button is clicked, I want to add that string to my JComboBox list items.
Depending which RadioButton they selected, I need to put the team in HOME or AWAY teams, and so on and so on, until they continue clicking submit.
View Replies
View Related
Mar 17, 2014
I am working on a java bean, on a stopwatch
private String displayFormat = "%02d:%02d:%02d";// produces 00:00:00 hour:min:seconds
public void timerHasChanged() {
currentTime = System.currentTimeMillis();
// How long has been taken so far?
long secsTaken = (currentTime - startTime) / 1000;
long minsTaken = secsTaken / 60;
secsTaken %= 60;
long hoursTaken = minsTaken/60;
minsTaken %= 60;
Formatter fmt = new Formatter();
fmt.format(displayFormat, hoursTaken, minsTaken, secsTaken);
timerJbl.setText(fmt.toString());
How would i code the get and set method for format, so in property tab a user can choose if they want the timer shown in seconds, or minutes or hours or seconds&minutes
View Replies
View Related
Feb 8, 2015
I'm trying to create a userlogin program using mysql. I have an error at line 70.
package userDatabasePack;
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class UserLogin {
public static void main (String[]args) throws SQLException{
[code]....
View Replies
View Related
Sep 19, 2014
I am trying to create a GUI interface in swing which consists of four classes: a GUI class, which creates a main JPanel, a label, and a JList, which it takes from the second class, a MovesList class that contains a JList and the stuff needed to interface with it. It also has a main class, which basically just creates an object of the GUI class for the main window, and an Other class from which I would like to be able to add an item to the JList. I created methods in the MovesList class to get each component (like getMoveslist, or getMovesListScrollPane), which I then used to create the JList in the GUI class. I also created an addMove method so that I can add an item to the JList from any class through a MovesList object. However, this addMove method only works when called from the GUI or MovesList classes -- it does nothing when I collect from the Other class.
Here is my code:
//Main class
public class TestProject {
public static void main(String[] args) {
GUI mainWindow = new GUI();
mainWindow.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
[Code] ....
When I run this code, I get a window with a JLabel that says "Moves," and a JList that contains five elements -- test 1-test 5, but not a sixth "test from other class." ( using the add move method ) However, when I click on the window, the addMove method is also called, and successfully adds "test 6" to the list.
View Replies
View Related
Dec 8, 2014
The problem is that I populate the table with autoincrement primary key. I don't want it to be visible. I have been googling for hours to find no solution. It seems that sql/mysql provides no solution by selecting all table columns except one. So I wonder, how I could overcome this problem. Here is some of my code:
public void tableChanged(TableModelEvent e) {
int row = e.getFirstRow();
int col = e.getColumn();
model = (MyTableModel) e.getSource();
String stulpPav = model.getColumnName(col);
Object data = model.getValueAt(row, col);
[Code] .....
The ID is used in
stmt.addBatch("update finance.fin set " + stulpPav + " = " + duom
+ " where ID = " + studId + ";");
I tried to omit ID from my SELECT statement, I tried to put Date as a first element in data[iEil][0] but neither options were successful. Data hasn't been changed in database. NOW, everything works fine, except I don't want ID column to be visible in my table.
View Replies
View Related
Sep 25, 2014
I'm not sure what I'm doing wrong but none of the buttons will show below. I tried using .add with the container name but it kept giving me an error. When I just put add.(); it seems fine but then nothing shows. Is there something I'm missing that's required?
import java.awt.Container;
import java.awt.FlowLayout;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
@SuppressWarnings("serial")
[code]....
View Replies
View Related
Feb 16, 2014
trying to get my image to show up on my compiled GUI.
Here is my GUI, I just need to know how to get the image to show, where do I save an image file so that it comes up in my GUI.
import java.awt.Image;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.Vector;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
[code]...
View Replies
View Related
Apr 2, 2014
I am working on a keypad for a phone app for school. I cannot get the numbers from the keys to show up in the textField. I have made multiple tweaks, but think maybe my case statement is the problem?We did a calculator application in the class, so I have based my code off of that. Although the telephone keypad seemed much simpler to code, I can't seem to get the numbers to show up.
public void actionPerformed(ActionEvent e) {
//test for button clicks
foundKey = false;
//search for clicked key
for (int i=0; i<keys.length && !foundKey; i++)
[Code] ....
View Replies
View Related
