一. resultMap配置

1. resultMap解決實體類和數(shù)據(jù)庫字段名不一致的問題

二. resultMap配置例子

1. 新建一個名為MybatisResultMap的Java工程, 拷入相關jar包

2. 新建User.java

package com.lywgames.domain;import java.util.Date;public class User {private Integer user_id;private String user_name;private String sex;private Date birthday;private String address;public User() {}public User(String user_name, String sex, Date birthday, String address) {this.user_name = user_name;this.sex = sex;this.birthday = birthday;this.address = address;}public User(Integer user_id, String user_name, String sex, Date birthday, String address) {this.user_id = user_id;this.user_name = user_name;this.sex = sex;this.birthday = birthday;this.address = address;}public Integer getUser_id() {return user_id;}public void setUser_id(Integer user_id) {this.user_id = user_id;}public String getUser_name() {return user_name;}public void setUser_name(String user_name) {this.user_name = user_name;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}@Overridepublic String toString() {return "User [user_id=" + user_id + ", user_name=" + user_name + ", sex=" + sex + ", birthday=" + birthday + ", address=" + address+ "]";}}

3. 新建UserMapper.java接口

package com.lywgames.dao;import java.util.List; import com.lywgames.domain.User;public interface UserMapper {public List<User> selectUser(String name);public int insertUser(User user);public int updateUser(User user);public int deleteUser(String name); }

4. 在和UserMapper.java接口同一目錄下新建UserMapper.xml映射文件

5. 在src目錄下新建jdbc.properties數(shù)據(jù)庫屬性文件

6. 在src目錄下新建SqlMapConfig.xml數(shù)據(jù)庫配置文件

7. 新建Test.java

package com.lywgames;import java.io.InputStream; import java.util.Date; import java.util.List; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import com.lywgames.dao.UserMapper; import com.lywgames.domain.User;public class Test {public static void main(String[] args) {SqlSession sqlSession = null;try {// 指定全局配置文件String resource = "SqlMapConfig.xml";// 讀取配置文件InputStream inputStream = Resources.getResourceAsStream(resource);// 構建sqlSessionFactorySqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);// 獲取sqlSessionsqlSession = sqlSessionFactory.openSession();UserMapper userDao = sqlSession.getMapper(UserMapper.class);// 插入操作User insertUser = new User("李中", "男", new Date(System.currentTimeMillis()), "河南省鄭州市");int insertResult = userDao.insertUser(insertUser);System.out.println("插入操作影響行數(shù):" + insertResult);// 查詢操作List<User> users = userDao.selectUser("李");for (User user : users) {System.out.println(user);}// 更新操作User user = new User(4, "李苗", "女", null, null);int updateResult = userDao.updateUser(user);System.out.println("更新操作影響行數(shù):" + updateResult);// 刪除操作int deleteResult = userDao.deleteUser("英");System.out.println("刪除操作影響行數(shù):" + deleteResult);// 寫操作, 需要提交事務。sqlSession.commit();} catch (Exception e) {e.printStackTrace();} finally {if(sqlSession != null) {// 釋放資源sqlSession.close();}}} }

8. 查看user表數(shù)據(jù)

9. 運行項目

10. 運行項目后查看user表數(shù)據(jù)

總結

以上是生活随笔為你收集整理的04_resultMap配置的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。