1.4 MyBatis \u6846\u67b6\u6982\u8ff0<\/h4>\n
MyBatis \u662f\u4e00\u6b3e\u4f18\u79c0\u7684\u6301\u4e45\u5c42\u6846\u67b6，\u5b83\u5bf9 JDBC \u8fdb\u884c\u5c01\u88c5，\u8ba9\u5f00\u53d1\u8005\u53ea\u9700\u5173\u6ce8 SQL \u672c\u8eab，\u65e0\u9700\u5904\u7406\u6ce8\u518c\u9a71\u52a8\u3001\u521b\u5efa\u8fde\u63a5\u3001\u53c2\u6570\u8bbe\u7f6e\u3001\u7ed3\u679c\u96c6\u89e3\u6790\u7b49\u7e41\u7410\u64cd\u4f5c\u3002<\/p>\n
MyBatis \u524d\u8eab\u662f Apache \u7684 iBatis，2010 \u5e74\u8fc1\u79fb\u81f3 Google Code \u5e76\u66f4\u540d，\u6838\u5fc3\u5b9a\u4f4d\u662f\u7b80\u5316\u6570\u636e\u5e93\u64cd\u4f5c，\u4e13\u6ce8 SQL \u5c42\u5f00\u53d1\u3002<\/p>\n
\u4e8c\u3001MyBatis \u5165\u95e8\u6848\u4f8b<\/h3>\n2.1 \u73af\u5883\u51c6\u5907<\/h4>\n（1）Maven \u4f9d\u8d56\u914d\u7f6e（pom.xml）<\/h5>\n
（1）Maven \u4f9d\u8d56\u914d\u7f6e（pom.xml）<\/h5>\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><\/p>\n
<groupId>com.hg<\/groupId>
\n <artifactId>01_mybatis_HelloWorld<\/artifactId>
\n <version>1.0-SNAPSHOT<\/version><\/p>\n
<properties>
\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>
\n <project.reporting.outputEncoding>UTF-8<\/project.reporting.outputEncoding>
\n <maven.compiler.source>8<\/maven.compiler.source>
\n <maven.compiler.target>8<\/maven.compiler.target>
\n <\/properties><\/p>\n
<dependencies>
\n <!– MyBatis\u6838\u5fc3\u4f9d\u8d56 –>
\n <dependency>
\n <groupId>org.mybatis<\/groupId>
\n <artifactId>mybatis<\/artifactId>
\n <version>3.4.5<\/version>
\n <\/dependency>
\n <!– MySQL\u9a71\u52a8 –>
\n <dependency>
\n <groupId>mysql<\/groupId>
\n <artifactId>mysql-connector-java<\/artifactId>
\n <version>5.1.47<\/version>
\n <\/dependency>
\n <!– \u65e5\u5fd7\u4f9d\u8d56 –>
\n <dependency>
\n <groupId>log4j<\/groupId>
\n <artifactId>log4j<\/artifactId>
\n <version>1.2.17<\/version>
\n <\/dependency>
\n <!– \u5355\u5143\u6d4b\u8bd5 –>
\n <dependency>
\n <groupId>junit<\/groupId>
\n <artifactId>junit<\/artifactId>
\n <version>4.12<\/version>
\n <\/dependency>
\n <\/dependencies><\/p>\n
<build>
\n <!– \u52a0\u8f7djava\u76ee\u5f55\u4e0b\u7684xml\u914d\u7f6e\u6587\u4ef6 –>
\n <resources>
\n <resource>
\n <directory>src\/main\/java<\/directory>
\n <includes>
\n <include>**\/*.xml<\/include>
\n <\/includes>
\n <\/resource>
\n <\/resources>
\n <\/build>
\n<\/project><\/p>\n
（2）\u65e5\u5fd7\u914d\u7f6e（log4j.properties）<\/h5>\n
properties<\/p>\n
# Global logging configuration
\nlog4j.rootLogger=DEBUG, stdout
\n# Console output
\nlog4j.appender.stdout=org.apache.log4j.ConsoleAppender
\nlog4j.appender.stdout.layout=org.apache.log4j.PatternLayout
\nlog4j.appender.stdout.layout.ConversionPattern=%5p [%t] – %m%n<\/p>\n
2.2 \u6838\u5fc3\u4ee3\u7801\u5b9e\u73b0<\/h4>\n（1）\u5b9e\u4f53\u7c7b（User.java）<\/h5>\n
public class User implements Serializable {
\n private Integer id;
\n private String username;
\n private Date birthday;
\n private String sex;
\n private String address;<\/p>\n
\/\/ Getter & Setter
\n public Integer getId() { return id; }
\n public void setId(Integer id) { this.id = id; }
\n public String getUsername() { return username; }
\n public void setUsername(String username) { this.username = username; }
\n public Date getBirthday() { return birthday; }
\n public void setBirthday(Date birthday) { this.birthday = birthday; }
\n public String getSex() { return sex; }
\n public void setSex(String sex) { this.sex = sex; }
\n public String getAddress() { return address; }
\n public void setAddress(String address) { this.address = address; }<\/p>\n
@Override
\n public String toString() {
\n return "User{" +
\n "id=" + id +
\n ", username='" + username + '\\\\'' +
\n ", birthday=" + birthday +
\n ", sex='" + sex + '\\\\'' +
\n ", address='" + address + '\\\\'' +
\n '}';
\n }
\n}<\/p>\n
（2）DAO \u63a5\u53e3（UserMapper.java）<\/h5>\n
public interface UserMapper {
\n \/**
\n * \u67e5\u8be2\u6240\u6709\u7528\u6237
\n * @return \u7528\u6237\u5217\u8868
\n *\/
\n public List<User> findAll();
\n}<\/p>\n
（3）Mapper \u6620\u5c04\u6587\u4ef6（UserMapper.xml）<\/h5>\n
<?xml version="1.0" encoding="UTF-8"?>
\n<!DOCTYPE mapper
\n PUBLIC "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN"
\n "http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd">
\n<!– namespace：\u63a5\u53e3\u5168\u7c7b\u540d –>
\n<mapper namespace="com.hg.dao.UserMapper">
\n <!–
\n id：\u63a5\u53e3\u65b9\u6cd5\u540d
\n resultType：\u8fd4\u56de\u503c\u7c7b\u578b
\n –>
\n <select id="findAll" resultType="com.hg.pojo.User">
\n select * from user
\n <\/select>
\n<\/mapper><\/p>\n
（4）MyBatis \u6838\u5fc3\u914d\u7f6e（mybatis-config.xml）<\/h5>\n
<?xml version="1.0" encoding="UTF-8"?>
\n<!DOCTYPE configuration PUBLIC "-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN" "http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd">
\n<configuration>
\n <!– \u73af\u5883\u914d\u7f6e –>
\n <environments default="dev">
\n <environment id="dev">
\n <!– \u4e8b\u52a1\u7ba1\u7406：JDBC\u539f\u751f\u4e8b\u52a1 –>
\n <transactionManager type="JDBC"><\/transactionManager>
\n <!– \u6570\u636e\u6e90：\u8fde\u63a5\u6c60 –>
\n <dataSource type="POOLED">
\n <property name="driver" value="com.mysql.jdbc.Driver"\/>
\n <property name="url" value="jdbc:mysql:\/\/127.0.0.1:3306\/mybatis?useSSL=false&serverTimezone=Asia\/Shanghai&characterEncoding=UTF-8"\/>
\n <property name="username" value="root"\/>
\n <property name="password" value="1111"\/>
\n <\/dataSource>
\n <\/environment>
\n <\/environments>
\n <!– \u52a0\u8f7dMapper\u6620\u5c04\u6587\u4ef6 –>
\n <mappers>
\n <mapper resource="com\/hg\/dao\/UserMapper.xml"\/>
\n <\/mappers>
\n<\/configuration><\/p>\n
2.3 \u6d4b\u8bd5\u4ee3\u7801<\/h4>\n
public class MyBatisTest {<\/p>\n
private InputStream inputStream;
\n private SqlSession sqlSession;<\/p>\n
@Before
\n public void createSqlSession() throws IOException {
\n \/\/ 1.\u52a0\u8f7d\u914d\u7f6e\u6587\u4ef6
\n String resource = "mybatis-config.xml";
\n inputStream = Resources.getResourceAsStream(resource);<\/p>\n
\/\/ 2.\u521b\u5efaSqlSessionFactory
\n SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);<\/p>\n
\/\/ 3.\u83b7\u53d6SqlSession
\n sqlSession = sqlSessionFactory.openSession();
\n }<\/p>\n
@Test
\n public void testFindAll(){
\n \/\/ 4.\u83b7\u53d6Mapper\u4ee3\u7406\u5bf9\u8c61
\n UserDao userDao = sqlSession.getMapper(UserMapper.class);<\/p>\n
\/\/ 5.\u6267\u884c\u67e5\u8be2
\n List<User> userList = userMapper.findAll();<\/p>\n
\/\/ 6.\u8f93\u51fa\u7ed3\u679c
\n for(User user : userList) {
\n System.out.println(user);
\n }
\n }<\/p>\n
@After
\n public void closeSqlSession() throws IOException {
\n \/\/ 7.\u91ca\u653e\u8d44\u6e90
\n sqlSession.close();
\n inputStream.close();
\n }
\n}<\/p>\n
2.4 MyBatis \u8fd0\u884c\u539f\u7406<\/h4>\n
MyBatis \u6267\u884c\u6d41\u7a0b\u6838\u5fc3 8 \u6b65：<\/p>\n
![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/03\/20260304130124-69a82d24e21c1.png\")
<\/p>\n
\u4e09\u3001MyBatis \u6838\u5fc3 CRUD \u64cd\u4f5c<\/h3>\n3.1 \u67e5\u8be2\u64cd\u4f5c<\/h4>\n（1）\u5355\u4e2a\u53c2\u6570\u67e5\u8be2<\/h5>\n
（1）\u5355\u4e2a\u53c2\u6570\u67e5\u8be2<\/h5>\n
\/\/ DAO\u63a5\u53e3
\npublic User findUserById(Integer id);<\/p>\n
<!– Mapper\u914d\u7f6e –>
\n<select id="findUserById" parameterType="java.lang.Integer" resultType="com.hg.pojo.User">
\n select * from user where id=#{id}
\n<\/select><\/p>\n
（2）\u591a\u53c2\u6570\u67e5\u8be2<\/h5>\n\u65b9\u5f0f 1：\u5e8f\u53f7\u7ed1\u5b9a<\/h6>\n
public User findUserByIdAndName(Integer id, String username);<\/p>\n
<select id="findUserByIdAndName" resultType="com.hg.pojo.User">
\n SELECT * FROM user WHERE id = #{arg0} AND username = #{arg1}
\n <!– \u6216\u4f7f\u7528param1\/param2：WHERE id = #{param1} AND username = #{param2} –>
\n<\/select><\/p>\n
\u65b9\u5f0f 2：\u6ce8\u89e3\u7ed1\u5b9a<\/h6>\n
public User findUserByIdAndName2(@Param("id") Integer id, @Param("username")String username);<\/p>\n
<select id="findUserByIdAndName2" resultType="com.hg.pojo.User">
\n SELECT * FROM user WHERE id = #{id} AND username = #{username}
\n<\/select><\/p>\n
\u65b9\u5f0f 3：\u5bf9\u8c61\u7ed1\u5b9a<\/h6>\n
public User findUserByUserInfo(User user);<\/p>\n
<select id="findUserByUserInfo" parameterType="com.hg.pojo.User" resultType="com.hg.pojo.User">
\n SELECT * FROM user WHERE id = #{id} AND username = #{username}
\n<\/select><\/p>\n
\u65b9\u5f0f 4：Map \u7ed1\u5b9a<\/h6>\n
public User findUserByMap(Map<String, Object> map);<\/p>\n
<select id="findUserByMap" parameterMap="java.util.Map" resultType="com.hg.pojo.User">
\n SELECT * FROM user WHERE id = #{id} AND username = #{username}
\n<\/select><\/p>\n
（3）\u6a21\u7cca\u67e5\u8be2<\/h5>\n
public List<User> findUserByName(String username);<\/p>\n
<select id="findUserByName" parameterType="string" resultType="com.hg.pojo.User">
\n <!– \u63a8\u8350\u65b9\u5f0f：\u9632\u6b62SQL\u6ce8\u5165 –>
\n select * from user where username like concat('%',#{username},'%')
\n <!– \u6216：select * from user where username like '%${value}%' –>
\n<\/select><\/p>\n
（4）\u805a\u5408\u51fd\u6570\u67e5\u8be2<\/h5>\n
public Integer getTotal();<\/p>\n
<select id="getTotal" resultType="int">
\n SELECT COUNT(id) FROM user
\n<\/select><\/p>\n
3.2 \u5220\u9664\u64cd\u4f5c<\/h4>\n
public void deleteUserById(Integer id);<\/p>\n
<delete id="deleteUserById" parameterType="Integer">
\n DELETE FROM user WHERE id = #{id}
\n<\/delete><\/p>\n
\/\/ \u6d4b\u8bd5\u4ee3\u7801
\n@Test
\npublic void testDeleteUserById(){
\n UserDao userDao = sqlSession.getMapper(UserDao.class);
\n userDao.deleteUserById(41);
\n sqlSession.commit(); \/\/ \u624b\u52a8\u63d0\u4ea4\u4e8b\u52a1
\n}<\/p>\n
3.3 \u4fee\u6539\u64cd\u4f5c<\/h4>\n
public void updateUserById(User user);<\/p>\n
<update id="updateUserById" parameterType="com.hg.pojo.User">
\n update user set username=#{username},password=#{password},
\n birthday=#{birthday},sex=#{sex},address=#{address} where id=#{id}
\n<\/update><\/p>\n
@Test
\n public void testUpdateUserById(){
\n User userParam = new User();
\n userParam.setId(41);
\n userParam.setUsername("\u5434\u5f66\u7956");
\n userParam.setSex("\u7537");
\n userParam.setAddress("\u4e2d\u56fd");
\n userParam.setBirthday(new Date());
\n userMapper.updateUserById(userParam);
\n }<\/p>\n
3.4 \u65b0\u589e\u64cd\u4f5c（\u542b\u4e3b\u952e\u56de\u586b）<\/h4>\n
public void insertUser(User user);<\/p>\n
<insert id="insertUser" useGeneratedKeys="true" keyProperty="id" parameterType="com.hg.pojo.User">
\n insert into user(username,password,birthday,sex,address)
\n values(#{username},#{password},#{birthday},#{sex},#{address})
\n<\/insert><\/p>\n
@Test
\npublic void testInsertUser(){
\n UserDao userDao = sqlSession.getMapper(UserDao.class);
\n User user = new User();
\n user.setUsername("\u5218\u5fb7\u534e");
\n user.setPassword("111");
\n user.setBirthday(new Date());
\n user.setSex("\u7537");
\n user.setAddress("\u9999\u6e2f");
\n userDao.insertUser(user);
\n System.out.println("\u65b0\u589e\u8bb0\u5f55\u7684id\u503c："+user.getId()); \/\/ \u83b7\u53d6\u81ea\u589e\u4e3b\u952e
\n sqlSession.commit();
\n}<\/p>\n
3.5 #{} vs ${} \u6838\u5fc3\u533a\u522b<\/h4>\n
| \u672c\u8d28<\/td>\n | \u9884\u7f16\u8bd1\u5360\u4f4d\u7b26<\/td>\n | SQL \u5b57\u7b26\u4e32\u62fc\u63a5<\/td>\n<\/tr>\n | ||||||||||||
| \u7c7b\u578b\u8f6c\u6362<\/td>\n | \u81ea\u52a8 Java\/JDBC \u7c7b\u578b\u8f6c\u6362<\/td>\n | \u65e0\u7c7b\u578b\u8f6c\u6362<\/td>\n<\/tr>\n | ||||||||||||
| SQL \u6ce8\u5165<\/td>\n | \u53ef\u9632\u6b62\u6ce8\u5165<\/td>\n | \u5b58\u5728\u6ce8\u5165\u98ce\u9669<\/td>\n<\/tr>\n | ||||||||||||
| \u53c2\u6570\u7ed1\u5b9a<\/td>\n | \u652f\u6301\u4efb\u610f\u53c2\u6570\u540d（\u5355\u4e2a\u53c2\u6570\u53ef\u5199 value）<\/td>\n | \u5355\u4e2a\u53c2\u6570\u53ea\u80fd\u5199 value<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\u56db\u3001\u81ea\u5b9a\u4e49 MyBatis（\u6838\u5fc3\u539f\u7406\u5256\u6790）<\/h3>\n |
| \u4ee3\u7801\u91cf<\/td>\n | \u9700\u624b\u52a8\u5b9e\u73b0 DAO \u7c7b<\/td>\n | \u4ec5\u9700\u63a5\u53e3 + Mapper，\u81ea\u52a8\u751f\u6210\u4ee3\u7406<\/td>\n<\/tr>\n |
| \u7ef4\u62a4\u6210\u672c<\/td>\n | \u9ad8（SQL \u4e0e\u4ee3\u7801\u8026\u5408）<\/td>\n | \u4f4e（SQL \u96c6\u4e2d\u914d\u7f6e）<\/td>\n<\/tr>\n |
| \u5f00\u53d1\u6548\u7387<\/td>\n | \u4f4e<\/td>\n | \u9ad8<\/td>\n<\/tr>\n |
| \u4e3b\u6d41\u7a0b\u5ea6<\/td>\n | \u51e0\u4e4e\u6dd8\u6c70<\/td>\n | \u76ee\u524d\u4e3b\u6d41<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\u516d\u3001\u603b\u7ed3<\/h3>\nMyBatis \u4f5c\u4e3a\u8f7b\u91cf\u7ea7\u6301\u4e45\u5c42\u6846\u67b6，\u6838\u5fc3\u4f18\u52bf\u5728\u4e8e：<\/p>\n \u638c\u63e1 MyBatis \u6838\u5fc3\u539f\u7406，\u4e0d\u4ec5\u80fd\u719f\u7ec3\u4f7f\u7528\u6846\u67b6，\u66f4\u80fd\u7406\u89e3\u5176\u8bbe\u8ba1\u601d\u60f3，\u4e3a\u89e3\u51b3\u590d\u6742\u4e1a\u52a1\u573a\u666f\u6253\u4e0b\u57fa\u7840\u3002<\/p>\n \n \u5982\u679c\u672c\u6587\u5bf9\u4f60\u6709\u5e2e\u52a9，\u8bb0\u5f97\u6536\u85cf\u3001\u70b9\u8d5e\u3001\u5173\u6ce8~~~<\/p>\n","protected":false},"excerpt":{"rendered":" \u4e00\u3001MyBatis \u6838\u5fc3\u4ecb\u7ecd1.1 \u4ec0\u4e48\u662f\u6846\u67b6\u6846\u67b6（Framework）\u662f\u8f6f\u4ef6\u5f00\u53d1\u7684 \\”\u534a\u6210\u54c1\\”，\u5b83\u5c01\u88c5\u4e86\u57fa\u7840\u4ee3\u7801\u5e76\u63d0\u4f9b\u6807\u51c6\u5316 API，\u5f00\u53d1\u8005\u57fa\u4e8e\u6846\u67b6\u5f00\u53d1\u53ef\u7701\u53bb\u91cd\u590d\u7f16\u7801\u5de5\u4f5c，\u5927\u5e45\u63d0\u5347\u5f00\u53d1\u6548\u7387\u3002\u5982\u679c\u628a\u6210\u54c1\u8f6f\u4ef6\u6bd4\u4f5c\u88c5\u4fee\u597d\u7684\u65b0\u623f，\u6846\u67b6\u5c31\u50cf\u6bdb\u576f\u623f \u2014\u2014 \u63d0\u4f9b\u57fa\u7840\u7ed3\u6784，\u4fdd\u8bc1\u6838\u5fc3\u8d28\u91cf，\u5f00\u53d1\u8005\u53ea\u9700\u4e13\u6ce8\u4e8e\u4e1a\u52a1\u903b\u8f91（\u88c5\u4fee）\u5373\u53ef\u30021.2 \u6846\u67b6\u8981\u89e3\u51b3\u7684\u6838\u5fc3\u95ee\u9898<\/p>\n","protected":false},"author":2,"featured_media":80278,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[99,1769,190],"topic":[],"class_list":["post-80279","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-java","tag-mybatis","tag-190"],"yoast_head":"\n |