Dynamic Contents In SQLite Query And Error Because It Is Not Final

Aug 21, 2014

I'm trying to execute SQLite query like this:

final String gender = new String();
if (sexCombo.getValue().toString().equals("Man")) {
gender = "1";
}
else {
gender = "0";
}
final string Q = "INSERT INTO ... VALUES (...., " + gender + "...)");
stmt.executeUpdate(Q);

The problem is:

error: local variables referenced from a lambda expression must be final or effectively final stmt.executeUpdate(Q);

How can I generate query command using conditionals and make it work?

View Replies


ADVERTISEMENT

Dynamic SQL In Java - Query Value From Database

Jun 18, 2014

I have code which query value from database, the use case is the user can enter value as 1,01,11 in database but when the user enter value in xml file he can only enter 11,01,12 in database there is two columns lets say column test1=1 and test2=2 combination of this is 12, which is the value the use will enter in xml, but sometime the use can enter test1=04 than column test2=00 how can i approach this
 
I got table called card with column crdind,crdpos1,cardpos2 as primary key. The user can enter value as
 
crdind=1
crdpos1=5
crdpos2=3
inactivedate=2013-05-24
activedate=null
 
another row
 
crdind=1
crdpos1=5
crdpos2=5
inactivedate=2013-05-24
activedate=null
 
another row

crdind=6
crdpos1=02
crdpos2=00
inactivedate=2013-05-24
activedate=null
 
The rule say if you enter one number in crdpos1 eg 2 than you must enter value in crdpos2 it can be any number 1-9 but if you enter 00-09 in crdpos1 than crdpos2 is 00
 
The challenge I have is to query this value after they been enter. I have xml file which got field crdpos the use enter 15 which is the combination of column crdpos1=1 and crdpos2=5 ... How can I split the value crdpos and got and able to query in database in two separate column ....

View Replies View Related

Insert A Record To A Table In Database - SQLITE Syntax Error

Jul 19, 2014

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 ...

View Replies View Related

Parsing Error With Final Bracket

May 8, 2014

Im working on a class to add to my final project but im getting a parsing error for the final bracket, i double checked to make sure im not missing any but im still getting an error

