db.cs

一个关于投票系统毕业设计


using System;
using System.Data;
using System.Configuration;
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;

/// <summary>
/// data 的摘要说明
/// </summary>
public class DB
{
    SqlConnection con = null;//定义一个类属性,类型为SQL连接
    SqlCommand cmd = new SqlCommand();//针对数据库操作的命令对象

    public DB()
    {
        con = new SqlConnection("Data Source=.;Initial Catalog=vote;uid=sa;pwd=sa;");
    }
    public SqlConnection getcon()
    {
        if (con.State == ConnectionState.Closed)
            con.Open();
        return con;


    }
    public SqlConnection clear()
    {
        if (con.State == ConnectionState.Open)
            con.Close();
        return con;



    }
    public void NonQueryexecute(string strsql)
    {
        
        cmd.Connection = getcon();
        cmd.CommandText = strsql;
        cmd.ExecuteNonQuery();
        clear();
      
    
    }
    //5	1	a	s	p	x.com

    public string executeGetReturn(string strsql)//strsql是传入SQL命令语句
    {
        //getcon();
        cmd.Connection = getcon();
        cmd.CommandText = strsql;
        string result = cmd.ExecuteScalar().ToString();
        clear();
        return result;

    }
    public SqlDataReader getsdr(string strsql)
    {
        cmd.Connection = getcon();
        cmd.CommandText = strsql;
        SqlDataReader sdr = cmd.ExecuteReader();
        return sdr;


    }
    public bool trantion(string[] sql)
    {
        bool flag = false;
        con = getcon();
        cmd.Connection = con;
        SqlTransaction mytransaction;
        mytransaction = con.BeginTransaction();
        try
        {
            for (int i = 0; i < sql.Length; i++)
            {
                cmd.Transaction = mytransaction;
                cmd.CommandText = sql[i];
                cmd.ExecuteNonQuery();

            }
            mytransaction.Commit();
            flag = true;

        }
        catch 
        {
            mytransaction.Rollback();
            flag = false;

        }
        finally
        {
            clear();

        }

        return flag;


    }
}