oralce 连接的实例

来源：互联网发布：靠垫知乎编辑：程序博客网时间：2024/05/18 01:51

本机已装Oracle服务端和客户端。

第一种：

public class BookDal222
    {
        private const string strConnect = "Data Source=orcl;Persist Security Info=True;User ID=system;Password=maokun;Unicode=True";
        public BookModel GetModel(int id)
        {
            BookModel model = new BookModel();
            OracleConnection conn = new OracleConnection(strConnect);
            conn.Open();
            OracleCommand cmd = new OracleCommand("select * from test_books ", conn);
            OracleDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                model.Bk_Id = reader["Bk_id"].ToString();
                model.Bk_Name = reader["Bk_Name"].ToString();

            }
            reader.Close();
            conn.Close();
            return model;
        }
    }

第二种：

public class BookDal
{

a .
private const string strConnect = "Provider=OraOLEDB.Oracle.1;Data Source=orcl;User Id=system;Password=maokun;";

b. private const string strConnect = "Provider=msdaora;Data Source=orcl;User Id=system;Password=maokun;";

        public BookModel GetModel(int id)
        {
            BookModel model = new BookModel();
            OleDbConnection conn = new OleDbConnection(strConnect);
            conn.Open();
            OleDbCommand cmd = new OleDbCommand("select * from test_books ", conn);
            OleDbDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                model.Bk_Id = reader["Bk_id"].ToString();
                model.Bk_Name = reader["Bk_Nqame"].ToString();

            }
            reader.Close();
            conn.Close();
            return model;
        }
    }