程序运行不了......

ding1188 2007-11-28 06:57:42
程序编译能通过,可就是不能运行...望高手解答,跪谢
//SeqList.h
#ifndef SEQLIST_H
#define SEQLIST_H
#include<iostream>
using namespace std;
const int maxSize=20;
template<class T>class SeqList
{
private:
T data[maxSize];
int len;
public:
SeqList();
~SeqList();
int Length()const;//返回线性表的长度
T Get(int i)const;//返回第i个数据元素
int Locate(T&item)const;//返回item在表中的位置
int Insert(const T&item,int i);//在序号i前插入item,成功返回1,否则返回0
int Insert(const T&item);//在表尾插入item,成功返回1,否则返回0
T Delete(const int&i);//删除序号为i的元素,并返回
int Empty();//表为空返回1,否则返回0
void Clear();//把表清空
};
template<class T>SeqList<T>::SeqList()
{
len=0;
}
template<class T>SeqList<T>::~SeqList()
{
}
template<class T>int SeqList<T>::Length()const
{
return len;
}
template<class T>T SeqList<T>::Get(int i)const
{
if(i>=1&&i<=len)return data[i-1];
return NULL;
}
template<class T>int SeqList<T>::Locate(T&item)const
{
for(int i=1;i<len;i++)
{
if(data[i-1]==item)break;
}
if(i>len)return 0;
return i;
}
template<class T>int SeqList<T>::Insert(const T&item,int i)
{
if(len==maxSize) return 0;
if(i<1||i>len+1)return 0;
for(int j=len;j>=i;j--)
data[j]=data[j-1];
data[i-1]=item;
len++;
return 1;
}
template<class T>int SeqList<T>::Insert(const T&item)
{
if(len>maxSize)return 0;
data[len]=item;
len++;
return 1;
}
template<class T>T SeqList<T>::Delete(const int &i)
{
if(len==0)return NULL;
if(i<1||i>len)return NULL;
T t=data[i-1];
for(int j=i;j<len;j++)
data[j-1]=data[j];
len--;
return i;
}
template<class T>int SeqList<T>::Empty()
{
if(len==0)return 1;
return 0;
}
template<class T>void SeqList<T>::Clear()
{
len=0;
}
#endif


