重庆三峡学院
cmd.CommandText = \\
cmd.Connection = conn; OleDbDataAdapter dr = new OleDbDataAdapter(cmd.CommandText, conn.ConnectionString);
DataSet ds = new DataSet(); dr.Fill(ds, \ conn.Close(); return ds; } catch {
conn.Close();
MessageBox.Show(\查询失败！\ }
return null; }
public DataSet selectAll() {
try {
cmd.CommandText = \ cmd.Connection = conn; OleDbDataAdapter dr = new OleDbDataAdapter(cmd.CommandText, conn.ConnectionString);
DataSet ds = new DataSet(); dr.Fill(ds, \ conn.Close(); return ds; } catch {
conn.Close();
MessageBox.Show(\查询失败！\ }
return null; }
public void update(string classno, string classdepart, string special, string studyyears, string entertime) {
cmd.CommandText = %update classinfo set \special='\studyyears='\entertime='\where classno='\classno +
共 42 页 第 30 页
重庆三峡学院
\
cmd.Connection = conn; try {
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show(\修改成功！\ conn.Close(); } catch {
conn.Close();
MessageBox.Show(\修改失败！\ } } } }
2.3课程类
namespace StudentManagerSys {
class Course {
public String strCon;
public OleDbConnection conn; public OleDbCommand cmd;
public Course() {
strCon = \Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =\+ System.Windows.Forms.Application.StartupPath + @\ conn = new OleDbConnection(strCon); cmd = new OleDbCommand(); }
public void insert(string courseno, string coursename, string coursetype, string courseopenteam, string coursehours, string coursecredi) {
cmd.CommandText = \+ coursetype + \ cmd.Connection = conn; try {
共 42 页 第 31 页
重庆三峡学院
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show(\添加成功\ } catch {
MessageBox.Show(\添加失败！\ } }
public void delete(string courseno) {
cmd.CommandText = \ cmd.Connection = conn; try {
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show(\删除成功！\ conn.Close(); } catch {
conn.Close();
MessageBox.Show(\删除失败！\ } }
public DataSet select(string selectype,string item) {
try {
if (selectype == \ {
cmd.CommandText = \\
cmd.Connection = conn;
OleDbDataAdapter dr = new OleDbDataAdapter(cmd.CommandText, conn.ConnectionString);
DataSet ds = new DataSet(); dr.Fill(ds, \ conn.Close(); return ds; }
共 42 页 第 32 页
重庆三峡学院
else {
cmd.CommandText = \ cmd.Connection = conn;
OleDbDataAdapter dr = new OleDbDataAdapter(cmd.CommandText, conn.ConnectionString);
DataSet ds = new DataSet(); dr.Fill(ds, \ conn.Close(); return ds; } } catch {
conn.Close();
MessageBox.Show(\查询失败！\ }
return null; }
public DataSet selectAll() {
try {
cmd.CommandText = \ cmd.Connection = conn; OleDbDataAdapter dr = new OleDbDataAdapter(cmd.CommandText, conn.ConnectionString);
DataSet ds = new DataSet(); dr.Fill(ds, \ conn.Close(); return ds; } catch {
conn.Close();
MessageBox.Show(\查询失败！\ }
return null; }
public void update(string courseno, string coursename, string coursetype, string courseopenteam, string coursehours, string coursecredi) {
共 42 页 第 33 页
重庆三峡学院
cmd.CommandText = %update course set \+ \+ coursename + \coursetype='\coursecredi=\ cmd.Connection = conn; try {
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show(\修改成功！\ conn.Close(); } catch {
conn.Close();
MessageBox.Show(\修改失败！\ } } } }
2.4成绩类
namespace StudentManagerSys {
class Score {
public String strCon;
public OleDbConnection conn; public OleDbCommand cmd;
public Score() {
strCon = \Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =\+ System.Windows.Forms.Application.StartupPath + @\ conn = new OleDbConnection(strCon); cmd = new OleDbCommand(); }
public void insert(string studentno, string courseno, string coursescore) {
cmd.CommandText = \into score(studentno,courseno,coursescore) values(\+ \+ studentno + \ cmd.Connection = conn; try
共 42 页 第 34 页