Swing GUI With MySql Database?
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
ADVERTISEMENT
Jul 22, 2014
I am having a problem to connect my .exe file to the database(mysql). I used launch4j to convert the jar file to .exe but the jar file can connect to the database when running inside the dist folder. When I run the .exe I am getting this error: No suitable driver found for jdbc:mysql.
View Replies
View Related
Jul 27, 2014
try {
is = new FileInputStream(file);
data = new byte[(int) file.length()];
is.read(data);
String extension = "";
int i = file.getName().lastIndexOf('.');
if(i>0)
[Code] ....
Everything works except transferring the image file.
View Replies
View Related
Apr 24, 2014
I created a database in mysql, but I have problems communicating with the DB in java.
Here is the error :
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/books
at java.sql.DriverManager.getConnection(DriverManager.java:604)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at displayauthors.DisplayAuthors.main(DisplayAuthors.java:30)
java.lang.NullPointerException
[Code] ....
HERE IS THE CODE
public class DisplayAuthors {
// database URL
static final String DATABASE_URL = "jdbc:mysql://localhost:3306/books";
// launch the application
public static void main( String args[] )
[Code] ....
View Replies
View Related
Apr 2, 2015
How to display pdf file which is stored in mysql database by using jsp and servlet ....
View Replies
View Related
Mar 13, 2015
This question is not about syntax but a best way to handle something. What is the best way to store a image into a database? For example converting it into binary etc. I just wanted to get some opinions.
View Replies
View Related
Oct 25, 2013
I did an application with jframe which i store member personal info like name, surname etc.But when i save it to Mysql database the values are ??????.I have changed database and table and columns collation to utf8, i checked java encoding it's utf-8 but the problem remains.i have spent hours in google search but nothing that works.
View Replies
View Related
Aug 3, 2014
import data from excel sheet into mysql database through a java program. How coding will be done in Core Java.
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
Jan 21, 2015
I want to develop desktop application with mysql . How to connect mysql . Any sample project or examples to learn .
View Replies
View Related
Nov 5, 2014
I m new to programming and am working on the college project. I have MySQL 5.6.20, Eclipse Kepler and Apache Tomcat 7.0.54. I m trying to retrieve the whole table from MySQL schema into a jsp. All the possible things i can do, i have already tried, but none of them are working.
The following attachment contains the whole project. I have my sql connection code in Sample.java file, which i want to get working in Fetch.jsp on the Submit button click. But it shows the tomcat error as localhost:8080/Sample HTTP Status 404-/Sample ; type Status report; message /Sample; Description The requested resource is not available.
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
[Code] ....
View Replies
View Related
Oct 29, 2014
I am developing my first Java application and the database I use is MySQL. I have created two separate buttons; one to insert new data into my database and the other to update the database when changes are made.
Each button is working perfectly, but I now want to combine both functions into just the save button. Thus, whether I am entering new data or modifying existing data, the save button should use an IF ELSE condition to decide whether to use the INSERT or UPDATE command.
My problem is, how do I write this IF ELSE statement? What should be the condition? For example;
IF(what? ){
String sql ="Insert into Table1 (classID,className,counselorID,startDate,endDate) values (?,?,?,?,?)";
}ELSE{
String sql2 = "update Table1 set classID = '"+value1+"',className='"+value2+"',counselorID='"+value3+"',startDate='"+value4+"',endDate='"+value5+"'
where classID = '"+value1+"'";
}
View Replies
View Related
Aug 17, 2014
I am trying to run a simple program that connects to a mysql database and prints out some fields. I am using Eclipse.
THe problem I am having is on the following line of code.
Class.forName("com.mysql.jdbc.Driver");
I get an error:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
[Code] ....
I have done some research and from what I have found is that I need to alter the class path to pick up the driver. When I downloaded the .msi I ran it and then the program closed. Where the files are ??? How to locate and import the file so I need to get my program to run?
I have included all the of the source code below.
package mySQLConnect;
import java.sql.*;
public class Connect {
// JDBC Driver name and database URL
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String BD_URL = "jdbc:mysql://localhost/sstbde";
[Code] .....
View Replies
View Related
Nov 16, 2012
I am developing an web application with servlets and jsp. I have an issue to store images. I am storing images in folder and their relative path's in mysql database.
When I retrieve path from database then using <IMG> tag i have displayed image like:
out.println("<td><img src="+user.getPlaceImage()+" width='70' height='50' /></td>");
It is working fine with internet explorer but not working (that is Not displaying image) in chrome/mozilla.
How to display that image in all browsers....
View Replies
View Related
Feb 13, 2014
I have created a jsp file which does the simple task of reading data from a mysql database and displaying the results on a web page. Please see below:
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
[Code] ....
However, each time I run the jsp file in the browser with my localhost as server, I get an HTTP Status 500 error.
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
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
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
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
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
Aug 11, 2014
How I can show data from Database in JXTreeTable?
View Replies
View Related
Apr 19, 2014
I have jFrame where I have to display data from database on button click. There are 4 buttons, first to display the first record in database, last to display the last record in database, next to display the next record and previous to display the previous record. I have done first and last record but what should I do to display the next and previous record.
View Replies
View Related
Sep 11, 2014
I need to implement an editable JComboBox. It should display a list of rivers from a database. However since the number of rivers is very large, the entries must be dynamically filled after the user has typed in three or more letters.
I have tried to solve this using a KeyAdapter. Everythings works. However after the user has typed in three characters, these three characters are selected in the Combobox. Of course when the user continues to type these chars will be replaced. I have so far not found a solution to deselect the characters and place the cursor at the end.
this.fliessgewaesserComboBox = new JComboBox<UisFliessgewaesser>();
this.fliessgewaesserComboBox.setEditable(true);
this.add(this.fliessgewaesserComboBox, c);
FliessgewaesserSuchenKeyAdapter fliessgewaesserSuchenKeyAdapter = new FliessgewaesserSuchenKeyAdapter(this);
this.fliessgewaesserComboBox.getEditor().getEditorComponent().addKeyListener(fliessgewaesserSuchenKeyAdapter);
[Code] .....
View Replies
View Related
Apr 16, 2014
Can we cance/stop a long running database query execution instantly so that we can do any another task.
As i know swing uses a single thread i,e Event Dispatch Thread (EDT), But at the same time we can use Swingworker class for better use of UI. When we use Swingworker class the process goes to a different thread and our basic UI is not Frozen. Infact we can do another task. But what I want is I want to stop of cancel the execution of swingworker thread ( Because I that thread takes long time to execute). How can I do that??
I used ProgressMonitor and in the cancel option i canceled the task ( worker.cancel(true) also i closed the connection and statement for executing the database query using stmt.close() and conn.close() methods.
But it does not work. How to cancel a long running database background process in a Java Swing Program.
View Replies
View Related
Apr 22, 2015
I don t know why this throw a nullpointerexception. i want to add rows from mysql database to my jlist, this is my method populateJlist().
public void populateJlist() throws SQLException {
conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/agenda","root","");
DefaultListModel m = new DefaultListModel();
statement=conn.prepareStatement("SELECT *FROM apunte");
rs=statement.executeQuery();
String itemCode;
[code]...
View Replies
View Related
