db_class.cs

在线小说阅读

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace novel
{
    public class DB_Class
    {
        private SqlConnection con;

        private void open()
        {
            con = new SqlConnection("server=.;database=novel;uid=sa;pwd=");
            if (con.State == System.Data.ConnectionState.Closed)
                con.Open();
        }

        private void close()
        {
            if (con != null)
                con.Close();
        }
        //查询
        public SqlDataReader Reader(string sqlstr)
        {
            SqlDataReader dr = null;
            try
            {
                open();
                SqlCommand cmd = new SqlCommand(sqlstr, con);
                dr = cmd.ExecuteReader();

            }
            catch
            {
                dr.Close();
                close();
                throw;

            }
            return dr;

        }

        //修改
        public bool ExecSql(string sqlstr)
        {
            try
            {
                open();
                SqlCommand cmd = new SqlCommand(sqlstr, con);
                cmd.ExecuteNonQuery();
                return true;
            }
            catch
            {
                return false;
                close();
                throw;
            }
        }


        //绑定
        public DataSet dst(string sqlstr)
        {
            DataSet ds = new DataSet();
            try
            {
                open();
                SqlDataAdapter ada = new SqlDataAdapter(sqlstr, con);
                ada.Fill(ds);
            }
            catch
            {
                close();
                throw;
            }
            return ds;
        }
    }
}