小知识(七)

在oracle中创建一个数据库比如说叫xmgl,它跟sqlserver不一样,sqlserver如果创建一个xmgl的数据库的话会直接创建一个xmgl.MDF的数据库文件，但在oracle中会创建一个xmgl的文件夹，然后你就可以先创建一个表空间A再创建一个用户A，将该用户A的默认表空间设为A，在创建表空间的时候会自动创建一个数据文件ora或dbf(与sqlserver不同,它不是一个数据库,但也差不多里面就是表视图什么的)，该数据文件就位于这个表空间A里，用户A可以操作该数据文件，当然也可以再创建一个数据文件，用户A同样可以操作它。

dbf文件与ora文件 http://zhidao.baidu.com/question/101928613.html

备份/还原(貌似win7有问题) exp导出dmp imp导入dmp

http://www.cnblogs.com/yugen/archive/2010/07/25/1784763.html

备份与还原也可以在plsql里的工具里更方便的进行，同时也可以看到当前用户可以管理的所有表空间，该用户默认表空间里的表不加表空间前缀，而不是默认的表空间比如是tb,里面有个表是tbnew，则会看到整个表是tb.tbnew，同样用sql语句可以 select * from tb.tbnew 这样来查。

将别处导出的dmp文件导入到一个数据库里，也可用plsql，导入的数据文件就是当前登录用户的默认表空间里的数据文件。

dblink

两台不同的数据库服务器，从一台数据库服务器的一个用户读取另一台数据库服务器下的某个用户的数据，这个时候可以使用dblink。

http://wenku.baidu.com/view/1ed8100190c69ec3d5bb756f.html

create public database link link_name connect to username identified by password using 'SID或TNS';

查询远程数据库服务器上的某个表 select * from 表明@link_name

12.公司分页方法

----------------------------------------------1--------------------------------------------------------

 <link href="UI/themes/default/easyui.css" rel="stylesheet" type="text/css" />
 <link href="UI/themes/icon.css" rel="stylesheet" type="text/css" />

int perPage = 20; //每页显示的记录条

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int recorders = 获取总记录数;
            rCount.InnerText = recorders.ToString();
            int pages = 0;
            if (recorders % perPage == 0)
            {
                pages = recorders / perPage;
            }
            else
            {
                pages = recorders / perPage + 1;
            }
            pageCount.InnerText = pages.ToString();
            createFolderDetials(1, 1, perPage);
        }
    }
    private void createFolderDetials(int current, int start, int end)
    {
        int recorders = int.Parse(rCount.InnerText.Trim());
        int pages = int.Parse(pageCount.InnerText.Trim());
        enableButtons(current, pages);
        DataTable dt =分页方法（见公司分页方法2）
        grwXX.DataSource = dt;
        grwXX.DataBind();
    }
    //firs page
    protected void firstPage_Click(object sender, EventArgs e)
    {
        createFolderDetials(1, 1, perPage);
    }
    //prev page
    protected void prePage_Click(object sender, EventArgs e)
    {
        int current = int.Parse(select.SelectedValue);
        current--;
        createFolderDetials(current, (current - 1) * perPage + 1, (current * perPage));
    }
    //next
    protected void nextPage_Click(object sender, EventArgs e)
    {
        int current = int.Parse(select.SelectedValue);
        current++;
        createFolderDetials(current, (current - 1) * perPage + 1, (current * perPage));
    }
    //last
    protected void endPage_Click(object sender, EventArgs e)
    {
        int current = int.Parse(pageCount.InnerText.Trim());
        createFolderDetials(current, (current - 1) * perPage + 1, (current * perPage));
    }
    //select change
    protected void select_SelectedIndexChanged(object sender, EventArgs e)
    {
        int current = int.Parse(select.SelectedValue);
        createFolderDetials(current, (current - 1) * perPage + 1, (current * perPage));
    }
    private void enableButtons(int current, int pages)
    {

        initSelect(current, pages);

        if (pages == 0 || pages == 1)
        {
            firstPage.Enabled = false;
            prePage.Enabled = false;
            nextPage.Enabled = false;
            endPage.Enabled = false;
        }
        else
        {
            if (current == 1)
            {
                firstPage.Enabled = false;
                prePage.Enabled = false;
                nextPage.Enabled = true;
                endPage.Enabled = true;
            }
            else
                if (current == pages)
                {

                    firstPage.Enabled = true;
                    prePage.Enabled = true;
                    nextPage.Enabled = false;
                    endPage.Enabled = false;
                }
                else
                {
                    firstPage.Enabled = true;
                    prePage.Enabled = true;
                    nextPage.Enabled = true;
                    endPage.Enabled = true;
                }
        }
    }
    //initialize the select
    private void initSelect(int current, int pages)
    {
        //此处数字20代表下拉框当前显示几页，如果小于20页就1到 current，如果大于20页就 current到 current+20页
        int start = current - 20;
        start = start <= 0 ? 1 : start;
        var end = current + 20;
        end = end <= pages ? end : pages;
        select.Items.Clear();
        int temp = 0;
        for (int i = start; i <= end; i++)
        {
            select.Items.Add(new ListItem(i.ToString(), i.ToString()));
            if (i == current)
            {
                select.SelectedIndex = temp;
            }
            temp++;
        }
        if (pages == 0)
        {
            select.Items.Add(new ListItem("0", "0"));
            rCount.InnerText = "0";
            pageCount.InnerText = "0";
        }
    }

