上机实习报告总结结尾
一.首页
代码如下;
using System;
using ;
using ;
using ;
using ;
using ;
using ;
namespace WindowsApplication1
{
public partial cla Form5 : Form {
public Form5()
{
InitializeComponent();
}
private void button1_Click(object sender, {
logo from = new logo();
(); EventArgs e)
} private void button2_Click(object sender, EventArgs e) {
Form2 from = new Form2();
();
} private void button3_Click(object sender, EventArgs e)http:///shijuan/ 试卷 {
Form3 from = new Form3();
();
} private void button4_Click(object EventArgs e) {
Form4 from = new Form4();
();
}
}
}
二.登录模块
代码如下:
using System;
using ;
using ;
using ;
sender,
using
;
using ;
using ;
using ;
namespace WindowsApplication1
{
public partial cla logo : Form
{
public logo()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
} private void button1_Click(object sender, EventArgs e) { string
connstring
=
@\"Data Source=panlunzhao;Initial Security=True\";
Catalog=;Integrated
SqlConnection conn = new SqlConnection(connstring); ();
string username = (); string paword = (); SqlCommand comm = ();
= \"select * from manage where username=\'\" + username + \"\' and paword=\'\" + paword + \"\'\";
SqlDataReader sqlda = ();
if (())
{ ifhttp:///gongzuobaogao/
工
作
报
告
(sqlda.ToString().Trim() == paword) {
//(\"恭喜您登陆成功!\", \"登陆成功!\", , );
//Form2 f = new Form2();
//();
Form3 from = new Form3();
();
}
else { (\"密码错误,请重新输入!\", \"错误
\", , ); }
}
else { (\"此用户不存在,请您注册!\", \"注册\", , ); }
();http:///dangtuangongzuozongjie/ 党团工作总结
();
} private void button2_Click(object sender, EventArgs e) {
= \"\";
= \"\";
}
}
}
三.会员管理模块
代码如下:
using System;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
namespace WindowsApplication1
{
public partial cla Form2 :
Form
{
protected SqlConnection conn;
protected SqlCommand cmd;
string connstring = @\"Data Sou/article/ 述职报告rce=panlunzhao;Initial
Catalog=;Integrated Security=True\";
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
load1();
load();
}
protected void load1()
{
string sql = \"select *from customer\";
conn = new SqlConnection(connstring);
();
SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet();
(ds, \"book\");
= ;
}
protected void load()
{
conn = new SqlConnection(connstring);
();
string sql_select = \"SELECT ID FROM customer \"; cmd = new SqlCommand(sql_select, conn);
SqlDataReader dr = ();
();
while (())
(dr);
();
}
private DataTable BindData(string sql)
{
string sql_select = sql;
conn = new SqlConnection(connstring);
SqlDataAdapter ad = new SqlDataAdapter(sql_select, conn); DataSet ds = new DataSet();
(ds, \"customer\");
return ;
} private void button1_Click(object sender, EventArgs e) {
string sql = \"select * from customer where ID=\'\" + () + \"\'\";
conn = new SqlConnection(connstring);
();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader ds = ();
();
= ds.ToString();
http:///xuexiaogongzuozongjie/ 学校工作总结 = ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= (bool)ds;
} private void update_Click(object sender, EventArgs e) {
string sql = \"customer set
name=@name,Levels=@Levels,Birthday=@Birthday,Degree=@Degree,Addre=@Addre,Telephone=@Telephone,Email=@Email,Score=@Score where ID=@ID\"; conn = new SqlConnection(connstring);
();
cmd = new SqlCommand(sql, conn);
(\"@ID\", ).Value = ();
(\"@name\", , 20).Value = ();
(\"@Levels\", ).Value = ();
(\"@Birthday\",
).Value = ();
(\"@Degree\", ,
20).Value = ();
(\"@Addre\", , 256).Value = ();
(\"@Telephone\", ,
50).Value = ();
(\"@Email\", , 50).Value = ();
(\"http:///yundonghuiyanjianggao/ 运动会演讲稿 @Gender\", ).Value = (bool);
(\"@Score\", ).Value = ();
();
SqlDataReader ds = ();
();
load1();
}
private void _Click(object sender, EventArgs e) {
string sql_ = \" into
customer(Name,Levels,Gender,Birthday,Degree,Addre,Telephone,Email,Score)
values(@Name,@Levels,@Gender,@Birthday,@Degree,@Addre,@Telephone,@Email,@Score)\";
cmd = new SqlCommand(sql_, conn);
try
{
();
(\"@Name\", ,
20).Value = ();
(\"@Levels\",
).Value = (()); (\"@Birthday\",
).Value =
(());
(\"@Degree\", ,
20).Value = ();
(\"@Addre\", , 256).Value = ();
(\"@Telephone\", ,
50).Value = ();
(\"@Email\", ,
50).Value = ();
(\"@Score\", ).Value = (());
if ()
{
(\"@Gender\",
).Value = \"true\";
}
else
{
(\"@Gender\",
).Valuhttp:///yuegongzuozongjie/ 月工作总结 e = \"false\";
}
int count = ();
if (count == 1)
{
if ((\"确认添加读者吗?\", \"提示\", , ) == ) return;
(\"添加成功!!\", \"提示!\"); }
else
{
(\"添加失败\", \"提示\",
, );
}
}
catch (Exception ex)
{
();
}
finally
{
();
}
}
}
}
四.增加、删除、修改图书模块
代码如下:
using System;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
namespace WindowsApplication1
{
public partial cla Form3 : Form
{
protected SqlConnection conn;
protected SqlComhttp:///shijicailiao/ mand cmd;
事迹材料
string connstring = @\"Data Source=panlunzhao;Initial Security=True\";
public Form3()
{
InitializeComponent();
}
Catalog=;Integrated
private void textBox7_TextChanged(object sender, EventArgs e) {
} private void label6_Click(object sender, EventArgs e) {
} private void select_Click(object sender, EventArgs e) {
string book_name = ();
string pre = ();
string Author = ();
StringBuilder sb1 = new StringBuilder();
(\"select * from book where \");
if ()
((\"Name LIKE \'%{0}%\'\", book_name));
if ( && ) (\"AND \");
if ()
{
((\"Pre = \'{0}\'\", pre)); }
if ( && ) (\"AND \");
if ()
{
((\"Author LIKE \'%{0}%\'\", Author));
}
= Binhttp:///banzhurengongzuojihua/ 班主任工作计划 dData(()); } private void reset_Click(object sender, EventArgs e) {
= true;
= false;
= false;
= \"\";
= \"\";
= \"\";
} private void button1_Click(object sender, EventArgs e) {
string sql = \"select * from book where ISBN=\'\" + () + \"\'\";
conn = new SqlConnection(connstring);
();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader ds = ();
();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString(http:///shiyongqigongzuozongjie/ 试用期工作总结 );
= ds.ToString();
= ds.ToString();
= ds.ToString();
= (bool)ds;
= ds.ToString();
} private void button2_Click(object sender, EventArgs e) {
string sql = \" into
book(ISBN,name,author,pre,publishdate,price,pages,barcode,cd,storage)
values(@ISBN,@name,@author,@pre,@publishdate,@price,@pages,@barcode,@cd,@storage)\";
conn = new SqlConnection(connstring);
();
cmd = new SqlCommand(sql, conn);
(\"@isbn\", , 10).Value = ();
(\"@name\", , 256).Value = ();
(\"@author\", , 100).Value = ();
(\"@pre\", , 50).Value = ();
(\"@publishdate\", ,
50).Value = ();
(\"@price\", , 50).Value = ();
(\"@pages\", , 50).Value
= ();
(\"@barcode\", SqlDbTypehttp:///dangxiaoxuexixindetihui/ 党校学习心得体会 .NVarChar,
50).Value = ();
(\"@cd\", , 50).Value = (bool);
(\"@storage\", ,
50).Value = ();
();
load1();
load();
}
private void save_Click(object sender, EventArgs e)
{
string sql = \"book set
name=@name,author=@author,pre=@pre,publishdate=@publishdate,price=@price,pages=@pages,barcode=@barcode,cd=@cd,Storage=@Storage where ISBN=@ISBN\";
conn = new SqlConnection(connstring);
();
cmd = new SqlCommand(sql, conn);
(\"@isbn\", , 10).Value = ();
(\"@name\", , 256).Value = ();
(\"@author\", , 100).Value = ();
(\"@pre\", , 50).Value = ();
(\"@publishdate\", ,
50).Value = ();
(\"@price\", , 50).Value = ();
(\"@pages\", , 50).Value = ();
(\"@barcode\", ,
50).Value = ();
(\"@cd\", , 50).Value = (bool);
(\"@storage\", ,
50).Value = ();
();
SqlDataReader ds = ();
();
load1();
}
private void quxiaosave_Click(object sender, EventArgs e) {
= \"\";
= \"\";
= \"\";
= \"\";
= \"&http:///shenbaocailiao/ 申报材料quot;;
= \"\";
= \"\";
= \"\";
= false;
= \"\";
}
private void _Click(object sender, EventArgs e) {
string sql = \" from book where isbn=@isbn\"; conn = new SqlConnection(connstring);
cmd = new SqlCommand(sql, conn);
();
(\"@isbn\", , 10).Value = ();
();
load1();
load();
}
private void Form3_Load(object sender, EventArgs e) {
load();
load1();
}
protected void load()
{
conn = new SqlConnection(connstring);
();
string sql_select = \"SELECT DISTINCT FROM ORDER BY \";
cmd = new SqlCommand(sql_select, conn);
SqlDataReader dr = ();
();
while (())
(dr);
();
= \"SELECT DISTINCT FROM ORDER BY \";
SqlDataReader ds = ();
();
while (())
(ds);
();
= \"SELECT DISTINCT FROM ORDER BY \";
SqlDataReader st = ();
();
while (())
(st);
();
}
protected void load1()
{
string sql = \"select *from book\";
conn = new SqlConnection(connstring);
();
SqlDataAdapter da = http:///qingkuangbaogao/ 情况报告new SqlDataAdapter(sql, conn); DataSet ds = new DataSet();
(ds, \"book\");
= ;
}
private DataTable BindData(string sql)
{
string sql_select = sql;
conn = new SqlConnection(connstring);
SqlDataAdapter
ad
=
new SqlDataAdapter(sql_select, conn); DataSet ds = new DataSet();
(ds, \"Book\");
return ;
}
private void all_Click(object sender, EventArgs e)
{
string sql = \"select *from book\";
conn = new SqlConnection(connstring);
();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
(ds, \"book\");
= ; }
}
}
五.借书模块
代码如下:
using System;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
namespace WindowsApplication1
{
public partial cla Form4 : Form
{
protected SqlConnection conn;
protected SqlCommand cmd; string
connstring
=
@\"Data Source=panlunzhao;Initial Catalog=:///banjigongzuojihua/ 班级工作计划 F;Integrated Security=True\";
public Form4()
{
InitializeComponent();
}
private void Form4_Load(object sender, EventArgs e)
{
try
{
conn = new SqlConnection(@\"Data
Source=panlunzhao;Initial Catalog=;Integrated
Security=True\");
();
();
}
catch (Exception exp)
{
(\"无法建立数据连接:\" + ); ();
}
}
protected void InitData()
{
cmd = new SqlCommand(\"select distinct from Book order By \", conn);
SqlDataReader reader1 = ();
();
while (())
(reader1);
();
cmd = new SqlCommand(\"select id from reader order by\",conn);
SqlDataReader reader2 = ();
();
while (())
(reader2);
();
} private void select_Click(object sender, EventArgs e) http:///chengxinyanjianggao/ 诚信演讲稿 {
string sql = \"select * from book where ID=\'\" +
() + \"\'\";
conn = new SqlConnection(connstring);
();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader ds = ();
();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= ds.ToString();
= (bool)ds;
= ds.ToString();
} private void jieshu_Click(object sender, EventArgs e) {
string sql = \"select * from reader where ID=\'\" + () + \"\'\";
conn = new SqlConnection(connstring);
();
SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet();
(ds, \"book\");
= ;
string sql_up = \"book set Storage=Storage-1 where ID=\'\" + () + \"\'\";
cmd = new SqlCommand(sql_up, conn);
();
DataSet hs = new DataSet();
(hs, \"book\");
= ;
if ( == \"\")
return;
= \"SELECT * FROM WHERE =\" + ;
SqlDataReader reader1 = null;
try
{
reader1 = ();
if (())
{
textBhttp:///gerengongzuojihua/ = reader1.ToString();
}
else
{
(\"没有符合条件的记录\", \"提示\", , );
}
}
catch (Exception exp)
{
(\"数据访问错误:\" + +
, \"错误\", , ); }
finally
{
if (reader1 != null && !)
个人工作计划
();
}
}
}
}
总结
此次实训综合考查了所学的c#知识,让我知道一个项目从构思、设计、实结题报告现、测试的过程。在实训中也综合运用了所学的知识,也涵盖了数据库的知识,用数据库存放数据,用脚本实现功能。