项目系统结构
一.数据库设计
1.需求分析:
(1)浏览所有教材信息,对教材信息进行增、删、改、查操作。
(2)浏览所有学生信息,对学生信息进行增、删、改、查操作。
(3)按年级、班级来统计教材征订的数量、金额等信息。
2.数据库概念设计:
(1) 登录信息: {账号,密码,姓名,}
(2).学生信息:{学号,班级,姓名,性别,出生日期,电话}
(3) 教材信息:{教材编号,教材名称,作者名,出版社,金额,库存}
3.系统E-R图:
二.系统所用的工具:
(1)Microsoft Visual Studio 2015,
(2)Microsoft SQL Server Management Studio 18
三.所需的环境:
(1)Visual Studio 2015
(2)SQL Server 2008
四.调试成功后基本流程的截图
(1)登录(from1)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace index691
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string connstr = Data Source=DESKTOP-OL0R6DR\SQLEXPRESS;Initial Catalog=JL691;Integrated Security=True;
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
string sqlstr = "select psd691 from Users691 where uid691='" + textBox1.Text + "'";
SqlCommand cmd = new SqlCommand(sqlstr, conn);
SqlDataReader dt = cmd.ExecuteReader();
if (dt.HasRows)
{
while (dt.Read())
{
if (dt["psd691"].ToString() == textBox2.Text)
{
MessageBox.Show("教材系统登录成功","欢迎登录");
this.Hide();
Main691 f = new Main691();
f.Show();
}
else
{
MessageBox.Show("登录失败");
}
}
}
conn.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
}
}
}
(2)系统页面(main691)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace index691
{
public partial class Main691 : Form
{
public Main691()
{
InitializeComponent();
}
private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
{
Close();
}
private void Main691_Resize(object sender, EventArgs e)
{
this.Invalidate(true);
}
private void 学生信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
Student691 f = new Student691();
f.MdiParent = this;
f.Show();
}
private void 教材信息EToolStripMenuItem_Click(object sender, EventArgs e)
{
books691 f = new books691();
f.MdiParent = this;
f.Show();
}
private void timer1_Tick(object sender, EventArgs e)
{
toolStripStatusLabel3.Text = DateTime.Now.ToString("yy-MM-dd HH:mm:ss");
}
private void 教材管理VToolStripMenuItem_Click(object sender, EventArgs e)
{
bostats691 f = new bostats691 ();
f.MdiParent = this;
f.Show();
}
private void 添加学生信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
Student691 f = new Student6