//Graph.h
#include<iostream>
#include"SeqList.h"
using namespace std;
const int MaxVertexes=20;
template<class VertexT,class ArcT>class Graph
{
private:
SeqList<VertexT>Vertexes;//存储顶点的信息
ArcT Arcs[MaxVertexes][MaxVertexes];//存储边的信息
int CurrentNumArcs;//当前的边数
int FindVertex(SeqList<VertexT>&L,const VertexT&v)
{return L.Locate(v);}//查找顶点v是否存在
int GetVertexPos(const VertexT&v)
{return FindVertex(Vertex,v);}//取顶点v在数组中的位置
public:
Graph(int num=MaxVertexes);
int IsEmpty()const{return Vertex.Empty();}
int NUmberOfVertexes()const{return Vertexes.Length();}
int NUmberOfArcs(){return CurrentNumArcs;}
VertexT GetValue(VertexT v);//取图中顶点v的值,如果不存在,返回空
ArcT GetWeight(VertexT v1,VertexT v2);//返回边(v1,v2)上的权
int GetFirstNeighbor(VertexT v);//取顶点v的第一个邻接点的序号,如果不存在返回-1
int GetNextNeighbor(VertexT v1,VertexT v2);//取图中顶点v1的在v2之后的下一个邻接点的序号,如果不存在,返回-1
int InsertVertex(VertexT& v);//在图中插入v,成功返回1,否则返回0
int InsertArc(VertexT v1,VertexT v2);//在图中插入依次依附于顶点v1和v2的边,成功返回1,否则返回0
void DeleteVertex(VertexT v);//删除顶点v及依附与v的边
void DeleteArc(VertexT v1,VertexT v2);//在图中删除依附与顶点v1和v2的边
void DepthFirstSearch();//深度优先遍历
void DFS(int v,int num[]);
};
template<class VertexT,class ArcT>Graph<VertexT,ArcT>::Graph(int num)
{
for(int i=0;i<num;i++)
{
for(int j=0;i<num;j++)
Arcs[i][j]=0;
}
CurrentNumArcs=0;
}
template<class VertexT,class ArcT>VertexT Graph<VertexT,ArcT>::GetValue(VertexT v)
{
int i=Vertexes.Locate(v);
if(i)
return NULL;
else
return Vertexes.Get(i);
}
template<class VertexT,class ArcT>ArcT Graph<VertexT,ArcT>::GetWeight(VertexT v1,VertexT v2)
{
int i,j;
i=Vertexes.Locate(v1);
j=Vertexes.Locate(v2);
if(i||j)
return NULL;
else
return Arcs[i][j];
}
template<class VertexT,class ArcT>int Graph<VertexT,ArcT>::GetFirstNeighbor(VertexT v)
{
int j=Vertexes.Locate(v)
if(j)
return -1;
else
for(i=0;i<Vertexes.Length();i++)
{
if(Arcs[j][i]==1)
return i;
}
}
template<class VertexT,class ArcT>int Graph<VertexT,ArcT>::GetNextNeighbor(VertexT v1,VertexT v2)
{
int i,j;
i=Vertexes.Locate(v1);
j=Vertexes.Locate(v2);
if(i||j)
return -1;
else
for(int k=v2+1;k<Vertexes.Length();k++)
if(Arcs[i][k]==1)
return k;
}
template<class VertexT,class ArcT>int Graph<VertexT,ArcT>::InsertVertex(VertexT &v)
{
return Vertexes.Insert(v);
}
template<class VertexT,class ArcT>int Graph<VertexT,ArcT>::InsertArc(VertexT v1,VertexT v2)
{
int i,j;
i=Vertexes.Locate(v1);
j=Vertexes.Locate(v2);
if(i||j)
return 0;
Arcs[i][j]=1;
CurrentNumArcs++;
return 1;
}
template<class VertexT,class ArcT> void Graph<VertexT,ArcT>::DeleteVertex(VertexT v)
{
int k=Vertexes.Locate(v);
for(int i=0;i<Vertexes.Length();i++)
{
if(Arcs[i][k]!=0)CurrentNumArcs--;
if(Arcs[k][i]!=0)CurrentNumArcs--;
}
for(i=v+1;i<Vertexes.Length();i++)
for(int j=0;j<Vertexes.Length();j++)
{
Arcs[i-1][j]=Arcs[i][j];
Arcs[j][i-1]=Arcs[j][i];
}
for(i=0;i<Vertexes.Length();i++)
{
Arcs[i][Vertexes.Length()-1]=0;
Arcs[Vertexes.Length()-1][i]=0;
}
Vertexes.Delete(k);
}
template<class VertexT,class ArcT> void Graph<VertexT,ArcT>::DeleteArc(VertexT v1,VertexT v2)
{
int i,j;
i=Vertexes.Locate(v1);
j=Vertexes.Locate(v2);
if(i||j)
return ;
Arcs[i][j]=0;
CurrentNumArcs--;
}
template<class VertexT,class ArcT> void Graph<VertexT,ArcT>::DepthFirstSearch()
{
int num[MaxVertexes];
for(int i=0;i<Vertexes.Length();i++)
num[i]=0;
for( i=0;i<Vertexes.Length();i++)
{
if(num[i]==0)
DFS(i,num);
}
}
template<class VertexT,class ArcT> void Graph<VertexT,ArcT>::DFS(int v,int num[])
{
int NextV[MaxVertexes]={0};
num[v]=1;
int j=0;
for(int i=0;i<Vertexes.Length();i++)
{
if(Arcs[v][i]==1)
{
NextV[j]=i;
j++;
}
}
for(j=0;NextV[j];j++)
{
if(num[NextV[j]]==0)
{
cout<<Vertexes.Get(v)<<"----"<<Vertexes.Get(NextV[j])<<endl;
DFS(NextV[j],num);
}
}
}
//main.cpp
#include<iostream>
#include"Graph.h"
using namespace std;
void main()
{
Graph<char,int>graph;
int temp;
char temp1,temp2;
cout<<"请输入插入的顶点数:";
cin>>temp;
cout<<endl;
cout<<"请输入顶点的值(字符):";
for(int i=0;i<temp;i++)
{
cin>>temp1;
graph.InsertVertex(temp1);
}
cout<<"请输入边的条数:";
cin>>temp;
cout<<endl;
cout<<"请输入插入边的起点和结尾:";
for(i=0;i<temp;i++)
{
cin>>temp1>>temp2;
graph.InsertArc(temp1,temp2);
}
graph.DepthFirstSearch();

}
...全文
102 6 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
yuyunliuhen 2007-11-28
  • 打赏
  • 举报
