网站导航网学 原创论文 原创专题 网站设计 最新系统 原创论文 论文降重 发表论文 论文发表 UI设计定制 论文答辩PPT格式排版 期刊发表 论文专题
返回网学首页
网学原创论文
最新论文 推荐专题 热门论文 论文专题
当前位置: 网学 > 交易代码 > SQL语法 > 正文

sql操作类

论文降重修改服务、格式排版等 获取论文 论文降重及排版 论文发表 相关服务
/*******************************************
    *功能:数据库操作相关
    *作者:FlashICP
    *时间:2005-7-22
    *******************************************/
    usingSystem;
    usingSystem.Data;
    usingSystem.Data.SqlClient;
    usingSystem.Web;
    namespacemoban
    {
    publicclassdata
    {
    protectedstaticstringcon="server=[yourserver];database=[yourdata];userid=[yourid];password=[youpassword]";
    //数据库字符串
    protectedSystem.Data.SqlClient.SqlConnectionDataConnection;
    //数据库连接对象
    protectedSystem.Data.SqlClient.SqlDataAdapterDataAdapter;
    //SqlDataAdapter对象
    protectedSystem.Data.SqlClient.SqlCommandDataCommand;
    //SqlCommand对象
    protectedSystem.Data.SqlClient.SqlCommandBuilderDataComBuilder;
    //SqlCommandBuilder对象
    protectedSystem.Data.DataSetDataSet;
    //DataSet对象
    protectedSystem.Data.DataRowDataRow;
    //DataRow对象
    protectedSystem.Data.SqlClient.SqlDataReaderDataReader=null;
    //构造函数
    publicdata()
    {
    DataConnection=DataConn();
    
    }
    //连接数据库参数
    publicstringCon
    {
    
    get{returncon;}
    set{con=value;}
    
    }
    //数据库连接参数
    publicSqlConnectionDataConn()
    {
    DataConnection=newSqlConnection(Con);
    returnDataConnection;
    
    }
    //返回数据库连接对象
    publicSqlDataReaderDataQuery(stringSql)
    {
    Sql=Sql.Replace("--","");
    Sql=Sql.Replace(";","");
    DataConnection=DataConn();
    DataConnection.Open();
    DataReader=null;
    DataCommand=newSqlCommand(Sql,DataConnection);
    DataReader=DataCommand.ExecuteReader();
    DataCommand.Dispose();
    returnDataReader;
    }
    //返回DataSet
    publicvirtualDataSetDataSetQuery(stringSql,stringTableName)
    {
    DataConnection=DataConn();
    DataAdapter=newSqlDataAdapter(Sql,DataConnection);
    DataSet=newDataSet();
    DataAdapter.Fill(DataSet,TableName);
    DataAdapter.Dispose();
    DataConnection.Close();
    DataConnection.Dispose();
    returnDataSet;
    }
    //返回DataSet
    publicDataSetDataSetQuery(DataSetmyds,stringTableName,stringSql)
    {
    DataConnection=DataConn();
    DataAdapter=newSqlDataAdapter(Sql,DataConnection);
    DataAdapter.Fill(myds,TableName);
    DataConnection.Close();
    DataConnection.Dispose();
    returnDataSet;
    }
    //返回DataSet
    publicDataSetDataSetQuery(stringSql,stringTableName,intStarIndex,intCount)
    {
    DataConnection=DataConn();
    DataConnection.Open();
    DataAdapter=newSqlDataAdapter(Sql,DataConnection);
    DataSet=newDataSet();
    DataAdapter.Fill(DataSet,StarIndex,Count,TableName);
    DataConnection.Close();
    DataConnection.Dispose();
    returnDataSet;
    }
    publicvoidDataDo(stringsqlstr)
    {
    DataConnection=DataConn();
    SqlCommandmycom=DataConnection.CreateCommand();
    mycom.CommandText=sqlstr;
    DataConnection.Open();
    mycom.ExecuteNonQuery();
    DataConnection.Close();
    }
    //返回DataSet开始行到结束行
    publicboolEditData(stringSql)
    {
    DataConnection=DataConn();
    DataConnection.Open();
    DataCommand=newSqlCommand(Sql,DataConnection);
    try
    {
    DataCommand.ExecuteNonQuery();
    DataConnection.Close();
    returntrue;
    }
    catch(Exceptionex)
    {
    System.Console.Write(ex.Message.ToString());
    DataConnection.Close();
    returnfalse;
    }
    }
    //执行成功返回真,否则返回假.
    publicobjectExecuteScalar(stringSql)
    {
    DataConnection=DataConn();
    DataConnection.Open();
    DataCommand=newSqlCommand(Sql,DataConnection);
    try
    {
    objectback=DataCommand.ExecuteScalar();
    DataConnection.Close();
    returnback;
    }
    catch(Exceptionex)
    {
    System.Console.Write(ex.Message.ToString());
    DataConnection.Close();
    returnnull;
    }
    }
    //返回一个值的查询语句
    publicDataSetEditData(DataSetDataSet,SqlDataAdaptermyda,stringTableName)
    {
    
    
    DataComBuilder=newSqlCommandBuilder(myda);
    myda.UpdateCommand=DataComBuilder.GetUpdateCommand();
    myda.DeleteCommand=DataComBuilder.GetDeleteCommand();
    myda.InsertCommand=DataComBuilder.GetInsertCommand();
    myda.Update(DataSet,TableName);
    DataSet.AcceptChanges();
    this.CloseConnection();
    returnDataSet;
    }
    //修改DataSet并且修改数据库值存储过程
    publicboolDataProcedure(stringProcedureName)
    {
    DataConnection=DataConn();
    DataConnection.Open();
    DataCommand=newSqlCommand();
    DataCommand.CommandText=ProcedureName;
    DataCommand.Connection=DataConnection;
    
    
    DataCommand.CommandType=System.Data.CommandType.StoredProcedure;
    try
    {
    DataCommand.ExecuteNonQuery();
    returntrue;
    }
    catch(Exceptionex)
    {
    System.Console.Write(ex.Message.ToString());
    returnfalse;
    }
    }
    
    //无参数存储过程的执行返回执行真假
    publicvoidCloseConnection()
    {
    if(DataReader!=null)
    {
    DataReader.Close();
    DataReader=null;
    }
    DataConnection.Close();
    DataConnection.Dispose();
    }
    //关闭连接
    
    }
    }
    
  • 上一篇资讯: sql教程(1)
  • 下一篇资讯: SQL操作全集
  • 设为首页 | 加入收藏 | 网学首页 | 原创论文 | 计算机原创
    版权所有 网学网 [Myeducs.cn] 您电脑的分辨率是 1280 x 720 像素
    Copyright 2008-2020 myeducs.Cn www.myeducs.Cn All Rights Reserved 湘ICP备09003080号 常年法律顾问:王律师