- \n
- properties\uff08\u5c5e\u6027\uff09<\/a><\/li>\n
- settings\uff08\u8bbe\u7f6e\uff09<\/a><\/li>\n
- typeAliases\uff08\u7c7b\u578b\u522b\u540d\uff09<\/a><\/li>\n
- typeHandlers\uff08\u7c7b\u578b\u5904\u7406\u5668\uff09<\/a><\/li>\n
- objectFactory\uff08\u5bf9\u8c61\u5de5\u5382\uff09<\/a><\/li>\n
- plugins\uff08\u63d2\u4ef6\uff09<\/a><\/li>\n
- environments\uff08\u73af\u5883\u914d\u7f6e\uff09<\/a><\/li>\n
- environment\uff08\u73af\u5883\u53d8\u91cf\uff09\n
- \n
- transactionManager\uff08\u4e8b\u52a1\u7ba1\u7406\u5668\uff09<\/li>\n
- dataSource\uff08\u6570\u636e\u6e90\uff09<\/li>\n<\/ul>\n<\/li>\n
- databaseIdProvider\uff08\u6570\u636e\u5e93\u5382\u5546\u6807\u8bc6\uff09<\/a><\/li>\n
- mappers\uff08\u6620\u5c04\u5668\uff09<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
2\u3001\u6211\u4eec\u8fd9\u91cc\u8bbe\u7f6e\u65e5\u5fd7\u3002\u4f7f\u7528setting\u6807\u7b7e\u8bbe\u7f6e<\/p>\n
3\u3001\u5982\u56fe<\/p>\n
![\"image-20240113152135218\"](\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\")
<\/div><\/p>\n4\u3001\u5b9e\u6218\u914d\u7f6e<\/p>\n
<?xml version="1.0" encoding="UTF-8" ?>\n<!DOCTYPE configuration\n PUBLIC "-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN"\n "http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd">\n<configuration>\n<!-- \u8ba9mybatis\u5f00\u542f\u65e5\u5fd7\u8f93\u51fa-->\n <settings>\n<!-- \u8fd9\u91cc\u8bbe\u7f6e\u7684\u662f\u9009\u62e9\u7528system\u8fdb\u884c\u65e5\u5fd7\u8f93\u51fa-->\n <setting name="logImpl" value="STDOUT_LOGGING"\/>\n <\/settings>\n\n <!-- environments\u8868\u793a\u914d\u7f6eMybatis\u7684\u5f00\u53d1\u73af\u5883\uff0c\u53ef\u4ee5\u914d\u7f6e\u591a\u4e2a\u73af\u5883\uff0c\u5728\u4f17\u591a\u5177\u4f53\u73af\u5883\u4e2d\uff0c\u4f7f\u7528default\u5c5e\u6027\u6307\u5b9a\u5b9e\u9645\u8fd0\u884c\u65f6\u4f7f\u7528\u7684\u73af\u5883\u3002default\u5c5e\u6027\u7684\u53d6\u503c\u662fenvironment\u6807\u7b7e\u7684id\u5c5e\u6027\u7684\u503c\u3002 -->\n <environments default="development">\n <!-- environment\u8868\u793a\u914d\u7f6eMybatis\u7684\u4e00\u4e2a\u5177\u4f53\u7684\u73af\u5883 -->\n <environment id="development">\n <!-- Mybatis\u7684\u5185\u7f6e\u7684\u4e8b\u52a1\u7ba1\u7406\u5668 -->\n <transactionManager type="JDBC"\/>\n <!-- \u914d\u7f6e\u6570\u636e\u6e90 -->\n <dataSource type="POOLED">\n <!-- \u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u7684\u5177\u4f53\u4fe1\u606f -->\n <property name="driver" value="com.mysql.cj.jdbc.Driver"\/>\n <property name="url" value="jdbc:mysql:\/\/localhost:3306\/mybatis-example"\/>\n <property name="username" value="root"\/>\n <property name="password" value="root"\/>\n <\/dataSource>\n <\/environment>\n <\/environments>\n\n <mappers>\n <!-- Mapper\u6ce8\u518c\uff1a\u6307\u5b9aMybatis\u6620\u5c04\u6587\u4ef6\u7684\u5177\u4f53\u4f4d\u7f6e -->\n <!-- mapper\u6807\u7b7e\uff1a\u914d\u7f6e\u4e00\u4e2a\u5177\u4f53\u7684Mapper\u6620\u5c04\u6587\u4ef6 -->\n <!-- resource\u5c5e\u6027\uff1a\u6307\u5b9aMapper\u6620\u5c04\u6587\u4ef6\u7684\u5b9e\u9645\u5b58\u50a8\u4f4d\u7f6e\uff0c\u8fd9\u91cc\u9700\u8981\u4f7f\u7528\u4e00\u4e2a\u4ee5\u7c7b\u8def\u5f84\u6839\u76ee\u5f55\u4e3a\u57fa\u51c6\u7684\u76f8\u5bf9\u8def\u5f84 -->\n <!-- \u5bf9Maven\u5de5\u7a0b\u7684\u76ee\u5f55\u7ed3\u6784\u6765\u8bf4\uff0cresources\u76ee\u5f55\u4e0b\u7684\u5185\u5bb9\u4f1a\u76f4\u63a5\u653e\u5165\u7c7b\u8def\u5f84\uff0c\u6240\u4ee5\u8fd9\u91cc\u6211\u4eec\u53ef\u4ee5\u4ee5resources\u76ee\u5f55\u4e3a\u57fa\u51c6 -->\n <mapper resource="mappers\/EmployeeMapper.xml"\/>\n <\/mappers>\n\n<\/configuration><\/code><\/pre>\n2\u3001\u4e24\u79cd\u5f62\u5f0f\u4f20\u53c2\u5f62\u5f0f<\/h2>\n
1\u3001${}<\/h3>\n
1\u3001\u8fd9\u4e2a\u5e95\u5c42\u662f\u5b57\u7b26\u4e32\u7684\u62fc\u63a5<\/p>\n
1\u3001\u7f3a\u70b9<\/h4>\n
1\u3001\u5bb9\u6613\u4ea7\u751fsql\u6ce8\u5165\u653b\u51fb<\/p>\n
2\u3001\u4f18\u70b9<\/h4>\n
1\u3001\u4e00\u822c\u7528\u6765\u5199\u5bb9\u5668\u540d\uff08\u8868\u5934\u3001\u5217\u540d\u3001\u6807\u7b7e\u3001sql\u5173\u952e\u5b57\u5565\u7684\uff09<\/p>\n
2\u3001#{}<\/h3>\n
1\u3001\u5e95\u5c42\u662f\u4f7f\u7528\u5360\u4f4d\u7b26\uff1f<\/p>\n
2\u3001\u4f18\u70b9<\/h4>\n
1\u3001\u53ef\u4ee5\u9632\u6b62sql\u653b\u51fb\u6ce8\u5165<\/p>\n
2\u3001\u80fd\u7528#{}\u5c31\u4e0d\u8981\u53bb\u7528${}<\/p>\n
3\u3001\u6570\u636e\u8f93\u5165<\/h2>\n
1\u3001mybatis\u603b\u4f53\u673a\u5236\u6982\u62ec<\/h3>\n
1\u3001\u5982\u56fe<\/p>\n
<\/div><\/p>\n2\u3001\u6982\u5ff5\u8bf4\u660e<\/h3>\n
\u8fd9\u91cc\u6570\u636e\u8f93\u5165\u5177\u4f53\u662f\u6307\u4e0a\u5c42\u65b9\u6cd5\uff08\u4f8b\u5982Service\u65b9\u6cd5\uff09\u8c03\u7528Mapper\u63a5\u53e3\u65f6\uff0c\u6570\u636e\u4f20\u5165\u7684\u5f62\u5f0f\u3002<\/p>\n
- \n
- \u7b80\u5355\u7c7b\u578b\uff1a\u53ea\u5305\u542b\u4e00\u4e2a\u503c\u7684\u6570\u636e\u7c7b\u578b\n
- \n
- \u57fa\u672c\u6570\u636e\u7c7b\u578b\uff1aint\u3001byte\u3001short\u3001double\u3001\u2026\u2026<\/li>\n
- \u57fa\u672c\u6570\u636e\u7c7b\u578b\u7684\u5305\u88c5\u7c7b\u578b\uff1aInteger\u3001Character\u3001Double\u3001\u2026\u2026<\/li>\n
- \u5b57\u7b26\u4e32\u7c7b\u578b\uff1aString<\/li>\n<\/ul>\n<\/li>\n
- \u590d\u6742\u7c7b\u578b\uff1a\u5305\u542b\u591a\u4e2a\u503c\u7684\u6570\u636e\u7c7b\u578b\n
- \n
- \u5b9e\u4f53\u7c7b\u7c7b\u578b\uff1aEmployee\u3001Department\u3001\u2026\u2026<\/li>\n
- \u96c6\u5408\u7c7b\u578b\uff1aList\u3001Set\u3001Map\u3001\u2026\u2026<\/li>\n
- \u6570\u7ec4\u7c7b\u578b\uff1aint[]\u3001String[]\u3001\u2026\u2026<\/li>\n
- \u590d\u5408\u7c7b\u578b\uff1aList
\u3001\u5b9e\u4f53\u7c7b\u4e2d\u5305\u542b\u96c6\u5408\u2026\u2026<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n 3\u3001\u5355\u4e2a\u7b80\u5355\u7c7b\u578b\u53c2\u6570<\/h3>\n
1\u3001Mapper\u62bd\u8c61\u65b9\u6cd5<\/p>\n
int deleteById(Integer id);<\/code><\/pre>\n2\u3001Sql\u8bed\u53e5<\/p>\n
<!-- \u573a\u666f1\uff1a\u5355\u4e2a\u7b80\u5355\u4fe1\u606f\u4f20\u5165-->\n <delete id="deleteById">\n delete\n from t_emp\n where emp_id = #{1}\n <\/delete><\/code><\/pre>\n3\u3001\u5355\u4e2a\u7b80\u5355\u7c7b\u578b\u53c2\u6570\uff0c\u5728#{}\u4e2d\u53ef\u4ee5\u968f\u610f\u547d\u540d\uff0c\u4f46\u662f\u6ca1\u6709\u5fc5\u8981\u3002\u901a\u5e38\u8fd8\u662f\u4f7f\u7528\u548c\u63a5\u53e3\u65b9\u6cd5\u53c2\u6570\u540c\u540d<\/p>\n
4\u3001\u5b9e\u4f53\u7c7b\u7c7b\u578b\u53c2\u6570<\/h3>\n
1\u3001Mapper\u62bd\u8c61\u65b9\u6cd5<\/p>\n
\/\/ \u63d2\u5165\u5458\u5de5\u4fe1\u606f\u3010\u5b9e\u4f53\u5bf9\u8c61\u3011\n int insertEmp(Employee employee);<\/code><\/pre>\n2\u3001Sql\u8bed\u53e5<\/p>\n
<!-- \u573a\u666f2\uff1a\u4f20\u5165\u7684\u662f\u4e00\u4e2a\u5b9e\u4f53\u5bf9\u8c61-->\n <insert id="insertEmp">\n insert into t_emp (emp_name,emp_salary\uff09 values(#{empName},#{empSalary})\n <\/insert><\/code><\/pre>\n3\u3001\u5bf9\u5e94\u5173\u7cfb\u5982\u56fe<\/p>\n
<\/div><\/p>\n4\u3001\u7ed3\u8bba<\/p>\n
- \n
- Mybatis\u4f1a\u6839\u636e#{}\u4e2d\u4f20\u5165\u7684\u6570\u636e\uff0c\u52a0\u5de5\u6210getXxx()\u65b9\u6cd5\uff0c\u901a\u8fc7\u53cd\u5c04\u5728\u5b9e\u4f53\u7c7b\u5bf9\u8c61\u4e2d\u8c03\u7528\u8fd9\u4e2a\u65b9\u6cd5\uff0c\u4ece\u800c\u83b7\u53d6\u5230\u5bf9\u5e94\u7684\u6570\u636e\u3002\u586b\u5145\u5230#{}\u89e3\u6790\u540e\u7684\u95ee\u53f7\u5360\u4f4d\u7b26\u8fd9\u4e2a\u4f4d\u7f6e\u3002<\/li>\n<\/ul>\n
5\u3001\u96f6\u6563\u7684\u7b80\u5355\u7c7b\u578b\u6570\u636e<\/h3>\n
1\u3001Mapper\u62bd\u8c61\u65b9\u6cd5<\/p>\n
\/\/ \u6839\u636e\u5458\u5de5\u59d3\u540d\u548c\u5de5\u8d44\u67e5\u8be2\u5458\u5de5\u4fe1\u606f\n\/\/ \u56e0\u4e3a\u4f20\u53c2\u987a\u5e8f\u4e0d\u77e5\u9053\uff0c\u6240\u4ee5\u6211\u4eec\u8fd9\u91cc\u4f7f\u7528@Param\u6307\u5b9a\n List<Employee> queryByNameAndSalary(@Param("name") String name,@Param("salary") String salary);\n\/\/ \u4e5f\u53ef\u4ee5\u9ed8\u8ba4\u4e0d\u7ba1\uff0c\u7528\u53e6\u5916\u4e00\u79cdmybatis\u9ed8\u8ba4\u7684\u65b9\u5f0f\n\/\/ List<Employee> queryByNameAndSalary( String name, String salary);<\/code><\/pre>\n2\u3001Sql\u8bed\u53e5<\/p>\n
<!-- \u573a\u666f3\uff1a\u4f20\u5165\u591a\u4e2a\u7b80\u5355\u7c7b\u578b\u6570\u636e\u5982\u4f55\u53d6\u503ckey\n \u4e0d\u80fd\u968f\u4fbf\u5199\n \u4e0d\u80fd\u5b89\u88c5\u5f62\u53c2\u540d\u79f0\u83b7\u53d6\n \u65b9\u6cd5\u4e00\uff1a\u6ce8\u89e3\u6307\u5b9a@Param\n \u65b9\u6cd5\u4e8c\uff1amybatis\u9ed8\u8ba4\u673a\u5236\n argo arg1.\u5f62\u6210\u4ece\u5de6\u5230\u53f3\n\n-->\n<!-- \u65b9\u6cd51:-->\n <select id="queryByNameAndSalary" resultType="com.atgui.pojo.Employee">\n select emp_id empId,emp_name empName,emp_salary empSalary\n from t_emp\n where emp_salary = #{name} and emp_name = #{salary}\n <\/select><\/code><\/pre>\n3\u3001\u96f6\u6563\u7684\u591a\u4e2a\u7b80\u5355\u7c7b\u578b\u53c2\u6570\uff0c\u5982\u679c\u6ca1\u6709\u7279\u6b8a\u5904\u7406\uff0c\u90a3\u4e48Mybatis\u65e0\u6cd5\u8bc6\u522b\u81ea\u5b9a\u4e49\u540d\u79f0<\/p>\n
4\u3001\u5bf9\u5e94\u5173\u7cfb\u56fe<\/p>\n
<\/div><\/p>\n6\u3001Map\u7c7b\u578b\u53c2\u6570<\/h3>\n
1\u3001Mapper\u62bd\u8c61\u65b9\u6cd5<\/p>\n
\/\/ \u63d2\u5165\u5458\u5de5\u6570\u636e\uff0c\u4f20\u5165\u7684\u662f\u4e00\u4e2amap\uff08name=\u5458\u5de5\u540d\u5b57\uff0csalary=\u5458\u5de5\u7684\u85aa\u6c34\uff09\n int insertEmpMap(Map data);<\/code><\/pre>\n2\u3001Sql\u8bed\u53e5<\/p>\n
<insert id="insertEmpMap">\n insert into t_emp (emp_name,emp_salary\uff09 values(#{empName},#{empSalary})\n <\/insert><\/code><\/pre>\n3\u3001\u5bf9\u5e94\u5173\u7cfb<\/p>\n
- \n
- \n
{}\u4e2d\u5199Map\u4e2d\u7684key<\/h1>\n<\/li>\n<\/ul>\n
4\u3001\u4f7f\u7528\u573a\u666f<\/p>\n
- \n
- \u6709\u5f88\u591a\u96f6\u6563\u7684\u53c2\u6570\u9700\u8981\u4f20\u9012\uff0c\u4f46\u662f\u6ca1\u6709\u5bf9\u5e94\u7684\u5b9e\u4f53\u7c7b\u7c7b\u578b\u53ef\u4ee5\u4f7f\u7528\u3002\u4f7f\u7528@Param\u6ce8\u89e3\u4e00\u4e2a\u4e00\u4e2a\u4f20\u5165\u53c8\u592a\u9ebb\u70e6\u4e86\u3002\u6240\u4ee5\u90fd\u5c01\u88c5\u5230Map\u4e2d\u3002<\/li>\n<\/ul>\n
4\u3001\u6570\u636e\u8f93\u51fa<\/h2>\n
1\u3001\u8f93\u51fa\u6982\u5ff5<\/h3>\n
1\u3001\u6570\u636e\u8f93\u51fa\u603b\u4f53\u4e0a\u6709\u4e24\u79cd\u5f62\u5f0f\uff1a<\/p>\n
- \n
- \u589e\u5220\u6539\u64cd\u4f5c\u8fd4\u56de\u7684\u53d7\u5f71\u54cd\u884c\u6570\uff1a\u76f4\u63a5\u4f7f\u7528 int \u6216 long \u7c7b\u578b\u63a5\u6536\u5373\u53ef<\/li>\n
- \u67e5\u8be2\u64cd\u4f5c\u7684\u67e5\u8be2\u7ed3\u679c<\/li>\n<\/ul>\n
2\u3001\u6211\u4eec\u9700\u8981\u505a\u7684\u662f\uff0c\u6307\u5b9a\u67e5\u8be2\u7684\u8f93\u51fa\u6570\u636e\u7c7b\u578b\u5373\u53ef\uff01<\/p>\n
3\u3001\u5e76\u4e14\u63d2\u5165\u573a\u666f\u4e0b\uff0c\u5b9e\u73b0\u4e3b\u952e\u6570\u636e\u56de\u663e\u793a\uff01<\/p>\n
2\u3001\u5355\u4e2a\u7b80\u5355\u7c7b\u578b<\/h3>\n
1\u3001\u91cd\u70b9\uff01\uff01\uff01<\/h4>\n
<!-- \u573a\u666f1\uff1a\u8fd4\u56de\u5355\u4e2a\u7b80\u5355\u7c7b\u578b\u5982\u4f55\u6307\u5b9a resultType\u7684\u5199\u6cd5\uff0c\u8fd4\u56de\u503c\u7684\u6570\u636e\u7c7b\u578b\n resultType \u8bed\u6cd5\uff1a\n \u5217\u7684\u5168\u9650\u5b9a\u7b26\u53f7\n \u522b\u540d\u7b80\u79f0\n mybatis\u4e2d\u670972\u4e2d\u9ed8\u8ba4\u522b\u540d\n \u90fd\u662fjava\u7684\u5e38\u7528\u6570\u636e\u7c7b\u578b\n \u57fa\u672c\u6570\u636e\u7c7b\u578b\uff1aint doublel -> _int _double\n \u5305\u88c5\u6570\u636e\u7c7b\u578b\uff1aInteger Double -> int integer double\n \u96c6\u5408\u5bb9\u5668\u7c7b\u578b\uff1a Map List HashMap -> \u5c0f\u5199\u5c31\u884c map list hashmap\n\n \u81ea\u5b9a\u4e49\u6269\u5c55\uff1a\u522b\u540d\n \u5355\u72ec\u5b9a\u4e49\n <typeAliases>\n <typeAlias type="com.atgui.pojo.Employee" alias="suibian"\/>\n <\/typeAliases>\n \u6279\u91cf\u5b9a\u4e49\n <package name="com.atgui.pojo"\/>\n\n \u6269\u5c55\uff1a\u5728\u6279\u91cf\u5b9a\u4e49\u7684\u57fa\u7840\u4e0a\uff0c\u5355\u72ec\u5b9a\u4e49\n \u5c31\u662f\u5148\u9700\u8981\u6279\u91cf\u5b9a\u4e49\n \u7136\u540e\u7528\u6ce8\u89e3@Alias\uff08\u201cxxxx\u540d\u79f0\u201d\uff09\n\n--><\/code><\/pre>\n2\u3001\u4f8b\u5b50<\/h4>\n
1\u3001Mapper\u63a5\u53e3<\/p>\n
package com.mapper;\n\npublic interface EmployeeMapper {\n\n\/\/ dml\u8bed\u53e5\n int deleteById(Integer id);\n\n\/\/ \u6307\u5b9a\u8f93\u51fa\u7c7b\u578b\uff0c\u67e5\u8be2\u8bed\u53e5\n\/\/ \u6839\u636e\u5458\u5de5\u7684id\u67e5\u8be2\u5458\u5de5\u7684\u59d3\u540d\n String queryNameById(Integer id);\n\n String querySalaryById(Integer id);\n}\n<\/code><\/pre>\n2\u3001\u914d\u7f6exml\u6587\u4ef6<\/p>\n
<!-- \u5b9a\u4e49\u81ea\u5df1\u7c7b\u7684\u522b\u540d-->\n <typeAliases>\n<!-- \u5355\u72ec\u5b9a\u4e49-->\n<!-- <typeAlias type="com.atgui.pojo.Employee" alias="suibian"\/>-->\n<!-- \u6279\u91cf\u5b9a\u4e49-->\n <package name="com.atgui.pojo"\/>\n <\/typeAliases><\/code><\/pre>\n3\u3001sql\u8bed\u53e5<\/p>\n
<select id="queryNameById" resultType="java.lang.String"><!-- \u8fd9\u91cc\u5199\u7684\u5c31\u662f\u5168\u9650\u5b9a\u7b26\u5408-->\n select emp_name\n from t_emp\n where emp_id = #{id}\n <\/select>\n\n <select id="querySalaryById" resultType="string"> <!-- \u8fd9\u91cc\u5199\u7684\u5c31\u662f\u522b\u540d-->\n select emp_salary\n from t_emp\n where emp_id = #{id}\n <\/select><\/code><\/pre>\n3\u3001\u8865\u5145<\/h4>\n
\u4e0b\u9762\u662fMybatis\u4e3a\u5e38\u89c1\u7684 Java \u7c7b\u578b\u5185\u5efa\u7684\u7c7b\u578b\u522b\u540d\u3002\u5b83\u4eec\u90fd\u662f\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u7684\uff0c\u6ce8\u610f\uff0c\u4e3a\u4e86\u5e94\u5bf9\u539f\u59cb\u7c7b\u578b\u7684\u547d\u540d\u91cd\u590d\uff0c\u91c7\u53d6\u4e86\u7279\u6b8a\u7684\u547d\u540d\u98ce\u683c\u3002<\/p>\n
\n\n
\n \n\u522b\u540d<\/th>\n \u6620\u5c04\u7684\u7c7b\u578b<\/th>\n<\/tr>\n<\/thead>\n \n _byte<\/td>\n byte<\/td>\n<\/tr>\n \n _char (since 3.5.10)<\/td>\n char<\/td>\n<\/tr>\n \n _character (since 3.5.10)<\/td>\n char<\/td>\n<\/tr>\n \n _long<\/td>\n long<\/td>\n<\/tr>\n \n _short<\/td>\n short<\/td>\n<\/tr>\n \n _int<\/td>\n int<\/td>\n<\/tr>\n \n _integer<\/td>\n int<\/td>\n<\/tr>\n \n _double<\/td>\n double<\/td>\n<\/tr>\n \n _float<\/td>\n float<\/td>\n<\/tr>\n \n _boolean<\/td>\n boolean<\/td>\n<\/tr>\n \n string<\/td>\n String<\/td>\n<\/tr>\n \n byte<\/td>\n Byte<\/td>\n<\/tr>\n \n char (since 3.5.10)<\/td>\n Character<\/td>\n<\/tr>\n \n character (since 3.5.10)<\/td>\n Character<\/td>\n<\/tr>\n \n long<\/td>\n Long<\/td>\n<\/tr>\n \n short<\/td>\n Short<\/td>\n<\/tr>\n \n int<\/td>\n Integer<\/td>\n<\/tr>\n \n integer<\/td>\n Integer<\/td>\n<\/tr>\n \n double<\/td>\n Double<\/td>\n<\/tr>\n \n float<\/td>\n Float<\/td>\n<\/tr>\n \n boolean<\/td>\n Boolean<\/td>\n<\/tr>\n \n date<\/td>\n Date<\/td>\n<\/tr>\n \n decimal<\/td>\n BigDecimal<\/td>\n<\/tr>\n \n bigdecimal<\/td>\n BigDecimal<\/td>\n<\/tr>\n \n biginteger<\/td>\n BigInteger<\/td>\n<\/tr>\n \n object<\/td>\n Object<\/td>\n<\/tr>\n \n object[]<\/td>\n Object[]<\/td>\n<\/tr>\n \n map<\/td>\n Map<\/td>\n<\/tr>\n \n hashmap<\/td>\n HashMap<\/td>\n<\/tr>\n \n list<\/td>\n List<\/td>\n<\/tr>\n \n arraylist<\/td>\n ArrayList<\/td>\n<\/tr>\n \n collection<\/td>\n Collection<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n 3\u3001\u8fd4\u56de\u5b9e\u4f53\u7c7b\u5bf9\u8c61<\/h3>\n
1\u3001Mapper\u63a5\u53e3\u7684\u62bd\u8c61\u65b9\u6cd5<\/p>\n
Employee selectEmployee(Integer empId);\n<\/code><\/pre>\n2\u3001SQL\u8bed\u53e5<\/p>\n
<!-- \u7f16\u5199\u5177\u4f53\u7684SQL\u8bed\u53e5\uff0c\u4f7f\u7528id\u5c5e\u6027\u552f\u4e00\u7684\u6807\u8bb0\u4e00\u6761SQL\u8bed\u53e5 -->\n<!-- resultType\u5c5e\u6027\uff1a\u6307\u5b9a\u5c01\u88c5\u67e5\u8be2\u7ed3\u679c\u7684Java\u5b9e\u4f53\u7c7b\u7684\u5168\u7c7b\u540d -->\n<select id="selectEmployee" resultType="com.atguigu.mybatis.entity.Employee">\n\n <!-- Mybatis\u8d1f\u8d23\u628aSQL\u8bed\u53e5\u4e2d\u7684#{}\u90e8\u5206\u66ff\u6362\u6210\u201c?\u201d\u5360\u4f4d\u7b26 -->\n <!-- \u7ed9\u6bcf\u4e00\u4e2a\u5b57\u6bb5\u8bbe\u7f6e\u4e00\u4e2a\u522b\u540d\uff0c\u8ba9\u522b\u540d\u548cJava\u5b9e\u4f53\u7c7b\u4e2d\u5c5e\u6027\u540d\u4e00\u81f4 -->\n select emp_id empId,emp_name empName,emp_salary empSalary from t_emp where emp_id=#{maomi}\n\n<\/select><\/code><\/pre>\n3\u3001select>\u901a\u8fc7\u7ed9\u6570\u636e\u5e93\u8868\u5b57\u6bb5\u52a0\u522b\u540d\uff0c\u8ba9\u67e5\u8be2\u7ed3\u679c\u7684\u6bcf\u4e00\u5217\u90fd\u548cJava\u5b9e\u4f53\u7c7b\u4e2d\u5c5e\u6027\u5bf9\u5e94\u8d77\u6765\u3002<\/p>\n
4\u3001\u589e\u52a0\u5168\u5c40\u914d\u7f6e\u81ea\u52a8\u8bc6\u522b\u5bf9\u5e94\u5173\u7cfb<\/p>\n
5\u3001\u5728 Mybatis \u5168\u5c40\u914d\u7f6e\u6587\u4ef6\u4e2d\uff0c\u505a\u4e86\u4e0b\u9762\u7684\u914d\u7f6e\uff0cselect\u8bed\u53e5\u4e2d\u53ef\u4ee5\u4e0d\u7ed9\u5b57\u6bb5\u8bbe\u7f6e\u522b\u540d<\/p>\n
<!-- \u5728\u5168\u5c40\u8303\u56f4\u5185\u5bf9Mybatis\u8fdb\u884c\u914d\u7f6e -->\n<settings>\n\n <!-- \u5177\u4f53\u914d\u7f6e -->\n <!-- \u4eceorg.apache.ibatis.session.Configuration\u7c7b\u4e2d\u53ef\u4ee5\u67e5\u770b\u80fd\u4f7f\u7528\u7684\u914d\u7f6e\u9879 -->\n <!-- \u5c06mapUnderscoreToCamelCase\u5c5e\u6027\u914d\u7f6e\u4e3atrue\uff0c\u8868\u793a\u5f00\u542f\u81ea\u52a8\u6620\u5c04\u9a7c\u5cf0\u5f0f\u547d\u540d\u89c4\u5219 -->\n <!-- \u89c4\u5219\u8981\u6c42\u6570\u636e\u5e93\u8868\u5b57\u6bb5\u547d\u540d\u65b9\u5f0f\uff1a\u5355\u8bcd_\u5355\u8bcd -->\n <!-- \u89c4\u5219\u8981\u6c42Java\u5b9e\u4f53\u7c7b\u5c5e\u6027\u540d\u547d\u540d\u65b9\u5f0f\uff1a\u9996\u5b57\u6bcd\u5c0f\u5199\u7684\u9a7c\u5cf0\u5f0f\u547d\u540d -->\n <setting name="mapUnderscoreToCamelCase" value="true"\/>\n\n<\/settings><\/code><\/pre>\n4\u3001\u8fd4\u56deMap\u7c7b\u578b<\/h3>\n
1\u3001\u9002\u7528\u4e8eSQL\u67e5\u8be2\u8fd4\u56de\u7684\u5404\u4e2a\u5b57\u6bb5\u7efc\u5408\u8d77\u6765\u5e76\u4e0d\u548c\u4efb\u4f55\u4e00\u4e2a\u73b0\u6709\u7684\u5b9e\u4f53\u7c7b\u5bf9\u5e94\uff0c\u6ca1\u6cd5\u5c01\u88c5\u5230\u5b9e\u4f53\u7c7b\u5bf9\u8c61\u4e2d\u3002\u80fd\u591f\u5c01\u88c5\u6210\u5b9e\u4f53\u7c7b\u7c7b\u578b\u7684\uff0c\u5c31\u4e0d\u4f7f\u7528Map\u7c7b\u578b\u3002<\/p>\n
2\u3001Mapper\u63a5\u53e3\u7684\u62bd\u8c61\u65b9\u6cd5<\/p>\n
Map<String,Object> selectEmpNameAndMaxSalary();<\/code><\/pre>\n3\u3001SQL\u8bed\u53e5<\/p>\n
<!-- Map<String,Object> selectEmpNameAndMaxSalary(); -->\n<!-- \u8fd4\u56de\u5de5\u8d44\u6700\u9ad8\u7684\u5458\u5de5\u7684\u59d3\u540d\u548c\u4ed6\u7684\u5de5\u8d44 -->\n<select id="selectEmpNameAndMaxSalary" resultType="map">\n SELECT\n emp_name \u5458\u5de5\u59d3\u540d,\n emp_salary \u5458\u5de5\u5de5\u8d44,\n (SELECT AVG(emp_salary) FROM t_emp) \u90e8\u95e8\u5e73\u5747\u5de5\u8d44\n FROM t_emp WHERE emp_salary=(\n SELECT MAX(emp_salary) FROM t_emp\n )\n<\/select><\/code><\/pre>\n5\u3001\u8fd4\u56deList\u96c6\u5408<\/h3>\n
1\u3001\u67e5\u8be2\u7ed3\u679c\u8fd4\u56de\u591a\u4e2a\u5b9e\u4f53\u7c7b\u5bf9\u8c61\uff0c\u5e0c\u671b\u628a\u591a\u4e2a\u5b9e\u4f53\u7c7b\u5bf9\u8c61\u653e\u5728List\u96c6\u5408\u4e2d\u8fd4\u56de\u3002\u6b64\u65f6\u4e0d\u9700\u8981\u4efb\u4f55\u7279\u6b8a\u5904\u7406\uff0c\u5728resultType\u5c5e\u6027\u4e2d\u8fd8\u662f\u8bbe\u7f6e\u5b9e\u4f53\u7c7b\u7c7b\u578b\u5373\u53ef\u3002<\/p>\n
2\u3001\u5c31\u662f\u8bf4\uff1a\u8fd4\u56de\u503c\u662f\u96c6\u5408\u3002resultType\u4e0d\u9700\u8981\u6307\u5b9a\u96c6\u5408\u7c7b\u578b\u3002\u53ea\u8981\u6307\u5b9a\u6cdb\u578b\u5c31\u884c\u56e0\u4e3a\u548cibatis\u5e95\u5c42\u76f8\u5173\uff0c\u6700\u7ec8\u8fd8\u662f\u4f1a\u8c03\u7528selectList<\/p>\n
3\u3001Mapper\u63a5\u53e3<\/p>\n
\/\/ \u67e5\u8be2\u5de5\u8d44\u9ad8\u4e8e\u4f20\u5165\u503c\u7684\u5458\u5de5\u59d3\u540d 200\n List<String> queryNamesBySalary(Double salary);\n\/\/ \u67e5\u8be2\u5168\u90e8\u5458\u5de5\u4fe1\u606f\n List<Employee> queryAll();<\/code><\/pre>\n4\u3001SQL\u8bed\u53e5<\/p>\n
<!-- \u573a\u666f4\uff1a\u8fd4\u56de\u96c6\u5408\u7c7b\u578b\u662f\u5982\u4f55\u6307\u5b9a\u7684\n \/\/ \u67e5\u8be2\u5de5\u8d44\u9ad8\u4e8e\u4f20\u5165\u503c\u7684\u5458\u5de5\u59d3\u540d 200\n List<String> queryNamesBySalary(Double salary);\n \/\/ \u67e5\u8be2\u5168\u90e8\u5458\u5de5\u4fe1\u606f\n List<Employee> queryAll();\n\n \u5207\u8bb0\uff1a\u8fd4\u56de\u503c\u662f\u96c6\u5408\u3002resultType\u4e0d\u9700\u8981\u6307\u5b9a\u96c6\u5408\u7c7b\u578b\u3002\u53ea\u8981\u6307\u5b9a\u6cdb\u578b\u5c31\u884c\n \u56e0\u4e3a\u548cibatis\u5e95\u5c42\u76f8\u5173\uff0c\u6700\u7ec8\u8fd8\u662f\u4f1a\u8c03\u7528selectList\n\n-->\n <select id="queryNamesBySalary" resultType="string">\n select emp_name\n from t_emp\n where emp_salary> #{salary}\n <\/select>\n\n <select id="queryAll" resultType="employee">\n select *\n from t_emp\n <\/select><\/code><\/pre>\n6\u3001\u8fd4\u56de\u4e3b\u952e\u503c<\/h3>\n
1\u3001\u81ea\u589e\u957f\u7c7b\u578b\u4e3b\u952e<\/h4>\n
1\u3001\u9700\u6c42\uff1a\u6211\u9700\u8981\u8fd4\u56de\u81ea\u589e\u957f\u7c7b\u578b\u7684\u4e3b\u952e\u503c<\/p>\n
1\u3001Mapper\u63a5\u53e3<\/p>\n
\/\/ \u5458\u5de5\u63d2\u5165\n int insertEmp(Employee employee);<\/code><\/pre>\n2\u3001sql\u8bed\u53e5<\/p>\n
<!-- \u5458\u5de5\u63d2\u5165\n \u573a\u666f5\uff1a\u4e3b\u952e\u56de\u663e\u3002\u83b7\u53d6\u63d2\u5165\u6570\u636e\u7684\u4e3b\u952e\n useGeneratedKeys \uff1a\u662f\u6211\u4eec\u60f3\u8981\u6570\u636e\u5e93\u5b57\u5178\u589e\u957f\u7684\u4e3b\u952e\u503c\n keyColumn \uff1a \u4e3b\u952e\u5217\u7684\u503c\n keyProperty \uff1a\u63a5\u6536\u4e3b\u952e\u5217\u503c\u7684\u5c5e\u6027\uff01\n\n-->\n <insert id="insertEmp" useGeneratedKeys="true" keyColumn="emp_id" keyProperty="empId">\n insert into t_emp (emp_name,emp_salary) values(#{empName},#{empSalary})\n <\/insert><\/code><\/pre>\n3\u3001\u6d4b\u8bd5<\/p>\n
@Test\n public void test1() throws IOException {\n InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");\n SqlSessionFactory sqlSessionFactory =new SqlSessionFactoryBuilder().build(inputStream);\n SqlSession sqlSession = sqlSessionFactory.openSession(true);\/\/\u4e8b\u52a1\u81ea\u52a8\u63d0\u4ea4\n EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);\n\n Employee employee = new Employee();\n employee.setEmpName("\u4e8c\u72d7\u5b50");\n employee.setEmpSalary(888.0);\n\n int row = mapper.insertEmp(employee);\n System.out.println(employee.getEmpId());\n\n System.out.println("row = " + row);\n\n sqlSession.close();\n }<\/code><\/pre>\n4\u3001\u4e3b\u8981\u6839\u636e\u4ee5\u4e0b3\u4e2a\u6807\u7b7e\u63d2\u5165\u5230insert\u8bed\u53e5\u4e2d<\/p>\n
- \n
- useGeneratedKeys \uff1a\u662f\u6211\u4eec\u60f3\u8981\u6570\u636e\u5e93\u5b57\u5178\u589e\u957f\u7684\u4e3b\u952e\u503c<\/li>\n
- keyColumn \uff1a \u4e3b\u952e\u5217\u7684\u503c<\/li>\n
- keyProperty \uff1a\u63a5\u6536\u4e3b\u952e\u5217\u503c\u7684\u5c5e\u6027\uff01<\/li>\n<\/ul>\n
5\u3001\u6ce8\u610f<\/p>\n
- \n
- Mybatis\u662f\u5c06\u81ea\u589e\u4e3b\u952e\u7684\u503c\u8bbe\u7f6e\u5230\u5b9e\u4f53\u7c7b\u5bf9\u8c61\u4e2d\uff0c\u800c\u4e0d\u662f\u4ee5Mapper\u63a5\u53e3\u65b9\u6cd5\u8fd4\u56de\u503c\u7684\u5f62\u5f0f\u8fd4\u56de\u3002<\/li>\n<\/ul>\n
2\u3001\u975e\u81ea\u589e\u957f\u7c7b\u578b\u4e3b\u952e<\/h4>\n
1\u3001\u9700\u6c42\uff1a\u628a\u5b57\u7b26\u4e32\u7c7b\u578b\u7684\u4e3b\u952e\u56de\u663e<\/p>\n
2\u3001Mapper\u63a5\u53e3<\/p>\n
\/\/ \u63d2\u5165\u8001\u5e08\u4fe1\u606f\n int insertTeacher(Teacher teacher);<\/code><\/pre>\n2\u3001sql\u8bed\u53e5<\/p>\n
<!--\n \u5bf9\u4e8e\u975e\u81ea\u589e\u957f\u7684\u4e3b\u952e\uff0c\u6211\u4eec\u6253\u7b97\u4ea4\u7ed9mybatis\u5e2e\u6211\u4eec\u7ef4\u62a4\u3002\n string\u65e0\u6cd5\u81ea\u589e\u957f\n \u6240\u4ee5\u6211\u4eec\u53ef\u4ee5\u6307\u5b9a\u4e00\u6bb5\u7a0b\u5e8f\uff0c\u751f\u6210\u4e00\u4e2a\u4e3b\u952e\uff0c\u5fc5\u987b\u5728\u63d2\u5165\u4e4b\u524d\n order = before\/after \u4e4b\u524d\u4e4b\u540e\n resultType = \u8fd4\u56de\u503c\u7c7b\u578b\n keyProperty = \u67e5\u8be2\u7ed3\u679c\u7ed9\u54ea\u4e2a\u5c5e\u6027\u8d4b\u503c\n-->\n <insert id="insertTeacher">\n\n <selectKey order="BEFORE" resultType="string" keyProperty="tId">\n SELECT REPLACE(UUID(),'-','')\n <\/selectKey>\n\n INSERT INTO teacher (t_id,t_name) VALUES(#{tId},#{tName})\n <\/insert><\/code><\/pre>\n3\u3001\u6d4b\u8bd5\u4ee3\u7801<\/p>\n
@Test\n public void test2() throws IOException {\n InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");\n SqlSessionFactory sqlSessionFactory =new SqlSessionFactoryBuilder().build(inputStream);\n SqlSession sqlSession = sqlSessionFactory.openSession(true);\/\/\u4e8b\u52a1\u81ea\u52a8\u63d0\u4ea4\n TeacherMapper teacherMapper = sqlSession.getMapper(TeacherMapper.class);\n\n Teacher teacher = new Teacher();\n teacher.settName("\u5927\u50bb\u74dc");\n\n int i = teacherMapper.insertTeacher(teacher);\n System.out.println("i = " + i);\n\n sqlSession.close();\n }<\/code><\/pre>\n4\u3001\u8865\u5145<\/p>\n
- \n
- \u4f7f\u7528\u8fd9\u79cd\u65b9\u5f0f\uff0c\u6211\u4eec\u53ef\u4ee5\u65b9\u4fbf\u5730\u63d2\u5165 UUID \u4f5c\u4e3a\u5b57\u7b26\u4e32\u7c7b\u578b\u4e3b\u952e\u3002\u5f53\u7136\uff0c\u8fd8\u6709\u5176\u4ed6\u63d2\u5165\u65b9\u5f0f\u53ef\u4ee5\u4f7f\u7528\uff0c\u5982\u4f7f\u7528Java\u4ee3\u7801\u751f\u6210UUID\u5e76\u5728\u7c7b\u4e2d\u663e\u5f0f\u8bbe\u7f6e\u503c\u7b49\u3002\u9700\u8981\u6839\u636e\u5177\u4f53\u5e94\u7528\u573a\u666f\u548c\u9700\u6c42\u9009\u62e9\u5408\u9002\u7684\u63d2\u5165\u65b9\u5f0f\u3002<\/li>\n<\/ul>\n
7\u3001\u5b9e\u4f53\u7c7b\u5c5e\u6027\u540d\u548c\u6570\u636e\u5e93\u5b57\u6bb5\u7684\u5bf9\u5e94\u5173\u7cfb<\/h3>\n
1\u3001\u522b\u540d\u5bf9\u5e94<\/h4>\n
1\u3001\u5c06\u5b57\u6bb5\u7684\u522b\u540d\u8bbe\u7f6e\u6210\u548c\u5b9e\u4f53\u7c7b\u5c5e\u6027\u4e00\u76f4<\/p>\n
2\u3001\u5c31\u662fresultType=\u5199\u5168\u7c7b\u540d \uff0c\u7136\u540eSQL\u8bed\u53e5\u8bbe\u7f6e\u4e00\u4e2a\u522b\u540d<\/p>\n
3\u3001\u4f8b\u5b50<\/p>\n
<!-- \u7f16\u5199\u5177\u4f53\u7684SQL\u8bed\u53e5\uff0c\u4f7f\u7528id\u5c5e\u6027\u552f\u4e00\u7684\u6807\u8bb0\u4e00\u6761SQL\u8bed\u53e5 -->\n<!-- resultType\u5c5e\u6027\uff1a\u6307\u5b9a\u5c01\u88c5\u67e5\u8be2\u7ed3\u679c\u7684Java\u5b9e\u4f53\u7c7b\u7684\u5168\u7c7b\u540d -->\n<select id="selectEmployee" resultType="com.atguigu.mybatis.entity.Employee">\n\n <!-- Mybatis\u8d1f\u8d23\u628aSQL\u8bed\u53e5\u4e2d\u7684#{}\u90e8\u5206\u66ff\u6362\u6210\u201c?\u201d\u5360\u4f4d\u7b26 -->\n <!-- \u7ed9\u6bcf\u4e00\u4e2a\u5b57\u6bb5\u8bbe\u7f6e\u4e00\u4e2a\u522b\u540d\uff0c\u8ba9\u522b\u540d\u548cJava\u5b9e\u4f53\u7c7b\u4e2d\u5c5e\u6027\u540d\u4e00\u81f4 -->\n select emp_id empId,emp_name empName,emp_salary empSalary from t_emp where emp_id=#{maomi}\n\n<\/select><\/code><\/pre>\n2\u3001\u901a\u8fc7\u5168\u5c40\u914d\u7f6e\u81ea\u52a8\u8bc6\u522b\u9a7c\u5cf0\u547d\u540d\u89c4\u5219<\/h4>\n
1\u3001\u5c31\u662f\u5c5e\u6027\u5199\u9a7c\u5cf0\u547d\u540d\uff0c\u7136\u540e\u6570\u636e\u5e93\u7684\u5217\u540d\u5199\u86c7\u5f62\uff08xx_xxx)<\/p>\n
2\u3001\u914d\u7f6e\u5982\u4e0b<\/p>\n
<!-- \u4f7f\u7528settings\u5bf9Mybatis\u5168\u5c40\u8fdb\u884c\u8bbe\u7f6e -->\n<settings>\n\n <!-- \u5c06xxx_xxx\u8fd9\u6837\u7684\u5217\u540d\u81ea\u52a8\u6620\u5c04\u5230xxXxx\u8fd9\u6837\u9a7c\u5cf0\u5f0f\u547d\u540d\u7684\u5c5e\u6027\u540d -->\n <setting name="mapUnderscoreToCamelCase" value="true"\/>\n\n<\/settings><\/code><\/pre>\n3\u3001sql\u8bed\u53e5\u5c31\u76f4\u63a5\u5199\u5c31\u597d<\/p>\n
<!-- Employee selectEmployee(Integer empId); -->\n<select id="selectEmployee" resultType="com.atguigu.mybatis.entity.Employee">\n\n select emp_id,emp_name,emp_salary from t_emp where emp_id=#{empId}\n\n<\/select><\/code><\/pre>\n3\u3001\u4f7f\u7528resultMap<\/h4>\n
1\u3001\u5c31\u662f\u81ea\u5b9a\u4e49\u6620\u5c04\u5173\u7cfb<\/p>\n
2\u3001\u7528resultType\u53ef\u4ee5\u81ea\u52a8\u6620\u5c04\uff0c\u4f46\u662f\u53ea\u80fd\u6620\u5c04\u4e00\u5c42<\/p>\n
3\u3001\u4f7f\u7528resultMap\u9700\u8981\u624b\u52a8\u8bbe\u7f6e\u6620\u5c04\u5173\u7cfb\uff0c\u4f46\u662f\u53ef\u4ee5\u6620\u5c04n\u5c42\u3002\u5728\u591a\u8868\u67e5\u8be2\u4e2d\u4f1a\u6d89\u53ca<\/p>\n
4\u3001\u4f8b\u5b50<\/p>\n
<resultMap id="tMap" type="teacher">\n\n <id column="t_id" property="tId"\/>\n <result column="t_name" property="tName"\/>\n\n <\/resultMap>\n\n <select id="queryById" resultMap="tMap">\n select *\n from teacher\n where t_id = #{tId}\n <\/select><\/code><\/pre>\n4\u3001\u603b\u7ed3<\/h4>\n
1\u3001<\/p>\n
<!-- \u573a\u666f\uff1a\u89e3\u51b3\u5217\u540d\u548c\u5c5e\u6027\u4e0d\u4e00\u81f4\u7684\u95ee\u9898\n \u65b9\u6cd51\uff1a\u5c31\u662f\u4f7f\u7528\u522b\u540d\n \u65b9\u6cd52\uff1a\u5f00\u542f\u9a7c\u5cf0\u5f0f\u6620\u5c04\n \u5f00\u542f\u9a7c\u5cf0\u5f0f\u81ea\u52a8\u6620\u5c04\n <setting name="mapUnderscoreToCamelCase" value="true"\/>\n \u65b9\u6cd53\uff1aresultMap\u81ea\u5b9a\u4e49\u6620\u5c04\n resultType:\u662f\u53ef\u4ee5\u81ea\u52a8\u6620\u5c04\uff0c\u4e0d\u8fc7\u53ea\u80fd\u6620\u5c04\u4e00\u5c42\n resultMap\uff1a\u81ea\u5b9a\u4e49\u6620\u5c04\uff0c\u53ef\u4ee5\u6620\u5c04\u66f4\u6df1\u5c42\u6b21\uff0c\u4e00\u5c42\u6216\u591a\u5c42\n\n \u5982\u4f55\u58f0\u660e\uff1a\n id\u6807\u8bc6\uff1a\u5c31\u662f\u5bf9\u5e94\u7684select resultMap=\u201d\u6807\u8bc6\u201c\n type\uff1a\u662f\u6307\u5177\u4f53\u7684\u8fd4\u56de\u503c\u7c7b\u578b \u5168\u9650\u5b9a\u7b26\u548c\u522b\u540d | \u96c6\u5408\u53ea\u5199\u6cdb\u578b\u5373\u53ef\n id \uff1a\u4e3b\u952e\u6620\u5c04\u5173\u7cfb\n result\uff1a\u666e\u901a\u5217\u7684\u6620\u5c04\u5173\u7cfb\n--><\/code><\/pre>\n8\u3001\u5355\u8868\u7684CRUD\u7ec3\u4e60<\/h3>\n
1\u3001\u4ee3\u7801<\/h4>\n
1\u3001\u51c6\u5907\u6570\u636e\u5e93<\/p>\n
CREATE TABLE `user` (\n `id` INT(11) NOT NULL AUTO_INCREMENT,\n `username` VARCHAR(50) NOT NULL,\n `password` VARCHAR(50) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;\n<\/code><\/pre>\n2\u3001\u7f16\u5199\u5b9e\u4f53\u7c7b<\/p>\n
package com.atgui.pojo;\n\nimport lombok.Data;\n\n@Data \/\/lombok\npublic class User {\n private Integer id;\n private String username;\n private String password;\n}<\/code><\/pre>\n3\u3001pom.xml\u6587\u4ef6<\/p>\n
<?xml version="1.0" encoding="UTF-8"?>\n<project xmlns="http:\/\/maven.apache.org\/POM\/4.0.0"\n xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance"\n xsi:schemaLocation="http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd">\n <modelVersion>4.0.0<\/modelVersion>\n\n <groupId>com.atgui<\/groupId>\n <artifactId>ssm-mybatis-part<\/artifactId>\n <version>1.0-SNAPSHOT<\/version>\n <packaging>pom<\/packaging>\n <modules>\n <module>mybatis-base-quickly-01<\/module>\n <module>mybatis-base-param-input-02<\/module>\n <module>mybatis-base-result-output-03<\/module>\n <module>mybatis-base-parm-crud-04<\/module>\n <\/modules>\n\n <properties>\n <maven.compiler.source>17<\/maven.compiler.source>\n <maven.compiler.target>17<\/maven.compiler.target>\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\n <\/properties>\n<!--mybatis\u7684\u4f9d\u8d56-->\n <dependencies>\n <!-- mybatis\u4f9d\u8d56 -->\n <dependency>\n <groupId>org.mybatis<\/groupId>\n <artifactId>mybatis<\/artifactId>\n <version>3.5.11<\/version>\n <\/dependency>\n\n <!-- MySQL\u9a71\u52a8 mybatis\u5e95\u5c42\u4f9d\u8d56jdbc\u9a71\u52a8\u5b9e\u73b0,\u672c\u6b21\u4e0d\u9700\u8981\u5bfc\u5165\u8fde\u63a5\u6c60,mybatis\u81ea\u5e26! -->\n <dependency>\n <groupId>mysql<\/groupId>\n <artifactId>mysql-connector-java<\/artifactId>\n <version>8.0.25<\/version>\n <\/dependency>\n\n <!--junit5\u6d4b\u8bd5-->\n <dependency>\n <groupId>org.junit.jupiter<\/groupId>\n <artifactId>junit-jupiter-api<\/artifactId>\n <version>5.3.1<\/version>\n <\/dependency>\n<!-- lombok\u63d2\u4ef6-->\n <dependency>\n <groupId>org.projectlombok<\/groupId>\n <artifactId>lombok<\/artifactId>\n <version>1.18.30<\/version>\n <\/dependency>\n <\/dependencies>\n\n<\/project><\/code><\/pre>\n4\u3001mybatis-config.xml\u6587\u4ef6<\/p>\n
<?xml version="1.0" encoding="UTF-8" ?>\n<!DOCTYPE configuration\n PUBLIC "-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN"\n "http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd">\n<configuration>\n<!-- \u8ba9mybatis\u5f00\u542f\u65e5\u5fd7\u8f93\u51fa-->\n <settings>\n<!-- \u8fd9\u91cc\u8bbe\u7f6e\u7684\u662f\u9009\u62e9\u7528system\u8fdb\u884c\u65e5\u5fd7\u8f93\u51fa-->\n <setting name="logImpl" value="STDOUT_LOGGING"\/>\n<!-- \u5f00\u542f\u9a7c\u5cf0\u5f0f\u81ea\u52a8\u6620\u5c04-->\n <setting name="mapUnderscoreToCamelCase" value="true"\/>\n <\/settings>\n\n<!-- \u5b9a\u4e49\u81ea\u5df1\u7c7b\u7684\u522b\u540d-->\n <typeAliases>\n<!-- \u5355\u72ec\u5b9a\u4e49-->\n<!-- <typeAlias type="com.atgui.pojo.Employee" alias="suibian"\/>-->\n<!-- \u6279\u91cf\u5b9a\u4e49-->\n <package name="com.atgui.pojo"\/>\n <\/typeAliases>\n\n <!-- environments\u8868\u793a\u914d\u7f6eMybatis\u7684\u5f00\u53d1\u73af\u5883\uff0c\u53ef\u4ee5\u914d\u7f6e\u591a\u4e2a\u73af\u5883\uff0c\u5728\u4f17\u591a\u5177\u4f53\u73af\u5883\u4e2d\uff0c\u4f7f\u7528default\u5c5e\u6027\u6307\u5b9a\u5b9e\u9645\u8fd0\u884c\u65f6\u4f7f\u7528\u7684\u73af\u5883\u3002default\u5c5e\u6027\u7684\u53d6\u503c\u662fenvironment\u6807\u7b7e\u7684id\u5c5e\u6027\u7684\u503c\u3002 -->\n <environments default="development">\n <!-- environment\u8868\u793a\u914d\u7f6eMybatis\u7684\u4e00\u4e2a\u5177\u4f53\u7684\u73af\u5883 -->\n <environment id="development">\n <!-- Mybatis\u7684\u5185\u7f6e\u7684\u4e8b\u52a1\u7ba1\u7406\u5668 -->\n <transactionManager type="JDBC"\/>\n <!-- \u914d\u7f6e\u6570\u636e\u6e90 -->\n <dataSource type="POOLED">\n <!-- \u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u7684\u5177\u4f53\u4fe1\u606f -->\n <property name="driver" value="com.mysql.cj.jdbc.Driver"\/>\n <property name="url" value="jdbc:mysql:\/\/localhost:3306\/mybatis-example"\/>\n <property name="username" value="root"\/>\n <property name="password" value="root"\/>\n <\/dataSource>\n <\/environment>\n <\/environments>\n\n <mappers>\n <!-- Mapper\u6ce8\u518c\uff1a\u6307\u5b9aMybatis\u6620\u5c04\u6587\u4ef6\u7684\u5177\u4f53\u4f4d\u7f6e -->\n <!-- mapper\u6807\u7b7e\uff1a\u914d\u7f6e\u4e00\u4e2a\u5177\u4f53\u7684Mapper\u6620\u5c04\u6587\u4ef6 -->\n <!-- resource\u5c5e\u6027\uff1a\u6307\u5b9aMapper\u6620\u5c04\u6587\u4ef6\u7684\u5b9e\u9645\u5b58\u50a8\u4f4d\u7f6e\uff0c\u8fd9\u91cc\u9700\u8981\u4f7f\u7528\u4e00\u4e2a\u4ee5\u7c7b\u8def\u5f84\u6839\u76ee\u5f55\u4e3a\u57fa\u51c6\u7684\u76f8\u5bf9\u8def\u5f84 -->\n <!-- \u5bf9Maven\u5de5\u7a0b\u7684\u76ee\u5f55\u7ed3\u6784\u6765\u8bf4\uff0cresources\u76ee\u5f55\u4e0b\u7684\u5185\u5bb9\u4f1a\u76f4\u63a5\u653e\u5165\u7c7b\u8def\u5f84\uff0c\u6240\u4ee5\u8fd9\u91cc\u6211\u4eec\u53ef\u4ee5\u4ee5resources\u76ee\u5f55\u4e3a\u57fa\u51c6 -->\n <mapper resource="mappers\/UserMapper.xml"\/>\n <\/mappers>\n\n<\/configuration><\/code><\/pre>\n5\u3001\u51c6\u5907\u63a5\u53e3Mapper<\/p>\n
package com.atgui.mapper;\n\nimport com.atgui.pojo.User;\n\nimport java.util.List;\n\npublic interface UserMapper {\n\n int insert(User user);\n\n int update(User user);\n\n int delete(Integer id);\n\n User selectById(Integer id);\n\n List<User> selectAll();\n}\n<\/code><\/pre>\n6\u3001\u51c6\u5907\u63a5\u53e3\u7684\u914d\u7f6e\u6587\u4ef6Mappers\/Mapper.xml<\/p>\n
<?xml version="1.0" encoding="UTF-8" ?>\n<!DOCTYPE mapper\n PUBLIC "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN"\n "https:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd">\n<!-- namespace\u7b49\u4e8emapper\u63a5\u53e3\u7c7b\u7684\u5168\u9650\u5b9a\u540d,\u8fd9\u6837\u5b9e\u73b0\u5bf9\u5e94 -->\n<mapper namespace="com.atgui.mapper.UserMapper">\n\n <insert id="insert" useGeneratedKeys="true" keyProperty="id" keyColumn="id">\n insert into user (username,password) value(#{username},#{password});\n <\/insert>\n\n <update id="update">\n update user set username =#{username},password = #{password};\n <\/update>\n\n <delete id="delete">\n delete\n from user\n where id = #{id};\n <\/delete>\n\n <select id="selectById" resultType="user">\n select *\n from user\n where id = #{id};\n <\/select>\n\n <select id="selectAll" resultType="user">\n select *\n from user;\n <\/select>\n\n<\/mapper><\/code><\/pre>\n7\u3001\u8fdb\u884c\u6d4b\u8bd5<\/p>\n
package com.atgui;\n\nimport com.atgui.mapper.UserMapper;\nimport com.atgui.pojo.User;\nimport org.apache.ibatis.io.Resources;\nimport org.apache.ibatis.session.SqlSession;\nimport org.apache.ibatis.session.SqlSessionFactory;\nimport org.apache.ibatis.session.SqlSessionFactoryBuilder;\n\nimport org.junit.jupiter.api.AfterEach;\nimport org.junit.jupiter.api.BeforeEach;\nimport org.junit.jupiter.api.Test;\n\nimport java.io.IOException;\nimport java.io.InputStream;\nimport java.util.List;\n\npublic class MybatisTest {\n\n private SqlSession sqlSession;\n\n\/\/ \u6bcf\u6b21\u6d4b\u8bd5\u65b9\u6cd5\u6267\u884c\u524d\u90fd\u4f1a\u6267\u884c\u8be5\u4ee3\u7801\n @BeforeEach\n public void before() throws IOException {\n InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");\n SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);\n sqlSession = sqlSessionFactory.openSession(true);\n }\n\n \/\/\u6bcf\u6b21\u6d4b\u8bd5\u65b9\u6cd5\u6267\u884c\u540e\u90fd\u4f1a\u6267\u884c\u8be5\u4ee3\u7801\n @AfterEach\n public void clean(){\n sqlSession.close();\n }\n @Test\n public void testInsert(){\n User user = new User();\n user.setUsername("1231");\n user.setPassword("123");\n UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n userMapper.insert(user);\n System.out.println("userMapper = " + userMapper);\n }\n\n @Test\n public void testUpdate(){\n UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n User user = userMapper.selectById(1);\/\/\u67e5\u8be2\u5230\u8fd9\u4e2a\u518d\u8fdb\u884c\u4fee\u6539\n user.setUsername("12311111");\n user.setPassword("12322222");\n userMapper.update(user);\n\n }\n\n @Test\n public void testDelete(){\n\n UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n userMapper.delete(1);\n\n }\n\n @Test\n public void testSelectById(){\n UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n User user = userMapper.selectById(1);\n System.out.println("user = " + user);\n }\n\n @Test\n public void testSelectAll(){\n UserMapper userMapper = sqlSession.getMapper(UserMapper.class);\n List<User> userList = userMapper.selectAll();\n System.out.println("userList = " + userList);\n }\n\n}\n<\/code><\/pre>\n9\u3001Mapper.xml\u603b\u7ed3<\/h3>\n
1\u3001\u5185\u5bb9<\/h4>\n
1\u3001\u9876\u7ea7\u5143\u7d20<\/p>\n
- \n
insert<\/code> \u2013 \u6620\u5c04\u63d2\u5165\u8bed\u53e5\u3002<\/li>\nupdate<\/code> \u2013 \u6620\u5c04\u66f4\u65b0\u8bed\u53e5\u3002<\/li>\ndelete<\/code> \u2013 \u6620\u5c04\u5220\u9664\u8bed\u53e5\u3002<\/li>\nselect<\/code> \u2013 \u6620\u5c04\u67e5\u8be2\u8bed\u53e5\u3002<\/li>\n<\/ul>\n2\u3001select\u6807\u7b7e<\/p>\n
- \n
- \n
\u884c\u4e3a\u7ec6\u8282<\/p>\n<\/li>\n
- \n
\n\n
\n \n\u5c5e\u6027<\/th>\n \u63cf\u8ff0<\/th>\n<\/tr>\n<\/thead>\n \n id<\/code><\/td>\n\u5728\u547d\u540d\u7a7a\u95f4\u4e2d\u552f\u4e00\u7684\u6807\u8bc6\u7b26\uff0c\u53ef\u4ee5\u88ab\u7528\u6765\u5f15\u7528\u8fd9\u6761\u8bed\u53e5\u3002<\/td>\n<\/tr>\n \n resultType<\/code><\/td>\n\u671f\u671b\u4ece\u8fd9\u6761\u8bed\u53e5\u4e2d\u8fd4\u56de\u7ed3\u679c\u7684\u7c7b\u5168\u9650\u5b9a\u540d\u6216\u522b\u540d\u3002 \u6ce8\u610f\uff0c\u5982\u679c\u8fd4\u56de\u7684\u662f\u96c6\u5408\uff0c\u90a3\u5e94\u8be5\u8bbe\u7f6e\u4e3a\u96c6\u5408\u5305\u542b\u7684\u7c7b\u578b\uff0c\u800c\u4e0d\u662f\u96c6\u5408\u672c\u8eab\u7684\u7c7b\u578b\u3002 resultType \u548c resultMap \u4e4b\u95f4\u53ea\u80fd\u540c\u65f6\u4f7f\u7528\u4e00\u4e2a\u3002<\/td>\n<\/tr>\n \n resultMap<\/code><\/td>\n\u5bf9\u5916\u90e8 resultMap \u7684\u547d\u540d\u5f15\u7528\u3002\u7ed3\u679c\u6620\u5c04\u662f MyBatis \u6700\u5f3a\u5927\u7684\u7279\u6027\uff0c\u5982\u679c\u4f60\u5bf9\u5176\u7406\u89e3\u900f\u5f7b\uff0c\u8bb8\u591a\u590d\u6742\u7684\u6620\u5c04\u95ee\u9898\u90fd\u80fd\u8fce\u5203\u800c\u89e3\u3002 resultType \u548c resultMap \u4e4b\u95f4\u53ea\u80fd\u540c\u65f6\u4f7f\u7528\u4e00\u4e2a\u3002<\/td>\n<\/tr>\n \n timeout<\/code><\/td>\n\u8fd9\u4e2a\u8bbe\u7f6e\u662f\u5728\u629b\u51fa\u5f02\u5e38\u4e4b\u524d\uff0c\u9a71\u52a8\u7a0b\u5e8f\u7b49\u5f85\u6570\u636e\u5e93\u8fd4\u56de\u8bf7\u6c42\u7ed3\u679c\u7684\u79d2\u6570\u3002\u9ed8\u8ba4\u503c\u4e3a\u672a\u8bbe\u7f6e\uff08unset\uff09\uff08\u4f9d\u8d56\u6570\u636e\u5e93\u9a71\u52a8\uff09\u3002<\/td>\n<\/tr>\n \n statementType<\/code><\/td>\n\u53ef\u9009 STATEMENT\uff0cPREPARED \u6216 CALLABLE\u3002\u8fd9\u4f1a\u8ba9 MyBatis \u5206\u522b\u4f7f\u7528 Statement\uff0cPreparedStatement \u6216 CallableStatement\uff0c\u9ed8\u8ba4\u503c\uff1aPREPARED<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/li>\n<\/ul>\n 3\u3001insert\u3001update\u3001delete\u6807\u7b7e<\/p>\n
- \n
- \n
\u7ec6\u8282<\/p>\n<\/li>\n
- \n
\u4e3b\u8981insert\u4f1a\u4f7f\u7528\uff0c\u56e0\u4e3a\u6d89\u53ca\u5230\u4e3b\u952e\u56de\u663e<\/p>\n<\/li>\n<\/ul>\n
\n\n
\n \n\u5c5e\u6027<\/th>\n \u63cf\u8ff0<\/th>\n<\/tr>\n<\/thead>\n \n id<\/code><\/td>\n\u5728\u547d\u540d\u7a7a\u95f4\u4e2d\u552f\u4e00\u7684\u6807\u8bc6\u7b26\uff0c\u53ef\u4ee5\u88ab\u7528\u6765\u5f15\u7528\u8fd9\u6761\u8bed\u53e5\u3002<\/td>\n<\/tr>\n \n timeout<\/code><\/td>\n\u8fd9\u4e2a\u8bbe\u7f6e\u662f\u5728\u629b\u51fa\u5f02\u5e38\u4e4b\u524d\uff0c\u9a71\u52a8\u7a0b\u5e8f\u7b49\u5f85\u6570\u636e\u5e93\u8fd4\u56de\u8bf7\u6c42\u7ed3\u679c\u7684\u79d2\u6570\u3002\u9ed8\u8ba4\u503c\u4e3a\u672a\u8bbe\u7f6e\uff08unset\uff09\uff08\u4f9d\u8d56\u6570\u636e\u5e93\u9a71\u52a8\uff09\u3002<\/td>\n<\/tr>\n \n statementType<\/code><\/td>\n\u53ef\u9009 STATEMENT\uff0cPREPARED \u6216 CALLABLE\u3002\u8fd9\u4f1a\u8ba9 MyBatis \u5206\u522b\u4f7f\u7528 Statement\uff0cPreparedStatement \u6216 CallableStatement\uff0c\u9ed8\u8ba4\u503c\uff1aPREPARED\u3002<\/td>\n<\/tr>\n \n useGeneratedKeys<\/code><\/td>\n\uff08\u4ec5\u9002\u7528\u4e8e insert \u548c update\uff09\u8fd9\u4f1a\u4ee4 MyBatis \u4f7f\u7528 JDBC \u7684 getGeneratedKeys \u65b9\u6cd5\u6765\u53d6\u51fa\u7531\u6570\u636e\u5e93\u5185\u90e8\u751f\u6210\u7684\u4e3b\u952e\uff08\u6bd4\u5982\uff1a\u50cf MySQL \u548c SQL Server \u8fd9\u6837\u7684\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u7684\u81ea\u52a8\u9012\u589e\u5b57\u6bb5\uff09\uff0c\u9ed8\u8ba4\u503c\uff1afalse\u3002<\/td>\n<\/tr>\n \n keyProperty<\/code><\/td>\n\uff08\u4ec5\u9002\u7528\u4e8e insert \u548c update\uff09\u6307\u5b9a\u80fd\u591f\u552f\u4e00\u8bc6\u522b\u5bf9\u8c61\u7684\u5c5e\u6027\uff0cMyBatis \u4f1a\u4f7f\u7528 getGeneratedKeys \u7684\u8fd4\u56de\u503c\u6216 insert \u8bed\u53e5\u7684 selectKey \u5b50\u5143\u7d20\u8bbe\u7f6e\u5b83\u7684\u503c\uff0c\u9ed8\u8ba4\u503c\uff1a\u672a\u8bbe\u7f6e\uff08 unset<\/code>\uff09\u3002\u5982\u679c\u751f\u6210\u5217\u4e0d\u6b62\u4e00\u4e2a\uff0c\u53ef\u4ee5\u7528\u9017\u53f7\u5206\u9694\u591a\u4e2a\u5c5e\u6027\u540d\u79f0\u3002<\/td>\n<\/tr>\n\n keyColumn<\/code><\/td>\n\uff08\u4ec5\u9002\u7528\u4e8e insert \u548c update\uff09\u8bbe\u7f6e\u751f\u6210\u952e\u503c\u5728\u8868\u4e2d\u7684\u5217\u540d\uff0c\u5728\u67d0\u4e9b\u6570\u636e\u5e93\uff08\u50cf PostgreSQL\uff09\u4e2d\uff0c\u5f53\u4e3b\u952e\u5217\u4e0d\u662f\u8868\u4e2d\u7684\u7b2c\u4e00\u5217\u7684\u65f6\u5019\uff0c\u662f\u5fc5\u987b\u8bbe\u7f6e\u7684\u3002\u5982\u679c\u751f\u6210\u5217\u4e0d\u6b62\u4e00\u4e2a\uff0c\u53ef\u4ee5\u7528\u9017\u53f7\u5206\u9694\u591a\u4e2a\u5c5e\u6027\u540d\u79f0\u3002<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":" \u4e8c\u3001MyBatis\u57fa\u672c\u4f7f\u7528 1\u3001mybatis\u65e5\u5fd7\u8f93\u51fa\u914d\u7f6e 1\u3001mybatis-config.xml\u8fd9\u4e2a\u6587\u4ef6\u91cc […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-5806","post","type-post","status-publish","format-standard","hentry","category-mybatis"],"_links":{"self":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts\/5806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/comments?post=5806"}],"version-history":[{"count":1,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts\/5806\/revisions"}],"predecessor-version":[{"id":5807,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts\/5806\/revisions\/5807"}],"wp:attachment":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/media?parent=5806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/categories?post=5806"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/tags?post=5806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- \n
- \u4f7f\u7528\u8fd9\u79cd\u65b9\u5f0f\uff0c\u6211\u4eec\u53ef\u4ee5\u65b9\u4fbf\u5730\u63d2\u5165 UUID \u4f5c\u4e3a\u5b57\u7b26\u4e32\u7c7b\u578b\u4e3b\u952e\u3002\u5f53\u7136\uff0c\u8fd8\u6709\u5176\u4ed6\u63d2\u5165\u65b9\u5f0f\u53ef\u4ee5\u4f7f\u7528\uff0c\u5982\u4f7f\u7528Java\u4ee3\u7801\u751f\u6210UUID\u5e76\u5728\u7c7b\u4e2d\u663e\u5f0f\u8bbe\u7f6e\u503c\u7b49\u3002\u9700\u8981\u6839\u636e\u5177\u4f53\u5e94\u7528\u573a\u666f\u548c\u9700\u6c42\u9009\u62e9\u5408\u9002\u7684\u63d2\u5165\u65b9\u5f0f\u3002<\/li>\n<\/ul>\n
- Mybatis\u662f\u5c06\u81ea\u589e\u4e3b\u952e\u7684\u503c\u8bbe\u7f6e\u5230\u5b9e\u4f53\u7c7b\u5bf9\u8c61\u4e2d\uff0c\u800c\u4e0d\u662f\u4ee5Mapper\u63a5\u53e3\u65b9\u6cd5\u8fd4\u56de\u503c\u7684\u5f62\u5f0f\u8fd4\u56de\u3002<\/li>\n<\/ul>\n
- \u6709\u5f88\u591a\u96f6\u6563\u7684\u53c2\u6570\u9700\u8981\u4f20\u9012\uff0c\u4f46\u662f\u6ca1\u6709\u5bf9\u5e94\u7684\u5b9e\u4f53\u7c7b\u7c7b\u578b\u53ef\u4ee5\u4f7f\u7528\u3002\u4f7f\u7528@Param\u6ce8\u89e3\u4e00\u4e2a\u4e00\u4e2a\u4f20\u5165\u53c8\u592a\u9ebb\u70e6\u4e86\u3002\u6240\u4ee5\u90fd\u5c01\u88c5\u5230Map\u4e2d\u3002<\/li>\n<\/ul>\n
- \n
- Mybatis\u4f1a\u6839\u636e#{}\u4e2d\u4f20\u5165\u7684\u6570\u636e\uff0c\u52a0\u5de5\u6210getXxx()\u65b9\u6cd5\uff0c\u901a\u8fc7\u53cd\u5c04\u5728\u5b9e\u4f53\u7c7b\u5bf9\u8c61\u4e2d\u8c03\u7528\u8fd9\u4e2a\u65b9\u6cd5\uff0c\u4ece\u800c\u83b7\u53d6\u5230\u5bf9\u5e94\u7684\u6570\u636e\u3002\u586b\u5145\u5230#{}\u89e3\u6790\u540e\u7684\u95ee\u53f7\u5360\u4f4d\u7b26\u8fd9\u4e2a\u4f4d\u7f6e\u3002<\/li>\n<\/ul>\n
- mappers\uff08\u6620\u5c04\u5668\uff09<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
- settings\uff08\u8bbe\u7f6e\uff09<\/a><\/li>\n
![\"image-20240113152135218\"](\"http:\/\/zyg.luchers.cn\/wp-content\/uploads\/2024\/04\/image-20240113152135218.png\")
<\/div><\/p>\n![\"image-20240113155435396\"](\"http:\/\/zyg.luchers.cn\/wp-content\/uploads\/2024\/04\/image-20240113155435396.png\")
<\/div><\/p>\n![\"image-20240113155810512\"](\"http:\/\/zyg.luchers.cn\/wp-content\/uploads\/2024\/04\/image-20240113155810512.png\")
<\/div><\/p>\n![\"image-20240113155942170\"](\"http:\/\/zyg.luchers.cn\/wp-content\/uploads\/2024\/04\/image-20240113155942170.png\")
<\/div><\/p>\n