iBatis做模糊查询时,报如下错误,不知道各位有没遇到过?如何处理?
错误:
com.ibatis.common.beans.ProbeException: There is no READABLE property named 'userName' in class 'java.lang.String'
at com.ibatis.common.beans.ClassInfo.getGetter(ClassInfo.java:259)
at com.ibatis.common.beans.ComplexBeanProbe.getProperty(ComplexBeanProbe.java:304)
at com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:199)
at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:74)
SQL为:
<!-- 用户名模糊查询 -->
<select id="getUserByName" resultMap="UserResult" parameterClass="String" resultClass="List" cacheModel="user-cache">
select A.userId,
A.userName,
A.companyId,
A.userBH,
A.userPassword,
A.userFunction,
B.companyName,
A.createUser,
A.createDate,
A.updateUser,
A.updateDate
from userTable A left outer join company B on A.companyId=B.companyId
<dynamic prepend="where">
<isNotEmpty prepend="and" property="userName">
userName like '%$userName$%'
</isNotEmpty>
</dynamic>
</select>
分享到:
相关推荐
标题中的"PyPI 官网下载 | xontrib-readable-traceback-0.2.4.tar.gz"指的是一款在Python Package Index (PyPI) 官网上发布的开源软件包。PyPI是Python开发者发布和分享自己编写的Python库、模块和工具的平台,方便...
The book starts with an explanation of what reactive programming is, why it is so appealing, and how we can integrate it in to Java. It continues by introducing the new Java 8 syntax features, such as...
"jQuery-Plugin-For-Easily-Readable-JSON-Data-Viewer.zip" 是一个专门用于解决这个问题的jQuery插件。jQuery是一个流行的JavaScript库,它简化了HTML文档遍历、事件处理、动画设计和Ajax交互。这个插件利用jQuery...
- **The C# String Type**: The `string` type in C# represents sequences of characters. This section covers operations like concatenation, comparison, and manipulation. - **The StringBuilder Class**: ...
/// This is default constructor of the EXIF class. /// public EXIF() { } /// /// This is base constructor of the EXIF class. /// public EXIF(string filePath) { _picture = Image.From...
严重: Error starting static Resources java.lang.IllegalArgumentException: Document base D:/Program Files/Apache SoftwareFoundation/Tomcat 5.0/webapps/tomcat-docs does not exist or is not a readable ...
} else if (key.isReadable()) { // 读取数据 SocketChannel socketChannel = (SocketChannel) key.channel(); ByteBuffer buffer = ByteBuffer.allocate(1024); int read = socketChannel.read(buffer); if ...
除了基本的读取操作,`Resource`还支持其他方法,如`exists()`检查资源是否存在,`isReadable()`判断是否可读,`getURI()`获取资源的URI,`getFileName()`获取文件名等,这些都是在处理资源时可能用到的功能。...
because the Groovy syntax is light and readable but still resembles that of Java. For interacting with XML payloads, web services, or databases, Groovy provides handy and elegant wrappers around the ...
Java 17, released in September 2021, is a long-term support (LTS) version of Java, which means it will receive updates and support for a longer period compared to non-LTS versions. This makes Java 17 ...
// First make sure the source file exists, is a file, and is readable. if (!from_file.exists()) abort("no such source file: " + from_name); if (!from_file.isFile()) abort("can't copy directory: ...
“I taught a CS2 Data Structures class in D with more success and student appreciation than when using either C++ or Java as it's an ideal language to express the relevant concepts at all scales, from...
Java NIO(New Input/Output)是从JDK 1.4版本开始引入的一个新IO API,它提供了不同于传统Java IO的I/O操作方式,尤其是支持非阻塞IO,这使得Java程序员能够构建高性能、可扩展的服务架构。传统的Java IO基于流模型...
官方离线安装包,测试可用。使用rpm -ivh [rpm完整包名] 进行安装
官方离线安装包,测试可用。使用rpm -ivh [rpm完整包名] 进行安装
官方离线安装包,测试可用。使用rpm -ivh [rpm完整包名] 进行安装
在Java编程中,Socket是网络通信的基础,它允许两个网络应用程序之间进行数据交换。本示例将详细解析如何使用Java的非阻塞I/O(NIO)实现Socket通信,包括客户端发送消息和服务器端接收消息的过程。 首先,理解NIO...
public boolean query(String userName,String userPsd) { Connection conn=null; PreparedStatement psm=null; ResultSet rs=null; String sql="select * from user_manager where name=? and psd=?";...
这是一个终端操作日志,如果你电脑安装了黑苹果Mac Big Sur,是否有遇到电脑疯了似的刷屏,比如disk3s5s1:device is not readable,直到满屏幕都是,它还不肯罢休。等你查完磁盘路径,发现正是新安装的系统磁盘。...