pst.executeUpdate("INSERT INTO sales_dcl_order_details ("
+ "order_no, trans_type, stk_code, description, unit,"
+ "unit_price, quantity, discount_percent, insert_date ) VALUES "
+ "('"+ max_id + "','" + 30+ "','" + item_code + "','" + item_desc + "','" + item_unit + "'"
+ ",'" + item_price + "','" + item_quentity + "','" + item_discount + "','" + u.todays_datetime() + "')",Statement.RETURN_GENERATED_KEYS);
generatedKeys = pst.getGeneratedKeys();
if(generatedKeys.next()){
src_id = generatedKeys.getString(1);
}
+ "order_no, trans_type, stk_code, description, unit,"
+ "unit_price, quantity, discount_percent, insert_date ) VALUES "
+ "('"+ max_id + "','" + 30+ "','" + item_code + "','" + item_desc + "','" + item_unit + "'"
+ ",'" + item_price + "','" + item_quentity + "','" + item_discount + "','" + u.todays_datetime() + "')",Statement.RETURN_GENERATED_KEYS);
generatedKeys = pst.getGeneratedKeys();
if(generatedKeys.next()){
src_id = generatedKeys.getString(1);
}
No comments:
Post a Comment