https://www.myziyuan.com/
- qian
- 图书馆的预订系统具有以下职能：（1）向订阅组提供供应商部门的订阅。（2）预订小组将预订从每个单位预订。（3）为此提供预订文件根据本书供应商的预订文件。（4）向供应商送回书籍信息（包括数量，数量等）。（5）通知订书机信息管理器。（6）重复订单的书签是自动的由系统检查并将结果送回订书机。根据需要将此问题的数据流图归还，并将其转换为软件结构图。我应该做什么？我不明白，人，专家来看。
- 2022-01-06 00:43:03
- LouisWang
- 图书管理系统,进入vc#，创建一个界面from1新建一个DBconn类:using System;using System.Collections.Generic;using System.Text;using System.Data.SqlClient;namespace test{ public class DBConn { public static string connStr = "Server=.;DataBase=myschool;Uid=sa;pwd=123"; public static SqlConnection conn = new SqlConnection(connStr); }}下面是窗体,有两个文本框,txtno,txtname,四个按钮增,删,改,查using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace test{ public partial class Form2 : Form { public Form2() { InitializeComponent(); } DataSet ds; SqlDataAdapter ada; string sql = null; SqlCommand cmd;//查询 private void btnSearch_Click(object sender, EventArgs e) { ShowView(); } private void ShowView() { ds = new DataSet("myschool"); if (ds.Tables.Count > 0) ds.Tables.Clear(); sql = "SELECT * FROM classinfo"; ada = new SqlDataAdapter(sql, DBConn.conn); ada.Fill(ds); this.dataGridView1.DataSource = ds.Tables[0]; }//添加 private void btnAdd_Click(object sender, EventArgs e) { sql = string.Format("INSERT classInfo VALUES ({0},'{1}')", int.Parse(txtNo.Text), txtName.Text); cmd = new SqlCommand(sql, DBConn.conn); DBConn.conn.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("添加成功!"); } else { MessageBox.Show("添加失败!"); } DBConn.conn.Close(); ShowView(); }//删除 private void btnDelete_Click(object sender, EventArgs e) { sql = string.Format("delete classinfo WHERE classno = {0}", int.Parse(txtNo.Text)); cmd = new SqlCommand(sql, DBConn.conn); DBConn.conn.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("删除成功!"); } else { MessageBox.Show("删除失败!"); } DBConn.conn.Close(); ShowView(); }//修改 private void btnUpdate_Click(object sender, EventArgs e) { SqlCommandBuilder bl = new SqlCommandBuilder(ada); ada.Update(ds); ShowView(); } }}然后自己调试去吧
- 2022-01-06 00:43:03
开通会员