myBatis模糊查询 <![CDATA[ and LOCATE(#{name}, p.name) > 0]]> 不同的数字对应不同的值 CASE pro.sale_state WHEN 0 THEN '未销售' WHEN 1 THEN '销售中' WHEN 2 THEN '销售完成' END AS sale_state_Str, 数据库连接池Python常用写法 默认系统时间 CURRENT_TIMESTAMP Sql拼接(Jfinal) sqlExcept.append(" AND DATE_FORMAT(products.createdTime,'%m-%d-%Y') " + " BETWEEN DATE_FORMAT(?,'%m-%d-%Y') AND DATE_FORMAT(?,'%m-%d-%Y') "); 创建触发器 CREATE PROCEDURE test () 查询数据库位置 select @@basedir As basePath from dual 编码 ALTER TABLE gong_ying CONVERT TO CHARACTER SET utf8mb4;