/else下面的代码没有问题,就是这两句sql语句不太正确当debug走到更新库存表时,会抛出异常publicbooleaninGoods(){Scannersc=newScanner(System.in);System.out.println...
/else下面的代码没有问题,就是这两句sql语句不太正确
当debug走到更新库存表时,会抛出异常
public boolean inGoods() { Scanner sc = new Scanner(System.in); System.out.println("请输入商品名称:"); String name = sc.next(); Goods g = opra_GoodsDao.findGoodsByName(name); if (g!=null) { System.out.println("该商品已存在!\n请直接输入增加的重量:"); double in_weight = sc.nextDouble(); System.out.println("请直接输入增加的数量:"); int in_num = sc.nextInt(); //库存表 String sql = "update a_goods set g_weight= " + in_weight +" g_weight, g_num="+ in_num +"g_num where g_id = "+g.getG_Id(); Object[] params ={}; //进货表 String sql_ = "insert into a_ingoods values (a_ingoods_seq.nextval,?,sysdate,"+g.getG_Price()+",?,?,"+g.getSup_id()+")"; Object[] params_ = {name,/*sysdate,price,*/in_weight,in_num/*,s.getSup_Id()*/}; int i = 0; int k = 0; try { i = DBUtil.update(sql, params);//更新库存表 k = DBUtil.update(sql_, params_);//更新进货表 } catch (Exception e) { e.printStackTrace(); }finally{ DBUtil.closeConn(); } if (i==0&& k==0) { return false; } } else {
展开