wuyouming666
2023-07-26 09a05342f4c60c834c3ee17a13529cd91c624f34
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
 
let str = window.location.href.substr(window.location.href.indexOf('?') + 1)
let json = new Object()
  const arr = str.split('&')
  for(let i = 0; i < arr.length; i++) {
    let item = arr[i].split('=')
    json[item[0]] = item[1]
}
 
var mixin={
    methods:{
        connects:function(gongneng,sql,flag,num){
          let param = new URLSearchParams(); 
          param.append("gongneng",gongneng);
          param.append("sql",sql);
          param.append("flag",flag);
          param.append("anquanma",json["anquanma"]);
              
          this.$http.post( '../mysqlInsert/mysql.jsp',param)
          .then(function (response) {
            if(num==1){
                  result=$(response.data).text();
                  index = result.indexOf("[[");
                  if(index>-1){
                      if(result.indexOf("[[anquanmaerr]]")>-1){
                            //alert('请先登录后操作');
                            window.parent.location.href='../login/index.jsp';
                      }else{
                          result=result.substring(index).trim()
                          alert(result);
                          window.location.reload();
                      }
                  }else{
                      alert(gongneng+"成功!")
                      window.location.reload();
                  }
              }
        })
        .catch(function (error) {
            alert('Error: ' + "服务器数据发生错误!"); 
        });
            
      },
      loadAjxss:function(gongneng,sql,flag,vals){
          let param = new URLSearchParams(); 
          param.append("yemian","123"); 
          param.append("gongneng",gongneng);
          param.append("sql",sql);
          param.append("flag",flag);
          param.append("anquanma",json["anquanma"]);
            this.$http.post( '../mysqlInsert/mysql.jsp',param
                )
            .then(function (response) {
                if(flag==2){
                    let result=$(response.data).text();
                    let index = result.indexOf("[{");
                    if(index>-1){
                        result=result.substring(index).trim();
                        app.$data[vals]=JSON.parse(result);
                        app.$data["loading"]=false;
                        console.log(vals+":");
                        console.log(app.$data[vals]);
                    }else if(result.indexOf("[[anquanmaerr]]")>-1){
                        //alert('请先登录后操作');
                        window.parent.location.href='../login/index.jsp';
                    }
                }
            })
            .catch(function (error) {
                alert('Error: ' + "服务器数据发生错误!"); 
            });
        }
    }
}
//gongneng:自定义,sql存储过程,flag标志(0,是用张工之前功能插入,1存储过程查询,2存储过程插入),vals:vue里data参数
function loadAjxs(gongneng,sql,flag,vals){
    
 
    $.post("../mysqlInsert/mysql.jsp",
              {"yemian":"123","gongneng":gongneng,"sql":sql,'flag':flag,'anquanma':json["anquanma"]},
              function(result){
            if(flag==2){
                result=$(result).text();
                index = result.indexOf("[{");
                if(index>-1){
                    result=result.substring(index).trim();
                    app.$data[vals]=JSON.parse(result);
                    console.log(vals+":");
                    console.log(app.$data[vals]);
                }else if(result.indexOf("[[anquanmaerr]]")>-1){
                    //alert('请先登录后操作');
                    window.parent.location.href='../login/index.jsp';
                }
            }
            
        })
         .fail(function(response) {
            alert('Error: ' + "服务器数据发生错误!"); 
        }); 
}