简易数据库包装类DBCtrl

最新推荐文章于 2022-08-15 09:41:55 发布
原创 最新推荐文章于 2022-08-15 09:41:55 发布 · 925 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#数据库 #command #dataset #string #null #byte

本文介绍了一个简单的数据库包装类DBCtrl的设计与实现细节。该类旨在简化数据库操作流程，通过提供连接、断开连接及获取记录等功能，为开发者提供便利。文章详细展示了如何通过继承base_Ctrl类来支持不同类型的数据库连接。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

简易的数据库包装类DBCtrl， 在开始学习ORM之前先mark一下

/-------------------------结构--------------------------------

/-------------------------baseCtrl

                                     |---------------------sqlCtrl

                                     |---------------------odbcCtrl

                                     |(可扩充,OLEDB等……)

/----------------------------------------------------------------

baseCtrl:

using System;
using System.Data;

namespace DBCtrl
{
    /// <summary>
    /// base_Ctrl 的摘要说明。
    /// </summary>
    public class base_Ctrl
    {
        public base_Ctrl()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //            
        }

        public virtual bool ConnectDB()
        {
            return false;
        }

        public virtual string GetError()
        {//返回错误信息
            return "";
        }

        public virtual bool IsHaveRecord(string command)
        {//探测数据库，是否存在指定内容
            return false;
        }

        public virtual bool disConnectDB()
        {//断开数据库
            return false;
        }

        public virtual string GetValue(string command)
        {//取得数据库文本内容            
            return "";
        }

        public virtual bool EditRecord(string command,int time_out)
        {//对数据库进行操作
            return false;
        }

        public virtual bool EditRecord(string command)
        {//对数据库进行操作
            return false;
        }

        public virtual DataRow GetRow(string command)
        {//得到数据库中一行    
            DataRow dr1 = null;
            return dr1;
        }

        public virtual DataTable GetRecord(string command,int time_out)
        {
            //得到数据库中一张表
            //参数：命令，超时时间
            DataTable dt1 = new DataTable();
            return dt1;
        }

        public virtual DataTable GetRecord(string command,string table_Name)
        {
            //得到数据库中一张表
            //参数：命令，填充的表名
            DataTable dt1 = new DataTable();
            return dt1;
        }

        public virtual DataTable GetRecord(string command)
        {
            //得到数据库中一张表
            DataTable dt1 = new DataTable();
            return dt1;
        }
        
        public virtual DataSet GetDataSet(string command,string table)
        {
            //得到一个数据集
            //参数：命令，表名
            DataSet ds1 = new DataSet();
            return ds1;
        }

        public virtual DataSet GetDataSet(string command)
        {
            //得到一个数据集
            DataSet ds1 = new DataSet();
            return ds1;
        }

        public virtual bool GetImage(string command,string imagename,out byte[] imagedata)
        {
            //得到图像
            imagedata = null;
            return false;
        }

        ~base_Ctrl()
        {
            try
            {
                disConnectDB();
            }
            catch
            {}
        }

    }
}

 

sqlCtrl

 

using System;
using System.Data;
using System.Data.SqlClient;

namespace DBCtrl
{
    /// <summary>
    /// sqlCtrl 的摘要说明。
    /// </summary>
    public class sqlCtrl:base_Ctrl
    {
        
        private string connString;
        private string errorMessage;    
        private SqlConnection sqlConn;

        public sqlCtrl(string connStr)
        {//构造函数
            connString=connStr;
            errorMessage="";
        }

        public override bool ConnectDB()
        {
            //连接数据库
            sqlConn=new SqlConnection(connString);
            try
            {
                sqlConn.Open();                
            }
            catch(SqlException ee)
            {
                errorMessage=ee.ToString();
                return false;
            }            
            return true;
        }

        public override string GetError()
        {//返回错误信息
            return errorMessage;
        }

        public override bool IsHaveRecord(string command)
         {//探测数据库，是否存在指定内容
             bool bl;
             bl=ConnectDB();
             if(!bl)
             {
                 return false;
             }        
             SqlCommand cmd=new SqlCommand(command,sqlConn);
             SqlDataReader reader;
             try
             {
                 reader=cmd.ExecuteReader();
                 if(reader.Read())
                 {                    
                     reader.Close();
                     SqlDataAdapter da=new SqlDataAdapter(cmd);
                     DataSet ds=new DataSet();
                     da.Fill(ds);
                     if(ds.Tables[0].Rows.Count<1)
                     {
                         disConnectDB();
                         return false;
                     }
                     bl=disConnectDB();
                     if(!bl)
                     {
                         return false;
                     }
                     return true;
                 }
                 else
                 {
                     reader.Close();
                     disConnectDB();
                     errorMessage="No Record in Database!";
                     return false;
                 }
             }
             catch(SqlException ee)
             {
                errorMessage=ee.ToString();
                 disConnectDB();
                return false;
             }        
         }

        public override bool disConnectDB()
        {//断开数据库
            try
            {
                sqlConn.Close();
            }
            catch(SqlException ee)
            {
                errorMessage=ee.ToString();
                return false;
            }
            return true;
        }

        public override string GetValue(string command)
        {//取得数据库文本内容
            string str="error";

            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return "error";
            }            
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            SqlDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();

                    SqlDataAdapter Adapter=new SqlDataAdapter(cmd);
                    DataSet ds= new DataSet();
                    Adapter.Fill(ds);                    
                    
                    str=ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim();

                    bl=disConnectDB();
                    if(!bl)
                    {
                        return "error";
                    }

                    return str.Trim();
                    
                }
                else
                {
                    disConnectDB();
                    reader.Close();
                    errorMessage="No Record in Database!";
                    return "error";
                }
            }
            catch(SqlException ee)
            {
                errorMessage=ee.ToString();
                disConnectDB();
                return "error";    
            }    
        }

        public override bool EditRecord(string command,int time_out)
        {//对数据库进行操作
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return false;
            }
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            cmd.CommandTimeout = time_out;
            SqlDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();                
                reader.Close();
            }
            catch(SqlException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return false;
            }
            bl=disConnectDB();
            if(!bl)
            {
                return false;
            }
            return true;
        }

        public override bool EditRecord(string command)
        {//对数据库进行操作
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return false;
            }
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            SqlDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();                
                reader.Close();
            }
            catch(SqlException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return false;
            }
            bl=disConnectDB();
            if(!bl)
            {
                return false;
            }
            return true;
        }

        public override DataRow GetRow(string command)
        {//得到数据库中一行
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }            
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            SqlDataReader reader;
            DataSet ds=new DataSet();
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {                    
                    reader.Close();
                    SqlDataAdapter da=new SqlDataAdapter(cmd);                    
                    da.Fill(ds);
                    if(ds==null)
                    {
                        disConnectDB();
                        return null;
                    }
                    if(ds.Tables[0].Rows.Count<1)
                    {
                        disConnectDB();
                        return null;
                    }
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }    

                    return ds.Tables[0].Rows[0];                
                }
                else
                {
                    reader.Close();
                    errorMessage="No Record in Database!";
                    disConnectDB();
                    return null;
                }
            }
            catch(SqlException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return null;
            }            
        }

        public override DataTable GetRecord(string command,int time_out)
        {//得到数据库中一张表
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            cmd.CommandTimeout = time_out;
            SqlDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    SqlDataAdapter da=new SqlDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    return ds.Tables[0];
                }
                else
                {
                    reader.Close();
                    disConnectDB();
                    errorMessage="No Record in Database!";
                    return null;
                }
            }
            catch(SqlException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return null;
            }
        }

        public override DataTable GetRecord(string command,string table_Name)
        {//得到数据库中一张表
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            SqlDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    SqlDataAdapter da=new SqlDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds,table_Name);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    
                    return ds.Tables[table_Name];
                }
                else
                {
                    reader.Close();
                    disConnectDB();
                    errorMessage="No Record in Database!";
                    return null;
                }
            }
            catch(SqlException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return null;
            }
        }

        public override DataTable GetRecord(string command)
        {//得到数据库中一张表
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            SqlDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    SqlDataAdapter da=new SqlDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    return ds.Tables[0];
                }
                else
                {
                    reader.Close();
                    disConnectDB();
                    errorMessage="No Record in Database!";
                    return null;
                }
            }
            catch(SqlException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return null;
            }
        }

        public override DataSet GetDataSet(string command,string table)
        {//得到一个数据集
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            SqlDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    SqlDataAdapter da=new SqlDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds,table);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    return ds;
                }
                else
                {
                    reader.Close();
                    disConnectDB();
                    errorMessage="No Record in Database!";
                    return null;
                }
            }
            catch(SqlException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return null;
            }
        }

        public override DataSet GetDataSet(string command)
        {//得到一个数据集
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            SqlDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    SqlDataAdapter da=new SqlDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    return ds;
                }
                else
                {
                    reader.Close();
                    disConnectDB();
                    errorMessage="No Record in Database!";
                    return null;
                }
            }
            catch(SqlException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return null;
            }
        }

        public override bool GetImage(string command,string imagename,out byte[] imagedata)
        {//得到图像
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                imagedata = new byte[1];
                imagedata[0] = (byte)2;
                return false;
            }            
            SqlCommand cmd=new SqlCommand(command,sqlConn);
            SqlDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {            
                    imagedata = (byte[])reader[imagename];
                    reader.Close();

                    bl=disConnectDB();
                    if(!bl)
                    {
                        imagedata = new byte[1];
                        imagedata[0] = (byte)2;
                        return false;
                    }
                    
                    return true;                    
                }
                else
                {
                    imagedata = new byte[1];
                    imagedata[0] = (byte)2;
                    reader.Close();
                    disConnectDB();
                    errorMessage="No Record in Database!";
                    return false;
                }
            }
            catch(SqlException ee)
            {
                imagedata = new byte[1];
                imagedata[0] = (byte)2;
                errorMessage=ee.ToString();
                disConnectDB();
                return false;
            }
        }

        
        ~sqlCtrl()
        {
            try
            {
                disConnectDB();
            }
            catch
            {}
        }
        
    }
}

 

