private static boolean insertPatient(Patient bean, PreparedStatement stmt) throws SQLException{

		stmt.setString(1, bean.getFirstName());
		stmt.setString(2, bean.getLastName());
		stmt.setDate(3, bean.getDob());
		stmt.setString(4, bean.getPrimaryDoc());
		stmt.setString(5, bean.getPhone());
		stmt.setString(6, bean.getAddress());
		stmt.setString(7, bean.getCity());
		stmt.setString(8, bean.getState());
		stmt.setString(9, bean.getZip());
		stmt.setBigDecimal(10, bean.getCoPay());
		
		int affected = stmt.executeUpdate();
		if(affected == 1){
			System.out.println("new patient added successfully");
		}else{
			System.out.println("error adding patient");
			return false;
		}
		return true;
	}