|
i am so new to java as well as to netbeans and sql.
do i write my query like this?
ResultSet resultSet = statement.executeQuery("SELECT COUNT(INCIDENTID) FROM INCIDENTDATA");
care to explain more about the purge process?
|
|
|
|
|
Sorry but I'm not an SQL or database expert; like I said you need to check your documentation. I find it difficult to see how you can be writing a Database application if you do not understand the basics.
I must get a clever new signature for 2011.
|
|
|
|
|
Post some code snippets, otherwise it's very hard for us to guess what's working what's not.
--
Arman
|
|
|
|
|
try{
Connection con = DriverManager.getConnection( );------------------------> Not sure what to include here.
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT INCIDENTID FROM INCIDENTDATA");
ArrayList allResults = new ArrayList();
while (rs.next()) {
int incidentID = rs.getInt("INCIDENTID");
allResults.add(incidentID);
}
}
catch (Exception ex) {
log("ErrorDescription", ex);
error(ex.getMessage());
}
My code are as shown above.
i am unsure of how to make use of sql to check/compare values in the table and with the values the user keyed into the textboxes.
|
|
|
|
|
I really think you should do some serious Database/SQL study before attempting to go any further with this project or you are likely to get into serious difficulties. Take a look at the tutorials here[^] for a good starter.
I must get a clever new signature for 2011.
|
|
|
|
|
I'm not sure what you mean "... check/compare values in the table and with the values the user keyed into the textboxes."
But I guess you need to get the value from the textbox and write your sql like so:
String myKey = myTextBox.getText();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT INCIDENTID FROM INCIDENTDATA WHERE PERSONNAME = '" + myKey + "'");
--
Arman
|
|
|
|
|
Arman S. wrote:
ResultSet rs = stmt.executeQuery("SELECT INCIDENTID FROM INCIDENTDATA WHERE PERSONNAME = '" + myKey + "'");
Please do not encourage people to use constructs that allow for SQL injection; it is almost guaranteed to compromise their entire system.
I must get a clever new signature for 2011.
|
|
|
|
|
lol, the OP should first realize the existence of such a construct and then understand it's disadvantages.
Thanks!
--
Arman
|
|
|
|
|
Arman S. wrote: the OP should first realize the existence of such a construct and then understand it's disadvantages.
Not quite; we are supposed to be helping people to learn. Your answer offers the OP the chance to make a big mistake, without advising how to avoid it.
I must get a clever new signature for 2011.
|
|
|
|
|
Agreed - generally speaking. But not quite, for this concrete situation.
If it were so, why wouldn't you go ahead and explain the whole theory behind secure Web development to the OP?
Common sense tells me, that you (and I) didn't do it as:
* We are not sure if it will solve a bit of OP's problem
* We are not sure if OP is even doing e.g. Web
* We are not sure if the proposed solution above (by myself) even targets the right problem (because of poor explanation of the problem)
My belief is that for beginners (assuming OP is) what matters most is the tangible result, something they can see and the feeling that something is working.
--
Arman
|
|
|
|
|
Arman S. wrote: Agreed - generally speaking. But not quite, for this concrete situation.
If it were so, why wouldn't you go ahead and explain the whole theory behind secure Web development to the OP?
Common sense tells me, that you (and I) didn't do it as:
* We are not sure if it will solve a bit of OP's problem
* We are not sure if OP is even doing e.g. Web
* We are not sure if the proposed solution above (by myself) even targets the right problem (because of poor explanation of the problem)
My belief is that for beginners (assuming OP is) what matters most is the tangible result, something they can see and the feeling that something is working.
Which would matter only if any of that is relevant.
One uses parameters (bind variables) in SQL because it prevents injection attacks AND because it correctly deals with other issues in correctly constructing SQL. And this applies to any programming language that supports such usage.
There are very few cases where one should be using string concatenation without using parameters. Even when concatenation is used in constructing SQL, such as with variable list productions, parameter usage is still better.
So you are presenting a technique that one should almost never use.
Your rationalizations do not change that.
And by the way SQL injection attacks are not something that are only relevant in Web apps.
|
|
|
|
|
Arman S. wrote: My belief is that for beginners (assuming OP is) what matters most is the tangible result, something they can see and the feeling that something is working.
And in your case working wrongly. There are already far too many examples of questions from people who obviously do not understand the dangers inherent in using this sort of construct, and you are just teaching one more programmer to do it the wrong way. You better hope that you do not fall foul of any product developed by this guy.
I must get a clever new signature for 2011.
|
|
|
|
|
i have change my code slightly.
Code as shown below:
String dbURL = "jdbc:derby:....";
String myString = (String) getIncidentidtxt().getValue();
Integer incidentIDName = Integer.parseInt(myString);
String incidentNameName = (String)getIncidentnametxt().getValue();
try{
Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
Connection con = DriverManager.getConnection(dbURL);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT INCIDENTID FROM INCIDENTDATA");
ArrayList allResults = new ArrayList();
while (rs.next()) {
int instanceID = rs.getInt("INCIDENTID");
allResults.add(instanceID);
int arrayCount = allResults.size();
label3.setValue(arrayCount);
for(Integer i =0; i<allResults.size(); i++)
{
if(myString.equals(allResults.get(i))){
}
}
}
}
catch (Exception ex) {
log("ErrorDescription", ex);
error(ex.getMessage());
}
But i have no idea if i did this correctly. what shld i do now to proceed on?
the main purpose of this is to compare the values in the textboxes with the database (displayed on a table).
btw i am using betneans..
http://img263.imageshack.us/img263/3673/arraysofvalues.png[^]
the image u see above is the array that i have created to store the incidentID values. how do i bases on this array to validation entry to the database? Like example the database alrdy have the id 3 when user enter 3 into the id textbox, an error message will appears?
modified on Monday, January 10, 2011 3:39 AM
|
|
|
|
|
How efficient would this code be if you have 1,000,000 records? Not very, I suspect. Instead of selecting all records in your database and comparing against the id entered by the user, do it the other way round. Select only the record with the id entered; if it does not exist you will get a failure. You should always try and design your system to take the shortest path to a solution. As I have stated a number of times in this thread, try and spend some time studying database and SQL, it will pay dividends in the long run.
I must get a clever new signature for 2011.
|
|
|
|
|
i very much want to spend time studying after all is for my own good, however i am rushing out this. I have made some changes to the code again as shown:
String incidentString = (String) getIncidentidtxt().getValue();
String incidentNameName = (String)getIncidentenametxt().getValue();
try{
Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
Connection con = DriverManager.getConnection(dbURL);
stmt = con.createStatement();
if(incidenteidtxt != null){
rs = stmt.executeQuery("Select INCIDENTID from INCIDENTDATA");
while(rs.next()){
id = rs.getString("INCIDENTID");
String idtxt = id.toString();
if(incidentString != idtxt){
getSessionBean1().updateIncident(incidentString, incidentNameName);
}
else{
incidentidtxt.setRequiredMessage("Id valid, enter new Id.");
}
}
}
}
catch (Exception ex) {
log("ErrorDescription", ex);
error(ex.getMessage());
}
however when i run the program, instead of adding one value when the add button is being clicked, it will add 20 over values. why is this so? hope to hear from you all soon.
|
|
|
|
|
pancakeleh wrote: however i am rushing out this.
That is a sure recipe for disaster.
You have the following statement within your try block, after you have opened your connection to the database.
if(incidenteidtxt != null){
I would assume that if the value is null there is no point in accessing your database, so you should make this test earlier.
Other than that I cannot quite figure out what your code is doing, although it looks like you are reading the database in sequence, and every time you see a record that does not match the incident id, you call your updateIncident method to do something.
I must get a clever new signature for 2011.
|
|
|
|
|
i have further change my code as shown below:
try{
Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
Connection con = DriverManager.getConnection(dbURL);
stmt = con.createStatement();
if(incidentidtxt != null){
id = rs.getInt(1);
if( id == 0){
getSessionBean1().updateIncident(incidentId, instanceName);
}
else{
Integer newIncidentID = incidentId + 1;
getSessionBean1().updateIncident(newIncidentID, instanceName);
}
}
}
catch (Exception ex) {
log("ErrorDescription", ex);
error(ex.getMessage());
}
return null;
}
|
|
|
|
|
pancakeleh wrote:
if(incidentidtxt != null){
1. You still have this test within your try catch block, you should be doing it outside as there is no point entering this block of code if incidentidtxt has a null value.
2. your executeQuery command is commented out; is this what you meant to do?
2a. adding database parameters by string concatenation in this way is extremely dangerous, and leaves your application open to SQL Injection problems: Google it and learn how to avoid it.
3. I am no longer certain what you are actually trying to do here or what your problem is.
I must get a clever new signature for 2011.
|
|
|
|
|
Need urgent help in assignment of JAVA, any idea suggestion plz
I need help in my JAVA assignment plz. kindly guide me any technique/idea to do the following. m not at advance level of programming. i already have the initial part of my assignment completed which is to make a simple command line calculator. this is the next part.
The program should take function definitions and those definitions can be used in future expressions
for eg:
def add(x,y)=(x+y)
>>> ok
def inv(x)=1/x
>>> ok
inv(add(2,2))
>>> ans : 0.25
Also four additional commands:
show; to prints all de?nitions on screen
save flename; to save all defnitions in a fle
load flename; to load all definitions from a fle
delete funname; to delete the defnition corresponding to the function named funname
|
|
|
|
|
See here[^] for information on how to write Java programs. Please do not expect other people to write your assignment for you, unless you are prepared to pay royalties from your future earnings.
Just say 'NO' to evaluated arguments for diadic functions! Ash
|
|
|
|
|
I'm a little confused. You say this is a Java assignment, but the example you have posted looks more like Python to me, not Java. Am I missing something?
|
|
|
|
|
no, this is a JAVA assignment.
|
|
|
|
|
So the assignment is to rewrite the Python example in Java, is that right?
|
|
|
|
|
bro, no we dont know any python. but htis is our assignment in java only.
|
|
|
|
|
aesthetic.crazy wrote: I need help in my JAVA assignment plz. kindly guide me any technique/idea to do the following
You need the following parts
1. Something to read the input that the user types.
2. Something to parse each line into a command and OPTIONAL values since some commands do not have values.
3. Something to process EACH command. Write a method for each command.
4. AFTER you have the above parts and you have TESTED them, then you put them together to create the final program.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
