学生成绩管理系统设计说明书(7)

重庆三峡学院

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 页

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库学生成绩管理系统设计说明书(7)在线全文阅读。