<div id="pagediv" runat="server" class="toolbar" style="padding: 0px; background: #efefef;

                        width: 100%; vertical-align: bottom; bottom: 0px;">
                        <asp:LinkButton ID="firstPage" class="easyui-linkbutton" ToolTip="首页" plain="true"
                            iconcls="pagination-first" runat="server" OnClick="firstPage_Click">首页</asp:LinkButton>
                        <asp:LinkButton ID="prePage" class="easyui-linkbutton" ToolTip="上一页" plain="true"
                            iconcls="pagination-prev" runat="server" OnClick="prePage_Click">上一页</asp:LinkButton>
                        <asp:LinkButton ID="nextPage" class="easyui-linkbutton" ToolTip="下一页" plain="true"
                            iconcls="pagination-next" runat="server" OnClick="nextPage_Click">下一页</asp:LinkButton>
                        <asp:LinkButton ID="endPage" class="easyui-linkbutton" ToolTip="末页" plain="true"
                            iconcls="pagination-last" runat="server" OnClick="endPage_Click">末页</asp:LinkButton>
                        <span class="spinner-text">第</span>
                        <asp:DropDownList ID="select" runat="server" class="combo" AutoPostBack="True" OnSelectedIndexChanged="select_SelectedIndexChanged">
                        </asp:DropDownList>
                        <span class="spinner-text">页/共&nbsp;</span><span id="pageCount" class="spinner-text"
                            style="color: #3399CC;" runat="server"></span>&nbsp;<span class="spinner-text">页</span>
                        <span class="spinner-text">共&nbsp;</span><span id="rCount" class="spinner-text" style="color: #3399CC;"
                            runat="server"></span>&nbsp;<span class="spinner-text">条</span>
                    </div>

----------------------------------------------2--------------------------------------------------------

/*-----------toolbar-------------------------*/

a
{
	text-decoration: underline;
}


.toolbar
{
	height: 28px;
	line-height: 28px;
	white-space: nowrap;
	border: 1px solid #DDDCE4;
	background-color: #EFEFEF;
	font-size: 12px;
	color: #1F6487;
}
.menubar
{
	margin-bottom: 1px;
	border-bottom: 1px solid #DDDCE4;
	color: #1F6487;
}
.pagebar
{
	margin-top: 1px;
	border-top: 1px solid #DDDCE4;
	color: #1F6487;
}

/*------------分割线--------------------------*/
.menu-sep-h
{
	border-left: outset #DDDCE4 1px;
	height: 28px;
	margin-left: 10px;
	margin-right: 10px;
}
.menu-sep-v
{
	margin: auto 3px;
	width: 2px;
	font-size: 2px;
	background: url('../../UI/themes/default/images/menu_sep.png') repeat-x;
}
/*------------分页左右部分---------------------*/
.pagebar-left
{
	float: left;
}
.pagebar-right span
{
	font-weight: 900;
	margin-left: 5px;
	margin-right: 5px;
}
.pagebar-right
{
	float: left;
}

int perPageCount = 20;   //每页显示的记录条
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
   {
       initGridview(1, 1, perPageCount);
    }
 }
