·¢²¼Ê±¼ä : ÐÇÆÚÈý ÎÄÕÂͼÊé½øÏú´æϵͳ(CS)¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ4758ae4f2e3f5727a5e96277
µÚ9Õ ͼÊé½ø´æÏúϵͳ ¡¤41¡¤
±£´æÊé±¾µÄÏúÊۼǼ£¬Ö»ÐèÒª±£´æ¶ÔÓ¦µÄÏúÊۼǼµÄÍâ¼ü¡¢Êé±¾¼Ç¼Íâ¼üºÍ½»Ò×ÊýÁ¿£¬ÓÉÓÚÒ»´Î½»Ò׼Ǽ¶ÔÓ¦¶àÊé±¾µÄÏúÊۼǼ£¬Òò´ËÒ»ÌõÊéµÄÏúÊۼǼ£¬Ö»ÐèÒªÓÐÒ»±¾ÊéµÄÍâ¼ü¡£ÒµÎñ²ãÖ»ÐèÒª½«BookSaleRecord£¨¶à¸ö£©ºÍSaleRecord£¨Ò»¸ö£©¸øµ½Á½¸öÊý¾Ý·ÃÎʲ㼴¿É¡£
´úÂëÇåµ¥£ºcode\\book\\src\\org\\crazyit\\book\\service\\impl\\SaleRecordServiceImpl.java
public void saveRecord(SaleRecord record) { //±éÀúÅжÏÊéµÄ¿â´æÊÇ·ñ²»¹» }
for (BookSaleRecord r : record.getBookSaleRecords()) { String bookId = r.getBook().getID(); Book b = bookDao.find(bookId); //µ±´æ¿â²»¹»Ê±,Å׳öÒì³£
if (Integer.valueOf(r.getTRADE_SUM()) > Integer.valueOf(b.getREPERTORY_SIZE())) { throw new BusinessException(b.getBOOK_NAME() + \µÄ¿â´æ²»¹»\
} }
//Ïȱ£´æ½»Ò׼Ǽ
String id = saleRecordDao.save(record); //ÔÙ±£´æÊéµÄ½»Ò׼Ǽ
for (BookSaleRecord r : record.getBookSaleRecords()) { //ÉèÖÃÏúÊۼǼid }
r.setT_SALE_RECORD_ID_FK(id);
bookSaleRecordDao.saveBookSaleRecord(r); //ÐÞ¸ÄÊéµÄ¿â´æ
String bookId = r.getBook().getID(); Book b = bookDao.find(bookId); //¼ÆËãÊ£ÓàµÄ¿â´æ
int leave = Integer.valueOf(b.getREPERTORY_SIZE()) - Integer.valueOf(r.getTRADE_SUM()); //ÉèÖÿâ´æ²¢½«¿â´æÊý±£´æµ½Êý¾Ý¿â
b.setREPERTORY_SIZE(String.valueOf(leave)); bookDao.updateRepertory(b);
ÒÔÉÏ´úÂë±£´æÁËÏúÊۼǼ²¢ÐÞ¸ÄÊé±¾µÄ¿â´æÁ¿£¬ÔÚ½øÐб£´æÏúÊۼǼǰ£¬ÐèÒª½øÐÐÒµÎñÅжϣ¬ÅжÏÊé±¾µÄ´æ¿âÁ¿ÊÇ·ñ×ã¹»£¬Èç¹û²»×ã¹»ÔòÅ׳öÒì³£¡£ÏÂÃæ¿ÉÒÔʵÏÖÏúÊۼǼµÄ²éѯ£¬¿ÉÒÔ¸ù¾ÝijһÌìµÄʱ¼ä²éѯµ±ÌìËùÓеÄÏúÊۼǼ£¬ÔÙ½øÐÐÊý¾ÝÏÔʾ£¬Ôڴ˲»ÔÙÏêϸ׸Êö¡£
µ½´Ë£¬ÏúÊÛ½çÃæµÄ¹¦ÄÜÒѾÍê³É£¬ÓëÆäËû¹¦ÄÜÏà±È£¬ÏúÊÛ¹ÜÀí½çÃæÖ»ÊǶàÁËÒ»¸öÁÐ±í£¬¸ÃÁбíµÄ´¦Àí·½·¨ÓëÖ÷ÁбíµÄ´¦Àí·½Ê½´óÖÂÏàͬ¡£ÎÒÃÇ¿ÉÒÔÈ¥¿´Ò»ÏÂÈë¿â¹ÜÀí½çÃ棬ÓëÏúÊÛ¹ÜÀí½çÃæÒ»Ñù£¬¶¼ÊÇͨ¹ýÏàͬµÄ½»»¥·½Ê½µÃµ½ÏúÊÛ»òÕßÈë¿âµÄÄ¿µÄ£¬µ«ÊÇÓëÖ®²»Í¬µÄµØ·½ÊÇ£¬ÔÚ´¦ÀíÈë¿âÒµÎñµÄʱºò£¬ÎÒÃÇͬÑùÒ²ÐèÒªÐÞ¸ÄÊé±¾µÄ¿â´æ£¬ÏúÊÛÊǼõÉÙ¿â´æ£¬Èë¿âÊÇÔö¼Ó¿â´æ¡£ÓëÏúÊÛ¹ÜÀí¹¦ÄÜÒ»ÑùµÄÊÇ£¬Èë¿â¹ÜÀí½çÃæµÄÏÂÃ沿·ÖÒ²ÊÇÓÐÒ»¸öÈë¿âµÄÊéµÄ¼Ç¼ÁÐ±í£¬ÔÀíÓëÊéµÄ½»Ò׼ǼÁбíÒ»Ö¡£Èë¿â¹ÜÀí¹¦ÄܵÄʵÏÖ£¬¿ÉÒԲο¼ÏúÊÛ¹ÜÀí¹¦ÄܵÄʵÏÖ¡£Èë¿â¹ÜÀí¹¦ÄÜÈçͼ9.12Ëùʾ¡£
¡¤42¡¤ µÚ9Õ ͼÊé½ø´æÏúϵͳ
ͼ9.12 Èë¿â¹ÜÀí¹¦ÄÜ
9.8 ±¾ÕÂС½á
ÔÚ±¾ÕÂÖУ¬ÎÒÃÇʵÏÖÁËÒ»¸ö¼òµ¥µÄͼÊé½ø´æÏúϵͳ£¬Ñ§Ï°ÁËʹÓÃJDBC½øÐÐÊý¾Ý¿â²Ù×÷£¬Ê¹ÓÃJavaµÄ·´Éä¼¼Êõ·â×°Êý¾Ý£¬Ê¹Óõ¥Ì¬Ä£Ê½È¥»ñµÃÊý¾Ý¿âÁ¬½Ó£¬Í¼Æ¬µÄѹËõ´¦ÀíµÈ֪ʶµã¡£ÔÚ½çÃæÖÐÖ÷ҪʹÓÃJTableµÄ´¦Àí£¬±íÏֲ㡢ҵÎñ²ãÓëÊý¾Ý·ÃÎʲãµÄ·Ö²ã½á¹¹£¬´ó´ó¼õµÍÁ˸÷²ãÖ®¼äµÄ´úÂëñîºÏ¡£ÔÚ±íÏÖ²ãÖмòµ¥µÄʹÓÃÁËÄ£°å·½·¨ÕâÖÖÉè¼Æģʽ£¬½«¸÷¸ö½çÃæÖеĹ²Í¬µãÌáÈ¡µ½¸¸Àà½øÐд¦Àí¡£Èç¹ûÐèҪд¸üÁ¼ºÃµÄ´úÂ룬¿ÉÒÔ¶Ô±¾ÕÂÖеĴúÂë½øÐÐÖع¹£¬²¢¿ÉÒÔÓ¦ÓöÔÓ¦µÄÉè¼Æģʽ¡£ÔËÐб¾Õ°²È«ÐèÒª½«¡°bin\\ͼÊé½ø´æÏúϵͳ\\sql¡±Ä¿Â¼ÏµÄBOOK_SYSTEM.sqlµ¼ÈëÄãµÄMySQLÊý¾Ý¿âÖУ¬´ò¿ª¡°bin\\ͼÊé½ø´æÏúϵͳ\\book.jar¡±Ð޸İüϵġ°book.jar\\cfg\\jdbc.propertis¡±ÅäÖÃÎļþ£¬×îºóÔËÐС°bin\\ͼÊé½ø´æÏúϵͳ\\startup.bat¡±¼´¿É£¬Ä¬ÈϵÄÓû§ÃûºÍÃÜÂ붼ÊÇcrazyit£¬±¾ÕÂËùʹÓõÄMySQL°æ±¾ÊÇ5.0¡£