Attach a database table structure

Operation database code block


On the Internet to find some solution, a and I almost yes character is defined as a char, I later see, change in order to query the table, all the returned result set is empty,

This is the data inside the


Bosses to reassure, thank!!!!!!!!!!

CodePudding user response:

Under debugging, see if there are any into circulation

CodePudding user response:

Sure use up sqlplus and their connection procedure is the same server, and use the same account, under normal circumstances is not likely to appear this kind of problem,

CodePudding user response:

First take a look at the oracle field names are case sensitive, look at the username and password you pass into the method exists in the table

CodePudding user response:

Without exception interrupt point debugging, but the tracking to see where the line of code problems step by step,

CodePudding user response:

Rs. Get string () instead of rs. GetObject () give it a try

CodePudding user response:

Rs. Get string (), rs. Get int () method, point check source code, which parameter is the column index, is not like you to follow the column name,

CodePudding user response:

Breaking point debugging, see if there are in circulation, where there is empty,

CodePudding user response:

Code can't see the problem, can only like upstairs said breaking point debugging, or have a look at whether the case-sensitive (default is not to distinguish),
But this kind of practice in performance has a problem, if there are millions of data, you such traversal is estimated to run one day, suggest you change the SQL to:
Select * from the userbean where username=? And password=?