Mybatis学习记录-增删改查问题总结之一

1.运行环境:

• JDK1.8
• MyBatis 3.3.0
• MySql 5.7.21(运行于Centos 7)
• Eclipse 4.4.0
• Apache Maven构建工具

2.问题点

　　链接字符串: jdbc:mysql://192.168.100.139:3306/mybatis?useSSL=false&characterEncoding=UTF-8

• MyBatis配置JDBC链接MySql字符串需要添加SSL设定(useSSL=false)，不然有如下警告

  WARN: Establishing SSL connection without server's identity verification is not recommended. 
  According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. 
  For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. 
  You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

• 再配置Update 语句完成后，使用测试方法测试时，出现中文乱码问题

      public void testUpdate(){
          //获取Session
          SqlSession sqlSession = getSqlSession();
          try {
              //获取UserMapper接口
              UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
              //从数据库查询id = 1的用户
              SysUser user = userMapper.selectById(1l);
              TestCase.assertEquals("admin", user.getUserName());
              user.setUserName("admin_test");
              user.setUserEmail("test@mybatis.tk");
              int result = userMapper.update(user);
              TestCase.assertEquals(1, result);
              //再次从数据库查询id = 1的用户
              user = userMapper.selectById(1l);
              //userName = admin_test
              TestCase.assertEquals("admin_test", user.getUserName());
          } finally {
              sqlSession.commit();
              // 不要忘记关闭sqlSession
              sqlSession.close();
          }
      }

• 特别说明，首次selectById并不会出现中文乱码，是在update资料过后再次执行selectById才会出现中文乱码。 解决方案:jdbc链接字符串加上&characterEncoding=UTF-8，因为是在XML中设定的，其中&amp为&的转义字符。