mvc程序连接数据库的方法可以有:
(1)在后台专门写一个连接数据库的静态封装方法。
public class OracleHelper
{
private static string connString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)" +
"(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));" +
"Persist Security Info=True;User ID=;Password=;";
public static OracleDataReader ExcuteDataReader(string sqlText)
{
OracleConnection con = new OracleConnection(connString);
con.Open();
OracleCommand cmd = new OracleCommand(sqlText, con);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
//增删改操作
public static int ExcuteNonQuery(string sqlText)
{
using (OracleConnection conn = new OracleConnection(connString))
{
using (OracleCommand cmd