import java.util.Scanner;
public class totalprice
{
public static void main(String[] args)
{
scanner keyboard = new Scanner(System.in);
{
DecimalFormat num = new DecimalFormat("#.00");
char meal;
int ammount;
double cost;

[code]....

View Replies View Related

Creating Final Arrays With Final Elements

Aug 2, 2013

I want to create a final array with final elements
 
{code}
final int[] array = {0, 1, 2, 3, 4, 5};
{code}
 
But here only the reference of the array is final , not it's elements ... So how can I do that??

View Replies View Related

PreparedStatement For MySQL Query - Where Query Seems To Get Cut Off

Mar 21, 2014

I am having a problem with a PreparedStatement for a MySQL query, where the query seems to get cut off. I can't really post a self contained example, because it involves an SQL database.The part of the code with the problem...

Java Code:

public void insertEntry(
Hashtable<String, String> strings,
Hashtable<String, Integer> integers,
Date created, Date paid, boolean enabled)
throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");

[code]....

The output of the whole program, though all it has done so far is create some default values and attempt to insert them with the above code, where the problem occurs.

Debug: SQLpaid = 1990-03-21

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT enabled=0, username='default_username', created='2000-03-21', paid='1990-' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45)

[code]....

View Replies View Related

SQLite Database Path

Jan 19, 2015

I was asked to create an Android App with SQLite Database. I had referred some example and tutorial which can be found from the internet but 1 thing that is still unsolved.

The default path for Android SQLite is //data/data/<Your-Application-Package-Name>/databases/<your-database-name> which can be found in Eclipse DDMS after connecting the phone to the computer or the emulator is on.

I had tried many example and tutorial and yet I can only access to "data" file only and the rest (/data/<Your-Application-Package-Name>/databases/<your-database-name>)are never appeared on my screen. This is one of the website (URL....) I learnt to create my database app.

I had follow the steps exactly for many times but I still can't find the path. The app is running fine as it will show saved data/"contact" although I restart the apps(Which mean it did save my data but I just can't find where did it saved). What's wrong with my Eclipse?

View Replies View Related

Running Java App With SQLite On Ubuntu

Nov 12, 2014

I have built a Java app that uses SQLite (sqlite-jdbc-3.8.7.jar). Running the jar file on windows works as expected however, trying to run it on Ubuntu Server 14.04 has turned into quite a task!

I put together a brand new machine in VirtualBox for testing. I installed Java (sudo apt-get install default-jre) and have installed SQLite (sudo apt-get install cl-sql-sqlite3 sqlitebrowser). I created a new sub-directory within my home directory and copied over the jar file. From terminal, I then run the command: sudo java -jar ProductionView.jar and I receive a java.lang.unsatisfiedlinkerror. For troubleshooting, within the app, before making a connection to the db, I have printed out the location of where the db is to be created and it is correct (see attached pic). Is there more that needs to be configured before I can run this app on Ubuntu? I have posted the relevant code below :

(AppDatabasePath() is what is printed in the image...).

public static String AppDatabasePath() {
return AppPath() + APP_NAME + ".db";
}
public static String AppDatabase() {
return "jdbc:sqlite:" + AppDatabasePath();

[Code] .....

View Replies View Related

Burning Java Application With Sqlite Database To CD

Jul 20, 2014

I have java application used to manage a sqlite database (add new records, search .....) I already have everything and I convert it to jar file but the question is how to burn it to cd with the sqlite database . I mean we need to change the database URL for connection class. My question is there any programs would combine my database + my jar file and make it exe file ?

or i should manually change my database url in connection class ? (if yes what should i write knowing that my database and my jar file will be burnt to a cd). I searched online but i could not found any one related sqlite database or at least a clear one . I already has my jar file but if i moved the database from its directory it will not work ...

View Replies View Related

SQLite Not Writable - Attempt To Write To Only Read Database

May 29, 2014

I designed a Java desktop application (i.e the app runs on local computer), everything is fine until when I compiled the program and wanted to run it on another computer then it tell me "java.sql.SQLException: attempt to write to only read database".

View Replies View Related

JSP :: Query String URL

Apr 10, 2014

how this query string will be prnted it is not showing me the psid values.

<tr bgcolor="pink" >
<td><%=resultSet.getString("FirstName") %></td>
<td><%=resultSet.getString("LastName") %></td>
<td><%=resultSet.getString("Username") %></td>
<td><%=resultSet.getString("Password") %></td>
<td><%=resultSet.getInt("Psid")%></td>
<td><a href="Edit.jsp?psid="<%=resultSet.getInt("Psid")%>>Edit</a></td>
<td><a href="Delete.jsp">Delete</a></td>
</tr>

View Replies View Related

JSP :: Sorting Query In JSTL?

Jun 21, 2006

i am doing a code using JSTL to fire a query. everything come fine except the resule is not sorted as desired. i am putting the code below--

String sort_order=(String)request.getAttribute("sort_order");
request.setAttribute("sort_order",sort_order);
<sql:query var="viewQueryj" sql= "select USER_ID, PERMISSION_ID, USER_NAME from administrator order by ?">
<sql:param value="${sort_order}"/>
</sql:query>

now the resule is always sorted by USER_ID. if i want to sort it using USER_NAME i pass parameter from controller to this page in sort_oredr variable which comes fine but the result doesn't sort by name, only by id. if i hardcode USER_NAME in query then the result is as desired.

View Replies View Related

JSP :: Insert Into Table Query

Feb 18, 2014

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] ....

View Replies View Related

Using A Database Query Result

Nov 17, 2014

I have done 90% of the coding however i am stuck with producing the output, i just cant get the user fields to show.

I have attached a picture of the output that is required. The program consists of two classes i have attached the database class, and have inserted my coding below.

import java.sql.*;
import java.io.*;
import java.util.*;
public class QueryDB {
private Connection con = null;
String userID,

[Code] ...

Attached image(s)

View Replies View Related

Java Console SQL DB Query App

Nov 4, 2014

I seem to be having a issue with my java console app what it should do is query a SQL DB and list the user details (userid, firstname ,lastname) from the user table, and the users stocks (stockname ,stockdiscription) associated to each user from the userstocks table if I'm thinking correctly!

I'm sure it is just a logical error, but I'm not sure of the way to get the out put I'm looking for. I will add the makeDB.java file and DatabaseQuery.java file as well as the current Exception(Run Time Exception) below.

**I have added other users and stocks manually - Not just what the MakeDB.java file inserts **

Output and Exception:

Stock holdings by User
User ID User Name
Stock - Description
-------------------------------------------
admin01 Default Admin
Exception in thread "main" java.sql.SQLException: ResultSet is closed
at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6647
)
at sun.jdbc.odbc.JdbcOdbcResultSet.next(JdbcOdbcResultSet.java:1248)
at DatabaseQuery.main(DatabaseQuery.java:45)
Press any key to continue . . .

Java Code:

MakeDB.java:
import java.sql.*;
import java.io.*;
public class MakeDB
{
public static void main(String[]args) throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

[Code] ....

View Replies View Related

Using Database Query Result

Nov 20, 2014

I have to get my output to show as per the image attached i am very close but not there yet. I have also attached the database where i extract my information from

/*
Program Name: QueryDBDB.java
Purpose: to build an initial database for the stocktrakcer application
*/

import java.sql.*;
import java.io.*;
import java.util.*;
public class QueryDB
{
private Connection con = null;
String userID,firstName,lastName,name,symbol;
public QueryDB() throws Exception

[Code] .....

Attached image(s)

View Replies View Related

How To Populate Jcombobox From MySQL Query

Sep 13, 2014

How could i populate jcombobox2 from MySQL depending upon the value of jcombobox1??

View Replies View Related

Stock Database Query Class

Dec 14, 2014

I have a Stock Database query class, it compiles and runs well. Thing is when i enter a user, it shows a user stock information but it repeats showing the same user in the command prompt. the repetition is so fast, you can't see the information. All i wanted was the application to show a user's info, then asks you to enter another user again and so forth. Here is the code

import java.io.*;
import java.sql.*;
import java.util.*;
public class StockDatabaseQuery {
public static void main(String[] args)throws Exception {
String userID;
String firstName;

[Code] ....

View Replies View Related

Console SQL Query App Not Working Correctly

Nov 6, 2014

My console SQL Query app is not giving me the desired output.I am sure its might have something to do with my SQL Query.Its missing the description of the stock items and it prints a new line for each user as per number of stocks an repeats the user details and then prints the stock listed by that user(only want the user listed once with all its stocks). I will add my files and current output and desired out put below.

MakeDB.java:

import java.sql.*;
import java.io.*;
public class MakeDB
{
public static void main(String[]args) throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:StockTracker";

[Code] .....

View Replies View Related

Why Constructor Cannot Be Final

Oct 27, 2014

"A constructor cannot be abstract, static, final, native, or synchronized."

I understand on why it can't be all of the above, except "final".

Why can't we have a final constructor, i understand constructors are not inherited, hence no chance/case of overriding etc. But why is it not allowed at all ?

View Replies View Related

JSP :: Assigning Session Variable In Query Syntax

Jan 9, 2015

In my JSP I need to retrieve some data from MySQL. I need to assign a "email" variable to the "WHERE" clause. The variable is retrieved from the session attribute. So far, I have this code:

<sql:query dataSource="${user}" var="result">
SELECT * from users where email = ${sessionScope.email};
</sql:query>

It doesn't work.

View Replies View Related

Query About Use Of NextLine Method Of Scanner Class

Apr 10, 2014

My code is as follows:

import java.util.Scanner;
public class GetUserInput {
public static void main (String args[]) {
int i;
float f ;
String s;

[code]....

My Query is: input.nextLine() does not wait for user input. Instead it continues execution from next line. But if I move up input.nextLine(); before both input.nextInt(); and input.nextFloat() in the above code, the execution works fine, input.nextLine(); waits for user input. edited code and output are as follows.

import java.util.Scanner;
public class GetUserInput {
public static void main (String args[]) {
int i;
float f ;
String s;

[code]....

View Replies View Related

How To Get Desired Output Layout Database Query

Jan 15, 2015

My output of my app its outputting the correct data just no the format ...

code :

DatabaseQuery.java :
import java.io.*;
import java.sql.*;
import java.util.*;
public class DatabaseQuery

[Code] ....

Current output:

Stock holdings by User

User ID User Name
Stock - Description
-------------------------------------------
admin01
Default Admin
DELL Dell Computer Corp
admin01
Default Admin
MSFT Microsoft Computer Corp

[Code] ....

Desired Output :

Stock holdings by User

User ID User Name
Stock - Description
-------------------------------------------
admin01 Default Admin
DELL Dell Computer Corp
MSFT Microsoft Computer Corp
ORCL Oracle Corp

[Code] .....

View Replies View Related

Show Count Mysql Query Into JTextField?

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

How To Store SQL Query In Tree Format In XML File

Nov 30, 2014

I want to store sql query in tree format in xml file.I wrote a code which split the code into different tokens and store it in xml file.I am storing keywords like "select",from,where etc as xmlelements and the values of these keywords as textnodes inside corresponding elements.When the query contains single single statement it works as i need.but when nested query occurs i want to store the nested query inside "where" element.In that case the code didn't works properly.I am hereby attaching the code. When i try to store the xmldata in "CreateFiles.xml" file ,the file is not displaying in the corresponding folder.what is the reason for that?

CreateXml.java
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package querywork;
import java.io.File;
import java.io.StringReader;
import java.io.StringWriter;

[Code]...

View Replies View Related

Query Embed In JAVA Returns NULL

Oct 4, 2014

I have embed a query in the JAVA to retrieve the data from the back end and I use Oracle for back end. What I'm trying to do is in my query has been shown below. The issue here is that result set returns the NULL. But fine when I change the query "SELECT 5 FROM DUAL" and it returns 5 for me which right. When I try to run the same at the back end as a query I'm getting proper result.
 
public String getReturnPart(String partNumberIn) {
//int returnPartNumber = 0;
  String query =
"SELECT COUNT(*) AS CHECK1 FROM PART_MASTER PM,UNITS_OF_MEASURE UOM WHERE PM.PART_NUMBER = '" +  partNumberIn
  + "' AND PM.UNIT_OF_ISSUE = UOM.UNIT_OF_MEASURE AND UOM.UNIT_TYPE = 0 ";
  //String query = "SELECT 5 AS CHECK1  FROM DUAL"; This returns fine as "5"
  ResultSet result = null;

[Code] ....

View Replies View Related







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