本机已装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; } }
