tds平台调用oracle存储过程

最新推荐文章于 2021-04-15 05:12:14 发布
最新推荐文章于 2021-04-15 05:12:14 发布
阅读量1.1k 收藏
点赞数
分类专栏： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xiehui_top/article/details/9844677
版权

由于系统数据量越来越大，所以将涉及查询大数据的业务逻辑  写在存储过程里，可以提高查询效率

create or replace package tomorrow as

  type p_cursor is ref Cursor;
end;
create or replace package pro_query_mywork is
  ---办事处我的工作查询工作流
  procedure query_mywork_info(curpage          in varchar2,
                              unitpage         in varchar2,
                              operatorid       in varchar2,
                              processid        in varchar2,
                              tasktype         in varchar2,
                              appliant         in varchar2,
                              taskstatus       in varchar2,
                              mercnum          in varchar2,
                              mercnam          in varchar2,
                              agentid          in varchar2,
                              agtnam           in varchar2,
                              area             in varchar2,
                              appday1          in varchar2,
                              appday2          in varchar2,
                              in_roles         in varchar2,
                              cdt_in_opers     in varchar2,
                              cdt_not_in_opers in varchar2,
                              v_cursor         out tomorrow.p_cursor);
  procedure query_mywork_count(operatorid       in varchar2,
                               processid        in varchar2,
                               tasktype         in varchar2,
                               appliant         in varchar2,
                               taskstatus       in varchar2,
                               mercnum          in varchar2,
                               mercnam          in varchar2,
                               agentid          in varchar2,
                               agtnam           in varchar2,
                               area             in varchar2,
                               appday1          in varchar2,
                               appday2          in varchar2,
                               cdt_in_opers     in varchar2,
                               cdt_not_in_opers in varchar2,
                               v_cursor         out tomorrow.p_cursor);
