Spring Mybatis配置动态SqlSessionFactory

u010589898 2013-09-10 05:44:18
SqlMap-Config.xml
<configuration>
<mappers>
<mapper resource="/sqlMap/User.xml"/>
</mappers>
</configuration>

User.xml
<mapper namespace="cn.com.sjb.pss.business.entity.User">
<resultMap id="user" type="cn.com.sjb.pss.business.entity.User">
<result property="User_ID" column="User_ID"></result>
<result property="User_Name" column="User_Name"></result>
</resultMap>
<select id="findUserID" resultMap="user" parameterType="String">
select
User_ID as "User_ID",
User_Name as "User_Name"
from UserMaster_Table U where U.User_ID = #{User_ID}
</select>
</mapper>

User
public class User { // 用户
private String User_ID; // 员工ID
private String User_Name; // 员工名称

public String getUser_ID() {
return User_ID;
}
public void setUser_ID(String user_ID) {
User_ID = user_ID;
}
public String getUser_Name() {
return User_Name;
}
public void setUser_Name(String user_Name) {
User_Name = user_Name;
}
}

java:

BasicDataSource dataSource=new BasicDataSource();
dataSource.setDriverClassName("..");
dataSource.setUrl("..");
dataSource.setUsername("..");
dataSource.setPassword("..");
TransactionFactory transactionFactory = new JdbcTransactionFactory();
Environment environment = new Environment("development", transactionFactory, dataSource);
Configuration configuration = new Configuration(environment);
configuration.addMapper(User.class);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
SqlSession sqlSession=sqlSessionFactory.openSession();
sqlSession.selectOne("cn.com.sjb.pss.business.entity.User.findUserID", User_ID);

报错
java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for cn.com.sjb.pss.business.entity.User.findUserID

...全文
84 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

50,542

社区成员

发帖
与我相关
我的任务
社区描述
Java相关技术讨论
javaspring bootspring cloud 技术论坛(原bbs)
社区管理员
  • Java相关社区
  • 小虚竹
  • 谙忆
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