回复
好长好长 ^_^
ding1188 2007-11-28
  • 打赏
  • 举报
回复
三楼,能写一下在那里改了吗????谢谢
ryfdizuo 2007-11-28
  • 打赏
  • 举报
回复
template <class VertexT,class ArcT>
Graph <VertexT,ArcT>::Graph(int num)
{
for(int i=0;i <num;i++)
{
for(int j=0;i <num;j++)
Arcs[i][j]=0;
}
CurrentNumArcs=0;
}
构造函数里面写错了;
for(int j=0; i<num; j++)
越界了
ding1188 2007-11-28
  • 打赏
  • 举报
回复
楼上你什么意思啊????
ckt 2007-11-28
  • 打赏
  • 举报
回复

#ifndef SEQLIST_H
#define SEQLIST_H
#include <iostream>
using namespace std;
const int maxSize=20;
template <class T> class SeqList
{
private:
T data[maxSize];
int len;
public:
SeqList();
~SeqList();
int Length()const;//返回线性表的长度
T Get(int i)const;//返回第i个数据元素
int Locate(T&item)const;//返回item在表中的位置
int Insert(const T&item,int i);//在序号i前插入item,成功返回1,否则返回0
int Insert(const T&item);//在表尾插入item,成功返回1,否则返回0
T Delete(const int&i);//删除序号为i的元素,并返回
int Empty();//表为空返回1,否则返回0
void Clear();//把表清空
};
template <class T> SeqList <T> ::SeqList()
{
len=0;
}
template <class T>
SeqList <T> ::~SeqList()
{
}
template <class T>
int SeqList <T> ::Length()const
{
return len;
}
template <class T> T
SeqList <T> ::Get(int i)const
{
if(i>=1&&i <=len)
return data[i-1];
return NULL;
}
template <class T>
int SeqList <T> ::Locate(T&item)const
{
for(int i=1;i <len;i++)
{
if(data[i-1]==item)break;
}
if(i> len)return 0;
return i;
}
template <class T>
int SeqList <T> ::Insert(const T&item,int i)
{
if(len==maxSize) return 0;
if(i <1 ||i> len+1)return 0;
for(int j=len;j> =i;j--)
data[j]=data[j-1];
data[i-1]=item;
len++;
return 1;
}
template <class T>
int SeqList <T> ::Insert(const T&item)
{
if(len> maxSize)return 0;
data[len]=item;
len++;
return 1;
}
template <class T>
T SeqList <T> ::Delete(const int &i)
{
if(len==0)return NULL;
if(i <1 | |i> len)return NULL;
T t=data[i-1];
for(int j=i;j <len;j++)
data[j-1]=data[j];
len--;
return i;
}
template <class T> int SeqList <T> ::Empty()
{
if(len==0)return 1;
return 0;
}
template <class T> void SeqList <T> ::Clear()
{
len=0;
}
#endif


