简单数据库操作 DBOper

数据库字符串

web.config中

<connectionStrings>
		<add name="OraclAdoConnection" connectionString="Data Source=dbname;Persist Security Info=True;User ID=username;Password=psw;Unicode=True"/>
</connectionStrings>

后台处理

    public class DBOper
    {
        private static string connectionstring = ConfigurationManager.ConnectionStrings["OraclAdoConnection"].ConnectionString;
        private DataSet ds = null;
        private OracleDataAdapter oda = null;
        private OracleConnection con = null;
        public OracleConnection GetConnection()
        {
            return new OracleConnection(connectionstring);
        }
        //返回DataSet
        public DataSet GetDataSet(string sql)
        {
            using (con = GetConnection())
            {
                ds = new DataSet();
                oda = new OracleDataAdapter(sql, con);
                oda.Fill(ds);
            }
            return ds;
        }
        //返回DataTable
        public DataTable GetDataTable(string sql)
        {
            using (con = GetConnection())
            {
                ds = new DataSet();
                oda = new OracleDataAdapter(sql, con);
                oda.Fill(ds);
            }
            return ds.Tables[0];
        }
        //更新
        public void Update(string sql)
        {
            using (con = GetConnection())
            {
                con.Open();
                OracleCommand cmd = new OracleCommand(sql, con);
                cmd.ExecuteNonQuery();
                con.Close();
            }
        }
        //ExecuteNoQuery
        public int ExecuteNoQuery(string sql)
        {
            int count;
            using (con = GetConnection())
            {
                con.Open();
                OracleCommand cmd = new OracleCommand(sql, con);
               count= cmd.ExecuteNonQuery();
                con.Close();
            }
            return count;
        }
        //ExecuteScalar
        public object ExecuteScalar(string sql)
        {
            object count;
            using (con = GetConnection())
            {
                con.Open();
                OracleCommand cmd = new OracleCommand(sql, con);
                count = cmd.ExecuteScalar();
                con.Close();
            }
            return count;
        }
    }