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.
I'm trying to add some mysql table columns to JSF table. And I'm getting error:
/index.xhtml: The class 'logon.User' does not have the property 'description'.
User.java
package logon;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
[Code]...
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]...
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+"'";
}
i found some problem for this jsp code. Actually I'm new in jsp. I'm trying to insert some data in a sql table in jsp by user input. Here's my code but i couldn't completed it.
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
[Code] ....
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 RelatedI 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] ....
I am trying to load a CSS file from a mySql DB table (each row represent a customer that use the application, and each one can set his own CSS file).
How can I convert the Stream / String that I loaded from the Clob column to something that I can use here XXXX
scene().getStylesheets().add( XXXX );
I found alot of examples, but they all talking about files from filesystem, or URLs. My CSS file is in the application memory. I want to prevent the option to write my string as a new file and then read it again. I have no problem with loading the CSS file from database, this part is O.K.
I am trying to insert information from a CVS file in a postgres table and I have this exception:
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 0
at crislicenta.automateImport.main(automateImport.jav a:29)
and the cod line is: db.importData(conn,args[0]);
The source code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class automateImport {
static final String JDBC_DRIVER="com.mysql.jdbc.Driver";
static final String DB_URL="jdbc:postgresql://localhost5432/";
[code]....
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.
question: A stored procedure to insert records into deliveries table HINT create stored procedure with parameters for each field in the deliveries table for ex customer address, phone, email and receivers’s address etc this is my answer, this store procedure right or wrong. if wrong, can you share with me
create or replace PROCEDURE ADD_ORIENT
(
EXCUSTOMER_NAME IN VARCHAR2
, EXCUSTOMER_PHONE IN VARCHAR2
, EXCUSTOMER_EMAIL IN VARCHAR2
, EXCUSTOMERRECEIVERADDRESS IN VARCHAR2
) AS
BEGIN
NULL;
END ADD_ORIENT;
I am trying to insert a record to a table in my database . I used the same syntax for 2 tables, one does work and the other does not work . I could not find any explanation for this error
"INSERT INTO CustomerRecord (Name, Number, Adress)"
+" VALUES(?,?,?)"; //first table working well
ps.setString(1,r.getCustomerName());
ps.setString(2,r.getCustomerNumber());
[Code] ....
For some reason one does work but the other does not work it says syntax error near order (table name). I am using sqlite db ...
I want to retrieve the data from this table given below and insert that data in the database in the next servlet
package com.sk;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
[Code] .....
How can insert value into sql server column of data type 'datetime' with jdbc the methods in java.sql are 'setdate()' and 'setTime()'
How can I do this. I'm using java.time.LocalDateTime.
I am not sure how to go about doing this, An ItemEvent.Selected constant is the hint given to me but i dont know how to start it.
My Array is : private ArrayList billItems = new ArrayList();
My method is : private void beverageJComboBoxItemStateChanged( ItemEvent event )
How to define Cell in the table by table event?
I need to process one component drag to the table. I misunderstand, how I can see to which Cell fall the component. I tried to use Event and Mouse event handlers in my custom Cell, but they do not work. I can copy the drag event to the table and table handles it, but how to get needed Cell I cant understand.
This is my codes in a button that if I click it . that information will send to Jtable but the problem is the jtable is in another frame so how can i connect this ?
DefaultTableModel model = (DefaultTableModel)
new admin().tableBagtags.getModel();
if (txtName.getText().equals("")) {
JOptionPane.showMessageDialog(null, "Please fill out all fields.", "Error!", JOptionPane.ERROR_MESSAGE);
[Code] .....
I'm trying to create my own arraylist using Collection. My program doesn't do anything. Obviously, I haven't a clue.
import java.util.Collection;
import java.util.Iterator;
public class MyArrayList<T> implements java.util.Collection<T> {
private int size = 4;
private T[] mArray;
public MyArrayList(String[] args) {
[Code] ....
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]...
I'm trying to show mysql data in JSF using this example [URL] .... . I figured out what <h:dataTable value="#{userBean.getUserList()}" var="u" border="1"> must be <h:dataTable value="#{userBean.userList}" var="u" border="1"> but getting error:
09:08:38,654 ERROR [stderr] (http--127.0.0.1-8080-1) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:307)
09:08:38,654 ERROR [stderr] (http--127.0.0.1-8080-1) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:101)
[code]...
I need to retrieve an image from the MySQL DB and display it in my JSP. The code below retrieves and displays the image with success. But, an exception is thrown:
SEVERE: Servlet.service() for servlet [jsp] in context with path [/FileFinalText] threw exception
[java.lang.IllegalStateException: getOutputStream() has already been called for this response] with root cause
java.lang.IllegalStateException: getOutputStream() has already been called for this response
[code]...
how can I resolve the cause with the getOutputStream() and prevent this exception to occur?
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]....
I am trying to export a DB record to an excel sheet. Below is the code which I tried. I am not getting any error but still only the first record of the table is getting inserted into the excel sheet. But when I try printing, I prints all the records. Below is the code I did to insert records.
for (int i=0;i<ColumnCount;i++) {
System.out.println("Inside for");
Label label=new Label(i,0,rsmd.getColumnName(i+1),cellFormat);
sheet.addCell(label);
WritableCell cell = sheet.getWritableCell(i+1, 0);
System.out.println("Column " + rsmd.getColumnName(i+1)+ " inserted");
cell.setCellFormat(cellFormat);
[code]....
I hope i am making a logical mi stake in the for loop. But still i am unable to locate that.
How could i populate jcombobox2 from MySQL depending upon the value of jcombobox1??
View Replies View RelatedI have written a java application that retrieves data from a database and display it on a graph. What i want is that the two systems are synchronized in such a way that when we update a value in the database, it is immediately shown on the graph.i have tried to use a refresh button but decided this would increase the overhead.
View Replies View RelatedI am unable to connect my javafx scene to mysql database. I get a java.lang.NullPointerException every time. I tried searching everywhere possible but no answers available. This is the Person class (super class for Teacher class):
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
[code].....