课程设计实验报告Word格式文档下载.docx
- 文档编号:20708131
- 上传时间:2023-01-25
- 格式:DOCX
- 页数:28
- 大小:631.65KB
课程设计实验报告Word格式文档下载.docx
《课程设计实验报告Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《课程设计实验报告Word格式文档下载.docx(28页珍藏版)》请在冰豆网上搜索。
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
namespace图书管理系统
{
publicpartialclassForm1:
Form
{
//publicstringuser;
publicForm1()
InitializeComponent();
}
privatevoidbutton2_Click(objectsender,EventArgse)
MessageBox.Show("
请查找出正确的用户名和密码"
);
privatevoidbutton1_Click(objectsender,EventArgse)
string用户名=textBox1.Text;
string密码=textBox2.Text;
string权限="
0"
;
if(radioButton1.Checked==true)
权限="
1"
elseif(radioButton2.Checked==true)
stringconsqlserver=@"
Datasource=localhost;
InitialCatalog=图书管理系统;
IntegratedSecurity=True"
SqlConnectioncon=newSqlConnection(consqlserver);
stringsql=string.Format("
selectcount(*)from权限设置where用户名='
{0}'
and密码='
{1}'
and权限='
{2}'
"
用户名,密码,权限);
try
con.Open();
SqlCommandcommand=newSqlCommand(sql,con);
intnum=(int)command.ExecuteScalar();
if(num>
0)
欢迎进入图书管理系统"
学生页面xuesheng=new学生页面();
//学生页面user=new学生页面();
xuesheng.user=textBox1.Text;
//xuesheng.user=textBox1.Text;
xuesheng.Show();
this.Visible=false;
else
输入的用户名或者密码错误,请重新检查后再登录"
管理员页面?
guanliyuan=new管理员页面();
//guanliyuan.user=textBox1.Text;
guanliyuan.Show();
输入的密码或用户名错误,请检查后再登录"
catch(Exceptionex)
MessageBox.Show(ex.Message);
finally
con.Close();
privatevoidForm1_Load(objectsender,EventArgse)
privatevoidlabel1_Click(objectsender,EventArgse)
}
publicpartialclass学生个人信息表:
publicstringuser1;
public学生个人信息表)
stringstr1=@"
DataSource=localhost;
SqlConnectionmycon;
SqlDataAdaptermyda;
DataSetmyds;
intcounts=0;
intMaxValue;
privatevoidshowdata()
textBox1.Text=user1;
stringstrSql="
Select学号,姓名,性别,院系,班级from学生表;
mycon=newSqlConnection(str1);
myda=newSqlDataAdapter(strSql,mycon);
myds=newDataSet();
myda.Fill(myds);
//dataGridView1.DataSource=myds.Tables[0];
privatevoidshowInfo(intsta)
myda=newSqlDataAdapter("
select*from学生表where学号="
+textBox1.Text,mycon);
textBox2.Text=myds.Tables[0].Rows[sta][1].ToString();
textBox3.Text=myds.Tables[0].Rows[sta][2].ToString();
textBox4.Text=myds.Tables[0].Rows[sta][3].ToString();
textBox5.Text=myds.Tables[0].Rows[sta][4].ToString();
privatevoid学生个人信息表Load(objectsender,EventArgse)
showdata();
showInfo(0);
mycon.Open();
SqlCommandcommand=newSqlCommand("
selectCount(*)from学生表,mycon);
MaxValue=Convert.ToInt32(command.ExecuteScalar());
mycon.Close();
privatevoidtextBox1_TextChanged(objectsender,EventArgse)
publicpartialclass学生库存:
publicstringuser3;
public学生库存()
stringstrCon=@"
SqlCommandcmd;
staticintcounts=0;
intcount;
privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse)
privatevoiddataGridView1_CellClick(objectsender,DataGridViewCellEventArgse)
privatevoid总体显示()
textBox5.Text=user3;
stringsql="
select书号,书名,作者,出版社,类别from图书where书号notin(select书号from图书借阅)"
mycon=newSqlConnection(strCon);
myda=newSqlDataAdapter(sql,mycon);
dataGridView1.DataSource=myds.Tables[0];
privatevoid详细显示(intsta)
select*from图书where书号notin(select书号from图书借阅)"
mycon);
textBox1.Text=myds.Tables[0].Rows[sta][0].ToString();
comboBox1.Text=myds.Tables[0].Rows[sta][4].ToString();
privatevoid学生库存_Load(objectsender,EventArgse)
//不可编辑();
总体显示();
详细显示
(1);
selectCount(*)from图书where书号notin(select书号from图书借阅)"
privatevoidbutton1_Click_1(objectsender,EventArgse)
SqlCommandmycom;
stringstrDel="
deletefrom图书where书号="
+textBox1.Text;
mycom=newSqlCommand(strDel,mycon);
mycom.ExecuteNonQuery();
MaxValue-=1;
详细显示(MaxValue-1);
SqlConnectionmycon1;
mycon1=newSqlConnection(strCon);
mycon1.Open();
stringstrInsert="
insertinto图书借阅(学号,书号,书名)values('
+textBox5.Text+"
'
'
+textBox1.Text+"
+textBox2.Text+"
)"
SqlCommandmycom1;
mycom1=newSqlCommand(strInsert,mycon1);
mycom1.ExecuteNonQuery();
mycon1.Close();
//学生个人借阅图书grjy=new学生个人借阅图书);
//grjy.user3=textBox1.Text;
//grjy.user4=textBox2.Text;
//grjy.ShowDialog();
privatevoiddataGridView1_CellClick_1(objectsender,DataGridViewCellEventArgse)
textBox1.Text=myds.Tables[0].Rows[e.RowIndex][0].ToString();
textBox2.Text=myds.Tables[0].Rows[e.RowIndex][1].ToString();
textBox3.Text=myds.Tables[0].Rows[e.RowIndex][2].ToString();
textBox4.Text=myds.Tables[0].Rows[e.RowIndex][3].ToString();
comboBox1.Text=myds.Tables[0].Rows[e.RowIndex][4].ToString();
catch(Exceptiones)
请点击正确的位置"
"
警告"
MessageBoxButtons.OK,MessageBoxIcon.Warning);
privatevoiddataGridView1_CellContentClick_1(objectsender,DataGridViewCellEventArgse)
stringstr1;
for(inti=1;
i<
dataGridView1.RowCount;
i++)
if(this.dataGridView1.Rows[i]!
=null)
str1=Convert.ToString(this.dataGridView1.Rows[i]);
详细显示(i-1);
break;
publicpartialclass学生个人借阅图书:
publicstringuser2;
//publicstringuser3;
//publicstringuser4;
public学生个人借阅图书)
textBox1.Text=user2;
select学号,书号,书名,借书日期from图书借阅where学号="
+textBox1.Text;
privatevoid学生个人借阅图书酣Load(objectsender,EventArgse)
selectCount(*)from图书借阅where学号="
+textBox1.Text,mycon);
publicpartialclass图书增加:
public图书增加()
privatevoid图书增加_Load(objectsender,EventArgse)
comboBox1.Items.Add("
计算机"
文学"
法学"
外语"
经济"
数学"
语言"
comboBox1.DropDownStyle=ComboBoxStyle.DropDownList;
this.Clears();
if(textBox1.Text=="
)
请输入图书的信息"
提示"
return;
if(textBox2.Text=="
if(textBox3.Text=="
if(textBox4.Text=="
if(comboBox1.Text=="
stringstrInsert="
insertinto图书书号,书名,作者,出版社,类别)values('
+textBox1.Text+"
+textBox2.Text+"
+textBox3.Text+"
+textBox4.Text+"
+comboBox1.Text+"
mycom=newSqlCommand(strInsert,mycon);
已成功插入该记录"
//MaxValue+=1;
//showInfo(0);
//showdata();
//mycon.Close();
privatevoidClears()
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
privatevoidbutton3_Click(objectsend
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 课程设计 实验 报告