//Graph.h
#include <iostream>
#include"SeqList.h"
using namespace std;
const int MaxVertexes=20;
template<class VertexT,class ArcT>
class Graph
{
private:
SeqList <VertexT> Vertexes;//存储顶点的信息
ArcT Arcs[MaxVertexes][MaxVertexes];//存储边的信息
int CurrentNumArcs;//当前的边数
int FindVertex(SeqList <VertexT> &L,const VertexT&v)
{return L.Locate(v);}//查找顶点v是否存在
int GetVertexPos(const VertexT&v)
{return FindVertex(Vertex,v);}//取顶点v在数组中的位置
public:
Graph(int num = MaxVertexes);
int IsEmpty()const{return Vertex.Empty();}
int NUmberOfVertexes()const{return Vertexes.Length();}
int NUmberOfArcs(){return CurrentNumArcs;}
VertexT GetValue(VertexT v);//取图中顶点v的值,如果不存在,返回空
ArcT GetWeight(VertexT v1,VertexT v2);//返回边(v1,v2)上的权
int GetFirstNeighbor(VertexT v);//取顶点v的第一个邻接点的序号,如果不存在返回-1
int GetNextNeighbor(VertexT v1,VertexT v2);//取图中顶点v1的在v2之后的下一个邻接点的序号,如果不存在,返回-1
int InsertVertex(VertexT& v);//在图中插入v,成功返回1,否则返回0
int InsertArc(VertexT v1,VertexT v2);//在图中插入依次依附于顶点v1和v2的边,成功返回1,否则返回0
void DeleteVertex(VertexT v);//删除顶点v及依附与v的边
void DeleteArc(VertexT v1,VertexT v2);//在图中删除依附与顶点v1和v2的边
void DepthFirstSearch();//深度优先遍历
void DFS(int v,int num[]);
};
template <class VertexT,class ArcT>
Graph <VertexT,ArcT>::Graph(int num)
{
for(int i = 0; i < num; i++)
{
for(int j = 0; j < num;j++)
Arcs[i][j]=0;
}
CurrentNumArcs=0;
}
template <class VertexT,class ArcT>
VertexT Graph <VertexT,ArcT>::GetValue(VertexT v)
{
int i=Vertexes.Locate(v);
if(i)
return NULL;
else
return Vertexes.Get(i);
}
template <class VertexT,class ArcT>
ArcT Graph <VertexT,ArcT>::GetWeight(VertexT v1,VertexT v2)
{
int i,j;
i=Vertexes.Locate(v1);
j=Vertexes.Locate(v2);
if(i | |j)
return NULL;
else
return Arcs[i][j];
}
template <class VertexT,class ArcT>
int Graph <VertexT,ArcT> ::GetFirstNeighbor(VertexT v)
{
int j=Vertexes.Locate(v)
if(j)
return -1;
else
for(i=0;i <Vertexes.Length();i++)
{
if(Arcs[j][i]==1)
return i;
}
}
template <class VertexT,class ArcT>
int Graph <VertexT,ArcT>::GetNextNeighbor(VertexT v1,VertexT v2)
{
int i,j;
i=Vertexes.Locate(v1);
j=Vertexes.Locate(v2);
if(i | |j)
return -1;
else
for(int k=v2+1;k <Vertexes.Length();k++)
if(Arcs[i][k]==1)
return k;
}
template <class VertexT,class ArcT>
int Graph <VertexT,ArcT>::InsertVertex(VertexT &v)
{
return Vertexes.Insert(v);
}
template <class VertexT,class ArcT>
int Graph <VertexT,ArcT> ::InsertArc(VertexT v1,VertexT v2)
{
int i,j;
i=Vertexes.Locate(v1);
j=Vertexes.Locate(v2);
if(i ||j)
return 0;
Arcs[i][j]=1;
CurrentNumArcs++;
return 1;
}
template <class VertexT,class ArcT>
void Graph <VertexT,ArcT> ::DeleteVertex(VertexT v)
{
int k=Vertexes.Locate(v);
for(int i=0;i <Vertexes.Length();i++)
{
if(Arcs[i][k]!=0)CurrentNumArcs--;
if(Arcs[k][i]!=0)CurrentNumArcs--;
}
for(i=v+1;i <Vertexes.Length();i++)
for(int j=0;j <Vertexes.Length();j++)
{
Arcs[i-1][j]=Arcs[i][j];
Arcs[j][i-1]=Arcs[j][i];
}
for(i=0;i <Vertexes.Length();i++)
{
Arcs[i][Vertexes.Length()-1]=0;
Arcs[Vertexes.Length()-1][i]=0;
}
Vertexes.Delete(k);
}
template<class VertexT,class ArcT>
void Graph <VertexT,ArcT> ::DeleteArc(VertexT v1,VertexT v2)
{
int i,j;
i=Vertexes.Locate(v1);
j=Vertexes.Locate(v2);
if(i | |j)
return ;
Arcs[i][j]=0;
CurrentNumArcs--;
}
template<class VertexT,class ArcT>
void Graph <VertexT,ArcT> ::DepthFirstSearch()
{
int num[MaxVertexes];
for(int i=0;i <Vertexes.Length();i++)
num[i]=0;
for( i=0;i <Vertexes.Length();i++)
{
if(num[i]==0)
DFS(i,num);
}
}
template<class VertexT,class ArcT>
void Graph <VertexT,ArcT>::DFS(int v,int num[])
{
int NextV[MaxVertexes]={0};
num[v]=1;
int j=0;
for(int i=0;i <Vertexes.Length();i++)
{
if(Arcs[v][i]==1)
{
NextV[j]=i;
j++;
}
}
for(j=0;NextV[j];j++)
{
if(num[NextV[j]]==0)
{
cout <<Vertexes.Get(v) <<"----" <<Vertexes.Get(NextV[j]) <<endl;
DFS(NextV[j],num);
}
}
}
//main.cpp
#include <iostream>
#include"Graph.h"
using namespace std;
void main()
{
Graph <char,int> graph;
int temp;
char temp1,temp2;
cout <<"请输入插入的顶点数:";
cin>> temp;
cout <<endl;
cout << "请输入顶点的值(字符):";
for(int i=0;i <temp;i++)
{
cin>> temp1;
graph.InsertVertex(temp1);
}
cout <<"请输入边的条数:";
cin>> temp;
cout <<endl;
cout <<"请输入插入边的起点和结尾:";
for(i=0;i <temp;i++)
{
cin>> temp1>> temp2;
graph.InsertArc(temp1,temp2);
}
graph.DepthFirstSearch();
}

