管理系统具体功能实现.docVIP

系统的部分源代码 using System; using System.Collections.Generic; using System.Text; using System.Data.OleDb; using System.Data; using System.Configuration; namespace 课程设计万次火柴.dbManager { class dbManager { private DataSet ds = new DataSet(); private OleDbConnection conn() { OleDbConnection myconn = new OleDbConnection(); string mystr = ConfigurationManager.ConnectionStrings[课程设计万次火柴.connectionStrings].ToString(); myconn.ConnectionString = mystr; myconn.Open(); return myconn; } private void close() { conn().Close(); } public void executeSql(string sql,string table) { OleDbDataAdapter sda = new OleDbDataAdapter(sql,conn()); sda.Fill(ds,table); } public OleDbDataReader executeReaderSql(string sql) { OleDbCommand cmd = new OleDbCommand(); cmd.CommandText = sql; cmd.Connection = conn(); return cmd.ExecuteReader(); } public bool findUser(string userName, string pwd) { string mySel = SELECT * FROM admin where userName= + userName + ; OleDbDataReader Dr; Dr = executeReaderSql(mySel); while (Dr.Read()) { string DrPwd = Dr[2].ToString(); if (DrPwd == pwd) { return true; } } this.close(); return false; } 添加管理员 public void addAdmin(string p) { string sql = insert into admin (userName)values( + p + 万次火柴); executeSql(sql,admin); } public void delAdmin(string userName) { string sql = delete from admin where userName= + userName + ; executeSql(sql,admin); } public DataSet dataSourse() { ds.Clear(); conn();