spring ibatis mysql_spring整合ibatis和mysql出现的错误?

痛定思痛。 2023-01-12 11:59 147阅读 0赞

org.springframework.jdbc.support.MetaDataAccessException:ErrorwhileextractingDatabaseMetaData;nestedexceptionisjava.sql.SQLException:Accessdeniedforuser'root'@'localhost'...

org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Access denied for user ' root'@'localhost' (using password: YES)

at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:296)

at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:320)

at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:212)

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:141)

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.(SQLErrorCodeSQLExceptionTranslator.java:104)

at org.springframework.jdbc.support.JdbcAccessor.getExceptionTranslator(JdbcAccessor.java:99)

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)

at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)

at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:287)

at com.svse.Dao.AuserDaoimpl.selectAll(AuserDaoimpl.java:22)

at com.svse.test.text.main(text.java:24)

报了很多异常,这是第一个,求解!!!!!

我的spring配置是这样的

com/svse/properties/SqlMapConfig.properties $\{JDBC.Driver $\{JDBC.ConnectionURL\} $\{JDBC.Username\} $\{JDBC.Password\}com/svse/xml/SqlMapConfig.xml

Dao的方法

public List selectAll() \{ List list = new ArrayList();try \{list = (List)sqlMap.queryForList("selectAllAuser");\} catch (SQLException e) \{// TODO Auto-generated catch blocke.printStackTrace();

\}return list; \}

这是auser.xml

select \* from Auser

展开