当前文件： QuikStartVote/App_Code/DB.cs[2K，2009-6-12 11:52:48]，打开代码结构图

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10//增加命名空间
 11using System.Data.SqlClient;
 12
 13/**//// <summary>
 14/// DB 的摘要说明
 15/// </summary>
 16public class DB
 17...{
 18    SqlConnection con = null;
 19    SqlCommand cmd = new SqlCommand();
 20
 21    //DB构造函数
 22    public DB()
 23    ...{
 24        con = new SqlConnection("server=.\\SQLEXPRESS;database=vote;uid=sa;pwd=sa;");
 25    }
 26
 27    //打开数据库连接
 28    public SqlConnection getCon()
 29    ...{
 30        if(con.State==ConnectionState.Closed)
 31            con.Open();
 32        return con;
 33    }
 34
 35    //关闭数据库连接
 36    public void clear()
 37    ...{
 38        if(con.State==ConnectionState.Open)
 39            con.Close();
 40    }
 41
 42    //取出标题
 43    public string executeGetReturn(string sqlcon)
 44    ...{
 45        cmd.Connection = getCon();
 46        cmd.CommandText = sqlcon;
 47
 48        String result = Convert.ToString(cmd.ExecuteScalar());
 49        clear();
 50        return result;
 51    }
 52
 53    //取出标题项目
 54    public SqlDataReader getSdr(string sqlcon)
 55    ...{ 
 56        cmd.Connection=getCon();
 57        cmd.CommandText = sqlcon;
 58
 59        SqlDataReader sdr = cmd.ExecuteReader();
 60        return sdr;
 61    }
 62
 63    //将投票者的IP和投票时间写入数据库
 64    public int executeNonQuery(string sqlcon)
 65    ...{
 66        cmd.Connection = getCon();
 67        cmd.CommandText = sqlcon;
 68        int i=cmd.ExecuteNonQuery();
 69        clear();
 70        return i;
 71    }
 72
 73    //设置投票的事物机制
 74    public bool executeTransaction(string[] sqlcon)
 75    ...{
 76        bool flag = false;
 77        con = getCon();
 78        cmd.Connection = con;
 79
 80        SqlTransaction voteTransaction=con.BeginTransaction();
 81        try
 82        ...{
 83            foreach (string sql in sqlcon)
 84            ...{
 85                cmd.Transaction = voteTransaction;
 86                cmd.CommandText = sql;
 87                cmd.ExecuteNonQuery();
 88            }
 89            voteTransaction.Commit();
 90            flag = true;
 91        }
 92
 93        catch (Exception e)
 94        ...{
 95            voteTransaction.Rollback();
 96            flag = false;
 97        }
 98        finally 
 99        ...{
100            clear();
101        }
102        return flag;
103    }
104
105}
106