不会功夫的茶的博客

<!-- 根据条件查询 -->  <select id="selectDeptRecord" resultType="com.xx.entity.job"> select * from job  <where> 1=1 <if test='Wtime!="" and Wtime!=null'> and Wtime=#{Wt

JDBC 和 Mybatis连接mysql数据库的时候，没有设置字符集编码就会导致传递过去的中文参数乱码，无效，查询没有结果。在url地址后加上?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull如下...

select * from YLXZ_PERSONinsert into YLXZ_PERSON(name) VALUES('嘘嘘')DELETE from YLXZ_PERSON where name ='嘘嘘'update YLXZ_PERSON set id=NULL//创建序列CREATE SEQUENCE PERSON_sequenceINCREMENT BY 1 -- ...

首先下载 Navicat for oracle 、 instantclient-sqlplus-nt-12.1.0.2.0 、instantclient-basic-nt-12.1.0.2.0下载地址：https://download.youkuaiyun.com/download/qq_36986305/107453021.解压 navicat, 2.把instantclient-basic-n...

数据集select "MAX"("arms_id") from IMS."arms" 结果  200原因是查询字段 arms_id 是vachar2类型，转为int型select "MAX"(cast("arms_id" as int)) from IMS."arms" 结果 10027 正确 ...