odbcCtrl:

 

using System;
using System.Data;
using System.Data.Odbc;

namespace DBCtrl
{
    /// <summary>
    /// odbcCtrl 的摘要说明。
    /// </summary>
    public class odbcCtrl:base_Ctrl
    {        
        private string connString;
        private string errorMessage;    
        private OdbcConnection  OdbcConn; 

        public odbcCtrl(string connStr)
        {//构造函数
            connString=connStr;
            errorMessage="";
        }

        public override bool ConnectDB()
        {//连接数据库
            OdbcConn=new OdbcConnection(connString);
            try
            {
                OdbcConn.Open();                
            }
            catch(OdbcException ee)
            {
                errorMessage=ee.ToString();
                return false;
            }            
            return true;
        }

        public override string GetError()
        {//返回错误信息
            return errorMessage;
        }

        public override bool IsHaveRecord(string command)
        {//探测数据库中是否存在指定内容
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return false;
            }        
            OdbcCommand cmd=new OdbcCommand(command,OdbcConn);
            OdbcDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {                    
                    reader.Close();
                    OdbcDataAdapter da=new OdbcDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds);
                    if(ds.Tables[0].Rows.Count<1)
                    {
                        disConnectDB();
                        return false;
                    }
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return false;
                    }
                    return true;
                }
                else
                {
                    reader.Close();
                    disConnectDB();
                    errorMessage="No Record in Database!";
                    return false;
                }
            }
            catch(OdbcException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return false;
            }
        }

        public override bool disConnectDB()
        {//断开数据库
            try
            {
                OdbcConn.Close();
            }
            catch(OdbcException ee)
            {
                errorMessage=ee.ToString();
                return false;
            }
            return true;
        }

        public override string GetValue(string command)
        {//返回文本内容
            string str="error";

            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return "error";
            }            
            OdbcCommand cmd=new  OdbcCommand(command,OdbcConn);
            OdbcDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();

                    OdbcDataAdapter Adapter=new  OdbcDataAdapter(cmd);
                    DataSet ds= new DataSet();
                    Adapter.Fill(ds);                    
                    
                    str=ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim();

                    bl=disConnectDB();
                    if(!bl)
                    {
                        return "error";
                    }

                    return str.Trim();    
                    
                }
                else
                {
                    reader.Close();
                    disConnectDB();
                    errorMessage="No Record in Database!";
                    return "error";
                }
            }
            catch(OdbcException ee)
            {
                disConnectDB();
                errorMessage=ee.ToString();
                return "error";
            }
        }

        public override bool EditRecord(string command)
        {//操作数据库
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return false;
            }
            OdbcCommand cmd=new  OdbcCommand(command,OdbcConn);
            OdbcDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();                
                reader.Close();
            }
            catch(OdbcException ee)
            {
                errorMessage=ee.ToString();
                disConnectDB();
                return false;
            }
            bl=disConnectDB();
            if(!bl)
            {
                return false;
            }
            return true;
        }

        public override DataRow GetRow(string command)
        {//得到数据库中一行
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }            
            OdbcCommand cmd=new  OdbcCommand(command,OdbcConn);
            OdbcDataReader reader;
            DataSet ds=new DataSet();
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {                    
                    reader.Close();
                    OdbcDataAdapter da=new OdbcDataAdapter(cmd);                    
                    da.Fill(ds);
                    if(ds==null)
                    {                        
                        disConnectDB();
                        return null;
                    }
                    if(ds.Tables[0].Rows.Count<1)
                    {
                        disConnectDB();
                        return null;
                    }
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }            
                    return ds.Tables[0].Rows[0];        
                }
                else
                {
                    reader.Close();
                    errorMessage="No Record in Database!";
                    disConnectDB();
                    return null;
                }
            }
            catch(OdbcException ee)
            {
                errorMessage=ee.ToString();
                disConnectDB();
                return null;
            }        
        }

        public override DataTable GetRecord(string command,int time_out)
        {//得到一张表
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            OdbcCommand cmd=new OdbcCommand(command,OdbcConn);
            cmd.CommandTimeout = time_out;
            OdbcDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    OdbcDataAdapter da=new OdbcDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    return ds.Tables[0];
                }
                else
                {
                    reader.Close();
                    errorMessage="No Record in Database!";
                    disConnectDB();
                    return null;
                }
            }
            catch(OdbcException ee)
            {
                errorMessage=ee.ToString();
                disConnectDB();
                return null;
            }
        }

        public override DataTable GetRecord(string command,string table_Name)
        {//得到指定表名的表            
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            OdbcCommand cmd=new OdbcCommand(command,OdbcConn);
            OdbcDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    OdbcDataAdapter da=new OdbcDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds,table_Name);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    return ds.Tables[table_Name];
                }
                else
                {
                    reader.Close();
                    errorMessage="No Record in Database!";
                    disConnectDB();
                    return null;
                }
            }
            catch(OdbcException ee)
            {
                errorMessage=ee.ToString();
                disConnectDB();
                return null;
            }
        }

        public override DataTable GetRecord(string command)
        {//得到一张表
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            OdbcCommand cmd=new OdbcCommand(command,OdbcConn);
            OdbcDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    OdbcDataAdapter da=new OdbcDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    return ds.Tables[0];
                }
                else
                {
                    reader.Close();
                    errorMessage="No Record in Database!";
                    disConnectDB();
                    return null;
                }
            }
            catch(OdbcException ee)
            {
                errorMessage=ee.ToString();
                disConnectDB();
                return null;
            }
        }

        public override DataSet GetDataSet(string command,string table)
        {//得到一个数据集
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            OdbcCommand cmd=new OdbcCommand(command,OdbcConn);
            OdbcDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    OdbcDataAdapter da=new OdbcDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds,table);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    return ds;
                }
                else
                {
                    reader.Close();
                    errorMessage="No Record in Database!";
                    disConnectDB();
                    return null;
                }
            }
            catch(OdbcException ee)
            {
                errorMessage=ee.ToString();
                disConnectDB();
                return null;
            }
        }

        public override DataSet GetDataSet(string command)
        {//得到一个数据集
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                return null;
            }
            OdbcCommand cmd=new OdbcCommand(command,OdbcConn);
            OdbcDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {
                    reader.Close();
                    OdbcDataAdapter da=new OdbcDataAdapter(cmd);
                    DataSet ds=new DataSet();
                    da.Fill(ds);
                    bl=disConnectDB();
                    if(!bl)
                    {
                        return null;
                    }
                    return ds;
                }
                else
                {
                    reader.Close();
                    errorMessage="No Record in Database!";
                    disConnectDB();
                    return null;
                }
            }
            catch(OdbcException ee)
            {
                errorMessage=ee.ToString();
                disConnectDB();
                return null;
            }
        }

        public override bool GetImage(string command,string imagename,out byte[] imagedata)
        {//得到图像
            bool bl;
            bl=ConnectDB();
            if(!bl)
            {
                imagedata = new byte[1];
                imagedata[0] = (byte)2;
                return false;
            }            
            OdbcCommand cmd=new OdbcCommand(command,OdbcConn);
            OdbcDataReader reader;
            try
            {
                reader=cmd.ExecuteReader();
                if(reader.Read())
                {                

                    imagedata = (byte[])reader[imagename];
                    reader.Close();

                    bl=disConnectDB();
                    if(!bl)
                    {
                        imagedata = new byte[1];
                        imagedata[0] = (byte)2;
                        return false;
                    }
                    
                    return true;
                    
                }
                else
                {
                    imagedata = new byte[1];
                    imagedata[0] = (byte)2;
                    reader.Close();
                    errorMessage="No Record in Database!";
                    disConnectDB();
                    return false;
                }
            }
            catch(OdbcException ee)
            {
                imagedata = new byte[1];
                imagedata[0] = (byte)2;
                errorMessage=ee.ToString();
                disConnectDB();
                return false;
            }
        }

        ~odbcCtrl()
        {
            try
            {
                disConnectDB();
            }
            catch
            {}
        }
        

    }
}
C++封装mysql数据库操作类及其使用
小米的修行之路
04-23 2906
1、封装类： #pragma once #include <mysql.h> #include <iostream> using namespace std; class mysqlConn { public: mysqlConn(); ~mysqlConn(); //连接 bool connect(string user, string passWord, string dbName, string ip, unsigned short port = 3306, u
一文带你了解三大开源关系型数据库：SQLite、MySQL和PostgreSQL
最新发布
dvlinker的技术专栏
10-08 5万+
一文带你了解三大开源关系型数据库：SQLite、MySQL和PostgreSQL。
通用数据库控制模块DBCtrl
09-13
该控制模块使用VS2008编写，通过该模块可以直接操作ACCESS,POSTGRE等通用数据库
链接数据库代码封装DBDA
03-30 288
<?php class DBDA { public $host = "localhost"; //服务器地址 public $uid = "root"; //数据库的用户名 public $pwd = "123"; //数据库的密码 //执行SQL语句，返回相应结果的函数 //$sql是要执行的SQL语句 ...
数据库JDBC包装实现
abc98526的博客
03-11 999
定义增删改查的接口 package cn.com.aistudynet.base; /** * 该接口表示数据库配置信息 */ public interface Config { /** * 数据库加载驱动 */ String drive = "com.mysql.cj.jdbc.Driver"; /** *数据库电脑所在的ip地址 */ String ip="localhost"; /** * 数据库在
数据库的封装
sun5208的专栏
11-11 1253
DB.javapackage com.sun.shopping.util;import java.sql.*;public class DB { static{    try {    Class.forName("com.mysql.jdbc.Driver");   } catch (ClassNotFoundException e) {    e.printStackTrace()
数据库封装 sql server mysql_mysql数据库封装
weixin_28788593的博客
01-18 156
/*** name: sql操作封装，可扩展 .* User: 张云山* Date: 2016/9/4* Time: 22:02*///php文件编码设置header('Content-type: text/html; charset=utf-8');//数据库类class sqled {public function addTabase($sql_url,$sql_name,$sql_pss,$...
PDO-数据库包装器类
02-20
PDO包装器数据库类 PHP-MySQL的数据库类，它使用PDO扩展名。 如何设定 在config.php中编辑数据库设置 // Database Settings define('DB_SERVER', "localhost"); // Database Host define('DB_USER', "root"); // ...
Python SQLite3数据库操作类分享
09-10
Python SQLite3数据库操作类是为了简化对SQLite数据库的交互而设计的一种自定义工具。SQLite3是Python内置的一个轻量级数据库引擎，它允许开发者在无需独立数据库服务器的情况下存储和管理数据。这种操作类的设计...
Odb.rar_odb_oracle_oracle cpp_封装类_数据库 封装
09-24
"封装类"和"数据库封装"则表明这个项目的核心是提供了一种抽象，将复杂的数据库操作包装在易于使用的C++类中。 在压缩包的文件名列表中，我们看到"www.pudn.com.txt"可能是一个链接到发布该资源的网站的文本文件，...
关于数据包装的一些想法
los1poserC的博客
06-29 468
最近也是在写后台管理系统，系统中的列表展示总是少不了要展示各种字段，其中包括本表的字段，还有涉及其他表的外键字段，因为在本表中那些外键字段存储的一般是ID，但展示在页面的则需要是名称，所以对这些数据也是需要进行查询 对于这些数据，我就以我的经验来看，大概可以用以下几种方式来进行包装 1、连表查询 这是最简单，直接在sql上进行关联查询，这种方式算是比较普遍的，但这种写法的话就是sql较为臃肿，特别是关联字段比较多的，用这种方式会让后续的维护扩展有一定的难度 2、装饰器模式 第二个就是使用jav
创建通用数据库访问包装类
曾青松的专栏
01-26 1299
package skydev.modules.data;import java.sql.*;/** * 使用ODBC的方法： * "sun.jdbc.odbc.JdbcOdbcDriver" * "jdbc:odbc:" + odbcName * * "oracle.thin.Driver" * "qwe.sql.qweMySqlDriver" * "symantec.dbanywhere
DBCtrlGrid
weixin_30611509的博客
06-25 629
procedure TForm1.FormShow(Sender: TObject); begin ADOTable1.Open; end; procedure TForm1.DBCtrlGrid1PaintPanel(DBCtrlGrid: TDBCtrlGrid; Index: Integer); var Status:string; Tname:str...
数据库安装
m0_63217468的博客
08-15 772
数据库安装
TDBCtrlGrid如何使用?
Cable Fan编程笔记
11-26 3404
要使每条记录(面板)显示的照片来自该记录中的某个字段,为什么不行? procedure TfrmConfluence.DBCtrlGrid1PaintPanel(DBCtrlGrid: TDBCtrlGrid; Index: Integer);var S: String;begin try Image1.Picture:= nil; S:= DBC
Tdbgrid应用大全
fanhongbin的专栏
02-18 2286
1.隔行不同颜色显示  with TDBGrid(Sender) do  begin    if (gdSelected in State) or (gdFocused in State) then      Canvas.Brush.Color := clAqua    else if DataSource.DataSet.RecNo mod 2 = 0 then      Canvas.Bru
ASP.NET数据库操作类实例与管理
此外，类中可能还包含其他辅助方法，如执行SQL查询、更新、插入或删除操作，这些方法通常会包装`SqlCommand`对象，以简化开发者在编写业务逻辑时的代码。可能还会提供参数化查询，以防止SQL注入攻击，提高安全性。 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值