数据库连接方法

2015-11-19 11:29:04

存在问题：
如何不调用数据库连接类文件，直接实现后台命令对数据库的操作

---

解决方案：
增删改查方法如下

/增加方法
            //数据库连接字符串
            string mySqlStr = "Data Source=jdlcerp;User ID=jduser;Password=jduser";
            OracleConnection cnn = new OracleConnection(mySqlStr);
            cnn.Open();
            OracleCommand Comm = new OracleCommand();
            Comm.Connection = cnn;
            //第一种插入方法
            //Comm.CommandText = "insert into xszxf(zxfid,lx,zxf) values('6','练习',3)";
            //第二种插入方法
            Comm.CommandText = "insert into xszxf(zxfid,lx,zxf) values(:zxfid,:lx,:zxf)";//变量只能用:开始
            OracleParameter parn = new OracleParameter(":zxfid", "4");
            Comm.Parameters.Add(parn);
            OracleParameter parp = new OracleParameter(":zxf", 3);
            Comm.Parameters.Add(parp);
            OracleParameter parl = new OracleParameter(":lx", "3");
            Comm.Parameters.Add(parl);
            //执行
            Comm.ExecuteNonQuery();
            cnn.Close();


 //删除
            OracleConnection conn = new OracleConnection();
            conn.ConnectionString = "User ID=jduser;Password=jduser;data source=jdlcerp";
            conn.Open();
            OracleCommand comm = new OracleCommand();
            comm.CommandText = "delete from xszxf where zxfid=:zxfid";
            comm.Connection = conn;
            OracleParameter parZ = new OracleParameter(":zxfid","1");
            comm.Parameters.Add(parZ);
            comm.ExecuteNonQuery();
            conn.Close();


            //修改
            OracleConnection conn = new OracleConnection();
            conn.ConnectionString = "User ID=jduser;Password=jduser;data source=jdlcerp";
            conn.Open();
            OracleCommand comm = new OracleCommand();
            comm.Connection = conn;
            comm.CommandText = " update xszxf set zxf=:zxf where zxfid=:zxfid";
            OracleParameter parZ = new OracleParameter(":zxf","hah");
            comm.Parameters.Add(parZ);
            OracleParameter parID = new OracleParameter(":zxfid","2");
            comm.Parameters.Add(parID);
            comm.ExecuteNonQuery();
            conn.Close();


 //查询
            OracleConnection conn = new OracleConnection();
            conn.ConnectionString = "User ID=jduser;Password=jduser;data source=jdlcerp";
            conn.Open();
            OracleCommand comm = new OracleCommand();
            comm.Connection = conn;
            comm.CommandText = "select * from xszxf";
            OracleDataAdapter da = new OracleDataAdapter(comm);
            //da.SelectCommand = comm;
            //DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            da.Fill(dt);
            conn.Close();
            GridView1.DataSource = dt;
            GridView1.DataBind();