1.1程序设计代码登录模块if""||"")("请输入用户名和密码","提示");else{if == true){string strcon = "Data Source=SIMON-VAIO;Initial Catalog=lkl2;Integrated Security=True;"; alue = ; alue = ; alue = ; alue = ; alue = ;["@bname"].Value = ;["@bauthor"].Value = ;["@bpublic"].Value = ;["@bclasses"].Value = ;["@benshu"].Value = ;();();("添加成功!");删除图书代码SqlConnection sqlcon = new SqlConnection("Data Source=SIMON-VAIO;InitialCatalog=lkl2;Integrated Security=True");();string str = "delete from book where bnum=@bnum";SqlCommand cmd = new SqlCommand(str, sqlcon);"@bnum", , 20);["@bnum"].Value = ();();("删除成功!")查询图书代码SqlConnection con = new SqlConnection();alue = ;SqlDataAdapter da = new SqlDataAdapter(cmd);DataTable dt = new DataTable("图书记录表");"BorrowRecord", "借阅记录表");[0].("bnum", "图书号");[0].("bname", "图书名");[0].("bauthor", "作者");[0].("bpublic", "出版社");[0].("bclasses", "类别");[0].("benshu", "本数");(dt);= dt;();图书更新代码SqlConnection con1 = new SqlConnection("Data Source=SIMON-VAIO;Initial Catalog=lkl2;Integrated Security=True;");();SqlCommand cmd1 = new SqlCommand("update book setbname=@bname,bauthor=@bauthor,bpublic=@bpublic,bclasses=@bclasses,benshu=@benshu wherebnum=@bnum;", con1);"@bnum", , 20);"@bname", , 20);"@bauthor", , 20);"@bpublic", , 20);"@bclasses", , 20);"@benshu", , 20);["@bnum"].Value = ;["@bname"].Value = ;["@bauthor"].Value = ;["@bpublic"].Value = ;["@bclasses"].Value = ;["@benshu"].Value = ;();();("更新成功!");添加用户代码SqlConnection sqlcon = new SqlConnection("Data Source=SIMON-VAIO;InitialCatalog=lkl2;Integrated Security=True;");string str = "insert into values(@usernum,@username,@userpassword,@usertype)"; ();SqlCommand cmd = new SqlCommand(str, sqlcon);"@usernum", , 20);"@username", , 20);"@userpassword", , 20);"@usertype", , 20);["@usernum"].Value =;["@username"].Value = ;["@userpassword"].Value = ;();();("用户添加成功!"删除用户代码SqlConnection sqlcon = new SqlConnection("Data Source=SIMON-VAIO;InitialCatalog=lkl2;Integrated Security=True");();string str = "delete from reader where usernum=@usernum";SqlCommand cmd = new SqlCommand(str, sqlcon);"@usernum", , 20);["@usernum"].Value = ();();("删除成功!");修改密码代码SqlConnection con1 = new SqlConnection("Data Source=SIMON-VAIO;InitialCatalog=lkl2;Integrated Security=True;");();SqlCommand cmd1 = new SqlCommand("update reader set userpassword=@userpassword where usernum=@usernum;", con1);"@usernum", , 20);"@userpassword", , 20);["@usernum"].Value = ;["@userpassword"].Value = ;();();("修改成功请从新登陆!");完善读者信息代码SqlConnection sqlcon = new SqlConnection("Data Source=SIMON-VAIO;InitialCatalog=lkl2;Integrated Security=True;");string str = "insert intovalues(@usernum,@username,@usersex,@usergrade,@telephone)";();SqlCommand cmd = new SqlCommand(str, sqlcon);"@usernum", , 20);"@username", , 20);"@usersex", , 20);"@usergrade", , 20);"@telephone", , 20);["@usernum"].Value = ;["@username"].Value = ;["@usersex"].Value = ;["@usergrade"].Value = ;();();("添加信息成功!");检索用户信息代码if == ""){("请输入学生学号！");}else{string strcon = "Data Source=SIMON-VAIO;Initial Catalog=lkl2;Integrated Security=True";SqlConnection sqlCon = new SqlConnection(strcon);();string sql = "select * from readerifo where usernum=@usernum ";SqlCommand cmd = new SqlCommand(sql, sqlCon);"@usernum", , 20);["@usernum"].Value = ;oString().Trim();= dr["username"].ToString().Trim();= dr["usersex"].ToString().Trim();= dr["usergrade"].ToString().Trim();= dr["telephone"].ToString().Trim();("欢迎光临本图书馆来借书！");}();借阅图书代码SqlConnection sqlcon = new SqlConnection("Data Source=SIMON-VAIO;InitialCatalog=lkl2;Integrated Security=True;");string str = "insert intovalues(@bnum,@bname,@bauthor,@bpublic,@bclasses,@benshu,@btime,@usernum,@username,@usersex,@ usergrade,@telephone)";();SqlCommand cmd = new SqlCommand(str, sqlcon);"@bnum", , 20);"@bname", , 20);"@bauthor", , 20);"@bpublic", , 20);"@bclasses", , 20);"@benshu", ;"@usernum", , 20);"@username", , 20);"@usersex", , 20);"@usergrade", , 20);"@telephone", , 20);["@bnum"].Value = ;["@bname"].Value = ;["@bauthor"].Value = ;["@bpublic"].Value = ;["@bclasses"].Value = ;["@benshu"].Value = "1";["@btime"].Value = ["@usernum"].Value = ;["@username"].Value = ;["@usersex"].Value = ;["@usergrade"].Value = ;SqlParameter("@borrowtime", );["@telephone"].Value = ;();();SqlConnection con1 = new SqlConnection("Data Source=SIMON-VAIO;InitialCatalog=lkl2;Integrated Security=True;");();SqlCommand cmd1 = new SqlCommand("update book set benshu=benshu-1 where bnum=@bnum", con1);"@bnum", , 20);["@bnum"].Value = ;();();("借阅成功!");归还图书代码SqlConnection sqlcon = new SqlConnection("Data Source=SIMON-VAIO;InitialCatalog=lkl2;Integrated Security=True;");string str = "insert intovalues(@bnum,@bname,@bauthor,@bpublic,@bclasses,@benshu,@rtime,@usernum,@username,@usersex,@ usergrade,@telephone)";();SqlCommand cmd = new SqlCommand(str, sqlcon);"@bnum", , 20);"@bname", , 20);"@bauthor", , 20);"@bpublic", , 20);"@bclasses", , 20);"@rtime", ;"@usernum", , 20);"@username", , 20);"@usersex", , 20);"@usergrade", , 20);"@telephone", , 20);["@bnum"].Value = ;["@bname"].Value = ;["@bauthor"].Value = ;["@bpublic"].Value = ;["@bclasses"].Value = ;["@benshu"].Value = ;["@rtime"].Value = ["@usernum"].Value =;["@username"].Value = ;["@usersex"].Value = ;["@usergrade"].Value = ;SqlParameter("@returntime", );["@telephone"].Value = ;();();SqlConnection con1 = new SqlConnection("Data Source=SIMON-VAIO;InitialCatalog=lkl2;Integrated Security=True;");();SqlCommand cmd1 = new SqlCommand("update book set benshu=benshu+1 where bnum=@bnum", con1);"@bnum", , 20);["@bnum"].Value = ;();();("还书成功!");查询借阅归还图书信息代码if == ""){("读者信息不能为空！", "提示信息", , ;}else{SqlConnection con = new SqlConnection();alue = ;SqlDataAdapter da = new SqlDataAdapter(cmd);DataTable dt = new DataTable("借阅记录表");"BorrowRecord", "借阅记录表");[0].("usernum", "借阅证号"); [0].("username", "姓名");[0].("usersex", "性别");[0].("usergrade", "班级");[0].("bname", "图书名");[0].("bauthor", "作者");[0].("bnum", "图书号");[0].("bpublic", "出版社");[0].("bclasses", "类别");[0].("benshu", "本数");[0].("btime", "借书时间");[0].("rtime", "还书时间");[0].("telephone", "电话号码");[0].("statu", "状态");(dt);= dt;();。