项目二 BUG 与 方法

• 1.循环出现的时区bug找mysql的版本问题(time zone) mysql驱动改成5.1.47
• 2.yml配置文件,prefix要全文小写
• 3.typehandler

• package com.cskaoyan.typehandler;
  
  import com.fasterxml.jackson.core.JsonProcessingException;
  import com.fasterxml.jackson.databind.ObjectMapper;
  import org.apache.ibatis.type.JdbcType;
  import org.apache.ibatis.type.MappedJdbcTypes;
  import org.apache.ibatis.type.MappedTypes;
  import org.apache.ibatis.type.TypeHandler;
  
  import java.sql.CallableStatement;
  import java.sql.PreparedStatement;
  import java.sql.ResultSet;
  import java.sql.SQLException;
  
  /**
   * @BelongProject: mall35th
   * @BelongPackage: com.cskaoyan.typeHandler
   * @Author: zhiMing
   * @Createtime: 2021-11-30 14点29分
   * @Description: 字符串和整型数组的转换
   */
  @MappedTypes(Integer[].class)
  @MappedJdbcTypes(JdbcType.VARCHAR)
  public class IntegerArrayHandler implements TypeHandler<Integer[]> {
      ObjectMapper objectMapper = new ObjectMapper();
  
      @Override
      public void setParameter(PreparedStatement preparedStatement, int i, Integer[] input, JdbcType jdbcType) throws SQLException {
          try {
              String inputSting = objectMapper.writeValueAsString(input);
              preparedStatement.setString(i,inputSting);
          } catch (JsonProcessingException e) {
              e.printStackTrace();
          }
      }
  
      @Override
      public Integer[] getResult(ResultSet resultSet, String s) throws SQLException {
          String result = resultSet.getString(s);
          return transfer(result);
      }
  
      @Override
      public Integer[] getResult(ResultSet resultSet, int i) throws SQLException {
          String result = resultSet.getString(i);
          return transfer(result);
      }
  
      @Override
      public Integer[] getResult(CallableStatement callableStatement, int i) throws SQLException {
          String result = callableStatement.getString(i);
          return transfer(result);
      }
  
      private Integer[] transfer(String result){
          if (result == null || "".equals(result)){
              return new Integer[0];
          }
          Integer[] integers = null;
          try {
              integers = objectMapper.readValue(result, Integer[].class);
          } catch (JsonProcessingException e) {
              e.printStackTrace();
          }
          return integers;
      }
  }
  

• 与

• package com.cskaoyan.typehandler;
  
  import com.fasterxml.jackson.core.JsonProcessingException;
  import com.fasterxml.jackson.databind.ObjectMapper;
  import org.apache.ibatis.type.JdbcType;
  import org.apache.ibatis.type.MappedJdbcTypes;
  import org.apache.ibatis.type.MappedTypes;
  import org.apache.ibatis.type.TypeHandler;
  
  import java.sql.CallableStatement;
  import java.sql.PreparedStatement;
  import java.sql.ResultSet;
  import java.sql.SQLException;
  
  /**
   * @BelongProject: mall35th
   * @BelongPackage: com.cskaoyan.typeHandler
   * @Author: zijin
   * @Createtime: 2021-11-30 星期二 11:21
   * @Description: todo
   */
  @MappedTypes(String[].class)
  @MappedJdbcTypes(JdbcType.VARCHAR)
  public class StringArrayHandler implements TypeHandler<String[]> {
      ObjectMapper objectMapper = new ObjectMapper();
  
      @Override
      public void setParameter(PreparedStatement preparedStatement, int i, String[] input, JdbcType jdbcType) throws SQLException {
          try {
              String inputSting = objectMapper.writeValueAsString(input);
              preparedStatement.setString(i,inputSting);
          } catch (JsonProcessingException e) {
              e.printStackTrace();
          }
      }
  
      @Override
      public String[] getResult(ResultSet resultSet, String s) throws SQLException {
          String result = resultSet.getString(s);
          return transfer(result);
      }
  
      @Override
      public String[] getResult(ResultSet resultSet, int i) throws SQLException {
          String result = resultSet.getString(i);
          return transfer(result);
      }
  
      @Override
      public String[] getResult(CallableStatement callableStatement, int i) throws SQLException {
          String result = callableStatement.getString(i);
          return transfer(result);
      }
  
      private String[] transfer(String result){
          if (result == null || "".equals(result)){
              return new String[0];
          }
          String[] strings = null;
          try {
              strings = objectMapper.readValue(result, String[].class);
          } catch (JsonProcessingException e) {
              e.printStackTrace();
          }
          return strings;
      }
  }
  

• 4.时间返回有0000的时候,用Localdate类型
•         时间左切割

• LEFT ( date_format( add_time, '%Y-%m-%d' ), 10 )

• 5.AOP/ASPECTJ获得Request

•   ServletRequestAttributes requestAttributes = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
          HttpServletRequest servletRequest = requestAttributes.getRequest();
          HttpSession session = servletRequest.getSession();

• 6.逆向工程排序

•   example.setOrderByClause(baseParam.getSort() + " " + baseParam.getOrder());