How to get value from database in JAVA program from a specific row and column?

Question

I am making a JAVA program where I have placed some values in a database with a table new_table. It has columns: Username, Password, and Name.

I am taking input from the user for a username and password through the console and check if it matches a row in the table.

Statement st=Myconn.createStatement();

ResultSet rs=st.executeQuery("select * from new_table");

String getusnm=rs.getString("username")

String get pswd=rs.getString("password");

The next thing is, I want to display the name of the users from the table if the username and password match. So, how do I get the name of the user using the same result set as a String?

I used:

String getname=rs.getString("name","where usnm = user"); // user is the String inputted from the console

but it doesn't seem to work.

Kindly help me out with this.

Thanks.

Also have a look at en.wikipedia.org/wiki/Java_Persistence_API and en.wikipedia.org/wiki/Bcrypt — classeswilldullyourmind
– classeswilldullyourmind, Commented Mar 20, 2020 at 7:44

Tim Biegeleisen · Accepted Answer · 2020-03-20 07:44:19Z

2

You should be using a WHERE clause in your SQL query which restricts by username and password:

String sql = "SELECT * FROM new_table WHERE usnm = ? AND pass = ?";
PreparedStatement st = conn.prepareStatement(sql);
st.setString(1, username);
st.setString(2, password);
ResultSet rs = st.executeQuery();
if (rs.next()) {
    String username = re.getString("usnm");
}

Note that in general it is bad practice to store clear text passwords in your database table. More typically, you would be hashing incoming passwords before inserting them. Then, to verify an incoming user password, you would also hash it, and then compare the two hashes.

answered Mar 20, 2020 at 7:44

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jyotirmay Over a year ago

Is the string in "sql" case sensitive?

Tim Biegeleisen Over a year ago

If you're asking if it matters whether you use SELECT, select, or maybe SeLeCt, no, it doesn't matter.

Collectives™ on Stack Overflow

How to get value from database in JAVA program from a specific row and column?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related