ding1188 2007-11-28
  • 打赏
  • 举报
回复

for(int j=0; i <num; j++)
改为for(int j=0; j<num; j++)后,还是不能运行.
直接出现press any key to continue
PART I – 概览.........................................................................................................................11 第 1章 – DB2 Express-C是什么?..........................................................................................13 1.1免费开发、部署和分发… 无限制!...............................................................................13 1.2用户帮助和技术支持.....................................................................................................14 1.3 DB2服务器..................................................................................................................14 1.4 DB2客户端和驱动........................................................................................................14 1.5 应用程序开发的自由性.................................................................................................15 1.6 DB2 版本号与 DB2 版本分类........................................................................................16 1.7升级到其它的 DB2版本................................................................................................16 1.8 DB2 Express-C的维护.................................................................................................16 1.9相关免费软件................................................................................................................17 1.9.1 IBM数据工作室(Data Studio)...........................................................................17 1.9.2 DB2 Net Search Extender .....................................................................................17 1.9.3 Starter Toolkit for DB2 on Rails.............................................................................17 1.9.4 Web 2.0 Starter Toolkit for DB2 ............................................................................17 1.9.5 WebSphere Application Server – Community Edition............................................18 第 2章 – DB2相关特性和产品................................................................................................19 2.1 DB2 Express-C订购中包含的功能...............................................................................22 2.1.1 Fix packs补丁包...................................................................................................22 2.1.2高可用性灾难恢复(HADR) ................................................................................22 2.1.3数据复制(Data Replication)...............................................................................22 2.2 DB2 Express-C所不具备的功能...................................................................................23 2.2.1数据库分区............................................................................................................23 2.2.2连接集中器(Connection Concentrator ).............................................................23 2.2.3 Geodetic Extender ................................................................................................23 2.2.4工作负载管理(Workload Management, WLM) .......................................................24 2.3 DB2相关收费产品........................................................................................................24 2.3.1 DB2连接(DB2 Connect)...................................................................................24 2.3.2 WebSphere Federation Server..............................................................................24 2.3.3 WebSphere Replication Server .............................................................................25 第 3章 – 安装 DB2..................................................................................................................27 3.1安装前提条件................................................................................................................27 3.2操作系统中的安装权限.................................................................................................27 3.3安装向导.......................................................................................................................27 3.4自动安装.......................................................................................................................31 实验 #1 安装DB2 Express-C,创建 SAMPLE数据库........................................................32 第 4章 – DB2的应用环境.......................................................................................................35 实验 #2 - 创建一个新的数据库............................................................................................43 4.1 DB2配置......................................................................................................................44 4.1.1 环境变量................................................................................................................44 4.1.2 数据库管理器配置文件(dbm cfg) ...........................................................................44 4.1.3 数据库配置文件(db cfg)....................................................................................46 4.1.4 DB2 概要文件注册表.............................................................................................47 4.2 DB2管理服务器...........................................................................................................48 实验 #3 – 实例、数据库和配置管理....................................................................................49 第 5章 – DB2工具..................................................................................................................51 5.1控制中心(Control Center).........................................................................................52 5.2命令编辑器(Command Editor) .................................................................................55 5.3 SQL帮助向导(SQL Assist Wizard ).........................................................................57 5.4 显示SQL按钮..............................................................................................................58 实验 #4 使用脚本填充EXPRESS数据库...........................................................................59 5.5 脚本..............................................................................................................................60 5.5.1 SQL脚本...............................................................................................................60 5.5.2操作系统(shell)脚本..........................................................................................61 实验 #5 为EXPRESS数据库创建一个安装脚本.................................................................62 5.6任务中心(Task Center )...........................................................................................65 5.6.1工具目录(Tools Catalog)数据库........................................................................65 5.7 日志(Journal)...........................................................................................................66 5.8运行状况监视器(Health Monitor ).............................................................................67 5.8.1运行状况中心(Health Center )...........................................................................68 PART II – DB2 Express-C 数据库管......................................................................................71 第 6章 – DB2体系结构...........................................................................................................73 6.1 DB2进程模型...............................................................................................................73 6.2 DB2内存模型...............................................................................................................74 6.3 DB2存储模型...............................................................................................................75 6.3.1数据页和扩展数据块..............................................................................................75 6.3.2缓冲池...................................................................................................................76 6.3.3表空间...................................................................................................................77 第 7章 – DB2 客户端的连接....................................................................................................81 7.1 DB2 目录......................................................................................................................81 7.2 配置助手(Configuration Assistant )..........................................................................82 7.2.1服务器端的安装要求..............................................................................................82 7.2.2 Setup required at the client 客户端的安装要求......................................................84 7.2.3建立客户端与服务器端概要文件............................................................................87 实验 #6 使用配置助手........................................................................................................90 第 8章 – 数据库对象...............................................................................................................93 8.1 模式..............................................................................................................................93 8.2表.................................................................................................................................93 8.2.1数据类型................................................................................................................93 8.2.2标识列...................................................................................................................96 8.2.3序列对象................................................................................................................96 8.2.4系统目录表............................................................................................................97 8.2.5已声明临时表.........................................................................................................97 实验 #7 创建一个数据表.....................................................................................................99 8.3视图............................................................................................................................101 8.4索引............................................................................................................................101 8.4.1 Design Advisor ....................................................................................................101 8.5参照完整性.................................................................................................................102 第 9章 – 数据迁移工具..........................................................................................................105 9.1 导出(EXPORT)工具...............................................................................................106 9.2 导入(IMPORT)工具................................................................................................106 9.3 使用 LOAD来导入......................................................................................................107 9.4 db2move 工具...........................................................................................................108 9.5 db2look 工具..............................................................................................................109 实验 #8 导出EXPRESS数据库的DDL............................................................................111 第 10章 – 数据库安全...........................................................................................................115 10.1 认证..........................................................................................................................116 10.2 授权..........................................................................................................................116 10.3 DBADM权限............................................................................................................118 10.4 PUBLIC 组...............................................................................................................119 10.5 GRANT和REVOKE语句 ........................................................................................119 10.6 查看授权和特权........................................................................................................119 10.7 关于组特权...............................................................................................................121 实验 #9 授予和撤销用户的权限........................................................................................122 第 11章 – 备份和恢复...........................................................................................................125 11.1 数据库的日志记录....................................................................................................125 11.2 日志的类型...............................................................................................................126 11.3 日志记录的类型.......................................................................................................126 11.3.1 循环日志记录 ....................................................................................................126 11.3.2 档案日志记录和日志保留...................................................................................127 11.4 从控制中心进行数据库日志记录...............................................................................127 11.5 日志记录的参数........................................................................................................129 11.6 数据库备份...............................................................................................................129 实验 #10 – 安排一个备份计划..........................................................................................131 11.7 数据库恢复...............................................................................................................133 11.7.1 恢复类型............................................................................................................133 11.7.2 数据库恢复........................................................................................................133 11.8 其他关于备份和恢复的操作......................................................................................134 第 12章 – 维护任务...............................................................................................................135 12.1 重组(REORG)、运行统计(RUNSTATS)、重绑定(REBIND).......................135 12.1.1重组(REORG)命令........................................................................................135 12.1.2运行统计(RUNSTATS)命令 ..........................................................................136 12.1.3 绑定/重新绑定.................................................................................................136 12.1.4 在控制中心执行维护工作...................................................................................137 12.2 维护方式...................................................................................................................139 实验#11 – 配置自动维护.................................................................................................141 第 13章 – 并行与锁定...........................................................................................................143 13.1 事务(Transactions)..............................................................................................143 13.2 并行(Concurrency) ..............................................................................................143 13.3无并行控制导致的问题 .............................................................................................144 13.3.1丢失更新(Lost update)..................................................................................145 13.3.2未落实的读(Uncommitted read)....................................................................145 13.3.3不可重复读(Non-repeatable read).................................................................146 13.3.4幻象(Phantom read)......................................................................................146 13.4隔离级别(Isolation Levels)...................................................................................147 13.4.1未落实的读........................................................................................................147 13.4.2游标稳定性........................................................................................................147 13.4.3读稳定性............................................................................................................148 13.4.4可重复读............................................................................................................148 13.4.5隔离级别对比.....................................................................................................148 13.4.6设定隔离级别.....................................................................................................149 13.5锁定升级...................................................................................................................150 13.6锁定监视...................................................................................................................151 13.7锁定等待...................................................................................................................151 13.8死锁的引发与侦测.....................................................................................................152 13.9并行与锁定的最佳实践:..........................................................................................153 PART III – DB2 Express-C应用程序开发............................................................................155 第 14章 –SQL PL 存储过程..................................................................................................157 14.1 IBM数据工作室(Data Studio)..............................................................................158 14.1.2在Data Studio中创建一个存储过程..................................................................159 14.2 SQL PL 存储过程基础..............................................................................................161 14.2.1存储过程的结构.................................................................................................161 14.2.2 可选的存储过程属性..........................................................................................162 14.2.3参数...................................................................................................................162 14.2.4 SQL PL存储过程中的注释................................................................................163 14.2.5 复合语句............................................................................................................163 14.2.6 变量声明............................................................................................................163 14.2.7 赋值语句............................................................................................................164 14.3 游标..........................................................................................................................164 14.4 流控制......................................................................................................................164 14.5 调用存储过程 ...........................................................................................................165 14.6 错误和情况处理器....................................................................................................166 14.7 动态SQL..................................................................................................................168 第 15章 – 直接插入 SQL 过程语言、触发器、用户定义函数(UDF)..................................169 15.1直接插入SQL PL .....................................................................................................169 15.2 触发器(Trigger)....................................................................................................170 15.2.1 触发器的类型 ....................................................................................................170 实验 #12 从控制中心创建一个触发器...............................................................................174 15.3 用户定义函数 (UDF).................................................................................................177 15.3.1 标量函数(Scalar function).............................................................................177 15.3.2 表函数(Table function)..................................................................................178 实验 #13 使用IBM Data Studio创建用户定义函数(UDF)............................................179 第 16章 – DB2 pureXML......................................................................................................181 16.1 在数据库中使用XML................................................................................................181 16.2 XML数据库..............................................................................................................182 16.2.1 启用 XML的数据库............................................................................................182 16.2.2 原生 XML数据库...............................................................................................182 16.3 DB2中的XML..........................................................................................................183 16.3.1 pureXML 技术优势............................................................................................184 16.3.2 XPath基础........................................................................................................185 16.3.3 XQuery的定义..................................................................................................188 16.3.4 插入 XML文档...................................................................................................189 16.3.5 查询 XML数据...................................................................................................191 16.3.6 使用 SQL/XML执行联合操作............................................................................196 16.3.7 使用 XQuery执行联合操作................................................................................196 16.3.8 更新与删除操作.................................................................................................197 16.3.9 XML 索引.........................................................................................................198 实验 #14 - SQL/XML 和 XQuery.......................................................................................200 第 17章 – 使用 Java、PHP和 Ruby进行数据库应用开发...................................................201 17.1 Java应用程序开发...................................................................................................201 17.1.1 JDBC类型 2驱动程序.......................................................................................201 17.1.2 JDBC类型 4驱动程序.......................................................................................202 17.2 PHP应用程序开发...................................................................................................203 17.2.1 DB2为PHP提供的连接选项.............................................................................203 17.2.2 Zend Core for IBM.............................................................................................204 17.3 Ruby on Rails应用程序开发.....................................................................................206 17.3.1 Startup Toolkit for DB2 on Rails ........................................................................206 附录 A — 排除故障...............................................................................................................207 A.1 查找错误代码的更多信息...........................................................................................207 A.2 SQLCODE与SQLSTATE .........................................................................................208 A.3 DB2 管理通知日志.....................................................................................................208 A.4 db2diag.log................................................................................................................209 A.5 CLI追踪.....................................................................................................................209 A.6 DB2缺陷与补丁.........................................................................................................209 参考资源 ...............................................................................................................................210 网站..................................................................................................................................210 书籍..................................................................................................................................211

65,186

社区成员

发帖
与我相关
我的任务
社区描述
C++ 语言相关问题讨论,技术干货分享,前沿动态等
c++ 技术论坛(原bbs)
社区管理员
  • C++ 语言社区
  • encoderlee
  • paschen
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
  1. 请不要发布与C++技术无关的贴子
  2. 请不要发布与技术无关的招聘、广告的帖子
  3. 请尽可能的描述清楚你的问题,如果涉及到代码请尽可能的格式化一下

试试用AI创作助手写篇文章吧