连接SQL，操作数据库实例（二）

最新推荐文章于 2023-03-08 22:22:58 发布
最新推荐文章于 2023-03-08 22:22:58 发布
阅读量1k 收藏
点赞数
分类专栏： ABAP 文章标签： sql 数据库 date sap table insert
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/myliulongtao/article/details/3227264
版权

*&---------------------------------------------------------------------*
*& Report  ZISD0065                                                    *
*&                                                                     *
*&---------------------------------------------------------------------*
*& Author:   vista                                                     *
*& Date  :   2008-10-27
*& Request:  "DEVK925889                                               *
*&---------------------------------------------------------------------*

REPORT  ZISD0065                                .

TYPE-POOLS: SLIS .

************************************************************************
************************************************************************
*  D E C L A R A T I O N
************************************************************************
************************************************************************

TABLES: VBAK,LIPS,LIKP,MKPF,MSEG.

DATA: BEGIN OF ITAB OCCURS 0,
        WERKS LIKE LIPS-WERKS,                  "Plant
        MATNR LIKE LIPS-MATNR,                  "Material No
        VBELN LIKE LIPS-VBELN,                  "DN
        POSNR LIKE LIPS-POSNR,                  "DN Item
        KUNNR LIKE LIKP-KUNNR,                  "Ship to party
*        LFIMG LIKE LIPS-LFIMG,                  "Delivery qty
        KCMENG LIKE LIPS-KCMENG,                 "Delivery qty by item
*        DNQTY(13) TYPE P DECIMALS 3,            "Total DN Qty
        WADAT_IST  LIKE LIKP-WADAT_IST,         "Ship Out Date
        CPUTM LIKE MKPF-CPUTM,                  "Ship Time
      END OF ITAB.


DATA: BEGIN OF DTAB OCCURS 0,
        WERKS LIKE LIPS-WERKS,                  "Plant
        MATNR LIKE LIPS-MATNR,                  "Material No
        VBELN LIKE LIPS-VBELN,                  "DN
        POSNR LIKE LIPS-POSNR,                  "DN Item
        KUNNR LIKE LIKP-KUNNR,                  "Ship to party
*        LFIMG LIKE LIPS-LFIMG,                  "Delivery qty
        KCMENG LIKE LIPS-KCMENG,                 "Delivery qty by item
*        DNQTY(15) TYPE P DECIMALS 3,            "Total DN Qty
        WADAT_IST  LIKE LIKP-WADAT_IST,         "Ship Out Date
        CPUTM LIKE MKPF-CPUTM,                  "Ship Time
      END OF DTAB.

DATA: BEGIN OF KTAB OCCURS 0,
        WERKS LIKE LIPS-WERKS,                  "Plant
        MATNR LIKE LIPS-MATNR,                  "Material No
        VBELN LIKE LIPS-VBELN,                  "DN
        POSNR LIKE LIPS-POSNR,                  "DN Item
        KUNNR LIKE LIKP-KUNNR,                  "Ship to party
*        LFIMG LIKE LIPS-LFIMG,                  "Delivery qty
        KCMENG LIKE LIPS-KCMENG,                "Delivery qty by item
*        DNQTY(15) TYPE P DECIMALS 3,            "Total DN Qty
        WADAT_IST LIKE LIKP-WADAT_IST,         "Ship Out Date
        CPUTM LIKE MKPF-CPUTM,                  "Ship Time
        AUART LIKE VBAK-AUART,                  "SO Type
      END OF KTAB.

DATA: BEGIN OF TTAB OCCURS 0,
        MENGE LIKE MSEG-MENGE,
        WERKS LIKE MSEG-WERKS,
        BWART LIKE MSEG-BWART,
        LGORT LIKE MSEG-LGORT,
        SHKZG LIKE MSEG-SHKZG,
        BUDAT LIKE MKPF-BUDAT,
      END OF TTAB.


DATA: BEGIN OF TIBL OCCURS 0,
        PO_REL TYPE I,
        WIP TYPE I,
        REJECT TYPE I,
        SPECIAL_OPEN TYPE I,
        SPECIAL_CLOSE TYPE I,
        IBL_SHIP_TO_VW TYPE I,
        IBL_SHIP_TO_OTH TYPE I,
        IBL_VW_SHIP_OUT TYPE I,
        SAP_SHIP_TO_VW TYPE I,
        SAP_SHIP_TO_OTH TYPE I,
        SAP_VW_SHIP_OUT TYPE I,
        FG TYPE I,
        VW_MOVE_OUT TYPE I,
        FROM_DATE(20),
        TO_DATE(20),
        CUR_DATE(20),
      END OF TIBL.


DATA: BEGIN OF TAB1 OCCURS 0,
        CURR_DATE(10) TYPE C,
        DNQTY1 TYPE I,
        DNQTY2 TYPE I,
        DNQTY3 TYPE I,
        DNQTY4 TYPE I,
      END OF TAB1.


DATA: DNQTY1(15) TYPE P DECIMALS 3,
      DNQTY2(15) TYPE P DECIMALS 3,
      DNQTY3(15) TYPE P DECIMALS 3,
      DNQTY4(15) TYPE P DECIMALS 3.

DATA: FMDATE(12) TYPE C,
      ENDATE(12) TYPE C.

DATA: WA_TAB1 LIKE TAB1.

*&---------------------------------------------------------------------*
*&                      S E L E C T I O N  S C R E E N                 *
*&---------------------------------------------------------------------*

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-000.
SELECT-OPTIONS: S_DATE FOR LIKP-WADAT_IST,
                S_TIME FOR MKPF-CPUTM.
SELECTION-SCREEN END OF BLOCK B1.


*----------------------------------------------------------------------*
*  Macro Definition                                                    *
*----------------------------------------------------------------------*
*  Get SQL Query result
DEFINE IBL_FETCH_DATA.

  TRY.
      EXEC SQL.
        FETCH NEXT &3 INTO :&1
      ENDEXEC.

    CATCH CX_SY_NATIVE_SQL_ERROR.
      &2 = '99'.
  ENDTRY.

  IF &2 NE 99.
    &2 = SY-SUBRC.
  ENDIF.

END-OF-DEFINITION.

*  Close SQL Cursor
DEFINE IBL_CLOSE_CURSOR.

  TRY.
      EXEC SQL.
        CLOSE &1
      ENDEXEC.

    CATCH CX_SY_NATIVE_SQL_ERROR.
      &2 = '99'.
  ENDTRY.

  IF &2 NE 99.
    &2 = SY-SUBRC.
  ENDIF.

END-OF-DEFINITION.


*----------------------------------------------------------------------*
*        INITIALIZATION                                                *
*----------------------------------------------------------------------*

INITIALIZATION.

*----------------------------------------------------------------------*
*        START-OF-SELECTION                                            *
*----------------------------------------------------------------------*
START-OF-SELECTION.

  PERFORM GET_DATA.

*----------------------------------------------------------------------*
*        END-OF-SELECTION                                              *
*----------------------------------------------------------------------


*&---------------------------------------------------------------------*
*&      Form  GET_DATA
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  -->  p1        text
*  <--  p2        text
*----------------------------------------------------------------------*
FORM GET_DATA .

**from date
  CONCATENATE  S_DATE-LOW(4) '-' S_DATE-LOW+4(2) '-' S_DATE-LOW+6(2)
              INTO FMDATE.
**end  date
  CONCATENATE  S_DATE-HIGH(4) '-' S_DATE-HIGH+4(2) '-' S_DATE-HIGH+6(2)
                 INTO ENDATE.


*SAP SHIP TO VW QTY
  SELECT SUM( LIPS~KCMENG ) AS KCMENG LIKP~WADAT_IST
*  MKPF~CPUTM LIPS~WERKS LIPS~VBELN LIPS~POSNR LIPS~MATNR
         INTO CORRESPONDING FIELDS OF TABLE ITAB
         FROM LIPS
         INNER JOIN LIKP ON LIKP~VBELN = LIPS~VBELN
         INNER JOIN MKPF ON MKPF~XBLNR = LIPS~VBELN
         WHERE LIKP~KUNNR = '0000088888'
         AND LIKP~WADAT_IST IN S_DATE
         AND MKPF~CPUTM IN S_TIME
         GROUP BY LIKP~WADAT_IST.


*SAP SHIP TO OTH QTY
  SELECT   SUM( LIPS~KCMENG ) AS KCMENG
           LIKP~WADAT_IST
*          MKPF~CPUTM LIPS~WERKS LIPS~VBELN
*          LIPS~POSNR LIPS~MATNR
         INTO CORRESPONDING FIELDS OF TABLE DTAB
         FROM LIPS
         INNER JOIN LIKP ON LIKP~VBELN = LIPS~VBELN
         INNER JOIN MKPF ON MKPF~XBLNR = LIPS~VBELN
         WHERE LIKP~KUNNR <> '0000088888'
         AND LIKP~WADAT_IST IN S_DATE
         AND MKPF~CPUTM IN S_TIME
         GROUP BY LIKP~WADAT_IST.


*SAP VW SHIP OUT QTY
  SELECT SUM( LIPS~KCMENG ) AS KCMENG LIKP~WADAT_IST
*        MKPF~CPUTM LIPS~WERKS LIPS~VBELN
*        LIPS~POSNR LIPS~MATNR VBAK~AUART
         INTO CORRESPONDING FIELDS OF TABLE KTAB
         FROM LIPS
         INNER JOIN LIKP ON LIKP~VBELN = LIPS~VBELN
         INNER JOIN MKPF ON MKPF~XBLNR = LIPS~VBELN
         INNER JOIN VBAK ON VBAK~VBELN = LIPS~KDAUF
         WHERE LIKP~KUNNR <> '0000088888'
         AND VBAK~AUART = 'SHIP'
         AND LIKP~WADAT_IST IN S_DATE
         AND MKPF~CPUTM IN S_TIME
         GROUP BY LIKP~WADAT_IST.


*VW MOVE OUT QTY
  SELECT SUM( MSEG~MENGE ) AS MENGE MKPF~BUDAT
  INTO CORRESPONDING FIELDS OF TABLE TTAB
  FROM MSEG
  INNER JOIN MKPF ON MKPF~MBLNR = MSEG~MBLNR
                  AND MKPF~MJAHR = MSEG~MJAHR
  WHERE MKPF~BUDAT IN S_DATE AND MKPF~CPUTM IN S_TIME
  AND MSEG~BWART = '601'
  AND MSEG~SHKZG = 'H'
  GROUP BY MKPF~BUDAT.


  IF ITAB[] IS NOT INITIAL.
    LOOP AT ITAB.
      TAB1-DNQTY1 = ITAB-KCMENG.
      TAB1-CURR_DATE = ITAB-WADAT_IST.
      APPEND TAB1.
      CLEAR TAB1.
    ENDLOOP.
  ENDIF.

  IF DTAB[] IS NOT INITIAL.
    LOOP AT DTAB.
      TAB1-DNQTY2 = DTAB-KCMENG.
      TAB1-CURR_DATE = DTAB-WADAT_IST.
      APPEND TAB1.
      CLEAR TAB1.
    ENDLOOP.
  ENDIF.

  IF KTAB[] IS NOT INITIAL.
    LOOP AT KTAB.
      TAB1-DNQTY3 = KTAB-KCMENG.
      TAB1-CURR_DATE = KTAB-WADAT_IST.
      APPEND TAB1.
      CLEAR TAB1.
    ENDLOOP.
  ENDIF.

  IF TTAB[] IS NOT INITIAL.
    LOOP AT TTAB.
      TAB1-DNQTY4 = TTAB-MENGE.
      TAB1-CURR_DATE = TTAB-BUDAT.
      APPEND TAB1.
      CLEAR TAB1.
    ENDLOOP.
  ENDIF.

  IF TAB1[] IS NOT INITIAL.
    LOOP AT TAB1.
      READ TABLE ITAB WITH KEY WADAT_IST = TAB1-CURR_DATE.
      IF SY-SUBRC = 0.
        TAB1-DNQTY2 = ITAB-KCMENG.
        TAB1-CURR_DATE = ITAB-WADAT_IST.
      ENDIF.

      READ TABLE DTAB WITH KEY WADAT_IST = TAB1-CURR_DATE.
      IF SY-SUBRC = 0.
        TAB1-DNQTY2 = DTAB-KCMENG.
        TAB1-CURR_DATE = DTAB-WADAT_IST.
      ENDIF.

      READ TABLE KTAB WITH KEY WADAT_IST = TAB1-CURR_DATE.
      IF SY-SUBRC = 0.
        TAB1-DNQTY3 = KTAB-KCMENG.
        TAB1-CURR_DATE = KTAB-WADAT_IST.
      ENDIF.

      READ TABLE TTAB WITH KEY BUDAT = TAB1-CURR_DATE.
      IF SY-SUBRC = 0.
        TAB1-DNQTY4 = TTAB-MENGE.
        TAB1-CURR_DATE = TTAB-BUDAT.
      ENDIF.
      MODIFY TAB1.
      CLEAR TAB1.

    ENDLOOP.
  ENDIF.


*Insert/Update data to IBL Table

  PERFORM CATCH_IBL_DATA.


ENDFORM.                    " GET_DATA
*

*&---------------------------------------------------------------------*
*&      Form  CHECK_DBCON
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ITAB-WERKS text
*      <--P_DBCONNAME text
*      <--P_SUBRC  text
*----------------------------------------------------------------------*
FORM CHECK_DBCON USING  P_DBCONNAME
                        P_SUBRC.
  TABLES:DBCON.
  CLEAR DBCON.
  SELECT SINGLE *  FROM  DBCON
         WHERE  CON_NAME  = P_DBCONNAME.
  IF SY-SUBRC NE 0.
    MESSAGE E398(00)
      WITH 'DB Connection ' P_DBCONNAME
           'has not been set up.'
           'Please check table DBCON.'.
    P_SUBRC = SY-SUBRC.
    CLEAR P_DBCONNAME.
  ELSE.
    P_SUBRC = SY-SUBRC.
  ENDIF.
ENDFORM.                    "CHECK_DBCON


*&---------------------------------------------------------------------*
*&      Form  CONNECT_DBCON
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->P_DBCONNAME  text
*      <--P_SUBRC  text
*----------------------------------------------------------------------*
FORM CONNECT_DBCON USING P_DBCONNAME LIKE DBCON-CON_NAME
                   CHANGING P_SUBRC.
  TRY.
      EXEC SQL.
        CONNECT TO :P_DBCONNAME
      ENDEXEC.
      EXEC SQL.
        SET CONNECTION :P_DBCONNAME
      ENDEXEC.

    CATCH CX_SY_NATIVE_SQL_ERROR.
      P_SUBRC = '99'.
  ENDTRY.
ENDFORM.                    " connect_dbcon

*&---------------------------------------------------------------------*
*&      Form  DISCONNECT_DBCON
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->P_L_DBCONNAME  text
*      <--P_L_SUBRC  text
*----------------------------------------------------------------------*
FORM DISCONNECT_DBCON USING P_DBCONNAME  LIKE DBCON-CON_NAME
                      CHANGING P_SUBRC.
  TRY.
      EXEC SQL.
        DISCONNECT :P_DBCONNAME
      ENDEXEC.

    CATCH CX_SY_NATIVE_SQL_ERROR.
      P_SUBRC = '99'.
  ENDTRY.

ENDFORM.                    " connect_dbcon


*&---------------------------------------------------------------------*
*&      Form  CATCH_IBL_DATA
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  -->  p1        text
*  <--  p2        text
*----------------------------------------------------------------------*
FORM CATCH_IBL_DATA .
*****Check data if exists in IBL
  DATA: L_DBCONNAME     LIKE DBCON-CON_NAME.
  DATA: L_SUBRC         LIKE SY-SUBRC.
  DATA: L_DBOPEN        LIKE SY-SUBRC.
  DATA: L_DBCON(10) VALUE 'HKMIBL_DG'.

  MOVE L_DBCON TO L_DBCONNAME.

  PERFORM CHECK_DBCON USING  L_DBCONNAME L_SUBRC.

  PERFORM CONNECT_DBCON USING  L_DBCONNAME
                      CHANGING L_SUBRC.

  L_DBOPEN = L_SUBRC.

  IF L_DBOPEN = 0.

    CLEAR L_SUBRC.

    LOOP AT TAB1 INTO WA_TAB1.

      PERFORM PROCESS_DATA CHANGING L_SUBRC.

      DO.
        CLEAR TIBL.
        CLEAR TIBL[].
        IF L_SUBRC = 0.
          IBL_FETCH_DATA TIBL L_SUBRC C11A.
          APPEND TIBL.
        ELSE.
          EXIT.
        ENDIF.
      ENDDO.

      IBL_CLOSE_CURSOR C11A L_SUBRC.

      IF TIBL[] IS NOT INITIAL.
        PERFORM UPDATE_DATA CHANGING L_SUBRC.
      ELSE.
        PERFORM INSERT_DATA CHANGING L_SUBRC.
      ENDIF.

      REFRESH TIBL[].

    ENDLOOP.

    PERFORM DISCONNECT_DBCON USING L_DBCONNAME
                             CHANGING L_SUBRC.
  ENDIF.
ENDFORM.                    " CATCH_IBL_DATA


*&---------------------------------------------------------------------*
*&      Form  PROCESS_DATA
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->P_P_TDATE  text
*      <--P_L_SUBRC  text
*----------------------------------------------------------------------*
FORM PROCESS_DATA USING L_SUBRC.

  CLEAR L_SUBRC.
  TRY.
      EXEC SQL.

        OPEN C11A FOR
        SELECT * FROM CHKWIPQTY
               where CUR_DATE = :WA_TAB1-CURR_DATE.
      ENDEXEC.

      L_SUBRC = SY-SUBRC.

    CATCH CX_SY_NATIVE_SQL_ERROR.
      L_SUBRC = '99'.
  ENDTRY.
ENDFORM.                    " PROCESS_DATA


*&---------------------------------------------------------------------*
*&      Form  UPDATE_DATA
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  -->  p1        text
*  <--  p2        text
*----------------------------------------------------------------------*
FORM UPDATE_DATA USING L_SUBRC.

  CLEAR L_SUBRC.
  TRY.
      EXEC SQL.

        update ChkWipQty set (sap_ship_to_vw,sap_ship_to_oth,
                   sap_vw_ship_out,vw_move_out,from_date,to_date)
        values( :WA_TAB1-DNQTY1, :WA_TAB1-DNQTY2, :WA_TAB1-DNQTY3,
                :WA_TAB1-DNQTY4, :FMDATE, :ENDATE )
                     where CUR_DATE = :WA_TAB1-CURR_DATE.
      ENDEXEC.

      COMMIT WORK.

      L_SUBRC = SY-SUBRC.

    CATCH CX_SY_NATIVE_SQL_ERROR.
      L_SUBRC = '99'.
  ENDTRY.

  IF L_SUBRC = 0.
    MESSAGE S000(00) WITH: 'Update Data to IBL table succeed!'.
  ELSE.
    MESSAGE E000(00) WITH: 'Update Data to IBL table failed!'.
  ENDIF.

ENDFORM.                    " UPDATE_DATA


*&---------------------------------------------------------------------*
*&      Form  INSERT_DATA
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  -->  p1        text
*  <--  p2        text
*----------------------------------------------------------------------*
FORM INSERT_DATA USING L_SUBRC.
  CLEAR L_SUBRC.
  TRY.
      EXEC SQL.
        insert ChkWipQty(sap_ship_to_vw,sap_ship_to_oth,
        sap_vw_ship_out,vw_move_out,from_date,to_date,cur_date)
        values( :WA_TAB1-DNQTY1, :WA_TAB1-DNQTY2, :WA_TAB1-DNQTY3,
                :WA_TAB1-DNQTY4, :FMDATE, :ENDATE, :WA_TAB1-CURR_DATE )
      ENDEXEC.

      COMMIT WORK.

      L_SUBRC = SY-SUBRC.

    CATCH CX_SY_NATIVE_SQL_ERROR.
      L_SUBRC = '99'.
  ENDTRY.

  IF L_SUBRC = 0.
    MESSAGE S000(00) WITH: 'Insert Data to IBL table succeed!'.
  ELSE.
    MESSAGE E000(00) WITH: 'Insert Data to IBL table failed!'.
  ENDIF.

ENDFORM.                    " INSERT_DATA 

myliulongtao
关注
专栏目录
sql数据库连接实例
02-08
通过这外实例，可以快速理解如何用C#连接SQL数据库
vb连接sql server数据库实例
06-13
vb连接sql server数据库实例，主题是关于狗的介绍，很漂亮
建立SQL Server数据库连接实例
weixin_30633507的博客
03-10 163
ADO.NET对数据库进行访问所用到的主要类： Connection,DataSet,DataRow,DataColumn,DataRelation,Command,DataAdapter,DataReader,Parameter,Transaction Default.aspx View Code <%@ Page Language="C#" A...
android连接sqlserver数据库实例
07-02
此应用程序可运行在Android2.1及以上版本的操作系统手机或手持设备上，使用时请将 1.使用管理员客户端时请将Android应用程序（可执行文件）文件夹里的adminBookSystem.apk文件拷贝到手机里，然后安装、运行即可， 2.使用学生客户端时请将Android应用程序（可执行文件）文件夹的StudentBookSystem.apk文件拷贝到手机里，然后安装、运行即可。 3.本地服务时只需运行Webservice即可
SQL关系数据库示例
weixin_47219891的博客
02-22 2222
Create database 数据库名；#创建数据库SCT。
C#编程实现连接SQL SERVER数据库实例详解
12-26
本文实例讲述了C#编程实现连接SQL SERVER数据库。分享给大家供大家参考，具体如下： 首先，在SQL SEVER里建立一个名为“Exercise”的数据库名，在该数据库下建立一张名为“lianxi”的表。好，现在开始写代码。 在...
Java 连接MS SQLServer数据库的实例
10-29
在本文中，我们将深入探讨如何使用Java连接到Microsoft SQL Server数据库，并进行基本的数据操作，如创建数据表和查询数据。这个实例将帮助开发者理解如何在Java应用程序中与SQL Server进行交互。 首先，为了连接到...
（VB.net 连接 SQL server数据库案例源码）数据收纳箱系统.zip
06-07
（VB.net 连接 SQL server数据库案例源码）数据收纳箱系统.zip 源码开放，datagridview1控件列示等等
SD-SO交货信息报表（开发笔记）
Nathan的博客
11-13 376
*&---------------------------------------------------------------------**&ReportZSDR008*&---------------------------------------------------------------------**&Author...
SQL语句学习--连接数据库
Excel工作圈的博客
03-08 1812
SQL连接方法及语句
连接SQL Server数据库（详细步骤+登录注册案例）
热门推荐
weixin_43624549的博客
08-16 7万+
SQL Server使用sql server身份验证，方便与编写的程序连接 <1> 首先使用Windows登录进去，右键实例，点击属性，再选择安全性，将该选项卡中的服务器身份验证改为sql server和windows身份验证模式。点击确定 <2> 此时重新登录数据库，OK，又失败了。。。 失败的提示是： 已成功与服务器建立连接 但是在登录过程中发生错误。 provider 共享内存提供程序 error 0 管道的另一端上无任何进程。 <3> 不要慌，淡定，打开SQL S
ZSD017出货达成率
03-29 319
其实早就应该写了，但一直落下来了。现在什么都记不得了，咳。直接上代码吧。 [plain] view plaincopyprint? *&---------------------------------------------------------------------*  *& Report  ZSD017  *&-------------------------
通过IP连接装有不同SQLSERVER实例的服务器（阿里云ecs服务器同理）
cgs的博客
06-03 7719
问题：一台Windows Server 2008服务器上装有四个数据库，如下图：我们知道可以在服务器上通过“主机名\实例名”的方式用sa账户来登录不同数据库，如下图：但是局域网内其他计算机如何访问该服务器上不通数据库实例呢？大家都知道，如果该服务器上装有一个数据库的话，可以用“IP\实例名”的方式进行访问，但是服务器上有多个数据库的话该怎么办呢？例如我现在有一台笔记本接入到了该局域网，我想要用Vi...
ABAP程序优化
weixin_42646630的博客
06-09 2312
程序优化这个易学，但是难以达到一个完美的地步，我在日常联系中也不确定某段代码选择的优化写法是不是最好的，所以以下代表的我一些个人看法。 在具体介绍优化方法之前，先介绍两个工具，SAT(原SE30)和ST05，SAT用来分析程序效能问题，ST05来确定SQL是否用到了INDEX，SAT除了可以直接测前端，也可以在schedule中后台测试，但是后台的不能时间太大，否则超过一定范围会无效， 优化方法： 1、选择合适内表，例如在用DN+Item寻找Billing + Item、SO + Item寻找DN +
关系型数据库进阶（三）连接运算及查询实例
weixin_34026276的博客
07-29 1970
上篇文字，我们知道如何获取数据了，那现在就把它们联接起来！ 　　我要展现的是3个个常用联接运算符：合并联接（Merge join），哈希联接（Hash Join）和嵌套循环联接（Nested Loop Join）。但是在此之前，我需要引入新词汇了：内关系和外关系（inner relation and outer relation）。 一个关系可以是： 一个表 一个索引 上一个运算的中间...
JDBC连接自定义sqlserver数据库实例名（多个实例）
真正的错误是，当你知道应该如何去提高时仍然选择做一名初学者！
06-07 2万+
java语言中，通过jdbc访问sqlserver2005(2008)数据库默认实例可以按常用的写法来写url连接。代码如下： Connection cn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=demo", "sa","sa"); 其中localhost为sqlser
SQL数据库查询 左连接、右连接、内连接 实例
wl_ldy的专栏
02-04 8475
 例子Table Aaid   adate 1      a1 2      a2 3      a3TableBbid bdate 1    b1 2    b2 4    b4 两个表a,b相连接,要取出id相同的字段 select * from a inner join b on a.aid = b.bid这是仅取出
连接数据库实例
qq_43907296的博客
10-27 546
package com.company; import java.sql.*; public class Main { public static void main(String[] args) { Student student = new Student(); try { SqlOperation.main(); ResultSet resultSet = StudentSql.selectStudentSql()
vb.net连接sqlserver数据库实例
最新发布
12-02
在VB.NET中连接SQL Server数据库实例需要使用.NET Framework中提供的一些类和方法。首先，我们需要导入System.Data.SqlClient命名空间，以便...这样就可以在VB.NET中连接SQL Server数据库实例并进行相关的数据库操作。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值