I can not use java.sql.date in java program correctly, it seems like there are some problems at the result set

Question

 String content = "SELECT * FROM " + "floor" + floor + " WHERE Roomnumber ='" + roomresult + "'";
                System.out.println("next query->" + content);
                statement.execute(content);
                ResultSet rs = statement.getResultSet();

Date u = rs.getDate("CheckIn");

I want to transform the java.sql.date into java.util.date. I think the final sentence is correct , but the java told me that there is a NullPointerExceptio

PLEASE read this: SQL Injection and How to Prevent It?. What you're doing is extremely unsafe and is a security flaw in your application. — Lino
– Lino, Commented May 11, 2020 at 9:49
also you probably wanted to use statement.executeQuery(content), else you won't have a result — Lino
– Lino, Commented May 11, 2020 at 9:51
You shouldn't be using java.util.Date anyway. Even if you had to load a java.sql.Date from the database, it's best to convert it to the appropriate class from java.time. It's also possible to get the value as the appropriate type using getObject in most modern JDBC drivers. — RealSkeptic
– RealSkeptic, Commented May 11, 2020 at 9:56
So what is the exactly data type i should use to represent the data from database — Eyyt Cghh
– Eyyt Cghh, Commented May 11, 2020 at 10:15
You can take the reference from here : stackoverflow.com/questions/22784523/… — Nitika Bansal
– Nitika Bansal, Commented May 11, 2020 at 10:17

rui.zhang · Accepted Answer · 2020-05-11 09:52:38Z

-2

if u want convert java.sql.date to java.util.date, use :

new java.util.Date(rs.getDate("CheckIn").getTime())

NullPointerException , may be CheckIn cloum not exist, or it be null;

pleas make sure CehckIn field exist and is not be null;

answered May 11, 2020 at 9:52

rui.zhang

292 bronze badges

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

Collectives™ on Stack Overflow

I can not use java.sql.date in java program correctly, it seems like there are some problems at the result set

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related