end;
create or replace package body pro_query_mywork is
  ----办事处我的工作查询工作流
  procedure query_mywork_info(curpage          in varchar2,
                              unitpage         in varchar2,
                              operatorid       in varchar2,
                              processid        in varchar2,
                              tasktype         in varchar2,
                              appliant         in varchar2,
                              taskstatus       in varchar2,
                              mercnum          in varchar2,
                              mercnam          in varchar2,
                              agentid          in varchar2,
                              agtnam           in varchar2,
                              area             in varchar2,
                              appday1          in varchar2,
                              appday2          in varchar2,
                              in_roles         in varchar2,
                              cdt_in_opers     in varchar2,
                              cdt_not_in_opers in varchar2,
                              v_cursor         out tomorrow.p_cursor) as
    startpos number;
    endpos   number;
    all_sql  varchar2(4000);
    tj       varchar2(300);
    tja      varchar2(300);
    tjb      varchar2(300);
  begin
    tj  := '';
    tja := '';
    tjb := '';
    --申请日期
    if (appday1 is not null) then
      tj := tj || 'AND SUBSTR(A.CREATETIME,1,8)>=' || appday1 || '';
    end if;
    if (appday2 is not null) then
      tj := tj || 'AND SUBSTR(A.CREATETIME,1,8)<=' || appday2 || '';
    end if;
    --任务流水号
    if (processid is not null) then
      tj := tj || ' AND (A.PROCESSID =''' || processid ||
            ''' OR A.PROCESSID LIKE ' || '''' || '%' || processid || '%' || '''' || ')';
    end if;
    --任务类型
    if ((tasktype is not null) and (tasktype <> '-1')) then
      if (tasktype = 'WF014') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF018''' || ')';
      elsif (tasktype = 'WF008') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF015''' || ')';
      elsif (tasktype = 'WF012') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF016''' || ')';
      elsif (tasktype = 'WF011') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF017''' || ')';
      elsif (tasktype = 'WF020') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF020''' || ')';
      elsif (tasktype = 'WF021') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF021''' || ')';
      else
        tj := tj || ' AND A.TASKTYPE =''' || tasktype || '''';
      end if;
    end if;
    if ((tasktype is not null) and (tasktype = '-1')) then
      tj := tj || ' AND A.TASKTYPE in' || '(' || '''WF020''' || ',' ||
            '''WF008''' || ',' || '''WF021''' || ',' || '''WF009''' || ',' ||
            '''WF010''' || ',' || '''WF011''' || ',' || '''WF014''' || ',' ||
            '''WF012''' || ',' || '''WF005''' || ',' || '''WF018''' || ',' ||
            '''WF017''' || ',' || '''WF016''' || ',' || '''WF015''' || ')';
    end if;
    --商户序号
    if (mercnum is not null) then
      tj := tj || ' AND (C.MERCNUM =''' || mercnum ||
            ''' OR C.MERCNUM LIKE ' || '''' || '%' || mercnum || '%' || '''' || ')';
    end if;
    --申请人
    if (appliant is not null) then
      tj := tj || ' AND (A.APPNAM =''' || appliant ||
            ''' OR A.APPNAM LIKE ' || '''' || '%' || appliant || '%' || '''' || ')';
    end if;
    --商户名称
    if (mercnam is not null) then
      tj := tj || ' AND (C.MERCNAM =''' || mercnam ||
            ''' OR C.MERCNAM LIKE ' || '''' || '%' || mercnam || '%' || '''' || ')';
    end if;
    --办事处编号
    if (agentid is not null) then
      tj := tj || ' AND (A.AGENTID =''' || agentid ||
            ''' OR A.AGENTID LIKE ' || '''' || '%' || agentid || '%' || '''' || ')';
    end if;
    --办事处名称
    if (agtnam is not null) then
      tj := tj || ' AND (B.AGTNAM =''' || agtnam || ''' OR B.AGTNAM LIKE ' || '''' || '%' ||
            agtnam || '%' || '''' || ')';
    end if;
    --所属区域
    if (area is not null) then
      tj := tj || ' AND A.AREA =''' || area || '''';
    end if;
    --任务状态
    --未处理
    if ((taskstatus is not null) and (taskstatus = '0')) then
      tja := tja || 'AND A.TASKSTATUS=0' || cdt_in_opers;
      tjb := tjb || 'AND 1=2';
    end if;
    --已处理
    if ((taskstatus is not null) and (taskstatus = '1')) then
      tjb := tjb || 'AND A.TASKSTATUS=0' || cdt_not_in_opers ||
             'AND A.PROCESSID IN (SELECT DISTINCT PROCESSID FROM PMWKFSTEPDEF WHERE TLRID =''' ||
             operatorid || ''')';
      tja := tja || 'AND 1=2';
    end if;
    --已完成
    if ((taskstatus is not null) and (taskstatus = '2')) then
      tjb := tjb || 'AND A.TASKSTATUS=1' ||
             'AND A.PROCESSID IN (SELECT DISTINCT PROCESSID FROM PMWKFSTEPDEF WHERE TLRID =''' ||
             operatorid || ''')';
      tja := tja || 'AND 1=2';
    end if;
    --不限  查询所有状态的任务
    if ((taskstatus is not null) and (taskstatus = '-1')) then
      tja := tja || 'AND A.TASKSTATUS=0' || cdt_in_opers;
      tjb := tjb || 'AND (A.TASKSTATUS=1' || 'OR (A.TASKSTATUS=0' ||
             cdt_not_in_opers || '))' ||
             'AND A.PROCESSID IN (SELECT DISTINCT PROCESSID FROM PMWKFSTEPDEF WHERE TLRID =''' ||
             operatorid || ''')';
    end if;
 
    all_sql := 'SELECT
             A.TASKTYPE,G.TASKNAME,A.MERATTR, C.MERCNAM,A.MERCHANTID,A.APPNAM,
             A.PROCESSID,B.AGTNAM,A.AGENTID,SUBSTR(A.CREATETIME,1,8) CREATETIME,A.CURRENTSTEP,A.STEPID,
             A.OPERATORID,C.MERCID,D.USER_NAM,D.USER_ID,E.ROLE_NAM,H.CITYNAM AREANAM,F.ROLE_NAM AS TLRROLENAME,A.TASKSTATUS,
            0 AS TASKSTATE
        FROM PMWKDLIST A
        LEFT JOIN PMMERINF C ON A.MERCHANTID = C.MERCNUM
        LEFT JOIN PMUSRINF D ON A.OPERATORID = D.USER_ID
        LEFT JOIN PMAGTINF B ON A.AGENTID = B.AGENTID
        LEFT JOIN PMCTYCOD H ON A.AREA=H.CITYID
        LEFT JOIN PMROLEINF E ON A.OPERATORROLE = E.ROLE_ID
        LEFT JOIN PMROLEINF F ON A.TLRROLE = F.ROLE_ID
        LEFT JOIN PMWKFDEF G ON A.TASKTYPE = G.TASKTYPE
       WHERE TRIM(A.DELETEFLAG) IS NULL
             ' || tj || '
             ' || tja || '
       UNION
    SELECT
             A.TASKTYPE,G.TASKNAME,A.MERATTR, C.MERCNAM,A.MERCHANTID,A.APPNAM,
             A.PROCESSID,B.AGTNAM,A.AGENTID,SUBSTR(A.CREATETIME,1,8) CREATETIME,A.CURRENTSTEP,A.STEPID,
             A.OPERATORID,C.MERCID,D.USER_NAM,D.USER_ID,E.ROLE_NAM,H.CITYNAM AREANAM,F.ROLE_NAM AS TLRROLENAM,A.TASKSTATUS,
             (CASE
                 WHEN A.TASKSTATUS = 1  THEN 2
                 ELSE 1 END
             ) AS TASKSTATE
        FROM PMWKDLIST A
        LEFT JOIN PMMERINF C ON A.MERCHANTID = C.MERCNUM
        LEFT JOIN PMUSRINF D ON A.OPERATORID = D.USER_ID
        LEFT JOIN PMAGTINF B ON A.AGENTID = B.AGENTID
        LEFT JOIN PMCTYCOD H ON A.AREA=H.CITYID
        LEFT JOIN PMROLEINF E ON A.OPERATORROLE = E.ROLE_ID
        LEFT JOIN PMROLEINF F ON A.TLRROLE = F.ROLE_ID
        LEFT JOIN PMWKFDEF G ON A.TASKTYPE = G.TASKTYPE
       WHERE TRIM(A.DELETEFLAG) IS NULL
             ' || tj || '
             ' || tjb || '
       ORDER BY TASKSTATE , PROCESSID DESC';
    if ((curpage is not null) and (unitpage is not null)) then
      startpos := (curpage - 1) * unitpage + 1;
      endpos   := curpage * unitpage;
    end if;
 
    all_sql := 'select  * from (select  B.*,rownum rid from (' || all_sql ||
               ')B where rownum<=' || endpos || ')A where A.rid>=' ||
               startpos;
    open v_cursor for all_sql;
    dbms_output.put_line(all_sql);
  Exception
    when others then
      dbms_output.put_line('数据库出现异常！');
      raise;
  end query_mywork_info;
  --查询办事处我的工作个数
  procedure query_mywork_count(operatorid       in varchar2,
                               processid        in varchar2,
                               tasktype         in varchar2,
                               appliant         in varchar2,
                               taskstatus       in varchar2,
                               mercnum          in varchar2,
                               mercnam          in varchar2,
                               agentid          in varchar2,
                               agtnam           in varchar2,
                               area             in varchar2,
                               appday1          in varchar2,
                               appday2          in varchar2,
                               cdt_in_opers     in varchar2,
                               cdt_not_in_opers in varchar2,
                               v_cursor         out tomorrow.p_cursor) as
    count_sql varchar2(4000);
    tj        varchar2(300);
    tja       varchar2(300);
    tjb       varchar2(300);
  begin
    tj  := '';
    tja := '';
    tjb := '';
    --申请日期
    if (appday1 is not null) then
      tj := tj || 'AND SUBSTR(A.CREATETIME,1,8)>=' || appday1 || '';
    end if;
    if (appday2 is not null) then
      tj := tj || 'AND SUBSTR(A.CREATETIME,1,8)<=' || appday2 || '';
    end if;
    --任务流水号
    if (processid is not null) then
      tj := tj || ' AND (A.PROCESSID =''' || processid ||
            ''' OR A.PROCESSID LIKE ' || '''' || '%' || processid || '%' || '''' || ')';
    end if;
    --任务类型
    if ((tasktype is not null) and (tasktype <> '-1')) then
      if (tasktype = 'WF014') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF018''' || ')';
      elsif (tasktype = 'WF008') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF015''' || ')';
      elsif (tasktype = 'WF012') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF016''' || ')';
      elsif (tasktype = 'WF011') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF017''' || ')';
      elsif (tasktype = 'WF020') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF020''' || ')';
      elsif (tasktype = 'WF021') then
        tj := tj || ' AND (A.TASKTYPE =''' || tasktype || '''' ||
              ' OR A.TASKTYPE = ' || '''WF021''' || ')';
      else
        tj := tj || ' AND A.TASKTYPE =''' || tasktype || '''';
      end if;
    end if;
    if ((tasktype is not null) and (tasktype = '-1')) then
      tj := tj || ' AND A.TASKTYPE in' || '(' || '''WF020''' || ',' ||
            '''WF008''' || ',' || '''WF021''' || ',' || '''WF009''' || ',' ||
            '''WF010''' || ',' || '''WF011''' || ',' || '''WF014''' || ',' ||
            '''WF012''' || ',' || '''WF005''' || ',' || '''WF018''' || ',' ||
            '''WF017''' || ',' || '''WF016''' || ',' || '''WF015''' || ')';
    end if;
    --商户序号
    if (mercnum is not null) then
      tj := tj || ' AND (C.MERCNUM =''' || mercnum ||
            ''' OR C.MERCNUM LIKE ' || '''' || '%' || mercnum || '%' || '''' || ')';
    end if;
    --申请人
    if (appliant is not null) then
      tj := tj || ' AND (A.APPNAM =''' || appliant ||
            ''' OR A.APPNAM LIKE ' || '''' || '%' || appliant || '%' || '''' || ')';
    end if;
    --商户名称
    if (mercnam is not null) then
      tj := tj || ' AND (C.MERCNAM =''' || mercnam ||
            ''' OR C.MERCNAM LIKE ' || '''' || '%' || mercnam || '%' || '''' || ')';
    end if;
    --办事处编号
    if (agentid is not null) then
      tj := tj || ' AND (A.AGENTID =''' || agentid ||
            ''' OR A.AGENTID LIKE ' || '''' || '%' || agentid || '%' || '''' || ')';
    end if;
    --办事处名称
    if (agtnam is not null) then
      tj := tj || ' AND (B.AGTNAM =''' || agtnam || ''' OR B.AGTNAM LIKE ' || '''' || '%' ||
            agtnam || '%' || '''' || ')';
    end if;
    --所属区域
    if (area is not null) then
      tj := tj || ' AND A.AREA =''' || area || '''';
    end if;
    --任务状态
    --未处理
    if ((taskstatus is not null) and (taskstatus = '0')) then
      tja := tja || 'AND A.TASKSTATUS=0' || cdt_in_opers;
      tjb := tjb || 'AND 1=2';
    end if;
    --已处理
    if ((taskstatus is not null) and (taskstatus = '1')) then
      tjb := tjb || 'AND A.TASKSTATUS=0' || cdt_not_in_opers ||
             'AND A.PROCESSID IN (SELECT DISTINCT PROCESSID FROM PMWKFSTEPDEF WHERE TLRID =''' ||
             operatorid || ''')';
      tja := tja || 'AND 1=2';
    end if;
    --已完成
    if ((taskstatus is not null) and (taskstatus = '2')) then
      tjb := tjb || 'AND A.TASKSTATUS=1' ||
             'AND A.PROCESSID IN (SELECT DISTINCT PROCESSID FROM PMWKFSTEPDEF WHERE TLRID =''' ||
             operatorid || ''')';
      tja := tja || 'AND 1=2';
    end if;
    --不限  查询所有状态的任务
    if ((taskstatus is not null) and (taskstatus = '-1')) then
      tja := tja || 'AND A.TASKSTATUS=0' || cdt_in_opers;
      tjb := tjb || 'AND (A.TASKSTATUS=1' || 'OR (A.TASKSTATUS=0' ||
             cdt_not_in_opers || '))' ||
             'AND A.PROCESSID IN (SELECT DISTINCT PROCESSID FROM PMWKFSTEPDEF WHERE TLRID =''' ||
             operatorid || ''')';
    end if;
 
    count_sql := 'SELECT A.PROCESSID
        FROM PMWKDLIST A
        LEFT JOIN PMMERINF C ON A.MERCHANTID = C.MERCNUM
        LEFT JOIN PMUSRINF D ON A.OPERATORID = D.USER_ID
        LEFT JOIN PMAGTINF B ON A.AGENTID = B.AGENTID
        LEFT JOIN PMCTYCOD H ON A.AREA=H.CITYID
        LEFT JOIN PMROLEINF E ON A.OPERATORROLE = E.ROLE_ID
        LEFT JOIN PMROLEINF F ON A.TLRROLE = F.ROLE_ID
        LEFT JOIN PMWKFDEF G ON A.TASKTYPE = G.TASKTYPE
       WHERE TRIM(A.DELETEFLAG) IS NULL
             ' || tj || '
             ' || tja || '
       UNION
    SELECT A.PROCESSID
        FROM PMWKDLIST A
        LEFT JOIN PMMERINF C ON A.MERCHANTID = C.MERCNUM
        LEFT JOIN PMUSRINF D ON A.OPERATORID = D.USER_ID
        LEFT JOIN PMAGTINF B ON A.AGENTID = B.AGENTID
        LEFT JOIN PMCTYCOD H ON A.AREA=H.CITYID
        LEFT JOIN PMROLEINF E ON A.OPERATORROLE = E.ROLE_ID
        LEFT JOIN PMROLEINF F ON A.TLRROLE = F.ROLE_ID
        LEFT JOIN PMWKFDEF G ON A.TASKTYPE = G.TASKTYPE
       WHERE TRIM(A.DELETEFLAG) IS NULL
             ' || tj || '
             ' || tjb || '';
    count_sql := 'SELECT COUNT(1) AS TOLCNT FROM (' || count_sql || ')';
    open v_cursor for count_sql;
    dbms_output.put_line(count_sql);
  Exception
    when others then
      dbms_output.put_line('数据库出现异常！');
      raise;
  end query_mywork_count;
end;
xiehui_top
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
oracle数据库中TDS,某高校开发了一个学生信息管理系统TDS，里面使用了Oracle数据库。则TDS被称为...
weixin_35964787的博客
04-03 1169
某高校开发了一个学生信息管理系统TDS，里面使用了Oracle数据库。则TDS被称为更多相关问题边界值分析方法如何帮助生成测试用例?如何结合使用等价类划分法和边界值分析法生成测试用例?张女士,25岁,宫内孕35周,本次产检中发现孕妇宫高与腹围明显大于妊娠周数,腹壁皮肤张力较大,腹部有液体震荡感,胎位触摸不清,胎心遥远。为明确诊断,应做的检查项目是中老年人定期进行健康体检属于促进健康行为中的是物料需...
oracle数据库 tds是什么,别被忽悠了才后悔 TDS值到底是什么
weixin_28949355的博客
04-11 2469
相信很多曾经购买了净水器的小伙伴们，都听到过净水器的销售员们提到水的TDS值数，但是这种专业术语对于只是想购买一款家电的消费者来说，肯定是不懂他在说什么的。一不懂就很容易被销售员牵着鼻子走，那么今天就来跟小编一起了解下有关于TDS的相关知识。1、TDS值是什么?首先TDS是TotalDissolvedSolids的缩写，中文意思就是可溶解固体总量，是指水中的钙镁离子、微生物等水中溶解物质的总含量。...
tds与oracle,Oracle错误ORA-65052：语句涉及具有不同容器范围的操作
weixin_36465073的博客
04-03 342
我是Oracle的新手.我已经在RHEL 7 VM上设置了一个运行Oracle 12c的实例.我正在连接到安装期间创建的数据库并运行一些安装脚本.下面是我试图运行的脚本的输出,有人能指出我正确的方向吗？我有一种感觉,我在做一些根本错误的事情.Error starting at line : 4 in command -GRANT CONNECT TO TDSUSER IDENTIFIED BY "...
数据库协议
chenkaifang的博客
06-30 7434
1、TDS协议 参考链接： https://blog.csdn.net/u014608280/article/details/80776703 https://blog.csdn.net/cxzhq2002/article/details/5720350 表格数据流（Tabular Data Stream, TDS）协议是一种数据库服务器和客户端间交互的应用层协议， 为微软SQL Ser...
oracle创建程序包语句,Oracle PL/SQL(13) - 程序包package
weixin_35065221的博客
04-15 1155
当项目越来越大的时候，数据库中可能会出现成百上千的函数、存储过程等，为了方便管理，Oracle提倡使用程序包的管理机制，实现业务模块隔离，方便管理。程序包：包是一组相关过程、函数、变量、游标、常量等PL/SQL程序设计元素的组合。它具有面向对象程序设计语言的特点，是对这些PL/SQL程序设计元素的封装。包类似于C++或Java程序中的类，而变量相当于类中的成员变量，过程和函数相当于方法，把相关的模...
一些常用数据库存储过程
09-30
在Java中调用Oracle存储过程的方法如下： ```java CallableStatement cs = conn.prepareCall("{ call add_numbers(?,?,?) }"); cs.setInt(1, 10); // 设置第一个输入参数 cs.setInt(2, 20); // 设置第二个输入参数 ...
JDBC 4 ORACLE
03-01
`jtds.jar`提供了对这些数据库的访问支持，其特性包括对TDS协议的支持，以及对SSL加密连接、存储过程和批处理操作的良好支持。 综上，"JDBC 4 ORACLE"的主题涵盖了Java编程与Oracle数据库的交互，涉及JDBC 4的新...
数据库存储过程的写法\\连接各种数据库写法
07-30
存储过程是一种预编译的SQL代码块，它可以存储在数据库服务器上，并通过一个名称来调用，从而提高应用程序的性能并简化复杂的数据库操作。此外，我们还将探讨使用Java语言连接多种数据库的基本方法。 #### 存储过程...
各种数据库jdbc 另附连接方法
03-05
在IT行业中，数据库是存储和管理数据的核心工具，而Java Database Connectivity（JDBC）是Java编程语言中用于与各种数据库进行交互的标准API。本主题主要围绕"各种数据库jdbc 另附连接方法"展开，涵盖了MySQL、...
数据库驱动包
01-07
有三种类型：Statement、PreparedStatement和CallableStatement，分别对应于简单的SQL执行、预编译的SQL执行和存储过程的调用。 4. **ResultSet**：当执行查询语句后，返回的结果集会封装在ResultSet对象中，可以...
JAVA数据库连接大全.pdf
10-02
此外，JDBC还提供了Statement、PreparedStatement和CallableStatement等对象，用于执行SQL查询、更新和存储过程调用。 总结来说，JDBC是Java开发者与数据库交互的标准接口，提供了跨数据库的通用性，但实际使用时仍...
jconnect-7.7.rar
08-18
在实际应用中，JConnect不仅支持基本的CRUD操作，还支持复杂的数据操作，如存储过程的调用、批处理等。结合Sybase的特性，JConnect还可以实现高效的数据处理和优化。 总之，JConnect-7.7.jar是Java程序员连接和操作...
全套数据库驱动JDBC_driver
09-04
此驱动支持最新的MySQL特性，包括SSL连接、连接池以及存储过程调用等。 4. **Oracle驱动** Oracle的JDBC驱动有多种版本，如 Thin 驱动和 OCI 驱动。Thin驱动（也称为纯Java驱动，Type 4）不需要Oracle客户端软件，...
java 连接各种数据库的代码
06-24
下面将详细介绍如何使用Java连接Oracle、DB2、SQL Server、Sybase、Informix、MySQL和PostgreSQL等数据库。 1. **Oracle数据库（thin模式）**： 使用Oracle JDBC驱动（ojdbc）进行连接。首先需要加载驱动类`oracle...
使用JDBC连接各种数据库总结
12-13
4. **使用Connection对象**：一旦建立了连接，就可以通过`Connection`对象进行数据库操作，如创建`Statement`或`PreparedStatement`来执行SQL查询，使用`CallableStatement`调用存储过程，以及管理事务等。...
tds协议详细解析
热门推荐
耿小渣的进阶之路
06-22 2万+
表格数据流（Tabular Data Stream, TDS）协议是一种数据库服务器和客户端间交互的应用层协议， 为微软SQL Server数据库和Sybase公司数据库产品所采用。 TDS 版本及SQLServer版本对应关系 4.2 Sybase SQL Server &lt; 10 and Microsoft SQL Server 6.5 5.0 ...
orace 表以及相关知识1
Douny的专栏
11-22 447
0、数据库： 数据文件：xxx.dbf 控制文件：xxx.ctl 日志文件：xxx.log 加载数据库时： 先加载控制文件,再加载数据文件和日志文件 a、表空间 : 包含一个或多个数据文件 （一个数据只能属于表空间) b、段: 表段... c、区: 连接空间         d、块:数据库中的最小单位 dba_tablespaces 查看系统中存在的表空间
plsql编程自学笔记（1）--分页程序的正确测试
swornsoft的专栏
04-03 379
create or replace package testpackage as TYPE test_cursor is ref cursor; end testpackage; --开始编写分页的过程 create or replace procedure fenye (tableName in varchar2, Pagesize in number,--一页显示记录数 page
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值