How To Use Single Button To Insert And Update In Java While Using MySQL Database

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


ADVERTISEMENT

Unable To Get Values From JTable And Insert Them In MySQL Database

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

Trying To Insert Image Using Button In Java Swing - How To Get The Right Output

Jul 11, 2014

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
class image implements ActionListener
{
JFrame frmobj= new JFrame("image");
JPanel panel= new JPanel();
JButton b1= new JButton("image");

[Code] ....

View Replies View Related

Importing Excel Data Into MySQL Database Through Java?

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

How To Connect MySQL Database For Java Desktop Application

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

Application Web Java To Insert Data Into Database Oracle From XML Files

Oct 27, 2014

I want to create an application wich can handle xml files ( display xml files's data on a html page) + insert those data into an oracle database.

I'm new to that, it a project for my internship. wich API is the most appropriate for that ( Jdom or Xstream or other), wich framework i can use ( there is only 3 IHM : connexion, upload file, display data, confirmation insertion data)?

View Replies View Related

Java Servlet :: Storing Images In Folder And Their Relative Paths In MySQL Database

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

Insert ArrayList In A Table (MySQL)

May 1, 2014

I am facing the following scenario:

1- Take information from distinct columns from two different tables - OK
2- Insert this information into a new table.

I have created a ArrayList and inserted all the information that I need but now I am trying to put this ArrayList into the new table and I am not sure how to do it. I have done research and tests but unsuccessfully.

View Replies View Related

JFrame Reload After MySQL Update

Apr 22, 2014

I've got a similar problem like here: URL...

private void btnAktualisierenActionPerformed(java.awt.event.ActionEvent evt) {
if(sql.conOK) {
tabelle.table.tableChanged(null);
tablePanel.remove(scrollPanel);
// The following fetches the new database data and adds the new jFrame
tableExists = false;
this.getTable();
tabelle.setOptions();
}
else
lblStatusCon.setText("Bitte zur Datenbank verbinden.");
}


this is what I've been doing. It shows only the new jTable when I resize the window.

View Replies View Related

Process 10000 XML Files / Verify And Insert Data Into Database - Java Heap Memory Error

Oct 12, 2013

I need to process 10000 xml files and verify and insert the data into database. I am loading all the files in the file object and iterating one by one. I am getting the memory issue. How to handle this?

View Replies View Related

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 View Related

Java Array Update Without Using ArrayList - Add Values And Update Size?

Feb 9, 2015

I am trying to create an array list without using the built in arrayList class that java has. I need to start the array being empty with a length of 5. I then add objects to the array. I want to check if the array is full and if not add a value to the next empty space. Once the array is full I then need to create a second array that starts empty and with the length of the first array + 1.

The contents of the first array are then copied into the new array without using the built in copy classes java has and then the new array ends up containing 5 elements and one null space the first time round. The first array is then overwritten with the new array containing the 5 elements and the null space. The process then starts again adding values until the array is full which will be 1 more value then recreating the second array empty and the length of the first array + 1. This is my attempt at creating this but I have run into multiple problems where I get only the last value I added and the rest of the values are null:

public class MyArrayList {
public Object arrayList[];
public MyArrayList(Object[] arrayList) {
this.arrayList = arrayList;

[code]...

View Replies View Related

Connect Exe File To MySQL Database

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

Transferring Data To MySQL Database

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

JDBC Connectivity With MySQL Database

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

How To Get JList To Update When Refresh Button Pressed

Mar 15, 2015

I am able to update the array holding the items but I don't know how to refresh the JList to include all the new items in the array.

Code for GUI:

import java.awt.ScrollPane;
import java.awt.event.ActionListener;
import javax.swing.*;
public class ListView extends JFrame{
HobbyList stuff = new HobbyList();

[Code] .....

View Replies View Related

Display PDF File Which Is Stored In MySQL Database?

Apr 2, 2015

How to display pdf file which is stored in mysql database by using jsp and servlet ....

View Replies View Related

JDBC :: Storing Images To MySQL Database?

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

Greek Characters Are Stored In MySQL Database

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

Insert DateTime Into Database

Sep 3, 2014

I'm building an application to save times that I've worked, being build in java. Now. I've made a testdatabse to test if everything works till now. Here is the code of testdatabse

package Controller;
import java.sql.SQLException;
import org.joda.time.DateTime;
import org.joda.time.LocalDate;
import org.joda.time.LocalDateTime;
import org.joda.time.LocalTime;

[Code] ....

what I can't figure out is how to insert a test localtime or DateTime into the database.

Here is my model

package Model;
import java.io.Serializable;
import javax.swing.JTextArea;
import org.joda.time.DateTime;
import org.joda.time.LocalDate;
import org.joda.time.LocalDateTime;
import org.joda.time.LocalTime;
public class TimeModel implements Serializable {

[Code] .....

View Replies View Related

JSP :: Update Database Values?

Jan 4, 2015

I am trying out jsp and servlets now for the first time. I have to insert two data, car code and car name into a mysql table. I got those details using jsp but if I use form, it redirects to another page for insertion. I want the data to be inserted and still remain in same jsp page. I am thinking of using onClick from javascript but as I googled this many places have said it is a bad idea to use jsp inside javascript. If so how can we insert data to mysql table without redirecting to another page?

View Replies View Related

Clicking Insert Button - Number Format Exception

Feb 9, 2015

Everything is working great except for my back button at line 172. It works good but if I try to click the "insert" button again. It gives me the java.lang.NumberFormatException error. Other than that it works fine, the "insert" button still works.

package userDatabasePack;

import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class Database{
//Variables
private String username2, insertUser, insertPassword;
private int insertUserId;

[Code] ....

View Replies View Related

How To Update JLabel Or ImageIcon Anytime On Press A Button

Apr 15, 2014

I am trying to do a program about a contact agenda, now, I have one JPanel that contains three sub panels (GridLayout(1,3)) where I have in the left the picture of the Contact, the middle one is not important, but the right one contains 4 JTextFields with information of the contact and one JCheckBox that indicates if the contact is a favorite or not. The thing is that I am only able to show the first contact, but I want to be able to scroll between the contacts with a Button that I have in another panel. I think I am actually scrolling among the contacts, but the panel with the information from the contact is not updating the information...

public class PanelInfoContacto extends JPanel{

// -----------------------------------------------------------------
// Constructores
// -----------------------------------------------------------------
/**
* Construye el panel. <br/>
* @param contacto - es una referencia al contacto que muestra. contacto != null.
*/
public PanelInfoContacto(Contacto contacto){
setLayout(new GridLayout(1,3));

[Code] .....

View Replies View Related

JSF :: How To Update Primefaces Picklist Dynamically On Button Events

Feb 1, 2014

I am new to JSF, trying to customize the primefaces picklist, I want to update the picklist Source List dynamically on certain events like onclick or change?

I tried to write an Listener and populate the dualModel, the call is going to the method and List is getting updated but in UI, the old list is only maintained . I have also asked this question in stackoverflow ,

Refer this link for further details : stackoverflow [URL] .....

View Replies View Related

Servlets :: Error Loading MySQL Database Table From JSP

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

Servlets :: Insert Data To The Database?

Apr 4, 2014

i am stucked with a little error in servlets

this is my jsp page
form.jsp
<form action="InsertData" method="post" >
username:<input type="text" name="username">
Password :<input type="password" name="password">

[Code]....

i am getting wroor page not foung 404

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved