测试mybatis原生

lxw

2023-10-16 f23f7f8794e4b3a7705b2359eb9102d7aa8fda86

测试mybatis原生

 src/main/java/com/whyc/service/MybatisSqlExecuteService.java

@@ -1,6 +1,7 @@
package com.whyc.service;

import com.whyc.mapper.CallBack;
import com.whyc.util.ActionUtil;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import org.apache.ibatis.session.SqlSession;
@@ -9,10 +10,8 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.swing.*;
import java.sql.*;
import java.util.List;

@Service
@@ -34,8 +33,15 @@
            while (rs.next()) {
                JSONObject jsonObject = new JSONObject();
                for(int i=1;i<=colCnt;i++){
                    jsonObject.put(metaData.getColumnName(i),rs.getObject(i));
                    String property=metaData.getColumnName(i);
                    Object obj=rs.getObject(i);
                    if(obj instanceof java.util.Date ){
                        jsonObject.put(property, ActionUtil.sdf.format(obj));
                    }else{
                        jsonObject.put(property,obj);
                    }
                }
                JSONObject.toBean(jsonObject,Object.class);
                jsonArray.add(jsonObject);
            }
        } catch (SQLException throwables) {
@@ -46,6 +52,51 @@
        return jsonArray;
    }

    //    自定义执行SQL
    public List executeQuery_call(String sql, CallBack call){
        PreparedStatement ps = null;
        ResultSet rs = null;
        SqlSession sqlSession = openSession();
        try {
            ps=sqlSession.getConnection().prepareStatement(sql);
            rs=ps.executeQuery();
            return call.getResults(rs);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {
            closeSession(rs,ps,sqlSession);
        }
        return null;
    }

    /**
     * 封装所有更新的操作(添加,删除,修改)
     * @param sql
     * @param values
     * @return
     */
    public  boolean executeUpdate(String sql, Object[] values){
        PreparedStatement ps = null;
        ResultSet rs = null;
        SqlSession sqlSession = openSession();
        try {
            ps = sqlSession.getConnection().prepareStatement(sql);
            if(values != null){
                for (int i = 0; i < values.length; i++) {
                    ps.setObject(i+1, values[i]);
                }
            }
            int flag =  ps.executeUpdate();
            if(flag>0){
                return true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            closeSession(rs,ps,sqlSession);
        }
        return false;
    }
    //    开启链接
    private SqlSession openSession() {
        SqlSessionFactory sqlSessionFactory = sqlSessionTemplate.getSqlSessionFactory();

 src/main/java/com/whyc/service/StandardFeatureCurveService.java

@@ -1,9 +1,12 @@
package com.whyc.service;

import cn.hutool.json.JSONUtil;
import com.whyc.dto.StandardFeatureCurve;
import com.whyc.mapper.CallBack;
import com.whyc.mapper.CommonMapper;
import com.whyc.mapper.StandardFeatureCurveMapper;
import com.whyc.pojo.Battinf;
import net.sf.json.JSONArray;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.*;
import org.springframework.beans.factory.annotation.Autowired;
@@ -12,8 +15,6 @@

import javax.annotation.Resource;
import java.io.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.stream.Collectors;
@@ -94,7 +95,7 @@
    //测试mybatisDb
    public List testTableDb(String va, String c) {
        String sql="select * from `web_site`.`tb_standard_feature_curve_"+va+"_"+c+"`";
        List<StandardFeatureCurve> list=sqlExecuteService.executeQuery(sql);
        List<StandardFeatureCurve> list = sqlExecuteService.executeQuery(sql);
        return  list;
    }
}