• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

login in java

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
:(
 
Marshal
Posts: 28177
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Yuri, welcome to the Ranch!

You're going to need a better question than "please help". Just posting the code tells us nothing about what your problem is. Could I suggest that you read our FAQ entry ItDoesntWorkIsUseless (<-- click on that link) and, based on what you read there, post a description of your problem?
 
Saloon Keeper
Posts: 27752
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
username: "fred"
password: "gotcha; select * from password;delete user"
 
Sheriff
Posts: 11604
178
Hibernate jQuery Eclipse IDE Spring MySQL Database AngularJS Tomcat Server Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi yuri tan,

First of all, a warm welcome to CodeRanch!

yuri tan wrote: :(


That's not how you should ask a question on a forum! The more information you provide, the easier it is for people to answer your questions (and the more useful the answers will be). You should always TellTheDetails. And here you'll find how you should ask questions on CodeRanch.

Based on the code snippet you have posted, I can already provide 2 remarks:
1/ you should always use prepared statements wherever possible to avoid SQL injection attacks (like Tim's post illustrates). You can find more info on SQL injection here and on prepared statements here.
2/ there's an error in the WHERE clause: to combine different conditions you should use AND or OR, not a comma. So it should beAs you can see, I've already introduced the appropriate syntax to use a prepared statement :)

Hope it helps!
Kind regards,
Roel
 
yuri tan
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
im sorry sir btw thanks for the response.i already delete that code that i post early i made a new one can you please help me?
java.jpg
[Thumbnail for java.jpg]
 
Roel De Nijs
Sheriff
Posts: 11604
178
Hibernate jQuery Eclipse IDE Spring MySQL Database AngularJS Tomcat Server Chrome Java
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

yuri tan wrote:can you please help me?


That's very hard to do if you don't TellTheDetails. You don't provide any stack trace of a possible exception or explain the problem/issue you are having. It's the second time in this topic that you are asked to do so. You can't expect that people will try to execute your code to see what's wrong. Next time such a question will probably be left unanswered! Luckily for you, it's a pretty obvious error (which is easy to fix too )

You are executing this querySo your result set (rows returned by this query) will contain only the column password. The statementtries to get the value for the column username, but this column does not exist in the result set. That's why you get the "column not found" exception.

And please update your code to use prepared statements to avoid SQL injection (as mentioned in my previous post as well).

Hope it helps!
Kind regards,
Roel
 
If we don't do the shopping, we won't have anything for dinner. And I've invited this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic