private static boolean insertDrug(Drug bean, PreparedStatement stmt) throws SQLException{
		
		stmt.setString(1, bean.getDrugName());
		stmt.setString(2, bean.getDescription());
		stmt.setInt(3, bean.getQuantity());
		stmt.setBoolean(4, bean.isControlFlag());
		stmt.setString(5, bean.getSideEffect());
        stmt.setBigDecimal(6, bean.getPrice());

		int affected = stmt.executeUpdate();
		if(affected == 1){
			System.out.println("new drug added successfully");
		}else{
			System.out.println("error adding drug");
			return false;
		}
		return true;
	}