上机实习报告总结结尾.docx

上机实习报告总结结尾 一. 首页 代码如下; using System; using ; using ; using ; using ; using ; using ; namespace WindowsApplication1 public partial class 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 sender, EventArgs e) Form4 from = new Form4(); (); 二. 登录模块 代码如下： using System; using ; using ; using ; using ; using ; using ; using ; namespace WindowsApplication1 public partial class 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 Catalog=;Integrated Security=True“; SqlConnection conn = new SqlConnection(connstring); (); string username = (); string password = (); SqlCommand comm = (); = “select * from manage where username=“ + username + “ and password=“ + password + “; SqlDataReader sqlda = (); if () ifhttp:/gongzuobaogao/ 工作报告 (sqlda.ToString().Trim() = password) /(“恭喜您登陆成功!“, “登陆成功!“, , ); /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 class 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,Address=Address,Telephone=Telephone,Emai l=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 = (); (“Address“, , 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,Address,T elephone,Email,Score) values(Name,Levels,Gender,Birthday,Degree,Add ress,Telephone,Email,Score)“; cmd = new SqlCommand(sql_, conn); try (); (“Name“, , 20).Value = (); (“Levels“, ).Value = (); (“Birthday“, ).Value = (); (“Degree“, , 20).Value = (); (“Address“, , 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 class Form3 : Form protected SqlConnection conn; protected SqlComhttp:/shijicailiao/ 事迹材料 mand cmd; string connstring = “Data Source=panlunzhao;Initial Catalog=;Integrated Security=True“; public Form3() InitializeComponent(); 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 press = (); string Author = (); StringBuilder sb1 = new StringBuilder(); (“select * from book where “); if () (“Name LIKE %0%“, book_name); if ( if () (“Press = 0“, press); if ( 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,press,publishdate,price,pages,b arcode,cd,storage) values(ISBN,name,author,press,publishdate,pri ce,pages,barcode,cd,storage)“; conn = new SqlConnection(connstring); (); cmd = new SqlCommand(sql, conn); (“isbn“, , 10).Value = (); (“name“, , 256).Value = (); (“author“, , 100).Value = (); (“press“, , 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,press=press,publishdate= publishdate,price=price,pages=pages,barcode=bar code,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 = (); (“press“, , 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) = “; = “; = “; = “; = “; = “; = “; = “; = 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 class 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