摘要: UserMapper.xml <select id="getUserbyName" parameterType="String" resultType="user"> select * from mybatis.user where name like #{username} </select> U 阅读全文
posted @ 2022-05-25 20:30 qiaoyizhi 阅读(10) 评论(0) 推荐(0) 编辑
摘要: mybatis-config.xml <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd 阅读全文
posted @ 2022-05-25 19:30 qiaoyizhi 阅读(34) 评论(0) 推荐(0) 编辑
摘要: 创建数据库 mysql创建user表 CREATE TABLE `user` ( `id` int(32) NOT NULL COMMENT 'id\r\n', `name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NUL 阅读全文
posted @ 2022-05-23 23:19 qiaoyizhi 阅读(72) 评论(0) 推荐(0) 编辑
摘要: CREATE OR REPLACE FUNCTION FN_GETPY(p_str IN VARCHAR2, p_flag NUMBER DEFAULT NULL) RETURN VARCHAR2 AS v_compare VARCHAR2(4); v_return VARCHAR2(4000); 阅读全文
posted @ 2022-05-18 16:54 qiaoyizhi 阅读(34) 评论(0) 推荐(0) 编辑