private void initGridview(int current, int start, int end)
{
    DataTable dt = new DataTable();
    int recorders = 0;   //数据行数
    int pages = 0;    //页数
    recorders=获取总记录数
    lblRecorderCount.Text = recorders.ToString();
    if (recorders % perPageCount == 0)
    {
       pages = recorders / perPageCount;
    }
    else
    {
       pages = recorders / perPageCount + 1;
     }
     lblPageCount.Text = pages.ToString();
     this.ddlCurrentPage.Items.Clear();
     for (int i = 1; i <= pages; i++)
    {
       this.ddlCurrentPage.Items.Add(new ListItem(i.ToString(), i.ToString()));
     }
     if (ddlCurrentPage.Items.Count > 0)
    {
       this.ddlCurrentPage.SelectedIndex = current - 1;//当前页绑定
     }
     else
    {
       ddlCurrentPage.Items.Add(new ListItem("0", "0"));
     }
     dt = 分页语句返回需要的那部分数据(start,end);
//oracle分页语句  SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME [可选过滤条件 WHERE FIEILD_NAME 条件]) A WHERE ROWNUM <= 40) WHERE RN >= 21   有时是对多表查询的结果进行分页，可能会有一些表的字段名字相同，会报ORA-00918: 未明确定义列的错误，需要将前面的A.*指出具体的字段A.某字段(但某字段不能是那些字段名相同的字段)
     GridView.DataSource=dt;   GridView.DataBind();
     enableButtons(pages, current);
    }

//使能翻页按钮
    private void enableButtons(int pages, int current)
    {
        if (pages == 0 || pages == 1)
        {
            this.btnFirstPage.Enabled = false;
            this.btnPrePage.Enabled = false;
            this.btnNextPage.Enabled = false;
            this.btnEndPage.Enabled = false;
        }
        else
        {
            if (current == 1)
            {
                this.btnFirstPage.Enabled = false;
                this.btnPrePage.Enabled = false;
                this.btnNextPage.Enabled = true;
                this.btnEndPage.Enabled = true;
            }
            else
                if (current == pages)
                {
                    this.btnFirstPage.Enabled = true;
                    this.btnPrePage.Enabled = true;
                    this.btnNextPage.Enabled = false;
                    this.btnEndPage.Enabled = false;
                }
                else
                {
                    this.btnFirstPage.Enabled = true;
                    this.btnPrePage.Enabled = true;
                    this.btnNextPage.Enabled = true;
                    this.btnEndPage.Enabled = true;
                }
        }
    }

 //首页
    protected void btnFirstPage_Click(object sender, EventArgs e)
    {
        initGridview(1, 0, perPageCount);
    }
    //上一页
    protected void btnPrePage_Click(object sender, EventArgs e)
    {
        int current = ddlCurrentPage.SelectedIndex + 1;
        current -= 1;
        initGridview(current, (current - 1) * perPageCount + 1, current * perPageCount);
    }
    //下一页
    protected void btnNextPage_Click(object sender, EventArgs e)
    {
        int current = ddlCurrentPage.SelectedIndex + 1;
        current += 1;
        initGridview(current, (current - 1) * perPageCount + 1, current * perPageCount);
    }
    //末页
    protected void btnEndPage_Click(object sender, EventArgs e)
    {
        int current = ddlCurrentPage.Items.Count;
        initGridview(current, (current - 1) * perPageCount + 1, current * perPageCount);
    }
    //下拉
    protected void ddlCurrentPage_SelectedIndexChanged(object sender, EventArgs e)
    {
        int current = ddlCurrentPage.SelectedIndex + 1;
        initGridview(current, (current - 1) * perPageCount + 1, current * perPageCount);
    }

<div class="toolbar pagebar">

<asp:Button ID="btnFirstPage" runat="server" Text="首页" OnClick="btnFirstPage_Click" />
        <asp:Button ID="btnPrePage" runat="server" Text="上一页" OnClick="btnPrePage_Click" />
        <asp:Button ID="btnNextPage" runat="server" Text="下一页" OnClick="btnNextPage_Click" />
        <asp:Button ID="btnEndPage" runat="server" Text="末页" OnClick="btnEndPage_Click" />
        <label>
            当前第</label>
        <asp:DropDownList ID="ddlCurrentPage" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlCurrentPage_SelectedIndexChanged">
        </asp:DropDownList>
        <label>
            页</label>
        <label>
            共</label>
        <asp:Label ID="lblPageCount" runat="server" Text=""></asp:Label>
        <label>
            页</label>
        <label>
            共</label>
        <asp:Label ID="lblRecorderCount" runat="server" Text=""></asp:Label>
        <label>
            条记录</label>
    </div>

kendezhu

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
小知识(七)

1.TreeView SelectedNodeChanged事件锁定当前选中节点注意sender是TreeViewprotected void trvwJdmc_SelectedNodeChanged(object sender, EventArgs e) { string val=((TreeView)sender).SelectedNode.Value; ...
复制链接

扫一扫