1.连接数据库,先找database.properties文件,看连接信息。
2.数据库21开头的是正式库,142开头的是测试库。
3.oracle中语句大写效率比小写效率高,小写的话会首先转换成大写。
4.oracle In查询
5.关于 List<Map<String, Object>>取值的问题
6.控制台报错
org.hibernate.QueryException: Space is not allowed after parameter prefix ':' [SELECT * FROM YKD_SPJG WHERE ID=(SELECT MAX(SP.ID) FROM YKD_SPJG SP WHERE SP.DKID =: ID) ]
解决方法:
<sql>
<![CDATA[
SELECT * FROM YKD_SPJG
WHERE ID=(SELECT MAX(SP.ID) FROM YKD_SPJG SP
WHERE SP.DKID =:ID)
]]>
</sql>
[WARN]2020-06-02 14:47:15:775, org.springframework.web.servlet.mvc.support.DefaultHandlerExceptionResolver[407], Failed to write HTTP message: org.springframework.http.converter.HttpMessageNotWritableException: Could not write JSON document: No serializer found for class oracle.jdbc.driver.OracleClobReader and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS)