ibatis can t query the data, the database does, and SQL can find out

resultmap="loginuser"Wrong should be resultmap="user"There is also such a write,The SQL that is tracked out is in the form of a stored procedure,Compare egg pain,select userid, username, password from t user where username= username and password= password Personally like select userid, username, password from t user where username=‘$username$' and password=‘$password$'

In the case of mysql, it may be a problem with the character set. Check out the database link configuration? Inside.

Generally accommodating.

I encountered this problem with the same problem, it has been solved, mine is because this statement has been changed before the ** record has been changed, so the same sql two places can not be found in one can not be found, it is recommended to check the previous ** carefully.

What is PARS, and is your data source oracle's?

Yes, it should be JDBC connection character set reason does not correspond to mysql character set, Chinese problem.

It is possible that the JDBC driver does not support this kind of SQL script.

I've encountered it before, and it's the configuration file after mysql installation to specify the encoding format.

mysqld]

character-set-server=utf8 and restart mysql.

The pre-code of this question is: suppose there are two tables of the same structure in a, and b; In addition, if you say "the priority output data in Table B and Table A are data in the same block of data", it is assumed that the conditions of the determined data are the same. col_1 =

If the above conditions are met, try the following statement:

Select *from B, where (select Col 1 from B) late picking.

All of the Alliance.

Select *There is no from A (select Col 1 from B).

Hope it helps :)

You post the method you wrote that calls this SQL statement, I guess it's parameterclass="user"Question: You use the user model for the parameter class here, but when you call it, is it the model type? Maybe you gave a hashmap. You check and see.

object1 in is not the corresponding parameterclass="object1"It's an alias, and object1 needs to redefine the receive type additionally.

That's fine, and if you use a namespace, remember to set it in the configuration file.

list list = (list) "", object1);

Is the name wrong?。。。 Missing a t?

listlist = (list) "", object1);

So what?

I'm more depressed than you, I found out that there are two records in the list, but I can't read them. The result is 2

Yes, this kind of problem, in fact, lz, you can just write a test method and try it, and you will know it.

if exists select from where id object_id(n'[dbo].[Your table name].')and objectproperty(id, n'isusertable') 1)

drop table dbo].[Your table name].'Heh, delete it.

It may be that the database data character set and the connection dataset do not match.

There is a problem with the SQL writing, send it out and take a look.