コード例 #1
0
        //updateBook(String BookNo,String BookName,String Author,String Publishment,String BuyTime,String Borrowed,String Ordered,String Introduction)
        public String updateBook(String BookNo, String BookName, String Author, String Publishment, String BuyTime, String Borrowed, String Ordered, String Introduction)
        {
            DB.updateBook(BookNo, BookName, Author, Publishment, BuyTime, Borrowed, Ordered, Introduction);

            String ISBN = "";

            ISBN = DB.GetBookNoISBN(BookNo); //得到ISBN
            String sql  = "update book set B_Name='" + BookName + "',B_Author='" + Author + "',B_Publishment='" + Publishment + "',B_BuyTime='" + BuyTime + "' Where  ISBN = '" + ISBN + "'";
            String sql2 = "update bdetailedinformation  set Borrowed='" + Borrowed + "',Ordered='" + Ordered + "',Introduction='" + Introduction + "' Where B_Num = '" + BookNo + "'";

            return(sql);
        }