Java query SQLServer encountered a problem: the object name is invalid.

cm200red

I used a Statement to query SQLServer, there was no problem connecting to the database, and there was no problem querying the system tables in the database, but when I query the table "userInfo" I created, an exception popped up: "The object name 'userInfo' is invalid". Masters, what is going on? ?

阿迪雅

If select * from sysobjects succeeds, it means everything is ok
If there is no problem above, please carefully check whether your database has userInfo table

阿迪雅

Try running it in the query analyzer

cm200red

Query analyzer can be run.

In the program, I use the prepared statement PreparedStatement:
String Query="SELECT id from userInfo where name=? and password=?";
PreparedStatement preStat=conn.prepareStatement(Query);

Will it be related to prepared sentences?

cm200red

I tried it, the following SQL statement can be run in the query analyzer:
SELECT id from userInfo where name='www'and password='000000'

However, when copied to the JAVA program and queried, an error that the object is invalid appears.

cm200red

Still don't know why.
Waiting for someone to resolve it.

digicam

Try to change to direct query

阿迪雅

Execute in JDBC:
SELECT filename FROM sysfiles1
Print out the filename, the database is definitely not the one you want to connect to

cm200red

Now I check the pubs table: SELECT filename FROM sysfiles1
The printed result is:
D:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf
D:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf

What's the matter?

sunzoutao

You choose the default library, not the library where your table is located